amxmodx 1.8.3 mysql not working at all

aron9forever · **Author**

I've been using 1.8.1 for a while just because it was always reliable and why fix something that's not broken

then yesterday I started writing my own votemapmenu and needed the blank space that increments another unit in the key value (new menu system) so to use menu_addblank2( menu ) I updated to amxx 1.8.3

biggest mistake ever

I started off by deleting the entire amxmodx folder. I'm on the test server so I don't give a crap
I copy everything from the base archive, then from the cstrike archive

I copy my 4 plugins and load them, edit modules.ini to enable mysql and well, surprise:

PHP Code:


			
[ 1] unknown unknown unknown bad load <-- mysql or sqlx

[ 2] FakeMeta 1.8.3-dev+ AMX Mod X Dev Teamrunning 

[ 3] Sockets 1.8.3-dev+ HLSW Dev Team running 

[ 4] CStrike 1.8.3-dev+ AMX Mod X Dev Teamrunning 

[ 5] Engine1.8.3-dev+ AMX Mod X Dev Teamrunning 

[ 6] RegEx 1.8.3-dev+ AMX Mod X Dev Teamrunning 

[ 7] Fun1.8.3-dev+ AMX Mod X Dev Teamrunning 

[ 8] Ham Sandwich1.8.3-dev+ AMX Mod X Dev Teamrunning 

8 modules, 7 correct

Since 3 out of my 4 plugins rely on sql you can imagine how pissed I was.
Tried everything but it's a no-go.
Replaced mysql_amxx_i386.so with the latest 1.8.1 one and it loads, kinda works but starts seg faulting on certain ocasions which still won't do it for me.

I'm running the latest dev build of 1.8.3 on engine 5787 with Metamod-P 1.21p37
no other plugins running except mine, not even the amxx defaults

what should I do? throw my static menu options (remove map / start vote) to the trash and go back to 1.8.1 or is there a way I can fix this?

ps: if your reply is "update to the latest engine build" then don't bother replying, we all know 5787 is the best valve will ever do

claudiuhks · *Last edited by claudiuhks; 02-28-2015 at 09:57.*

We have recently changed MySQL's WinSock dependency from WSock32.LIB to WS2_32.LIB.
That seems fine, it has nothing to do with this since SQLite's status is also "Bad Load".

Can you please add "+log on" to the server's command line (as a launch option) or "log on" inside server.cfg and copy-paste what Meta Mod says (either in server's console or in default log files that you can find in '%gamedir%/logs' directory)?

Meta Mod is reporting the problem exactly so we know how to further investigate.

**Arkshine** · 02-28-2015 , 09:55 Re: amxmodx 1.8.3 mysql not working at all

Having meta_debug to 3 should help too.

aron9forever · *Last edited by aron9forever; 02-28-2015 at 09:58.*

I have to run to the gym because it closes in 1 hour
but ill do it all when I return

any difference between +log on or log on in cfg? I have gamecp and I'd rather not change the params because they're global

also the server runs on centos

**Arkshine** · 02-28-2015 , 10:02 Re: amxmodx 1.8.3 mysql not working at all

Should make no difference.

Why people having trouble with server have always CentOS? lol.

JusTGo · 02-28-2015 , 10:23 Re: amxmodx 1.8.3 mysql not working at all

he is using out dated hlds lol amx 1.8.2 doesn't work on that hlds so how for amx 1.8.3 -_- update your hlds with steamcmd and seg fault shouldn't occur anymore.

claudiuhks · 02-28-2015 , 10:31 Re: amxmodx 1.8.3 mysql not working at all

Quote:

Originally Posted by JusTGo

he is using out dated hlds lol amx 1.8.2 doesn't work on that hlds so how for amx 1.8.3 -_- update your hlds with steamcmd and seg fault shouldn't occur anymore.

Yes, especially HamData.INI file. If they expect AMX Mod X 1.8.3 working well with their outdated HLDS build, they must use an old HamData.INI file.

