AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Off-Topic (https://forums.alliedmods.net/forumdisplay.php?f=15)
-   -   MYSQL error? or amxbans? help pls (https://forums.alliedmods.net/showthread.php?t=141192)

volodoy 10-20-2010 15:54

MYSQL error? or amxbans? help pls
 
Hi, I have this problem for few months already... It happens almost every day, sometimes even 5-6 times in one day, and i must still turn server on because it crash all the time due to this error:

L 10/19/2010 - 17:31:52: Start of error session.
L 10/19/2010 - 17:31:52: Info (map "de_dust") (file "addons/amxmodx/logs/error_20101019.log")
L 10/19/2010 - 17:31:52: [MySQL] Invalid handle: 0
L 10/19/2010 - 17:31:52: [AMXX] Run time error 10 (plugin "amxbans.amxx") (native "SQL_FreeHandle") - debug not enabled!
L 10/19/2010 - 17:31:52: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes).


When I add "debug" there is still another error....

L 10/20/2010 - 20:21:12: Start of error session.
L 10/20/2010 - 20:21:12: Info (map "de_dust") (file "addons/amxmodx/logs/error_20101020.log")
L 10/20/2010 - 20:21:12: [MySQL] Invalid handle: 0
L 10/20/2010 - 20:21:12: [AMXX] Displaying debug trace (plugin "amxbans.amxx")
L 10/20/2010 - 20:21:12: [AMXX] Run time error 10: native error (native "SQL_FreeHandle")
L 10/20/2010 - 20:21:12: [AMXX] [0] amxbans.sma::plugin_end (line 621)


btw. I have another server on the same machine with same database and same amxbans, without problems..thats strange.. Itīs amxbans 5.1, server running on linux

Help me pls... Anyone know what the fark is wrong with this?
Thank you...

Exolent[jNr] 10-20-2010 15:57

Re: MYSQL error? or amxbans? help pls
 
Post on AMXBans website: http://www.amxbans.net/

YamiKaitou 10-20-2010 15:58

Re: MYSQL error? or amxbans? help pls
 
It is a MySQL connection issue, nothing to do with AMXBans. The server does not initiate the connection. Check the AMXX Logs (not error logs) to see if there is other information in there

Exolent[jNr] 10-20-2010 16:08

Re: MYSQL error? or amxbans? help pls
 
Quote:

Originally Posted by YamiKaitou (Post 1330414)
It is a MySQL connection issue, nothing to do with AMXBans. The server does not initiate the connection. Check the AMXX Logs (not error logs) to see if there is other information in there

Yes, but it still has to do with the AMXBans code. It obviously isn't fail-safe.

volodoy 10-20-2010 16:30

Re: MYSQL error? or amxbans? help pls
 
Quote:

Originally Posted by YamiKaitou (Post 1330414)
It is a MySQL connection issue, nothing to do with AMXBans. The server does not initiate the connection. Check the AMXX Logs (not error logs) to see if there is other information in there

if it was MySQL connection issue, the second server will crash too, or not? but it does not

amxbans.org will tell me "we do not support 5.X version anymore..."

Styles 10-20-2010 16:31

Re: MYSQL error? or amxbans? help pls
 
Lol i found like 5 issues already in the new version released. So fail not even worth talking about.

I would be ashamed to be them. (I only looked at the WebGUI part not yours Yami :)).

volodoy 10-20-2010 16:37

Re: MYSQL error? or amxbans? help pls
 
I use amxbans 5.1, not the new version

i checked those logs, dunno if this is normal or not..

Code:

L 10/20/2010 - 20:21:11: [META] dll: Loaded plugin 'dproto': dproto v0.8.68 2010-08-04, Crock
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Not loading plugin 'MySQL'; already loaded (status=running)
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Failed to load plugin 'mysql_amxx_i386.so'
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Not loading plugin 'SQLite'; already loaded (status=running)
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Failed to load plugin 'sqlite_amxx_i386.so'
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Not loading plugin 'Fun'; already loaded (status=running)
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Failed to load plugin 'fun_amxx_i386.so'
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Not loading plugin 'Engine'; already loaded (status=running)
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Failed to load plugin 'engine_amxx_i386.so'
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Not loading plugin 'FakeMeta'; already loaded (status=running)
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Failed to load plugin 'fakemeta_amxx_i386.so'
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Not loading plugin 'CStrike'; already loaded (status=running)
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Failed to load plugin 'cstrike_amxx_i386.so'
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Not loading plugin 'CSX'; already loaded (status=running)
L 10/20/2010 - 20:21:11: [META] ERROR: dll: Failed to load plugin 'csx_amxx_i386.so'
L 10/20/2010 - 20:21:11: [META] dll: Finished loading 2 plugins


Exolent[jNr] 10-20-2010 17:26

Re: MYSQL error? or amxbans? help pls
 
Remove dproto.

volodoy 10-21-2010 02:27

Re: MYSQL error? or amxbans? help pls
 
without dproto itīs same

Exolent[jNr] 10-21-2010 02:40

Re: MYSQL error? or amxbans? help pls
 
Show the complete and unedited output of the following commands:
rcon meta version
rcon meta list
rcon version

Also, provide the contents of the following files:
addons/metamod/plugins.ini
addons/amxmodx/modules.ini


All times are GMT -4. The time now is 09:25.

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