[ciscoderp]

Im having an issue with my website communicating with the server.

The website can see the server is online, but I can not access RCON, sm_ban doesnt register to the website when I perform it in game. If I manually add a ban in, it will say "Player Not in the server" (Even when they are), then "Ban" them, but it wont kick them or if they rejoin, it wont keep them out.

In console I get this error when I try to run sm_ban:

[SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
[SM] Displaying call stack trace for plugin "sourcebans.smx":
[SM] [0] Line 530, sourcebans.sp::CommandBanIp()


My SB page voice.chcory.com/sb

My VPS and Web server are on the same machine.
Im not running Sourcebans 2.0 (im running the 1.4)


Here is my Database.cfg:

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

Here is my Sourcebans.cfg

/**
* sourcebans.cfg
*
* This file contains settings for the SourceBans Source Server Plugin
* @author SteamFriends Development Team
* @version 0.0.0.$Rev: 74 $
* @copyright SteamFriends (www.steamfriends.com)
* @package SourceBans
*/

"SourceBans"
{
    "Config"
    {
        // Website address to tell where the player to go for unban, etc
        "Website"            "voice.chcory.com"

        // Allow or disallow admins access to addban command
        "Addban"            "1"

        // Allow or disallow admins access to unban command
        "Unban"                "1"
        
        // The Tableprefix you set while installing the webpanel. (default: "sb")
        "DatabasePrefix"    "sb"

        // How many seconds to wait before retrying when a players ban fails to be checked. Min = 15.0 Max = 60.0
        "RetryTime"            "45.0"
        
        // How often should we process the failed ban queue in minutes
        "ProcessQueueTime"    "5"

        // Should the plugin automaticaly add the server to sourcebans 
        // (servers without -ip being set on startup need this set to 0)
        "AutoAddServer"        "0"

        // Enable backing up config files after getting admins from database (1 = enabled, 0 = disabled)
        "BackupConfigs"    "1"

        // Enable admin part of the plugin (1 = enabled, 0 = disabled)
        "EnableAdmins"    "1"
        
        // Require the admin to login once into website
        "RequireSiteLogin"    "0"

        // This is the ID of this server (Check in the admin panel -> servers to find the ID of this server)
        "ServerID"        "1"
    }

    /*
     * Generic menu options for if a reason isn't supplied in a ban
     * Without a supplied reason the ban will never be written to the database
     */
    "BanReasons"
    {
        "Hacking"    "Hacking"
        "Exploit"    "General Exploit of Game/Map/Server"
        "TK"    "Team Killing"
        "TF"    "Team Flashing"
        "CommSpam"    "Spamming Mic/Chat"
        "BadSpray"    "Inappropriate Spray"
        "BadLang"    "Inappropriate Language"
        "BadName"    "Inappropriate Name"
        "IgnoreAdmin"    "Ignoring Admins"
        "Stacking"    "Team Stacking"
        "Own Reason"    "Own Reason"
    }
    
    /*
     * Submenu options for when "Hacking" is selected
     * If "Hacking" is removed from the menu above this will not be accessable
     */
    "HackingReasons"
    {
        "Aimbot"    "Aimbot"
        "Antirecoil"    "Anti Recoil"
        "Wallhack"    "Wallhack"
        "Spinhack"    "Spinhack"
        "Speedhack"    "Speedhack"
        "Multi-Hack"    "Multi-Hack"
        "No Smoke"    "No Smoke"
        "No Flash"    "No Flash"
    }
}

I created a Database named **** using the command "Create Database **** "

I dont know what else to do, My server ID in sourcebans.cfg matches the server id in the web admin panel.