UBan -- Global ban system. Ban users from all servers connected to a single DB!

[Dv2236]

new alittle annoying problem when i added this to the server, (edit ops i mean to say) i get this times error at random times "Timer Error: attempt to call a nil value"

[Darksoul]

ULib/modules/uban_ulx.lua:25: attempt to index global 'UBan' (a nil value)

Edit: restart fixed it.

[Darksoul]

Uban conflict?.

The exact error was: The following error has occured: Column 'serverip' cannot b
e null

Trace:
        1: Line 32      "Trace" includes/extensions/debug.lua
        2: Line 15      "errorHalt"     autorun/shared/StargateExtras.lua
        3: Line 17      "errorHalt"     autorun/shared/StargateExtras.lua
        4: Line 17      "errorHalt"     autorun/shared/StargateExtras.lua
        5: Line 17      "errorHalt"     autorun/shared/StargateExtras.lua
        6: Line 17      "errorHalt"     autorun/shared/StargateExtras.lua
        7: Line 17      "errorHalt"     autorun/shared/StargateExtras.lua
        8: Line 17      "errorHalt"     autorun/shared/StargateExtras.lua
        9: Line 17      "errorHalt"     autorun/shared/StargateExtras.lua
        10: Line 17     "errorHalt"     autorun/shared/StargateExtras.lua
        11: Line 17     "error" autorun/shared/StargateExtras.lua
        12: Line 49     "DoQuery"       autorun/server/uban.lua
        13: Line 158    "(null)"        autorun/server/uban.lua
        14: Line -1     ""      (tail call)
15      C function
        16: Line 25     "fn"    ULib/modules/uban_ulx.lua
        17: Line 159    "(null)"        ULib/shared/concommand.lua
18      C function
        19: Line 169    "PCallError"    includes\util.lua
        20: Line 82     "sv"    ULib/shared/concommand.lua
        21: Line 41     "?"     ULib/server/concommand.lua
        22: Line 62     "(null)"        includes/modules/concommand.lua
        23: Line -1     ""      (tail call)


The exact error was: UBan failure. Error is: autorun/shared/StargateExtras.lua:1
7: Column 'serverip' cannot be null
Dropped Darksoul from server (Kicked by Console :  Banned on global ban list)
removeid:  filter removed for STEAM_0:1:10592870

Server IP is a domain name, and it works on my other server just fine.

[JamminR]

From the first post, the SQL table for serverip must be an integer (ie #.#.#.#), not a domain name. (blah.blah.blah)
"serverip INT UNSIGNED NOT NULL,"

Not anywhere near sure that will fix all your problems, but I am 99% sure it won't hurt.

[Darksoul]

I use the domain name on my other server and it works fine. (Not disregarding your advice though, just saying..)

[Darksoul]

Does this no longer work?. I had to gbanid twice, it shows up twice in the list. And the guy was still able to rejoin. I had to manually ban him on the server banlist...

[Megiddo]

Should still work, it uses the srcds ban method.

[wilkisam]

Erm was I supposed to add localhost or keep it the same in the DB setup on the server?

[Megiddo]

What do you mean?

[wilkisam]

In the uban.lua at the top I edited the ip kinda number to "localhost" was I supposed to? when I try and ban myself I get this message in server console, "UBan failure. Error is: autorun/server/uban.lua:67: Unknown MySQL server host '123.456.789.012' (11004)
         Global ban failed! See server console for error."

[Megiddo]

You have to run a mysql server

[Darksoul]

Hello Megiddo,

I've been having random lag spikes for over a month now. I've never caught the actual error but today I had HLSW open when it happened and caught it.

The lag is around 16-20 seconds at a time and then it's back to normal.

16:05:47 L 04/05/2009 - 18:05:28: Lua Error: Timer Error: autorun/server/uban.lua:67: Can't connect to MySQL server on 'blank for security' (10060)

but its fine after that.

Is there a way to stop this from happening?. I can confirm the database is getting ban info.

[JamminR]

I don't know MySQL (any any SQL), but the 10060 seemed familiar.
Seems it has nothing specifically to do with SQL, but TCP/IP socket connections in general.
Found this, perhaps it will help you troubleshoot.
http://wiki.answers.com/Q/What_does_Mysql_error_number_10060_mean

[Darksoul]

I don't know MySQL (any any SQL), but the 10060 seemed familiar.
Seems it has nothing specifically to do with SQL, but TCP/IP socket connections in general.
Found this, perhaps it will help you troubleshoot.
http://wiki.answers.com/Q/What_does_Mysql_error_number_10060_mean

Thank you, JamminR. I'll look into it!.

[NikolaiResokav]

I have recently been having a problem with uban, here is the error:

Code: [Select]

03:34:41 Lua Error: Timer Error: autorun/server/uban.lua:67: Reached max connections - MAX_MYSQL_CONNECTIONS!
anyone know whats causing this or how to fix this?