Reply Subscribe

**Lexic** · 9th August 2010

Are you sure that
a) You have all the correct details in
b) Your server's IP is allowed to connect to the db
c) You did actually install MySQLOO?
Additional info:
What OS you running the server on?
What version of SourceBans are you running?
What version of MySQL are you running?
Does your MySQL server have any limits such as connections or bandwith that might be locking the game server out?

**.\\Shadow}** · 9th August 2010

a) Yes
b) Yes, it is.
3) I used Xenon Server's mod installer for it.

Windows, I'm assuming.
The current one in Xenon's mod installer.
Not that I know of.

**Lexic** · 9th August 2010

How odd. Are you able to access your server's files/server.cfg?
Either enabling `lua_log_sv 1` or `log on` during startup and then plumbing the relevent logs (garrysmod/lua_errors_server.txt, garrysmod/logs/*.log) would give a far better understanding of what's going on. I made the module spit out lots of info as it does things.

**.\\Shadow}** · 10th August 2010

Code:

[08/10/10 02:13:56][SourceBans.lua] Failed to connect to the database: Can't connect to MySQL server on 'onlinecomphelp.com' (10060). Retrying in 60 seconds.

I guess it's an error on my end, no idea what is causing it though... :/

**Lexic** · 10th August 2010

I'll see if I can force it to provide more information on the connection failure when I get back.

gamer_lv · 10th August 2010

.\\Shadow} posted:

3) I used Xenon Server's mod installer for it.

Are you sure its the OO version. last time I used xenons mod install (2 months ago) it only had the old V8 module.

**Lexic** · 10th August 2010

Turns out 'Can't connect to MySQL server on 'onlinecomphelp.com' (10060)' is the only error message I can get out of it, but it's definitely why it's not working. I suggest you create a support ticket on your host.

**.\\Shadow}** · 10th August 2010

V8? Would using V7 be causing this.. ?

The thing is, the clan this is for (nonerdsjustgeeks.com), uses different hosts and different people for it. I run the server I am trying to use this for, but the owner of the clan runs "onlinecomphelp.com" and that's where SourceBans is on. I would have to ask HIM to make a support ticket, and there wasn't this problem on Sourcebans.lua 1.5

**Lexic** · 10th August 2010

I haven't changed anything relating to connecting since the first release, so I don't see how it could be me, and that error is coming from the MySQLOO module, so it's definitely your end.
Sorry. :/

**.\\Shadow}** · 11th August 2010

I tried this again with a different database website, still didn't work.

Long story short after a couple hours I got mad and switched to the almost never used EasyBan.

**Lexic** · 15th August 2010

I'm going away for a week and a half, so I won't be able to provide any support. Good luck.

**Bubka3** · 1st September 2010

.\\Shadow} posted:

Code:

[08/10/10 02:13:56][SourceBans.lua] Failed to connect to the database: Can't connect to MySQL server on 'onlinecomphelp.com' (10060). Retrying in 60 seconds.

I guess it's an error on my end, no idea what is causing it though... :/

This plugin cant resolve domains. You need to put an IP

mikeym · 10th September 2010

If I unban from the website, it never unbans...

Yes RCON is correct
Yes Sourcebans is installed correctly
Yes I have admin privileges
Yes the database is working properly

Rambomst · 26th September 2010

I am unable to get this working ingame without the use of RCON but I am able to ban with the use of RCON. Each time I try and ban it says

Code:

sm_ban MeoW 1 test
You do not have access to this command!

I am not getting any LUA errors and it is connecting to the MySQL DB.

*edit*

On server startup I noticed I got this error and I also noticed that if I ban myself via the webpanel for for x amount of time I am still able to connect and play in the server while banned.

Code:

[@lua\includes\modules\sourcebans.lua:118] invalid value (nil) at index 7 in table for 'concat'
[@lua\includes\modules\sourcebans.lua:118] invalid value (nil) at index 7 in table for 'concat'
[@lua\includes\modules\sourcebans.lua:118] invalid value (nil) at index 7 in table for 'concat'

mikeym · 26th September 2010

Make sure you have admin privileges on your sourcebans website.
With the correct StEAM ID

Rambomst · 26th September 2010

I have admin privs on the website and I am using the correct SteamID. My sourcebans system works fine with the 7 CSS servers I have.

Rambomst · 27th September 2010

I really need to get this error fixed. I don't want to have to use metamod and sourcemod so any help is much appreciated.

**.\\Shadow}** · 27th September 2010

Are you admin on the server... ?

**Lexic** · 27th September 2010

Fixed. [Link]
You are assigned as an admin on to the server, but do not have a server group selected. I hadn't anticipated this when I made the module, and the previous quickfix didn't work.

Rambomst · 28th September 2010

I just updated to that new version and it still isn't working for me. It keeps saying I do not have access to the command but on server load I get this in console

Code:

L 09/28/2010 - 10:07:51: [09/28/10 10:07:51][SourceBans.lua] Loaded admin group Server Admin
[09/28/10 10:07:51][SourceBans.lua] Loaded admin group Server Admin
L 09/28/2010 - 10:07:51: [09/28/10 10:07:51][SourceBans.lua] Loaded admin group Owner Server Admin
[09/28/10 10:07:51][SourceBans.lua] Loaded admin group Owner Server Admin
L 09/28/2010 - 10:07:51: [09/28/10 10:07:51][SourceBans.lua] Loading Admins . . .
[09/28/10 10:07:51][SourceBans.lua] Loading Admins . . .
L 09/28/2010 - 10:07:52: [09/28/10 10:07:52][SourceBans.lua] Loaded admin Arkwolf with group Server Admin.
[09/28/10 10:07:52][SourceBans.lua] Loaded admin Arkwolf with group Server Admin.
L 09/28/2010 - 10:07:52: [09/28/10 10:07:52][SourceBans.lua] Loaded admin MeoW with group Owner Server Admin.
[09/28/10 10:07:52][SourceBans.lua] Loaded admin MeoW with group Owner Server Admin.
L 09/28/2010 - 10:07:52: [09/28/10 10:07:52][SourceBans.lua] Loaded admin Deadmouse with group NO GROUP ASSIGNED.
[09/28/10 10:07:52][SourceBans.lua] Loaded admin Deadmouse with group NO GROUP ASSIGNED.
L 09/28/2010 - 10:07:52: [09/28/10 10:07:52][SourceBans.lua] Loaded admin Kazzarry with group Server Admin.
[09/28/10 10:07:52][SourceBans.lua] Loaded admin Kazzarry with group Server Admin.
L 09/28/2010 - 10:07:52: [09/28/10 10:07:52][SourceBans.lua] Loaded admin Jesus with group Server Admin.
[09/28/10 10:07:52][SourceBans.lua] Loaded admin Jesus with group Server Admin.
L 09/28/2010 - 10:07:52: [09/28/10 10:07:52][SourceBans.lua] Loaded admin BOT with group NO GROUP ASSIGNED.
[09/28/10 10:07:52][SourceBans.lua] Loaded admin BOT with group NO GROUP ASSIGNED.
L 09/28/2010 - 10:07:52: [09/28/10 10:07:52][SourceBans.lua] Loaded admin TheBoss with group Server Admin.
[09/28/10 10:07:52][SourceBans.lua] Loaded admin TheBoss with group Server Admin.
L 09/28/2010 - 10:07:52: [09/28/10 10:07:52][SourceBans.lua] Loaded admin Cavtek with group Server Admin.
[09/28/10 10:07:52][SourceBans.lua] Loaded admin Cavtek with group Server Admin.
L 09/28/2010 - 10:07:52: [09/28/10 10:07:52][SourceBans.lua] Loaded admin Crayola with group Server Admin.
[09/28/10 10:07:52][SourceBans.lua] Loaded admin Crayola with group Server Admin.
L 09/28/2010 - 10:07:52: [09/28/10 10:07:52][SourceBans.lua] Loaded admin Rupert with group Server Admin.
[09/28/10 10:07:52][SourceBans.lua] Loaded admin Rupert with group Server Admin.

So it seems to be loading the admins I just can't use the commands...

**Lexic** · 28th September 2010

Please post a pic of your group (Owner Server Admin) and specific user (you) flag permissions.

Rambomst · 28th September 2010

I have tired it with the 'z' flag and without it. Both times it didn't work. Also the group "Owner Server Admin" was just a test since I read before that this module didn't work if you were not in a group and I have since deleted it after the test was unsuccessful.

**Lexic** · 28th September 2010

Do you get the server console message "XXX has joined, and they are a YYY"?
Replacing XXX with a name and YYY with a group.

Rambomst · 28th September 2010

I do not get any message in my console or the servers console saying that.

**Lexic** · 28th September 2010

In that case, the server doesn't recognize you when you log in. I'm not sure why. What details have you provided in the sourcebans Admin Details section on the website?

Rambomst · 28th September 2010

Are you talking about the details for my sourcebans account like username, email, steamid, password , etc. Well I have provided all of those.

**Lexic** · 28th September 2010

Hmmm. I dunno then. I've got to go, but when I come back I'll write you a debug version to find out what's going on. In the mean time, use lua_log_sv 1 in your startup parameters and make sure there are no lua errors.

Rambomst · 28th September 2010

I already have that enabled and there are no errors that are linked to sourcebans.lua.

davlyn_20 · 4th October 2010

Hello,

I want to sync my sourcebans with Garry's mod with custom administrator group, working with evolve.

Because evolve doesn't allow to add custom groups with sourcebans..

Can anyone make this:

Adding groups on Evolve using sourcebans. Read the Custom Admin Server Permissions on sourcebans, for example:
-Custom flag "o" Admin privileges
-Custom flag "p" All access ( Like the z flag in sourcemod )
-Custom flag "q" Reserved slots..

Thank you very much !

I got 7 servers to manage, 3 gmod servers.

**Lexic** · 16th October 2010

Uploaded a new version which may fix Rambomst's problems, and will aid davlyn_20's quest.
Enjoy.

**Lexic** · 24th October 2010

Uploaded a new version which fixes admin loading breaking under certain (new) circumstances. I think this one could actually be Rambombst's issue. Please get back to me if it's not.

erie1555 · 30th October 2010

When unbanning someone they are not unipbanned.

ayre10 · 31st October 2010

I am currently using evolve that has this integrated.
My problem is I cant get this to write information to the sql database but I do know it can read information.
I've used both evolves !ban command and sm_ban but either will not write anything to database and if course wont show up in the ban list on my website.

Im also getting this error.

[10/31/10 13:35:50][SourceBans.lua] The server has lost connection to the database. Retrying... Timer Error: [addons\evolve\lua\includes\modules\sourcebans.lua: 551] attempt to index local 'query' (a nil value)

This error happens a few mins after server startup.

Nova Prospekt · 31st October 2010

Your doing the work of gods, sir.

**Lexic** · 5th November 2010

erie1555 posted:

When unbanning someone they are not unipbanned.

Works fine here. Please explain more.

ayre10 posted:

I am currently using evolve that has this integrated.
My problem is I cant get this to write information to the sql database but I do know it can read information.
I've used both evolves !ban command and sm_ban but either will not write anything to database and if course wont show up in the ban list on my website.

Im also getting this error.

[10/31/10 13:35:50][SourceBans.lua] The server has lost connection to the database. Retrying... Timer Error: [addons\evolve\lua\includes\modules\sourcebans.lua: 551] attempt to index local 'query' (a nil value)

This error happens a few mins after server startup.

There will be several more errors during startup that would explain that one. Please find them and tell me what they are. lua_log_sv 1 in your server's startup parameters will provide a text log of all errors which will help. Be aware that Overv does not update the module he supplies as I update. Please download the version from the first post and put it in Evolve/lua/includes/modules/ before continuting

Nova Prospekt posted:

Your doing the work of gods, sir.

ayre10 · 5th November 2010

Lexic posted:

Works fine here. Please explain more.

There will be several more errors during startup that would explain that one. Please find them and tell me what they are. lua_log_sv 1 in your server's startup parameters will provide a text log of all errors which will help. Be aware that Overv does not update the module he supplies as I update. Please download the version from the first post and put it in Evolve/lua/includes/modules/ before continuting

/orangebox/garrysmod/lua_errors_server.txt

Code:

[@gamemodes\sandbox\entities\entities\gmod_rtcameraprop\init.lua:89] bad argument #1 to 'random' (interval is empty)
[@gamemodes\sandbox\entities\entities\gmod_rtcameraprop\init.lua:89] bad argument #1 to 'random' (interval is empty)
[11/05/10 23:31:10][SourceBans.lua] The server has lost connection to the database. Retrying...Timer Error: [@addons\evolve\lua\ev_sourcebans.lua:35] bad argument #1 to 'ipairs' (table expected, got boolean)
[11/05/10 23:36:10][SourceBans.lua] The server has lost connection to the database. Retrying...

/orangebox/garrysmod/console.txt

Code:

Mounting hl2.. OK
Mounting cstrike.. Failed
Mounting dod.. Failed
Mounting ep2.. Failed
Mounting tf.. Failed
Mounting episodic.. Failed
Mounting hl2mp.. Failed
Mounting portal.. OK
Mounting lostcoast.. Failed
Mounting hl1.. Failed
Mounting hl1mp.. Failed
Mounting zeno_clash.. OK
Garry's Mod server.dll Build #109 [Nov  1 2010 15:56:15]
maxplayers set to 10
Unknown command "sv_allow_wait_command"
maxplayers set to 10
Network: IP 109.169.52.73, mode MP, dedicated Yes, ports 27015 SV / 27005 CL
Lua initialized (Lua 5.1)
================================
Stargate Carter Addon Pack Loaded
Revision 57
List of all installed CAP files:
================================
==========================================================
Simple Prop Protection Version 1.51 by Spacetech has loaded
==========================================================
=======================================================
StarGate Pack: Initializing
Version: 47

Loading: stargate/shared/init.lua
Loading: stargate/shared/keyboard.lua
Loading: stargate/shared/bullets.lua
Loading: stargate/shared/lib.lua
Loading: stargate/shared/matrix.lua
Loading: stargate/shared/print_r.lua
Loading: stargate/shared/tracelines.lua
Loading: stargate/server/init.lua
INIParser:parse - File stargate/config.ini successfully parsed
INIParser:parse - File stargate/user_config.ini successfully parsed
Loading: stargate/server/keyboard.lua
Loading: stargate/server/spawner.lua
Loading: stargate/server/entity.lua
Loading: stargate/server/ini_parser.lua
Loading: stargate/server/protection.lua
Loading: stargate/server/teleport.lua
Loading: stargate/server/tool.lua
Loading: stargate/server/wire_rd.lua
=======================================================
================================
===  Wire  2207 (exported)   Installed  ===
================================
Loaded GM Lua DLL.
1 modelprecache 1024 10 0
1 modelprecache 8192 13 0
4 decalprecache 512 9 0
4 decalprecache 1024 10 0
12 Materials 1024 10 0
12 Materials 2048 11 0

=====================================================
 Evolve 1.0 by Overv succesfully started serverside.
=====================================================

[11/05/10 23:25:36][SourceBans.lua] Starting the database.
Registering gamemode 'sandbox' derived from 'base'
ScriptEnforce is disabled
Compressing lua files into data pack..
Compression complete. 1164 files. (1.861s)
Executing dedicated server config file
[11/05/10 23:25:45][SourceBans.lua] Loading Admin Groups . . .
Connection to Steam servers successful.
   VAC secure mode is activated.
Client "TheCreeper" connected (93.96.51.96:27005).
[11/05/10 23:26:09][SourceBans.lua] Loading Admins . . .
INIParser:parse - File stargate/gatespawner_maps/gm_flatgrass.ini successfully parsed
Setting CBaseEntity to non-brush model models/zup/stargate/stargate_gring.mdl
Setting CBaseEntity to non-brush model models/zup/stargate/stargate_gring.mdl
=================================================
Simple Prop Protection: 68 props belong to world
=================================================
[EV] TheCreeper last joined 22 minutes ago.
[EV] Add This Server To Your Favourites, 109.169.52.73:27015.
[@gamemodes\sandbox\entities\entities\gmod_rtcameraprop\init.lua:89] bad argument #1 to 'random' (interval is empty)
[@gamemodes\sandbox\entities\entities\gmod_rtcameraprop\init.lua:89] bad argument #1 to 'random' (interval is empty)
[EV] Noclip Is Disabled For Guests.
[11/05/10 23:31:10][SourceBans.lua] The server has lost connection to the database. Retrying...
Timer Error: [@addons\evolve\lua\ev_sourcebans.lua:35] bad argument #1 to 'ipairs' (table expected, got boolean)
[EV] Must Be 16+ To Use Microphone.
[EV] Don't Bug The Owner For Admin.
[11/05/10 23:36:10][SourceBans.lua] The server has lost connection to the database. Retrying...
[EV] Use Multi-Tool For All Your Needs.
[EV] Submit ban requests at thecreeper.co.uk
[EV] Still Working On The Server.
[11/05/10 23:41:10][SourceBans.lua] The server has lost connection to the database. Retrying...
Timer Error: [@addons\evolve\lua\ev_sourcebans.lua:35] bad argument #1 to 'ipairs' (table expected, got boolean)
[EV] Add This Server To Your Favourites, 109.169.52.73:27015.
[EV] Noclip Is Disabled For Guests.

I also updated the module at the link you supplied in the first page.

mikeym · 6th November 2010

Why can't you guys just use Sourcemod/metamod with Sourcebans? Its much easier and less buggier than this.

**Lexic** · 7th November 2010

Because SourceMod + MetaMod + Garry'sMod results in a horrible clusterfuck and lag.
This is small, compact, works fine for most people and is FAR simpler to install than SourceMod.
It also comes with a large script interface for server owners who make their own admin mod.

Edited:

The errors you are getting are because Evolve doesn't bother to check the result passed to the callback and plows straight in with the looping, even though it's being passed an error message. I'll tell Overv.
You also seem to lose connection to your SourceBans database fairly quickly. You probably want to look into that, as the module can connect fine the first time.
Incidentally, did you assign yourself as admin on that server in sourcebans? You don't show up in the readout.

**meatwad253** · 8th November 2010

Lexi, could I pay you to set up the MYSQL part of source bans for me? :3

**Lexic** · 8th November 2010

No.