Server and mysql no connection

Simca · **Author**

I tried banning myself and I could get in the server. I tried banning ingame and it's not passing onto the database, not seeing it in webpanel. Also I set up server admin access in webpanel but I don't get admin in server. I have portforwarded mysql 3306 to the internal server ip. The webpanel is showing my servers. Have all 3 plugins loaded.

My sourcebans.cfg is using the same external server ip same as database. I didn't add port after server ip.

Code:

"Databases"
{
	"driver_default"		"mysql"
	
	"sourcebans"
	{
		"driver"		"mysql"
		"host"			"my external server ip"	
		"database"		"sourcebans"	
		"user"			"root"		
		"pass"			"root password"	// The password for this user
	}
	
	
	"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"
	}
	

}

Cruckes · 08-08-2014 , 12:24 Re: Server and mysql no connection

Any errors when you reload SB/admins?

Simca · *Last edited by Simca; 08-08-2014 at 18:42.*

i reloaded the plugins through server console no errors. Nothing in the logs.

Amroth · *Last edited by Amroth; 08-08-2014 at 20:24.*

May mysql server isn't allowed for external connections.

If you access to cpanel or something like this, try add remote mysql ip (your server ip) to access to mysql.