AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   MYSQLX connection (https://forums.alliedmods.net/showthread.php?t=127373)

BolliN 05-20-2010 11:29

MYSQLX connection
 
Okey, i've running war3ft in my server for some months, but now i've change the host and im having some problems in user MySQL database.

I set this,
PHP Code:

wc3_sql_dbhost        "200.43.193.116"         // Host Name
wc3_sql_dbuser        "NAME"        // User Name
wc3_sql_dbpass        "MY_PASSWORD"        // Password
wc3_sql_dbname        "NAME"        // Database Name 


When i start the server it give this logs..

05/20/2010 - 12:19:43: ** Map 'de_inferno' ended
L 05/20/2010 - 12:19:57: ** Map de_inferno started, version: '3.0 RC13'
L 05/20/2010 - 12:20:18: [MYSQLX] Database Connection Failed: [2003] Can't connect to MySQL server on '200.43.193.116' (10060)


Somebody know what could be the problem? :S


Sorry for my english

YamiKaitou 05-20-2010 11:41

Re: MYSQLX connection
 
MySQL server is either not running, does not exist, or is firewalled

BolliN 05-20-2010 12:53

Re: MYSQLX connection
 
Firewalled, ok thanks.

Now i change the server and.. the wc3_error give me this..

PHP Code:

L 05/20/2010 13:48:24: [MYSQLXError in querying databaselocation2
L 05
/20/2010 13:48:24: [MYSQLXMessageMySQL server has gone away (2006)
L 05/20/2010 13:48:24: [MYSQLXQuery statementSELECT `player_idFROM `wc3_playerWHERE `player_name` = 'a1mb0t; > oriel el toskero TL'
L 05/20/2010 13:48:24: [MYSQLXAttempting to re-establish connection to MySQL server 

u.u

I MUST run the data base in the same computer im running the serveR?


edit: and continue..

PHP Code:

L 05/20/2010 13:54:28: [MYSQLXError in querying databaselocation4
L 05
/20/2010 13:54:28: [MYSQLXMessageMySQL server has gone away (2006)
L 05/20/2010 13:54:28: [MYSQLXQuery statementREPLACE INTO `wc3_player_race` ( `player_id` , `race_id` , `race_xp` ) VALUES '1''2''217'); 
L 05/20/2010 13:54:28: [MYSQLXAttempting to re-establish connection to MySQL server 



All times are GMT -4. The time now is 03:48.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.