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

[Megiddo]

Just remove the NOT NULL bit from serverip. This is a bug I'm going to fix as soon as I have time...

[LUADuck]

Just remove the NOT NULL bit from serverip. This is a bug I'm going to fix as soon as I have time...

Brilliant! Thanks!

[Megiddo]

From the SQL table definition.

[LUADuck]

From the SQL table definition.

Don't worry, working now. Have a e-cookie.

[Lt.Smith]

Not sure if I posted here already, but I just wanted to pop in and say thanks. I use this for my two servers and it works a treat!

[JamminR]

LuaDuck, do you have any information that might help others keep your original connection issue from happening in the future?
If not prevention, I'm just darn curious.

[Lt.Smith]

You said it yourself: "Various applications and operating systems won't let you log in as 'root' remotely, only locally."

I'm pretty sure that was it. I had the same problem with an SQL server once which was fixed once I added another account that I could use.

[LUADuck]

LuaDuck, do you have any information that might help others keep your original connection issue from happening in the future?
If not prevention, I'm just darn curious.

Turns out I was forwarding ports incorrectly 

[Sc00by22]

EDIT : Nevermind I did what was suggested above and it worked, Thanks




I thought I would start using this again now that I have a dedicated server,

Error

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

and sometimes this

UBan failure. Error is: autorun/server/uban.lua:158: Column 'serverip' cannot be null


I have tried 3 installs of Uban already.

[Radikll]

Can someone make a public ban database?  I would like to beneft from other servers' bans.  I hate it when people crash my server and I know that other people do to.  I think it would be a good idea if we could all share a ban database to protect all of our server.  If someone does make a public ban database, it might be a good idea to add a whitelist option for individual servers.  That way if someone is banned from one server with the public database he can talk to the server admin of another server with the database to unbanned from his server (if that makes sense).

[JamminR]

Radikill, I understand your request. However, the answer is no.
The potential for abuse, even with your proposed list, is way to high.
In effect, using a normal 'ban' is the 'only on one server' way. Management of allowing unbans on some servers but not on others using UBan would then become nightmare.
I'm not sure if you've seen the Facepunch forums "UBan" release, but too many people whined when they thought it was a program that would ban from ALL servers.
We repeatedly had to tell people, "NO, this is only for those servers who make a private database"

Your best bet would be to find/make a few good friends who host thier own servers, and make a database of your own.
I believe at one time we were part of about a 8 server shared list.
This is no longer the case, as the majority of the servers are now out of service or formed thier own new communities.

[Megiddo]

Why don't you make a public ban database? That way people can benefit from your bans. You can make it read-only to other people also (UBan doesn't technically support this, it'll just error out when they try to make a gban to it but just have them apply for a ban add in your database if you want to control it).

[Dv2236]

so this only works with local mysql? also does mysql have to be installed on the hosting server?
im trying this on my server computer, conneting to my webhost mysql database i seem to get the error autorun/server/uban.lua:64:attempt to index global 'mysql' <a nail value>

[Dv2236]

NVM my host does allow remote mysql user connetion

[Dv2236]

I was getting this error too.. I just went into my database(PhPMyAdmin) and set the NULL on serverip and serverport from NO to YES.. This allows for the script to pass null to these rows on the table withouth erroring..
Tested it and it works perfectly.

OMFG i cant belive i mist this post, you so saved my ass, IT WORKS NOW!

Thanks