EQEmulator Forums - Queryserv cannot connect to database

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Queryserv cannot connect to database (https://www.eqemulator.org/forums/showthread.php?t=37170)

Randymarsh9

08-11-2013 07:46 PM

Queryserv cannot connect to database

I updated my server's source code today, but now I can no longer long a character into the game. As soon as you try to connect to my server, it just freezes up. The only error I noticed is

Code:

Failed to connect to database: Error: #2003: Can't connect to MySQL server on 'localhost' (0)

in the logs. World and zone are both still connecting to my database though, so I am not sure what is wrong.

fwaits

08-11-2013 08:50 PM

I had the same issue recently with my login server, the fix was changing the setting for connection to the DB in the config file from localhost to 127.0.0.1. Windows Server 2008 R2 at least, does auto DNS resolution and pinging localhost gives ::1: rather than 127.0.0.1 unless you force it in the hosts file.

Akkadius

08-11-2013 08:56 PM

Make sure you have this config in your eqemu_config.xml

Code:

        <qsdatabase>

                <host>localhost</host>

                <port>3306</port>

                <username>user</username>

                <password>pass</password>

                <db>queryserv</db>

        </qsdatabase>

Of course, make sure it compliments your actual database settings

moltke24

05-31-2015 03:57 PM

sorry for the grave digging

Quote:

Originally Posted by Randymarsh9 (Post 223358)

I updated my server's source code today, but now I can no longer long a character into the game. As soon as you try to connect to my server, it just freezes up. The only error I noticed is

Code:

Failed to connect to database: Error: #2003: Can't connect to MySQL server on 'localhost' (0)

in the logs. World and zone are both still connecting to my database though, so I am not sure what is wrong.

I'm having this same issue and i dont think my peq password is working anymore in mysql, i haven't changed anything but can't log into it anymore.

anyone know anything about reestablishing your password to access mysql?

moltke24

05-31-2015 04:45 PM

nevermind

I just reinstalled mysql and then changed the password back to the same thing and it worked again

All times are GMT -4. The time now is 10:07 PM.