mySQL Errors v2.2.5

iwatchyou0 · Post by **iwatchyou0** » Sun Aug 21, 2005 3:56 pm

So I found the setting up mysql tutorial and i was getting some "stuff" in the console. (This is when the FT savexp vars were on).

Code: Select all

 
[AMXX] SQL error: can't connect: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client'
[AMXX] Loaded 2 admins from file
L 08/21/2005 - 14:48:31: [AMXX] [MYSQL] Invalid database handle -1
L 08/21/2005 - 14:48:31: [AMXX] Displaying call trace (plugin "cstrike\addons\amxmodx\plugins\warcraft3FT.amxx")
L 08/21/2005 - 14:48:31: [AMXX]    [0] XP.inl::XP_Set_DBI (line 565)
L 08/21/2005 - 14:48:31: [AMXX]    [1] war3ft.inl::WAR3_Set_Variables (line 1228)

It is a Windows Dedicated Server. Running Windows XP Professional Edition SP 1. Here is the plugins running etc.

Code: Select all

] status
hostname:  Ms. Wonderful
version :  47/1.1.2.5 3213 insecure
tcp/ip  :  192.168.1.100:27015
map     :  de_cbble at: 0 x, 0 y, 0 z
players :  0 active (10 max)

#      name userid uniqueid frag time ping loss adr
0 users
] cdversion
] meta version
Metamod v1.18p24  2005/07/12
by Will Day
   http://www.metamod.org/
 Patch: Metamod-P (mm-p) v24
 by Jussi Kivilinna
    http://koti.mbnet.fi/axh/
compiled: Jul 12 2005, 19:35:43 EET (optimized)
] meta list
Currently loaded plugins:
      description      stat pend  file              vers      src   load  unlod
 [ 1] AMX Mod X        RUN   -    amxmodx_mm.dll    v1.50     ini   ANY   ANY  
 [ 2] Fun              RUN   -    fun_amxx.dll      v1.50     pl1   ANY   ANY  
 [ 3] Engine           RUN   -    engine_amxx.dll   v1.50     pl1   ANY   ANY  
 [ 4] FakeMeta         RUN   -    fakemeta_amxx.dl  v1.50     pl1   ANY   ANY  
 [ 5] MySQL            RUN   -    mysql_amxx.dll    v1.50     pl1   ANY   ANY  
 [ 6] CStrike          RUN   -    cstrike_amxx.dll  v1.50     pl1   ANY   ANY  
 [ 7] CSX              RUN   -    csx_amxx.dll      v1.50     pl1   ANY   ANY  
 [ 8] War3ft           RUN   -    war3ft_amxx.dll   v2.2.5    pl1   ANY   ANY  
8 plugins, 8 running
] amxx version
AMX Mod X 1.50
Authors: Felix "SniperBeamer" Geyer, David "BAILOPAN" Anderson, Pavol "PM OnoTo" Marko, Jonny "Got His Gun" Bergstrom, and Lukasz "SidLuke" Wlasinski.  (http://www.amxmodx.org)
Compiled: Aug  2 2005, 02:39:17
Core mode: JIT+ASM32
] amxx modules
Currently loaded modules:
      name                    version  author               status     
 [ 1] Fun                     1.50     AMX Mod X Dev Team   running    
 [ 2] Engine                  1.50     AMX Mod X Dev Team   running    
 [ 3] FakeMeta                1.50     AMX Mod X Dev Team   running    
 [ 4] MySQL                   1.50     AMX Mod X Dev Team   running    
 [ 5] CStrike                 1.50     AMX Mod X Dev Team   running    
 [ 6] CSX                     1.50     AMX Mod X Dev Team   running    
 [ 7] War3ft                  2.2.5    Geesu (Pimp Daddy)   running    
