Queryserv cannot connect to database

Randymarsh9 · #1 08-11-2013, 07:46 PM

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 · #2 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** · #3 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 · #4 05-31-2015, 03:57 PM

Quote:

Originally Posted by Randymarsh9

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 · #5 05-31-2015, 04:45 PM

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