[IcEWoLF]

When players are being banned from the actual server ( in game) the bans do not show on the sourcebans page.

However when I ban them from the sourceban page they do show, not sure what's going on. :/

http://www.47r-squad.com/sourcebans/

[Peace-Maker]

Check the sourcebans.log on your gameserver and read the FAQ linked in that error message. Your gameserver can't connect to your database.

[IcEWoLF]

Originally Posted by Peace-Maker Check the sourcebans.log on your gameserver and read the FAQ linked in that error message. Your gameserver can't connect to your database.

Hi there here is the file, I am not sure what I did wrong here:

"Databases"
{
	"driver_default"		"mysql"
	
	// When specifying "host", you may use an IP address, a hostname, or a socket file path
	
	"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"
	}
"Databases"
{
	"driver_default"		"mysql"
	
	"sourcebans"
	{
		"driver"			"mysql"
		"host"				"localhost"
		"database"			"****_sourcebans"
		"user"				"****************"
		"pass"				"*************"
		//"timeout"			"0"
		"port"			"3306"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}
}

[Horsedick]

may wish to include the database on storage-local below that to the database for your sourcebans db too, are you 100% sure the game server and host are communicating as in test that with the connection test?

[jsterling]

Remove everything above the red code. You're using duplicate code.

[IcEWoLF]

For hosts since I host it on my main website do I put the website IP or the link?

[jsterling]

Are you hosting the website on a dedicated server or do you have a shared web hosting plan?

I would use the IP to be on the safe side.

[IcEWoLF]

I am hosting the site on a VPS server but I can't still connect :/
L 11/10/2012 - 12:008: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '173.254.194.142' (10061). See FAQ: http://www.sourcebans.net/node/20

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

[jsterling]

Who's your host?

[IcEWoLF]

hostavps.com

I should be able to make any changes since I control the entire vps.

I double checked the cPanel forums and I did add my game server IP's to be able to connect with my database.