For the last 2 days I have been on and off trying to get sb install and working.
This is my setup:
- VPS (Ubuntu 12) This runs a CS:GO server
- Shared web hosting (cPanel) This runs the db's
I installed SourceBans 1.4.11 to the shared hosting and CS:GO server.
I then added the VPS IP to the external access db allow list.
Edited ../addons/sourcemod/configs/databases.cfg (removed irrelevant entries)
Code:
"Databases"
{
"driver_default" "mysql"
"sourcebans"
{
"driver" "mysql"
"host" "**Web IP**"
"database" "bans"
"user" "username"
"pass" "password"
//"timeout" "0"
"port" "3306"
}
}
Changed line 47 in ../addons/sourcemod/configs/sourcebans/sourcebans.cfg
And added the server to the web panel.
The web panel shows the server and the players that are connected (in my case myself and 9 bots)
I use the web panel to kick myself and it returns "Player not on the server anymore!" but I was never kicked.
I test to see if the CS:GO server can't connect to the mySQL but I could connect with the mysql-client I got from the PPA (on the game server box ofc :P)
Test to see if I can remotely use rcon and I can. :\
I then start looking for answers and found
Sarabveer's Fork. I install his patch but still no fix..
Instead when I tried to kick myself this time I get new feedback saying "Player 'x' has been kicked from the server."
The whole time I had a permanent ban on myself in the database and it never stopped me connecting :P
I didn't get a any errors in logs?
I know this is basically a duplicate of
Wilczek's topic but I'm hoping that someone will point at what I did wrong :P