#MySQL Problem

1 messages · Page 1 of 1 (latest)

ember summitBOT
#

If your server cannot see the database, please make sure your mod/plugin is connecting to pterodactyl0 interface 172.18.0.1 or the public IP to reach the local database. You can not use localhost or 127.0.0.1 as that would be the container itself.

You also have to configure the database bind-address to listen on all interfaces following the guide below.
https://pterodactyl.io/tutorials/mysql_setup.html#creating-a-database-host-for-nodes

cobalt warren
#

In addition you may need a firewall rule.

#

sudo ufw allow from 172.18.0.0/16 to any port 3306 proto tcp

stoic plover
#

doesn't work

ember summitBOT
#

Please explain the issue you're experiencing in as much detail as possible. Preferably with error messages in a text format or paste link to logs. Nobody can assist you without information that helps to understand the issue. Help us help you. Messages such as "doesn't work" or "i need help" will most likely be ignored.

stoic plover
#

I get an error from the plugin because it is not connected to the database. I tried that command and all the ip's.

cobalt warren
#

What does your plugin config look like?

stoic plover
cobalt warren
#

That's not a config, that's a Proxy's name. I mean the actual config file.

stoic plover
#

Wait

# 
    hostname: "dedicated ip"
    port: 3306
    user: "u29_*********"
    password: "js2A!*********C3"
    database: "s29_nullcord"
    # How many threads to use for concurrent database access
    pool-size: 2
    connection-timeout: 15000
    # What parameters to use to connect to the database
    parameters:
      - "useSSL=false"
      - "useUnicode=true"
      - "characterEncoding=utf-8"
      - "autoReconnect=true"```
#

and the sql is this

cobalt warren
#

Did you change bind-address from 127.0.0.1 to 0.0.0.0?

#

In your MariaDB settings

stoic plover
#

yes

cobalt warren
stoic plover
#

is linux

cobalt warren
#

That tells me the operating system, not whether the port is open or not

stoic plover
#

I don't know why but I confused 3389 with 3306 ahaha.

image.png
stoic plover
cobalt warren
#

What's the exact error message when it tries to connect?

stoic plover