[zvp]

Okay, I've installed Sourcebans correctly:
http://infernogamers.com/bans/
And now when ever I ban myself, it tells me to go to InfernoGamers.com to check this, but when I look at SourceBans, the ban isn't listed.

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

    "clientprefs"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
}

[Horsedick]

anything in the logs?

[zvp]

Ehh, how do I check logs in NFOServers?

[TnTSCS]

FTP to your game and look in the sourcemod/logs folder... unless you don't have FTP access, but you should.

[zvp]

L 01/26/2013 - 02:29:38: SourceMod error session started
L 01/26/2013 - 02:29:38: Info (map "cs_office") (file "errors_20130126.log")
L 01/26/2013 - 02:29:38: [SM] Plugin encountered error 25: Call was aborted
L 01/26/2013 - 02:29:38: [SM] Native "SetFailState" reported: Database failure: Could not find Database conf "sourcebans"
L 01/26/2013 - 02:29:38: [SM] Displaying call stack trace for plugin "sourcebans.smx":
L 01/26/2013 - 02:29:38: [SM]   [0]  Line 206, D:\scripting\sourcebans.sp::OnPluginStart()
L 01/26/2013 - 11:10:03: Error log file session closed.
L 01/26/2013 - 11:10:03: SourceMod error session started
L 01/26/2013 - 11:10:03: Info (map "cs_office") (file "errors_20130126.log")
L 01/26/2013 - 11:10:03: [SM] Plugin encountered error 25: Call was aborted
L 01/26/2013 - 11:10:03: [SM] Native "SetFailState" reported: Database failure: Could not find Database conf "sourcebans"
L 01/26/2013 - 11:10:03: [SM] Displaying call stack trace for plugin "sourcebans.smx":
L 01/26/2013 - 11:10:03: [SM]   [0]  Line 206, D:\scripting\sourcebans.sp::OnPluginStart()
L 01/26/2013 - 11:14:32: Error log file session closed.

L 01/25/2013 - 23:21:36: SourceMod error session started
L 01/25/2013 - 23:21:36: Info (map "cs_office") (file "errors_20130125.log")
L 01/25/2013 - 23:21:36: [SM] Plugin encountered error 25: Call was aborted
L 01/25/2013 - 23:21:36: [SM] Native "SetFailState" reported: Database failure: Could not find Database conf "sourcebans"
L 01/25/2013 - 23:21:36: [SM] Displaying call stack trace for plugin "sourcebans.smx":
L 01/25/2013 - 23:21:36: [SM]   [0]  Line 206, D:\scripting\sourcebans.sp::OnPluginStart()

L 01/25/2013 - 23:21:36: [sourcebans.smx] Database failure: Could not find Database conf "sourcebans". See FAQ: http://sourcebans.net/node/19
L 01/26/2013 - 02:29:38: [sourcebans.smx] Database failure: Could not find Database conf "sourcebans". See FAQ: http://sourcebans.net/node/19
L 01/26/2013 - 11:10:03: [sourcebans.smx] Database failure: Could not find Database conf "sourcebans". See FAQ: http://sourcebans.net/node/19
L 01/26/2013 - 11:14:32: [sourcebans.smx] plugins/basebans.smx was unloaded and moved to plugins/disabled/basebans.smx
L 01/26/2013 - 11:14:33: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on 'localhost' (10061). See FAQ: http://www.sourcebans.net/node/20
L 01/26/2013 - 11:17:08: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on 'localhost' (10061). See FAQ: http://www.sourcebans.net/node/20
L 01/26/2013 - 11:21:17: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on 'localhost' (10061). See FAQ: http://www.sourcebans.net/node/20
L 01/26/2013 - 11:23:55: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on 'localhost' (10061). See FAQ: http://www.sourcebans.net/node/20

[zvp]

Help?

[Horsedick]

Originally Posted by zvp Help?

its saturday night dude....not everyone is sitting at their computer.

Look at the logs you have and check the FAQ on the sourcebans site you will see steps to take

http://www.sourcebans.net/faq

appears to be issues with the database - opening ports and NFO requires a weird entry for remote MySQL settings like:

c-11-111-11-111.internap-dallas.nfoservers.com

those 1's are just for your IP# broken down with dashes. you need to put that into your web host's remote MySQL and you need to make sure ports are open..use the connection php debug file also found on the FAQ to test.

[killjoy64]

Originally Posted by Horsedick its saturday night dude....not everyone is sitting at their computer. Look at the logs you have and check the FAQ on the sourcebans site you will see steps to take http://www.sourcebans.net/faq appears to be issues with the database

could you help me when you get a chance, i posted a thread a few days ago in the sourcebans forum but no replies, im having the same error.

[sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on 'localhost' (10061). See FAQ: http://www.sourcebans.net/node/20

I read the page, my host said he opened a few ports that i needed, but still no success, Here is my post.

[YamiKaitou]

There is no MySQL server running on the same machine as the game server. You should configure your database settings to connect to the remote MySQL server

[htcarnage]

Originally Posted by YamiKaitou There is no MySQL server running on the same machine as the game server. You should configure your database settings to connect to the remote MySQL server

I.E you guys need to get the static ip address of the webserver you're using and put THAT ip in the databases.cfg file instead of the "localhost" that is currently there. You should be able to submit a support ticket to your server provider asking for the ip, if they dont already have it listed somewhere in your control panel. Remember, the ip for the website is not the same as the ip for the server.