AlliedModders - Bans not showing on sourceban page

AlliedModders (https://forums.alliedmods.net/index.php)

- SourceBans / SourceBans++ (https://forums.alliedmods.net/forumdisplay.php?f=152)

- - Bans not showing on sourceban page (https://forums.alliedmods.net/showthread.php?t=200094)

Bans not showing on sourceban page

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/

Re: Bans not showing on sourceban page

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

Re: Bans not showing on sourceban page

Quote:

Originally Posted by Peace-Maker (Post 1833508)

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:

Code:

"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"

        }

}

Re: Bans not showing on sourceban page

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?

Re: Bans not showing on sourceban page

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

Re: Bans not showing on sourceban page

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

Re: Bans not showing on sourceban page

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.

Re: Bans not showing on sourceban page

I am hosting the site on a VPS server but I can't still connect :/
L 11/10/2012 - 12:00:38: [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

Code:

"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"

        }

}

Re: Bans not showing on sourceban page

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.