Mysql problem.

vfi · Post by **vfi** » Sun Apr 22, 2007 6:55 am

War3ft Version: 2.3.2
Amxmodx Version: 1.71
Metamod Version: 1.19
amxx list: (i dont know how to view this in my linux shell)
amxx modules: (i dont know how to view this in my linux shell)
meta list: (i dont know how to view this in my linux shell)

Basically, I am having a problem connecting to a specific mysql database. It is a database that is used for 4 other servers as well that is part of a wc3ft community. We are trying to add a fifth server and the mysql will not connect properly but I can connect it to a localhost mysql database.

What happens with the database that isn't working properly is this:

The server boots up, loads admins and everything. It loads AMXX and Metamod and then gives the message "Vac Secure Mode is Activated". No confirmation of connecting to the mysql database given and while the server says it is up, you cannot connect to it via steam. The server doesn't even load onto the steam network.

So, pretty much the server is getting hung at the mysql certification I think and I am completely clueless as to why. The address, password, database and user are correct (the war3ft.cfg file came right out of another server that is working fine and so did the sql.cfg and modules.cfg).

Anyone got any ideas?

vfi · Post by **vfi** » Sun Apr 22, 2007 7:54 am

It will load a localhost mysql, but not one from a non-local.

vfi · Post by **vfi** » Sun Apr 22, 2007 7:55 am

oh and can a linux box connect to a mysql database on windows?

vfi · Post by **vfi** » Sun Apr 22, 2007 8:21 am

How do I start a binary logging for the mysql database?

Post by **YamiKaitou** » Sun Apr 22, 2007 8:26 am

Server OS shouldn't matter. Also, is the non-local host able to accept requests from your server's ip? And, can the MySQL server accept more than 4 connections at once?

vfi · Post by **vfi** » Sun Apr 22, 2007 8:27 am

Yes, it has 4 servers currently running off the database. Ill check with the database owner about the connections.

Could you possibly tell me how to check the number of maximum connections for mysql?

Here is the error I get after it passes the "Vac Secure Mode is Activated"

L 04/22/2007 - 09:35:35: [warcraft3FT.amxx] Database connection failed, attempting to reconnect in 5 seconds
L 04/22/2007 - 09:35:35: [warcraft3FT.amxx] Error: Can't connect to MySQL server on '208.97.147.234' (110)

Getting this too (alot of them)

NET_SendPacket ERROR: Operation not permitted

Post by **Krazy** » Sun Apr 22, 2007 11:20 am

vfi wrote:Here is the error I get after it passes the "Vac Secure Mode is Activated"

L 04/22/2007 - 09:35:35: [warcraft3FT.amxx] Database connection failed, attempting to reconnect in 5 seconds
L 04/22/2007 - 09:35:35: [warcraft3FT.amxx] Error: Can't connect to MySQL server on '208.97.147.234' (110)

Getting this too (alot of them)

NET_SendPacket ERROR: Operation not permitted

This is just telling you that the server is not connecting to the mySQL datebase. Which means you have incorrect mySQL information in the server files (which you said you double checks so this is probably not the problem), or your mySQL is not setup to accept the remote ip address from the gaming server.

vfi · Post by **vfi** » Mon Apr 23, 2007 12:22 pm

Krazy what do you mean about not accepting a remote ip from the server. Do you mean that the owner of the DB needs to set it up to allow my ip specifically to connect?