FiveM does not communicate with the Databases in Pterodactyl. | Pterodactyl® | Page 1

strong bone Nov 20, 2023, 3:51 PM

#

The IP address it is trying to connect to is not even the correct address I am pointing my mysql URL to. I am pointing it to 27.x.x.x but when it comes up in the console, it shows what is on the image instead. I have 0 documentation for this as well. Any help would be appreciated. I have the panel installed on one machine. DNS is configured in Cloudflare. The panel and its databases are pointing to the correct areas. I just have no clue as to why this panel is not accepting the requests.

sage quartzBOT Nov 20, 2023, 3:52 PM

#

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

strong bone Nov 20, 2023, 3:53 PM

#

I did that, the error I am having is located on the console. I am pointing it to 27x.x.x, however it is telling me in the console that it is connected to 172.x.x.x.

I am not sure why it would be doing this.

#

And even though it is pointing there, the database will not connect.

spring fog Nov 20, 2023, 3:59 PM

#

The 172 IP in the rror message is not an IP address it's connecting to, it's the IP address it's connecting from.

#

What did you set "CONNECTIONS FROM" to when you created the database in pterodactyl ?

strong bone Nov 20, 2023, 4:02 PM

#

I am pretty sure i left it open to any connection

spring fog Nov 20, 2023, 4:02 PM

#

Then it's possible your password is entered wrong into the fivem config.

If it contains special characters, you will prob need to run it though url encode

strong bone Nov 20, 2023, 4:04 PM

#

I have no idea how to do any of that

#

That is where the problem lies

#

I have looked into the configuration and the "link" for the fivem server does not connect to it. I saw this: https://forum.cfx.re/t/finally-this-is-the-ultimate-fix-if-your-fivem-server-cant-connect-to-database-because-of-pterodactyl/5043770

Cfx.re Community

Finally: This is the ultimate fix if your FiveM Server, can't conne...

You get this error?: [script:mysql-async] [mysql-async] [ERROR] connect ECONNREFUSED 127.0.0.1:3306 I finally figured it out: namely when you use Pterodactyl and use “localhost” or “127.0.0.1”, you call the container itself. Very simple fix: enter the following command in your SSH console: ip addr | grep docker0 Then you should get somethi...

#

is this the fix? Because when I tried it I got a login error telling me that my login credentials are incorrect

#

when I copied them right from the mysql setup thing

#FiveM does not communicate with the Databases in Pterodactyl.