MySQL Problems in v2.2.5

WOG · Post by **WOG** » Fri Aug 19, 2005 9:11 pm

In my lan listenserver im getting an error identical to this one viewtopic.php?t=273 except that i am using the local host

when the server runs the menu to choose races doesnt pop up.

this server is running the install package for war3ft v2.2.5 you have with amx and amxx 1.5 included

i am getting the following feedback from Counterstrike:

Code: Select all

L 08/19/2005 - 22:42:06: [AMXX] [MYSQL] Invalid database handle -1
L 08/19/2005 - 22:42:06: [AMXX] Displaying call trace (plugin "cstrike\addons\amxmodx\plugins\warcraft3FT.amxx")
L 08/19/2005 - 22:42:06: [AMXX]    [0] XP.inl::XP_Set_DBI (line 565)
L 08/19/2005 - 22:42:06: [AMXX]    [1] XP.inl::XP_Retreive (line 341)
L 08/19/2005 - 22:42:06: [AMXX]    [2] war3ft.inl::WAR3_chooserace (line 206)
L 08/19/2005 - 22:42:06: [AMXX]    [3] other.inl::getuserinput (line 151)

now what really has me miffed is that i have another server with war3FT v2.2.3 (the server install with the included amx and amxx) with the EXACT same setup for mysql in the config file on this same machine and i dont get any errors (im not running it at the same time)

my server is running as a listenserver on a

Code: Select all

2.4Ghz P4
640Mb of RAM
WindowsXP SP2
MySQL 4.1

in my war3ft.cfg file i have the setup

Code: Select all

// MySQL configuration
FT_mysql_host		"127.0.0.1"	// Host Name
FT_mysql_user		"amx"		// User Name
FT_mysql_pass		"wogger"		// Password
FT_mysql_db		"amx"		// Database Name
sv_mysql_auto_pruning	0		// Automatically prunes the database of old users at a mapchange occuring between 5:36 to 5:59 AM (default is 0, doesn't work for vault)
sv_daysbeforedelete	31		// However many days before deleting XP or pruning from MySQL database (default is 31)
sv_mysqltablename	"war3users"	// Table Name, no need to change (default is war3users)
sv_mysql_save_end_round 0		// Save Users at the end of each round (causes slight lag, default is 0)
FT_disable_savexp	0		// Set this to 1 to disable users typing /savexp (default is 0)

running all the checks you asked for i get the following data:

Code: Select all

] status
hostname:  Counter-Strike
version :  47/1.1.2.5/2.0.0.0 3213 insecure
tcp/ip  :  192.168.1.100:27015
map     :  cs_assault_upc at: 528 x, 144 y, 53 z
players :  1 active (32 max)

#      name userid uniqueid frag time ping loss adr
# 1 "+]-[+WOG+" 1 STEAM_ID_LAN   0 00:21    0    0 loopback
1 users
Type 'amx_langmenu' in the console to display a menu where you can choose your language
] cdversion
Unknown command: 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] POD-Bot mm       RUN   -    podbot_mm.dll     vR2b46d   ini   Chlvl ANY  
 [ 3] Fun              RUN   -    fun_amxx.dll      v1.50     pl1   ANY   ANY  
 [ 4] Engine           RUN   -    engine_amxx.dll   v1.50     pl1   ANY   ANY  
 [ 5] FakeMeta         RUN   -    fakemeta_amxx.dl  v1.50     pl1   ANY   ANY  
 [ 6] MySQL            RUN   -    mysql_amxx.dll    v1.50     pl1   ANY   ANY  
 [ 7] CStrike          RUN   -    cstrike_amxx.dll  v1.50     pl1   ANY   ANY  
 [ 8] CSX              RUN   -    csx_amxx.dll      v1.50     pl1   ANY   ANY  
 [ 9] War3ft           RUN   -    war3ft_amxx.dll   v2.2.5    pl1   ANY   ANY  