7 modules, 7 correct
] amxx plugins
Currently loaded plugins:
       name               version  author            file             status   
 [  1] Admin Base (SQL)   1.50     AMXX Dev Team     admin_sql.amxx   running  
 [  2] Admin Commands     1.50     AMXX Dev Team     admincmd.amxx    running  
 [  3] Admin Help         1.50     AMXX Dev Team     adminhelp.amxx   running  
 [  4] Slots Reservation  1.50     AMXX Dev Team     adminslots.amxx  running  
 [  5] Multi-Lingual Sys  1.50     AMXX Dev Team     multilingual.am  running  
 [  6] Menus Front-End    1.50     AMXX Dev Team     menufront.amxx   running  
 [  7] Commands Menu      1.50     AMXX Dev Team     cmdmenu.amxx     running  
 [  8] Players Menu       1.50     AMXX Dev Team     plmenu.amxx      running  
 [  9] Teleport Menu      1.50     AMXX Dev Team     telemenu.amxx    running  
 [ 10] Maps Menu          1.50     AMXX Dev Team     mapsmenu.amxx    running  
 [ 11] Admin Chat         1.50     AMXX Dev Team     adminchat.amxx   running  
 [ 12] Anti Flood         1.50     AMXX Dev Team     antiflood.amxx   running  
 [ 13] Scrolling Message  1.50     AMXX Dev Team     scrollmsg.amxx   running  
 [ 14] Info. Messages     1.50     AMXX Dev Team     imessage.amxx    running  
 [ 15] Admin Votes        1.50     AMXX Dev Team     adminvote.amxx   running  
 [ 16] NextMap            1.50     AMXX Dev Team     nextmap.amxx     running  
 [ 17] Nextmap Chooser    1.50     AMXX Dev Team     mapchooser.amxx  running  
 [ 18] TimeLeft           1.50     AMXX Dev Team     timeleft.amxx    running  
 [ 19] Pause Plugins      1.50     AMXX Dev Team     pausecfg.amxx    running  
 [ 20] Stats Configurati  1.50     AMXX Dev Team     statscfg.amxx    running  
 [ 21] Restrict Weapons   1.50     AMXX Dev Team     restmenu.amxx    running  
 [ 22] StatsX             1.50     AMXX Dev Team     statsx.amxx      running  
 [ 23] CS Misc. Stats     1.50     AMXX Dev Team     miscstats.amxx   running  
 [ 24] CS Stats Logging   1.50     AMXX Dev Team     stats_logging.a  running  
 [ 25] Warcraft 3 Frozen  2.2.5    Pimp Daddy (OoTO  warcraft3FT.amx  debug    
25 plugins, 25 running

also reguarding

Code: Select all

[AMXX] SQL error: can't connect: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client'
[AMXX] Loaded 2 admins from file

do you know what ip or whatever am i supposed to allow to access the database. is it the ip i get at sites like whatismyip.com? please help me out and thanks.

Post by **Lazarus Long** » Sun Aug 21, 2005 5:55 pm

Hello, iwatchyou0:

OK, follow this thread since I posted some info that summarises your options and will help you out.

Cheers,

iwatchyou0 · Post by **iwatchyou0** » Sun Aug 21, 2005 8:13 pm

i did that. still getting this

Code: Select all

L 08/21/2005 - 19:09:31: [AMXX] [MYSQL] Invalid database handle -1
L 08/21/2005 - 19:09:31: [AMXX] Displaying call trace (plugin "cstrike\addons\amxmodx\plugins\warcraft3FT.amxx")
L 08/21/2005 - 19:09:31: [AMXX]    [0] XP.inl::XP_Set_DBI (line 565)
L 08/21/2005 - 19:09:31: [AMXX]    [1] war3ft.inl::WAR3_Set_Variables (line 1228)

Post by **Geesu** » Sun Aug 21, 2005 8:32 pm

http://amxmodx.org/forums/viewtopic.php?t=17566

You need the new mysql module

iwatchyou0 · Post by **iwatchyou0** » Sun Aug 21, 2005 8:56 pm

alright testing out now.
(btw , i love the support on this forum

)

iwatchyou0 · Post by **iwatchyou0** » Sun Aug 21, 2005 9:28 pm

After i replaced the modules when ever i start up hlds or do it in gui mode i get this error. HLDS Launcher has encountered a prolem and needs to close. We are sorry for the inconvience. blah blah blah. help? ill see if its either the module or something else

//edit it was the module