Ubuntu + MySql + Apache2 + Webmin + Sourcebans 1.4.11 all on the same computer.
I also tried 2.0.
Game server can't connect with mysql. Sourceban panel is working fine. Banned myself ip and steamid and i can still join my server.
Code:
L 05/13/2015 - 21:25:32: [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
L 05/13/2015 - 21:25:36: [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
L 05/13/2015 - 21:26:50: [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
L 05/13/2015 - 21:26:55: [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
L 05/13/2015 - 21:27:06: [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
In Webmin I made a seperate user 'server' and gave it any host. In Mysql Server Configuration MySQL server listening address is set to any.
Code:
"Databases"
{
"driver_default" "mysql"
"sourcebans"
{
"driver" "default"
"host" "localhost"
"database" "sourcebans"
"user" "server"
"pass" "blank"
//"timeout" "0"
"port" "3306"
}
"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"
}
}
Code:
[11] <FAILED> file "connect.ext.so": /home/l4d2/server/left4dead2/addons/sourcemod/extensions/connect.ext.so: cannot open shared object file: No such file or directory
[12] Socket (3.0.1alpha): Socket extension for SourceMod
[13] MySQL-DBI (1.6.0-dev+4284): MySQL driver implementation for DBI
[14] SQLite (1.6.0-dev+4284): SQLite Driver