JusTGo · 02-28-2015 , 10:33 Re: amxmodx 1.8.3 mysql not working at all

Quote:

Originally Posted by claudiuhks

Yes, especially HamData.INI file. If they expect AMX Mod X 1.8.3 working well with their outdated HLDS build, they must use an old HamData.INI file.

they use amx 1.8.2 dev24 that works fine i guess.

aron9forever · *Last edited by aron9forever; 02-28-2015 at 11:23.*

Quote:

Originally Posted by JusTGo

he is using out dated hlds lol amx 1.8.2 doesn't work on that hlds so how for amx 1.8.3 -_- update your hlds with steamcmd and seg fault shouldn't occur anymore.

seg fault occurs when using the mysql module from 1.8.1 with amxx 1.8.3, amxmodx 1.8.3 loads totally fine except the mysql module
1.8.2 was released as an emergency update for steampipe and as far as I know it's the only build that only runs on 6xxx

added log on and meta_debug 3 to server.cfg

Code:

Auto detecting CPU
Using Pentium II Optimised binary.
Enabling debug mode
Auto-restarting the server on crash

Console initialized.
Using breakpad crash handler
Setting breakpad minidump AppID = 10
Forcing breakpad minidump interfaces to load
Looking up breakpad interfaces from steamclient
Calling BreakpadMiniDumpSystemInit
Installing breakpad exception handler for appid(10)/version(5787)
scandir failed:/home/client4/service14/cs/SAVE
scandir failed:/home/client4/service14/cs/./valve/SAVE
scandir failed:/home/client4/service14/cs/./platform/SAVE
Protocol version 48
Exe version 1.1.2.7/Stdio (cstrike)
Exe build: 11:30:00 Aug 28 2012 (5787)
STEAM Auth Server

Server logging data to file logs/L0228137.log
L 02/28/2015 - 18:13:19: Log file started (file "logs/L0228137.log") (game "cstrike") (version "48/1.1.2.7/Stdio/5787")
L 02/28/2015 - 18:13:19: Server cvar "sv_contact" = "http://"
L 02/28/2015 - 18:13:19: Server cvar "sv_maxrate" = "50000"
L 02/28/2015 - 18:13:19: Server cvar "sv_minrate" = "10000"
L 02/28/2015 - 18:13:19: Server cvar "sv_stopspeed" = "75"
L 02/28/2015 - 18:13:19: Server cvar "max_queries_sec_global" = "***PROTECTED***"
L 02/28/2015 - 18:13:19: Server cvar "max_queries_sec" = "***PROTECTED***"
L 02/28/2015 - 18:13:19: Server cvar "sv_region" = "1"
L 02/28/2015 - 18:13:19: Server cvar "mp_consistency" = "0"
L 02/28/2015 - 18:13:19: Log file closed
Server logging data to file logs/L0228138.log
L 02/28/2015 - 18:13:19: Log file started (file "logs/L0228138.log") (game "cstrike") (version "48/1.1.2.7/Stdio/5787")
Alias name is invalid
Alias name is invalid
Alias name is invalid
   
   Metamod version 1.21p37 Copyright (c) 2001-2013 Will Day
     Patch: Metamod-P (mm-p) v37 Copyright (c) 2004-2013 Jussi Kivilinna
   Metamod comes with ABSOLUTELY NO WARRANTY; for details type `meta gpl'.
   This is free software, and you are welcome to redistribute it
   under certain conditions; type `meta gpl' for details.
   
