Page 1 of 1

Database Connection Failed

Posted: Mon Aug 21, 2006 3:52 am
by Azazel
Ok Guys Im Trying to set up the server using MySQL 5.0.24-community-nt and Running WC3FT...

Every time I boot the server I get the same Error... and I dont understand why....

L 08/21/2006 - 00:05:07: [warcraft3FT.amxx] Database connection failed, attempting to reconnect in 5 seconds
L 08/21/2006 - 00:05:07: [warcraft3FT.amxx] Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
L 08/21/2006 - 00:05:12: [warcraft3FT.amxx] Database connection failed, attempting to reconnect in 5 seconds
L 08/21/2006 - 00:05:12: [warcraft3FT.amxx] Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client


That is the most up to date MySQL that I can find. But im also running my adimns through MySQL and not having any Issues with that at all...

Meta Version
Metamod v1.18 2005/08/24 (5:12)
by Will Day <willday@metamod.org>


Meta List
Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm.dll v1.60 ini ANY ANY
[ 2] POD-Bot mm RUN - podbot_mm.dll vR2b46d ini Chlvl ANY
[ 3] Fun RUN - fun_amxx.dll v1.60 pl1 ANY ANY
[ 4] Engine RUN - engine_amxx.dll v1.60 pl1 ANY ANY
[ 5] FakeMeta RUN - fakemeta_amxx.dl v1.60 pl1 ANY ANY
[ 6] MySQL RUN - mysql_amxx.dll v1.60 pl1 ANY ANY
[ 7] nVault RUN - nvault_amxx.dll v1.60 pl1 ANY ANY
[ 8] CStrike RUN - cstrike_amxx.dll v1.60 pl1 ANY ANY
[ 9] CSX RUN - csx_amxx.dll v1.60 pl1 ANY ANY
9 plugins, 9 running


Amxx Plugins (abreviated cutting out all amxx Dev Team Plugins)

[ 25] Warcraft 3 Frozen 2.3.0 Geesu==Pimp Dad warcraft3ft.amx debug
[ 26] POD-Bot Menu 1.2 g4s|figurE.09 amxx_podbotmenu running

26 plugins, 26 running



I belive there is one other piece of info that might be handy.... If there is anything other than this that i can help you with... Please tell me.

mysql> describe war3users;
+------------+-------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+-------------------+-------+
| playerid | varchar(35) | NO | PRI | | |
| playername | varchar(35) | NO | | | |
| xp | int(11) | NO | | 0 | |
| race | tinyint(4) | NO | PRI | 0 | |
| skill1 | tinyint(4) | NO | | 0 | |
| skill2 | tinyint(4) | NO | | 0 | |
| skill3 | tinyint(4) | NO | | 0 | |
| skill4 | tinyint(4) | NO | | 0 | |
| time | timestamp | YES | | CURRENT_TIMESTAMP | |
+------------+-------------+------+-----+-------------------+-------+
9 rows in set (0.16 sec)

Posted: Mon Aug 21, 2006 7:51 am
by YamiKaitou
Upgrade your AmxX. v1.60 does not connect to MySQL v5

Posted: Mon Aug 21, 2006 1:28 pm
by Azazel
Ok I will try that... but what still puzzles me... if AMXX 1.60 wont connect to that MySQL server... then why does the Admins work properly.. It has to access the database for that purpose....

Posted: Mon Aug 21, 2006 3:00 pm
by Azazel
Well I upgraded and now im recieving a Different Error.... Mind you That I copied exactly what the sticky had for setting up the table...

and I now recieve this error...

L 08/21/2006 - 15:58:09: [warcraft3FT.amxx Connected to MySQL database successful
Couldn't find option(s) with such variable (name "PlayerName")


Is this a Result of my having the Podbot Installed?

Posted: Mon Aug 21, 2006 4:39 pm
by Geesu
Not an error... ignore it

Posted: Mon Aug 21, 2006 11:24 pm
by Azazel
Thanks alot for the help.... It appears to be working but i havnt killed the server and reloaded it to make sure it is....