share databases between servers | Pterodactyl® | Page 1

naive oak Jan 21, 2023, 8:27 PM

#

i want to have a database shared between servers. how do i do that?

rose chasm Jan 21, 2023, 8:29 PM

#

where are you hosting the Database?

naive oak Jan 21, 2023, 8:31 PM

#

my server

#

in a docker container

dense slate Jan 21, 2023, 8:37 PM

#

naive oak i want to have a database shared between servers. how do i do that?

Add a firewall rule to allow traffic from your container's ip to any port 3306 (Or whichever port your DB uses). Repeat for any other containers you want to have access. From inside the container you'll connect to the DB through your server's public ip address.

naive oak Jan 21, 2023, 8:46 PM

#

ok pterodactyl cant connect to my database for some reason

#

There was an error while trying to connect to the host or while executing a query: "SQLSTATE[HY000] [2002] No such file or directory (SQL: SELECT 1 FROM dual)"

broken deltaBOT Jan 21, 2023, 8:47 PM

#

@naive oak; This error appears to be due to insufficient permissions for your database, please see the following guide for more information: https://pterodactyl.io/tutorials/mysql_setup.html#creating-a-database-host-for-nodes

naive oak Jan 21, 2023, 8:49 PM

#

i alr did that dumb bot

minor sinew Jan 21, 2023, 9:08 PM

#

naive oak i alr did that dumb bot

Apparently not right lol

#share databases between servers