AlliedModders
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

AlliedModders (https://forums.alliedmods.net/index.php)
-   General (https://forums.alliedmods.net/forumdisplay.php?f=7)
-   -   amxmodx 1.8.3 mysql not working at all (https://forums.alliedmods.net/showthread.php?t=259078)

aron9forever 02-28-2015 09:41
amxmodx 1.8.3 mysql not working at all
 
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 02-28-2015 09:49
Re: amxmodx 1.8.3 mysql not working at all
 
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 02-28-2015 09:57
Re: amxmodx 1.8.3 mysql not working at all
 
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 (Post 2267831)
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 (Post 2267835)
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 02-28-2015 11:20
Re: amxmodx 1.8.3 mysql not working at all
 
Quote:
Originally Posted by JusTGo (Post 2267831)
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?


All times are GMT -4. The time now is 13:03.
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.