L 02/28/2015 - 18:13:19: [META] Metamod v1.21p37  2013/05/30
L 02/28/2015 - 18:13:19: [META] by Will Day
L 02/28/2015 - 18:13:19: [META]    http://www.metamod.org/
L 02/28/2015 - 18:13:19: [META]  Patch: Metamod-P (mm-p) v37
L 02/28/2015 - 18:13:19: [META]  by Jussi Kivilinna
L 02/28/2015 - 18:13:19: [META]     http://metamod-p.sourceforge.net/
L 02/28/2015 - 18:13:19: [META] compiled: May 30 2013, 11:41:16 EET (optimized)
L 02/28/2015 - 18:13:19: [META] Recognized game 'cstrike'; using dllfile 'cs_i386.so'
L 02/28/2015 - 18:13:19: [META] Game DLL for 'Counter-Strike' loaded successfully
L 02/28/2015 - 18:13:19: [META] ini: Begin reading plugins list: /home/client4/service14/cs/cstrike/addons/metamod/plugins.ini
L 02/28/2015 - 18:13:19: [META] ini: Read plugin config for: <amxmodx_mm_i386.so>
L 02/28/2015 - 18:13:19: [META] ini: Finished reading plugins list: /home/client4/service14/cs/cstrike/addons/metamod/plugins.ini; Found 1 plugins to load
L 02/28/2015 - 18:13:19: [META] dll: Loading plugins...

   AMX Mod X version 1.8.3-dev+4627 Copyright (c) 2004-2014 AMX Mod X Development Team 
   AMX Mod X comes with ABSOLUTELY NO WARRANTY; for details type `amxx gpl'.
   This is free software and you are welcome to redistribute it under 
   certain conditions; type 'amxx gpl' for details.
  
L 02/28/2015 - 18:13:19: [META] dll: Loaded plugin 'AMX Mod X': AMX Mod X v1.8.3-dev+4627 Feb 20 2015, AMX Mod X Dev Team
L 02/28/2015 - 18:13:19: [META] dll: Finished loading 1 plugins
scandir failed:/home/client4/service14/cs/SAVE
scandir failed:/home/client4/service14/cs/./valve/SAVE
scandir failed:/home/client4/service14/cs/./platform/SAVE
L 02/28/2015 - 18:13:19: Log file closed
Server logging data to file logs/L0228139.log
L 02/28/2015 - 18:13:19: Log file started (file "logs/L0228139.log") (game "cstrike") (version "48/1.1.2.7/Stdio/5787")
L 02/28/2015 - 18:13:19: Loading map "jail_xmf"
L 02/28/2015 - 18:13:19: Server cvars start
L 02/28/2015 - 18:13:19: Server cvars end
L 02/28/2015 - 18:13:19: -------- Mapchange to jail_xmf --------
L 02/28/2015 - 18:13:19: [META] dll: Loaded plugin 'FakeMeta': FakeMeta v1.8.3-dev+4627 Feb 17 2015, AMX Mod X Dev Team
L 02/28/2015 - 18:13:19: [META] dll: Loaded plugin 'CStrike': CStrike v1.8.3-dev+4627 Feb 17 2015, AMX Mod X Dev Team
L 02/28/2015 - 18:13:19: [CSTRIKE] GiveShield is not available
L 02/28/2015 - 18:13:19: [CSTRIKE] GiveNamedItem is not available
L 02/28/2015 - 18:13:19: [CSTRIKE] AddAccount is not available
L 02/28/2015 - 18:13:19: [CSTRIKE] Some functions are not available - forward CS_OnBuyAttempt and CS_OnBuy have been disabled
L 02/28/2015 - 18:13:19: [CSTRIKE] CREATE_NAMED_ENITTY is not available - native cs_create_entity() has been disabled
L 02/28/2015 - 18:13:19: [CSTRIKE] UTIL_FindEntByString is not available - native cs_find_ent_by_class() has been disabled
L 02/28/2015 - 18:13:19: [META] dll: Loaded plugin 'Engine': Engine v1.8.3-dev+4627 Feb 17 2015, AMX Mod X Dev Team
L 02/28/2015 - 18:13:19: [META] dll: Loaded plugin 'Fun': Fun v1.8.3-dev+4627 Feb 17 2015, AMX Mod X Dev Team
L 02/28/2015 - 18:13:19: [META] WARNING: Failed to find memloc for regcmd 'ham'
L 02/28/2015 - 18:13:19: [META] dll: Loaded plugin 'Ham Sandwich': Ham Sandwich v1.8.3-dev+4627 Feb 17 2015, AMX Mod X Dev Team
L 02/28/2015 - 18:13:19: Server cvar "amxmodx_version" = "1.8.3-dev+4627"
L 02/28/2015 - 18:13:19: [AMXX] Plugin "r4ge-auth.amxx" failed to load: Module/Library Class "sqlx" required for plugin.  Check modules.ini.
L 02/28/2015 - 18:13:19: [AMXX] Plugin "r4ge-admincmd.amxx" failed to load: Module/Library Class "sqlx" required for plugin.  Check modules.ini.
L 02/28/2015 - 18:13:19: [AMXX] Plugin "r4ge-player-activity.amxx" failed to load: Module/Library Class "sqlx" required for plugin.  Check modules.ini.
L 02/28/2015 - 18:13:19: Server cvar "sv_maxspeed" = "900"
L 02/28/2015 - 18:13:19: Server cvar "pausable" = "0"
should be downloading the check file
Looking up breakpad interfaces from steamclient
Calling BreakpadMiniDumpSystemInit
L 02/28/2015 - 18:13:19: Server cvar "sv_accelerate" = "5"
L 02/28/2015 - 18:13:19: Started map "jail_xmf" (CRC "174492096")

L 02/28/2015 - 18:13:19: Log file closed
Server logging data to file logs/L0228140.log
L 02/28/2015 - 18:13:19: Log file started (file "logs/L0228140.log") (game "cstrike") (version "48/1.1.2.7/Stdio/5787")
L 02/28/2015 - 18:13:19: Log file closed
Server logging data to file logs/L0228141.log
L 02/28/2015 - 18:13:19: Log file started (file "logs/L0228141.log") (game "cstrike") (version "48/1.1.2.7/Stdio/5787")
Connection to Steam servers successful.
   VAC secure mode is activated.
L 02/28/2015 - 18:13:27: World triggered "Round_Start"
amxx modules
Currently loaded modules:
      name                    version     author               status     
 [ 1] unknown                 unknown     unknown              bad load   
 [ 2] FakeMeta                1.8.3-dev+  AMX Mod X Dev Team   running    
 [ 3] Sockets                 1.8.3-dev+  HLSW Dev Team        running    
 [ 4] CStrike                 1.8.3-dev+  AMX Mod X Dev Team   running    
 [ 5] Engine                  1.8.3-dev+  AMX Mod X Dev Team   running    
 [ 6] RegEx                   1.8.3-dev+  AMX Mod X Dev Team   running    
 [ 7] Fun                     1.8.3-dev+  AMX Mod X Dev Team   running    
 [ 8] Ham Sandwich            1.8.3-dev+  AMX Mod X Dev Team   running    
8 modules, 7 correct

Code:

L 02/28/2015 - 18:13:19: [META] dll: Loaded plugin 'FakeMeta': FakeMeta v1.8.3-dev+4627 Feb 17 2015, AMX Mod X Dev Team
L 02/28/2015 - 18:13:19: [META] dll: Loaded plugin 'CStrike': CStrike v1.8.3-dev+4627 Feb 17 2015, AMX Mod X Dev Team
L 02/28/2015 - 18:13:19: [META] dll: Loaded plugin 'Engine': Engine v1.8.3-dev+4627 Feb 17 2015, AMX Mod X Dev Team
L 02/28/2015 - 18:13:19: [META] dll: Loaded plugin 'Fun': Fun v1.8.3-dev+4627 Feb 17 2015, AMX Mod X Dev Team
L 02/28/2015 - 18:13:19: [META] WARNING: Failed to find memloc for regcmd 'ham'
L 02/28/2015 - 18:13:19: [META] dll: Loaded plugin 'Ham Sandwich': Ham Sandwich v1.8.3-dev+4627 Feb 17 2015, AMX Mod X Dev Team

fysiks · 02-28-2015 , 11:34 Re: amxmodx 1.8.3 mysql not working at all

tl;dr did you try using the correct version of Metamod?