9 plugins, 9 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
Type 'amx_help' in the console to see available commands
Time Left: 19:41 min. Next Map: de_airstrip
] 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         1.50     AMXX Dev Team     admin.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] Maps Menu          1.50     AMXX Dev Team     mapsmenu.amxx    running  
 [ 10] Admin Chat         1.50     AMXX Dev Team     adminchat.amxx   running  
 [ 11] Anti Flood         1.50     AMXX Dev Team     antiflood.amxx   running  
 [ 12] Scrolling Message  1.50     AMXX Dev Team     scrollmsg.amxx   running  
 [ 13] Info. Messages     1.50     AMXX Dev Team     imessage.amxx    running  
 [ 14] Admin Votes        1.50     AMXX Dev Team     adminvote.amxx   running  
 [ 15] NextMap            1.50     AMXX Dev Team     nextmap.amxx     running  
 [ 16] Nextmap Chooser    1.50     AMXX Dev Team     mapchooser.amxx  running  
 [ 17] TimeLeft           1.50     AMXX Dev Team     timeleft.amxx    running  
 [ 18] Pause Plugins      1.50     AMXX Dev Team     pausecfg.amxx    running  
 [ 19] Stats Configurati  1.50     AMXX Dev Team     statscfg.amxx    running  
 [ 20] StatsX             1.50     AMXX Dev Team     statsx.amxx      running  
 [ 21] CS Misc. Stats     1.50     AMXX Dev Team     miscstats.amxx   running  
 [ 22] CS Stats Logging   1.50     AMXX Dev Team     stats_logging.a  running  
 [ 23] AMX Bank           1.5      twistedeuphoria   amx_bank.amxx    running  
 [ 24] Warcraft 3 Frozen  2.2.5    Pimp Daddy (OoTO  warcraft3FT.amx  debug    
24 plugins, 24 running
This server is using AMX Mod X
Visit http://www.amxmodx.org

again i have another server on this computer which usues the same SQL information but encounters no errors. the only difference in the two is the version of amx mod x and war3ft

the error doesnt allow users to acess that race menu

Thanks for your time i hope i didnt miss anything obvious.
-WOG

WOG · Post by **WOG** » Sun Aug 21, 2005 11:57 am

An update on this i still am getting the same problems of the error messages and no race menu with the podbot module removed

Post by **Geesu** » Sun Aug 21, 2005 1:29 pm

It's not a war3ft error....

The database connection is never made...

L 08/19/2005 - 22:42:06: [AMXX] [MYSQL] Invalid database handle -1

Are you running mysql 4.0 or 4.1?

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

im getting that

Code: Select all

[AMXX] [MYSQL] Invalid database handle -1

error as well and im using 4.1.

WOG · Post by **WOG** » Sun Aug 21, 2005 5:15 pm

MySQL 4.1

but what really bugs me is that using the same user and password and an older version of both amxx and war3ft i dont get the error.

the mysql server was set up using the tutorial from your site and worked fine with v2.2.3 and the included version of amxx

ive checked many times and all the SQL access information is the same in the 2.2.5 server as in the working v2.2.3 server (their not running at the same time im trying to transition over to the new one. their both on the same computer)

Post by **Lazarus Long** » Sun Aug 21, 2005 6:01 pm

OK, guys:

Read this thread please.

The problem will probably go away in the next version of AMX Mod X, the MySQL modules suffer from a small build error that can cause this to be more frequent than it was before. The AMX Mod X authors are aware and will have it fixed in the next build.

(by the way, this was asked and replied before, so please do use the search)

Regards,

WOG · Post by **WOG** » Sun Aug 21, 2005 6:25 pm

that doesnt really help me as i have installed the new sql support on both servers already. the older for the other server when i set it up and the newer on this one in the past week.

i got the "[AMXX] SQL error: can't connect: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client'" the time i first installed v2.2.1 i think. it was about half a year ago. anyways i searched the forum and found the answers that time.

but no such luck this time

that fix doesnt seem to help in this situation. if anyone has any ideas or can point out something i have overlooked that would be aprecciated

Post by **Lazarus Long** » Sun Aug 21, 2005 7:08 pm

WOG:

WOG wrote:that fix doesnt seem to help in this situation. if anyone has any ideas or can point out something i have overlooked that would be aprecciated

OK, I gave you that link 'cause I summarized your options in a post I made in the thread, it's odd you didn't find it, 'cause it's the longest post in there.

The situation is that the authentication protocol has changed from MySQL 4.0.x to 4.1.x so, what the server is telling you is that you must update your MySQL AMX Mod X modules with the SQL Modules package.

Now there is another situation here, the AMX Mod X 1.50 version is beta so it's not perfect. As I stated above the MySQL modules suffered from a small mistake when they were built, the headers and libraries used are from different versions, the authors are aware of it and the next release will fix this, so if you are one of the unlucky ones that get the error due to that you'll have to be patient.

Regards,

WOG · Post by **WOG** » Sun Aug 21, 2005 7:47 pm

the server is updated with the SQL modules package already.

i geuss ill have to wait for their fix then.

thanks for all your help and patience

Post by **Lazarus Long** » Sun Aug 21, 2005 10:16 pm

Have a look at Geesu's post regarding this.

iwatchyou0 · Post by **iwatchyou0** » Mon Aug 22, 2005 12:02 am

sigh. i must be very unlucky.

Post by **Geesu** » Mon Aug 22, 2005 7:13 am

WOG, the sql package download that was on their site is wrong... Either wait for my release, or see the sticky in this section.

It was compiled for 4.0 by mistake instead of for 4.1 (in the amxx downloads)

iwatchyou0 · Post by **iwatchyou0** » Mon Aug 22, 2005 12:10 pm

Geesu, i get a "failed to initialize error" when ever i try to start my dedicated server using your module.

Post by **Geesu** » Mon Aug 22, 2005 1:24 pm

OK, wait for the official amxx release then.. There should be a new release soon

iwatchyou0 · Post by **iwatchyou0** » Mon Aug 22, 2005 4:33 pm

alright cool. thanks for trying to help out.

WOG · Post by **WOG** » Mon Aug 22, 2005 6:35 pm

thanks. i hope i can start using the new amxx on my server soon