Raised This Month: $51 Target: $400
 12% 

Issues with SourceBans (Database?)


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
SammehOsborn
Junior Member
Join Date: Jan 2013
Old 01-31-2013 , 16:39   Issues with SourceBans (Database?)
Reply With Quote #1

So basically, I've been trying to figure out what the problem could be without any luck. The installation went good, no errors. The database itself could connect without any issues.

Now, when it comes to adding admins/editing admin groups whatnot - That is not working, nothing is being changed in the config files (admin_groups.cfg whatnot). What could be the cause of the issue? My host is hostgator, I have whitelisted both my Game Server IP & my host IP for "Remote MySQL".

This is how my databases.cfg looks like.
The "host" has the IP of my webhost server, it used to be "localhost" but that was not working either.

Code:
"Databases"
{
    "driver_default"        "mysql"
    
    "sourcebans"
    {
        "driver"            "default"
        "host"                "***"
        "database"            "selinder_bans"
        "user"                "selinder_bans"
        "pass"                "***"
        //"timeout"            "0"
        "port"            "3306"
    }
    
    "default"
    {
        "driver"            "default"
        "host"                "localhost"
        "database"            "sourcemod"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
    
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }

    "clientprefs"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
}
This is the server/admin groups I've setup on sourcebans:




This is the admin:



This is a copy of my admin_groups.cfg

Code:
Groups
{
    /**
     * Allowed properties for a group:
     *
     *   "flags"           - Flag string.
     *   "immunity"        - Immunity level number, or a group name.
     *                         If the group name is a number, prepend it with an 
     *                         '@' symbol similar to admins_simple.ini.  Users 
     *                         will only inherit the level number if it's higher 
     *                         than their current value.
     */
    "Default"
    {
        "immunity"        "1"
    }
    
    "Server Manager"
    {
        /**
         * You can override commands and command groups here.
         * Specify a command name or group and either "allow" or "deny"
         * Examples:
         *         ":CSDM"            "allow"
         *        "csdm_enable"    "deny"
         */
         Overrides
         {
         }
        "flags"            "abcdefghiz"

        /* Largish number for lots of in-between values. */
        "immunity"        "99"
    }
    "Server Admin"
    {
        /**
         * You can override commands and command groups here.
         * Specify a command name or group and either "allow" or "deny"
         * Examples:
         *         ":CSDM"            "allow"
         *        "csdm_enable"    "deny"
         */
         Overrides
         {
         }
        "flags"            "abcdfhi"

        /* Largish number for lots of in-between values. */
        "immunity"        "99"
    }
}
This is a copy of my admins.cfg

Code:
/**
 * USE THIS SECTION TO DECLARE DETAILED ADMIN PROPERTIES.
 *
 * Each admin should have its own "Admin" section, followed by a name.
 * The name does not have to be unique.
 *
 * Available properties: (Anything else is filtered as custom)
 *      "auth"          - REQUIRED - Auth method to use.  Built-in methods are:
 *                        "steam"  - Steam based authentication
 *                        "name"   - Name based authentication
 *                        "ip"    - IP based authentication
 *                        Anything else is treated as custom.
 *                     Note: Only one auth method is allowed per entry.
 *
 *      "identity"      - REQUIRED - Identification string, for example, a steamid or name.
 *                     Note: Only one identity is allowed per entry.
 *
 *      "password"      - Optional password to require.
 *      "group"         - Adds one group to the user's group table.
 *      "flags"         - Adds one or more flags to the user's permissions.
 *        "immunity"        - Sets the user's immunity level (0 = no immunity).
 *                          Immunity can be any value.  Admins with higher 
 *                          values cannot be targetted.  See sm_immunity_mode 
 *                          to tweak the rules.  Default value is 0.
 *
 * Example:
    "BAILOPAN"
    {
        "auth"            "steam"
        "identity"        "STEAM_0:1:16"
        "flags"            "abcdef"
    }
 *
 */
Admins
{
}


As you can see, nothing is being updated. What do you suggest that I do? What could be the problem? Am I doing something wrong in the databases.cfg?

Last edited by SammehOsborn; 01-31-2013 at 16:44.
SammehOsborn is offline
Peace-Maker
SourceMod Plugin Approver
Join Date: Aug 2008
Location: Germany
Old 01-31-2013 , 21:40   Re: Issues with SourceBans (Database?)
Reply With Quote #2

Is the sourcebans plugin loaded?
__________________
Peace-Maker is offline
SammehOsborn
Junior Member
Join Date: Jan 2013
Old 02-01-2013 , 06:41   Re: Issues with SourceBans (Database?)
Reply With Quote #3

Quote:
Originally Posted by Peace-Maker View Post
Is the sourcebans plugin loaded?
I solved the issue, I had two different IP's for my game - I allowed remote access to the other one as well and it worked.

Thank you anyways for replying!
~ Sammy
SammehOsborn is offline
petraunas
Junior Member
Join Date: Mar 2015
Old 09-27-2015 , 16:31   Re: Issues with SourceBans (Database?)
Reply With Quote #4

Thanks Sam for posting the fix. Quick one please. How did you know that this was a firewall issue if I may ask?
__________________
Looking for plugins.
petraunas is offline
micazoid
Veteran Member
Join Date: Oct 2010
Location: Munich - Germany
Old 09-28-2015 , 06:22   Re: Issues with SourceBans (Database?)
Reply With Quote #5

Quote:
Originally Posted by petraunas View Post
Thanks Sam for posting the fix. Quick one please. How did you know that this was a firewall issue if I may ask?
A quick (and dirty) method to check if firewall is blocking:

Disable Firewall and check again.
__________________
micazoid is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 19:09.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode