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

[AviZ]

if its on a lan then you must use the lan ip address e.g 192.168.1.60 for the server to listen on, then user portwarding to the mysql port, the only way you can connect to it if its on your lan is use the lan ip, anyone else uses the external ip...

anyway this isnt a gban problem its a server problem.

[LUADuck]

if its on a lan then you must use the lan ip address e.g 192.168.1.60 for the server to listen on, then user portwarding to the mysql port, the only way you can connect to it if its on your lan is use the lan ip, anyone else uses the external ip...

anyway this isnt a gban problem its a server problem.

Have you even read what I've been doing? I'm connecting via my LOCAL LAN!

[Sc00by22]

Why would you want a LAN server anyway? Go out and rent one

[LUADuck]

Why would you want a LAN server anyway? Go out and rent one

That's not what the scope of this is about 

[Sc00by22]

But still, Uban should only be used if you actually going to have a community of some kind with a lot of players, It's pointless if its only a LAN server that a few people will play.

[LUADuck]

But still, Uban should only be used if you actually going to have a community of some kind with a lot of players, It's pointless if its only a LAN server that a few people will play.

:/

I'M RUNNING THE SQL SERVER ON MY NETWORK, AND IT WILL EVENTUALLY BE CONNECTED TO THROUGH THE NET, BUT I CAN'T EVEN CONNECT TO MY SQL SERVER FROM A SERVER THAT'S RUNNING IN MY LAN!!! AND YES, I HAVE A COMMUNITY!!!

Can you read that?

[Megiddo]

Did you try a MySQL client yet?

[JamminR]

This was in reply to Megiddo asking if he'd try connecting with an SQL client.

LuaDuck, is that the output when you connected?

1hour, 15 mins remaining (1.5 kbps)

WHAT!?!?!?!?!

[LUADuck]

It downloaded, and it got a connection.

So it must be UBans somewhere.

[Sc00by22]

Can you read that?

No need to be rude.

[LUADuck]

Helpful.

Still no luck. I'll try some router-fu later.

[LUADuck]

Still not working 

[JamminR]

root @ DuckyStudios has attributes : ALL PRIVILEGES

I have no direct SQL experience, but I do come from a broad background of various IT related projects.
I'll grasp for straws here for you.
Various applications and operating systems won't let you log in as 'root' remotely, only locally.
When you attempted to connect using a MySQL client, were you logging in from the same machine you're running Gmod/UBan on?
If so, were you using root to log in? (If yes, then my theory gets blown out the window)
If not, I suggest trying from the same machine running Gmod, and attempt root.
If that fails, try creating another username (uban_rox_when_I_can_get_it_working? ) with all privileges, and try again.

Also, with MySQL, does case sensitivity count? Would bantable and gbans for database and table name be same as BanTable and GBans?
Perhaps verify your database and table names match case too.

My straws for now.

[LUADuck]

I've set my Webserver's MySQL table to use it, and, with phpMyAdmin on the webserver changed privilages to allow root to be logged into anywhere.

I've got some good ideas in mah head, I'll report back.

[LUADuck]

I managed to get it working! I'm running a SQL table on the Gameserver.

Slight problem though. When I try to ban an ID, I get

Code: [Select]

UBan failure. Error is: autorun/server/uban.lua:158: Column 'serverip' cannot be null
Global ban failed! See server console for error.
Ideas?