Hello I have sourcebans installed on my game server and my database.cfg is set up as below:
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" "91.238.160.3"
"database" "voidreal_sourcebans"
"user" "voidreal_bansuser"
"pass" "BLANK"
//"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"
}
"rankme"
{
"driver" "default"
"host" "91.238.160.3"
"database" "voidreal_rankme"
"user" "voidreal_rankme"
"pass" "BLANK"
}
"sourcebans"
{
"driver" "default"
"host" "91.238.160.3"
"database" "voidreal_sourcebans"
"user" "voidreal_bansuser"
"pass" "BLANK"
}
}
and the web client is all set up on my webserver (hosted on the same server as my SQL server). I know that the SQL Database is set up to allow remote connection as the rankme plugin works as expected.
However the client shows no bans and the data base is empty. Upon investigation I found the following error in my sourceban.log:
Code:
L 12/27/2016 - 17:07:22: [sourcebans.smx] Database failure: [1045]: Access denied for user 'voidreal_bansuse'@'185.114.224.63' (using password: YES).
As you can see not only is the username incorrect (it is missing an r) the Ip is also incorrect. the ip shown here is the IP of the game server, not the server that was specified in the database.cfg. Any help will be greatly appreciated