PDA

View Full Version : Bans Don't Show Up On The Site


zvp
01-26-2013, 12:00
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
01-26-2013, 12:06
anything in the logs?

zvp
01-26-2013, 12:33
Ehh, how do I check logs in NFOServers?

TnTSCS
01-26-2013, 12:34
FTP to your game and look in the sourcemod/logs folder... unless you don't have FTP access, but you should.

zvp
01-26-2013, 12:38
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
01-26-2013, 13:43
Help?

Horsedick
01-26-2013, 19:45
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
01-27-2013, 02:31
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 (https://forums.alliedmods.net/showthread.php?t=206730)is my post.

YamiKaitou
01-27-2013, 04:06
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
02-01-2013, 01:34
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.