Database Connection Failed

Azazel · Post by **Azazel** » Mon Aug 21, 2006 3:52 am

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 <[email protected]>

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)

Post by **YamiKaitou** » Mon Aug 21, 2006 7:51 am

Upgrade your AmxX. v1.60 does not connect to MySQL v5

Azazel · Post by **Azazel** » Mon Aug 21, 2006 1:28 pm

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....

Azazel · Post by **Azazel** » Mon Aug 21, 2006 3:00 pm

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?

Post by **Geesu** » Mon Aug 21, 2006 4:39 pm

Not an error... ignore it

Azazel · Post by **Azazel** » Mon Aug 21, 2006 11:24 pm

Thanks alot for the help.... It appears to be working but i havnt killed the server and reloaded it to make sure it is....