AlliedModders - MySQL Connection Problems (mysql.sock) missing

Good day all.

I do hope I am posting this in the right place.

I am looking for help and advice with regards to setting up SourceBans on my server.

I have my GameServer & Website on the same server, I am running Ubuntu 12.04.1 x64 server, and Easy Hosting Control Panel (EHCP).

I have setup the MySQL database, and the website side of SourceBans is working fine, but I am having problems with the GameServer side.

Here is my /addons/sourcemod/configs/databases.cfg

Quote:

"Databases"
{
"driver_default" "mysql"

// When specifying "host", you may use an IP address, a hostname, or a socket file path

"sourcebans"
{
"driver" "mysql"
"host" "localhost"
"database" "sourcebans"
"user" "xxxxxxxxxx"
"pass" "xxxxxxxxxx"
"port" "3306"
//"timeout" "0"
}
"default"
{
"driver" "mysql"
"host" "localhost"
"database" "sourcemod"
"user" "xxxxxxxxxx"
"pass" "xxxxxxxxxx"
//"timeout" "0"
//"port" "0"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "xxxxxxxxxx"
"pass" "xxxxxxxxxx"
//"timeout" "0"
//"port" "0"
}
}

Here is my /addons/sourcemod/logssourcebans.log

Quote:

L 02/15/2013 - 10:52:42: [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

I see that SourceBans is trying to connect to MySQL via the Socket file "/tmp/mysql.sock".
I have looked in the "/tmp" folder and there is no "mysql.sock" file.

I am new to Linux and MySQL, so at this point I am now stuck.

Can someone please adivce me what I need to do.

Thanks for your time.

Best Regards.