SQL problem

[ufo56]

That error appears then when i create second server. First i make counter strike source server and all works fine and then i make counter strike 1.6 and that error appear

14.03.2010 20:23:55 : StandardPlugins.Database.Manager.Execute: ExecuteReader re
quires an open and available Connection. The connection's current state is Close
d. SQL Command: SELECT COUNT(*) as PORT_COUNT FROM TC_SERVICES, TC_SERVERS WHERE
TC_SERVICES.SERVER_ID = TC_SERVERS.SERVER_ID AND TC_SERVERS.ENABLED = 1 AND TC_
SERVICES.SERVER_IP = '80.79.115.242' AND (TC_SERVICES.SERVER_PORT = 27020 OR TC_
SERVICES.SERVER_QUERY_PORT = 27020 OR TC_SERVICES.SERVER_RCON_PORT = 27020) SQL
Command: SELECT COUNT(*) as PORT_COUNT FROM TC_SERVICES, TC_SERVERS WHERE TC_SER
VICES.SERVER_ID = TC_SERVERS.SERVER_ID AND TC_SERVERS.ENABLED = 1 AND TC_SERVICE
S.SERVER_IP = '80.79.115.242' AND (TC_SERVICES.SERVER_PORT = 27020 OR TC_SERVICE
S.SERVER_QUERY_PORT = 27020 OR TC_SERVICES.SERVER_RCON_PORT = 27020)

14.03.2010 20:23:55 : StandardPlugins.Database.ManagerODBC.Connect: ERROR [HY000
] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10055)
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localho
st' (10055)

14.03.2010 20:23:55 : StandardPlugins.Database.Manager.Execute: ExecuteReader re
quires an open and available Connection. The connection's current state is Close
d. SQL Command: SELECT COUNT(*) as PORT_COUNT FROM TC_SERVICES, TC_SERVERS WHERE
TC_SERVICES.SERVER_ID = TC_SERVERS.SERVER_ID AND TC_SERVERS.ENABLED = 1 AND TC_
SERVICES.SERVER_IP = '80.79.115.242' AND (TC_SERVICES.SERVER_PORT = 27020 OR TC_
SERVICES.SERVER_QUERY_PORT = 27020 OR TC_SERVICES.SERVER_RCON_PORT = 27020) SQL
Command: SELECT COUNT(*) as PORT_COUNT FROM TC_SERVICES, TC_SERVERS WHERE TC_SER
VICES.SERVER_ID = TC_SERVERS.SERVER_ID AND TC_SERVERS.ENABLED = 1 AND TC_SERVICE
S.SERVER_IP = '80.79.115.242' AND (TC_SERVICES.SERVER_PORT = 27020 OR TC_SERVICE
S.SERVER_QUERY_PORT = 27020 OR TC_SERVICES.SERVER_RCON_PORT = 27020)

[Admin-Nation-Servers]

Is this on a Master server or Remote server?

[ufo56]

Master server

 

Any suggestions ?

 

maybe i must change database connector ODBC to .NET connector ?

[ECF]

Try the ODBC driver and see if that fixes the issue. Basically the Master Monitor is having problems connecting to the MYSQL database.

 

If you only have 1 server then you may want to just use the Access database. This will work fine and uses less resources.

[ufo56]

No ODBC and .NET drivers doesent work. :S

 

Mysql hangs, it doesent show anymore tcadmin panel contents, only header and footer.

 

Mysql is installed Windows and connection limit is set to 100 (x86, 64-bit), MSI Installer 5.1.44 31.7M

Download

(mysql-essential-5.1.44-winx64.msi)

 

Maybe some permissions is wrong ?

 

EDIT: update. Now i discover that. First i crate css server and then if i want to make new server cs 1.6 then i must stop fist server. When server is created then i can start both

[ufo56]

That error only appears with counter strike 1.6 servers