[nerdy97]

I keep getting this error regarding database failure using this plugin and all other plugins that are using databases. Does anyone know any solutions?

[SourceBans] Loading configs/sourcebans.cfg config file
[SM] Plugin SourceBans reloaded successfully.
rcon from "43.245.163.78:53644": command "sm plugins reload sourcebans"
L 08/23/2016 - 22:08:46: [sourcebans.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). See FAQ: http://www.sourcebans.net/node/20

This is my database.cfg

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


}

Thanks

[Cooky]

Is your gameserver allowed to connect remotely to the SQL server?

[nerdy97]

Yes, my provider has checked everything and can't seem to find the reason either.

[asherkin]

Did you search? This is one of the most common SourceMod MySQL configuration problems.

[nerdy97]

I have tried changing the localhost name and installing extensions, reinstalling plugins. Nothing seems to work.

[nerdy97]

Anyone help me here please?

[nerdy97]

Fixed.