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

[Megiddo_at_work]

Go to your server console to see the error. The server console is the one that you see before any players join your server and where you can enter commands when no one is connected.

[MrPresident]

If you dont have access to it, try running UBan on a listen server and try a test ban. Your game console is your server console on a listen server(assuming you are the host)

[Sc00by22]

Here you go
UBan failure. Error is: autorun/server/uban.lua:64: attempt to index global 'mysql' (a nil value)
Can't ban users with ID "UNKNOWN"

[Megiddo_at_work]

You don't have the MySQL module installed.

[Sc00by22]

That's very strange, I did exactly what it said the readme file

Looks like i forgot a file

It worked in the listen server, I'll have to check my files

Everything is the same as my listen server yet it fails, Everything is in the correct place

[Sc00by22]

Finally got access to the server console, Here's the error

Error is: autorun/server/uban.lua:129: Invalid connection!

Line 129 : local curuser = DoQuery( "SELECT CURRENT_USER()" )

[MrPresident]

Its not connecting to your database correctly.


1. make sure your database is set up to receive connections from your server's IP/
2. make sure your database host allows outside connections (my first host which was my web host only allowed local connections)
3. make sure your user has access to the database
4. make sure you have the information (database, user, password) inserted correctly into the lua file.

[Sc00by22]

1. make sure your database is set up to receive connections from your server's IP/ Yes it is
2. make sure your database host allows outside connections (my first host which was my web host only allowed local connections) It does
3. make sure your user has access to the database It does
4. make sure you have the information (database, user, password) inserted correctly into the lua file. It does

:/

EDIT : I'm getting this now

Timer Error: autorun/server/uban.lua:176: MySQL server has gone away

[spbogie]

Your SQL server is dropping the connection. (likely something with timeout)

[Megiddo]

Try setting it to not use a persistent connection

[Sc00by22]

Now I'm getting this again

Error is: autorun/server/uban.lua:129: Invalid connection!

The funny thing is, I'm using the same configuration that I used on a listen server which worked fine

[Sc00by22]

Ok. Here is a dilemma, I have setup Uban correctly, My mysql database is setup to receive the information, I have allowed my server hostname, My server has the port 3306 open for outbound access, But when i go to ban somebody, It fails without an error, What could be the cause of this?

[Megiddo]

Anything in console? Does the record appear in SQL?

[JamminR]

Scooby, check for errors at server startup and/or map change.
Though no error may be occuring at ban, it might be due to UBan not starting.

[Sc00by22]

Megiddo knows what the problem is and is currently finding a fix