1. Post #41
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    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?

  2. Post #42
    Gold Member
    .\\Shadow}'s Avatar
    November 2009
    896 Posts
    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.

  3. Post #43
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    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.

  4. Post #44
    Gold Member
    .\\Shadow}'s Avatar
    November 2009
    896 Posts
    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... :/

  5. Post #45
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    I'll see if I can force it to provide more information on the connection failure when I get back.

  6. Post #46
    gamer_lv's Avatar
    November 2007
    121 Posts
    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.

  7. Post #47
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    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.

  8. Post #48
    Gold Member
    .\\Shadow}'s Avatar
    November 2009
    896 Posts
    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

  9. Post #49
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    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. :/

  10. Post #50
    Gold Member
    .\\Shadow}'s Avatar
    November 2009
    896 Posts
    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.

  11. Post #51
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    I'm going away for a week and a half, so I won't be able to provide any support. Good luck.
    Reply With Quote Edit / Delete Reply United Kingdom Show Events Dumb Dumb x 1Winner Winner x 1 (list)

  12. Post #52
    Gold Member
    Bubka3's Avatar
    August 2010
    51 Posts
    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
    Reply With Quote Edit / Delete Reply United States Show Events Bad Spelling Bad Spelling x 1Disagree Disagree x 1 (list)

  13. Post #53

    November 2009
    474 Posts
    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

  14. Post #54
    Rambomst's Avatar
    November 2006
    75 Posts
    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'

  15. Post #55

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

  16. Post #56
    Rambomst's Avatar
    November 2006
    75 Posts
    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.

  17. Post #57
    Rambomst's Avatar
    November 2006
    75 Posts
    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.

  18. Post #58
    Gold Member
    .\\Shadow}'s Avatar
    November 2009
    896 Posts
    Are you admin on the server... ?

  19. Post #59
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    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.

  20. Post #60
    Rambomst's Avatar
    November 2006
    75 Posts
    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...

  21. Post #61
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    Please post a pic of your group (Owner Server Admin) and specific user (you) flag permissions.

  22. Post #62
    Rambomst's Avatar
    November 2006
    75 Posts
    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.


  23. Post #63
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    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.

  24. Post #64
    Rambomst's Avatar
    November 2006
    75 Posts
    I do not get any message in my console or the servers console saying that.

  25. Post #65
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    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?

  26. Post #66
    Rambomst's Avatar
    November 2006
    75 Posts
    Are you talking about the details for my sourcebans account like username, email, steamid, password , etc. Well I have provided all of those.

  27. Post #67
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    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.

  28. Post #68
    Rambomst's Avatar
    November 2006
    75 Posts
    I already have that enabled and there are no errors that are linked to sourcebans.lua.

  29. Post #69
    davlyn_20's Avatar
    April 2010
    20 Posts
    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.
    Reply With Quote Edit / Delete Reply Belgium Show Events Agree Agree x 1 (list)

  30. Post #70
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    Uploaded a new version which may fix Rambomst's problems, and will aid davlyn_20's quest.
    Enjoy.
    Reply With Quote Edit / Delete Reply United Kingdom Show Events Lua King Lua King x 3 (list)

  31. Post #71
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    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.

  32. Post #72
    peopleofgaming.com
    erie1555's Avatar
    January 2009
    1,087 Posts
    When unbanning someone they are not unipbanned.

  33. Post #73
    ayre10's Avatar
    August 2009
    466 Posts
    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.

  34. Post #74
    Nova Prospekt's Avatar
    January 2009
    247 Posts
    Your doing the work of gods, sir.
    Reply With Quote Edit / Delete Reply United States Show Events Agree Agree x 1 (list)

  35. Post #75
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    When unbanning someone they are not unipbanned.
    Works fine here. Please explain more.
    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
    Your doing the work of gods, sir.

  36. Post #76
    ayre10's Avatar
    August 2009
    466 Posts
    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.

  37. Post #77

    November 2009
    474 Posts
    Why can't you guys just use Sourcemod/metamod with Sourcebans? Its much easier and less buggier than this.
    Reply With Quote Edit / Delete Reply United States Show Events Dumb Dumb x 4 (list)

  38. Post #78
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    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.
    Reply With Quote Edit / Delete Reply United Kingdom Show Events Agree Agree x 1 (list)

  39. Post #79
    Cool Kid
    meatwad253's Avatar
    December 2009
    1,219 Posts
    Lexi, could I pay you to set up the MYSQL part of source bans for me? :3
    Reply With Quote Edit / Delete Reply United States Show Events Dumb Dumb x 3Funny Funny x 1 (list)

  40. Post #80
    Gold Member
    Lexic's Avatar
    March 2009
    6,123 Posts
    No.
    Reply With Quote Edit / Delete Reply United Kingdom Show Events Funny Funny x 3Lua King Lua King x 1Late Late x 1Friendly Friendly x 1 (list)