ufo56 Posted March 14, 2010 Share Posted March 14, 2010 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) Link to comment Share on other sites More sharing options...
Admin-Nation-Servers Posted March 14, 2010 Share Posted March 14, 2010 Is this on a Master server or Remote server? Link to comment Share on other sites More sharing options...
ufo56 Posted March 14, 2010 Author Share Posted March 14, 2010 Master server Any suggestions ? maybe i must change database connector ODBC to .NET connector ? Link to comment Share on other sites More sharing options...
ECF Posted March 14, 2010 Share Posted March 14, 2010 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. Link to comment Share on other sites More sharing options...
ufo56 Posted March 15, 2010 Author Share Posted March 15, 2010 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 Link to comment Share on other sites More sharing options...
ufo56 Posted March 16, 2010 Author Share Posted March 16, 2010 That error only appears with counter strike 1.6 servers Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.