mysql connection refused | Dynmap® | Page 1

twin salmon Nov 16, 2024, 12:21 AM

#

Set up dynmap on my Minecraft server that runs on pterodactyl. Set up a mysql in a docker container. Database is created, user is created, user has all privileges on database, but I keep getting the error, that the connection was refused.

Console on startup of server:
[00:15:03 INFO]: [dynmap] Initializing database schema
[00:15:07 ERROR]: [dynmap] SQLException: Error creating tables
[00:15:07 ERROR]: [dynmap] ErrorCode: 0, SQLState=08001
[00:15:07 ERROR]: [dynmap] Message: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
[00:15:07 ERROR]: [dynmap] ConnectionString: jdbc:mysql://127.0.0.1:3307/s9_dynmap01?allowReconnect=true&autoReconnect=true
[00:15:07 ERROR]: [dynmap] CausedBy: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[00:15:07 ERROR]: [dynmap] CausedBy: Connection refused
[00:15:07 ERROR]: [dynmap] Map storage initialization failure

mysql> SHOW GRANTS FOR 'u9_QpJwey0Kv9'@'127.0.0.1';
GRANT USAGE ON . TO `u9_QpJwey0Kv9`@`127.0.0.1`
GRANT ALL PRIVILEGES ON `s9_dynmap01`.* TO `u9_QpJwey0Kv9`@`127.0.0.1`

Any ideas on what it could be?

forest idolBOT Nov 16, 2024, 12:21 AM

#

Before we get started, please tell us a bit about your server setup:

twin salmon Nov 16, 2024, 12:22 AM

#

Server is running on Minecraft Paper 1.21.1-131

#

Dynmap is running on v3.7-SNAPSHOT-948

forest idolBOT Nov 16, 2024, 12:23 AM

#

Before we get started, please tell us a bit about your server setup:

#

Thank you! Please provide any errors you are experiencing and upload your configuration.txt. Someone from our <@&801354402010628138> team will respond to help shortly. As a general reminder, everyone on our support team is a volunteer, please be kind!

#

Configuration.txt link: https://pastebin.com/WwY3FVL0

Pastebin

# All paths in this configuration file are relative to Dynmap's dat...

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

forest idolBOT Nov 16, 2024, 12:26 AM

#

forest idol Configuration.txt link: https://pastebin.com/WwY3FVL0

twin salmon Nov 16, 2024, 12:27 AM

#

Since it's been moved further up:

Server is running on Minecraft Paper 1.21.1-131
(the bot only let me pick 1.13.x-1.20.x, sorry about that)
Dynmap is running on v3.7-SNAPSHOT-948

serene finch Nov 17, 2024, 10:22 PM

#

twin salmon Set up dynmap on my Minecraft server that runs on pterodactyl. Set up a mysql in...

its most likely not 127.0.x

#

check whihc IP the docker has

#

especialy with pterodactyl it is NOT localhost or 127.0.0.1 you need to add but a different IP

forest idolBOT Nov 20, 2024, 11:55 PM

#

This support thread has been archived due to inactivity. Click the button below to reopen it.

#mysql connection refused