Mysql problem.

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Post Reply
vfi
Peon
Posts: 6
Joined: Fri Apr 20, 2007 1:44 pm

Mysql problem.

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
Peon
Posts: 6
Joined: Fri Apr 20, 2007 1:44 pm

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

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

vfi
Peon
Posts: 6
Joined: Fri Apr 20, 2007 1:44 pm

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

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

vfi
Peon
Posts: 6
Joined: Fri Apr 20, 2007 1:44 pm

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

How do I start a binary logging for the mysql database?
Last edited by vfi on Sun Apr 22, 2007 8:26 am, edited 1 time in total.

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

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?
Image

No support via PM or Email

vfi
Peon
Posts: 6
Joined: Fri Apr 20, 2007 1:44 pm

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

User avatar
Krazy
Forum Administrator
Posts: 282
Joined: Wed Jul 06, 2005 9:40 am
Location: Dayton, Ohio
Contact:

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.
Website: www.djpsych.com
Image

Need help anything to do with Warcraft 3 Mod, installing other plugins, setting up mySQL, installing PsychoStats, or anything else just PM/email me!

vfi
Peon
Posts: 6
Joined: Fri Apr 20, 2007 1:44 pm

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?

Post Reply