Raised This Month: $ Target: $400
 0% 

MYSQL error? or amxbans? help pls


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
volodoy
Junior Member
Join Date: Oct 2009
Old 10-20-2010 , 15:54   MYSQL error? or amxbans? help pls
Reply With Quote #1

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 - 171:52: Start of error session.
L 10/19/2010 - 171:52: Info (map "de_dust") (file "addons/amxmodx/logs/error_20101019.log")
L 10/19/2010 - 171:52: [MySQL] Invalid handle: 0
L 10/19/2010 - 171:52: [AMXX] Run time error 10 (plugin "amxbans.amxx") (native "SQL_FreeHandle") - debug not enabled!
L 10/19/2010 - 171: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...

Last edited by volodoy; 10-20-2010 at 16:45.
volodoy is offline
Exolent[jNr]
Veteran Member
Join Date: Feb 2007
Location: Tennessee
Old 10-20-2010 , 15:57   Re: MYSQL error? or amxbans? help pls
Reply With Quote #2

Post on AMXBans website: http://www.amxbans.net/
__________________
No private work or selling mods.
Quote:
Originally Posted by xPaw View Post
I love you exolent!
Exolent[jNr] is offline
YamiKaitou
Has a lovely bunch of coconuts
Join Date: Apr 2006
Location: Texas
Old 10-20-2010 , 15:58   Re: MYSQL error? or amxbans? help pls
Reply With Quote #3

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
__________________
ProjectYami Laboratories

I do not browse the forums regularly anymore. If you need me for anything (asking questions or anything else), then PM me (be descriptive in your PM, message containing only a link to a thread will be ignored).
YamiKaitou is offline
Exolent[jNr]
Veteran Member
Join Date: Feb 2007
Location: Tennessee
Old 10-20-2010 , 16:08   Re: MYSQL error? or amxbans? help pls
Reply With Quote #4

Quote:
Originally Posted by YamiKaitou View Post
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.
__________________
No private work or selling mods.
Quote:
Originally Posted by xPaw View Post
I love you exolent!
Exolent[jNr] is offline
volodoy
Junior Member
Join Date: Oct 2009
Old 10-20-2010 , 16:30   Re: MYSQL error? or amxbans? help pls
Reply With Quote #5

Quote:
Originally Posted by YamiKaitou View Post
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..."
volodoy is offline
Styles
Veteran Member
Join Date: Jul 2004
Location: California
Old 10-20-2010 , 16:31   Re: MYSQL error? or amxbans? help pls
Reply With Quote #6

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 ).
Styles is offline
Send a message via AIM to Styles
volodoy
Junior Member
Join Date: Oct 2009
Old 10-20-2010 , 16:37   Re: MYSQL error? or amxbans? help pls
Reply With Quote #7

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
volodoy is offline
Exolent[jNr]
Veteran Member
Join Date: Feb 2007
Location: Tennessee
Old 10-20-2010 , 17:26   Re: MYSQL error? or amxbans? help pls
Reply With Quote #8

Remove dproto.
__________________
No private work or selling mods.
Quote:
Originally Posted by xPaw View Post
I love you exolent!
Exolent[jNr] is offline
volodoy
Junior Member
Join Date: Oct 2009
Old 10-21-2010 , 02:27   Re: MYSQL error? or amxbans? help pls
Reply With Quote #9

without dproto itīs same
volodoy is offline
Exolent[jNr]
Veteran Member
Join Date: Feb 2007
Location: Tennessee
Old 10-21-2010 , 02:40   Re: MYSQL error? or amxbans? help pls
Reply With Quote #10

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
__________________
No private work or selling mods.
Quote:
Originally Posted by xPaw View Post
I love you exolent!
Exolent[jNr] is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:24.


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