New to using sourcebans, sorry. Anyways, banning someone online doesn't do anything, and banning in-game doesn't show on the dashboard. whenever I click administration, servers, and server configuration I get a
The game server needs the following configuration to be able to communicate with the database.
Copy the "sourcebans" section below and place it on the game server in /[game]/addons/sourcemod/configs/databases.cfg, so that it looks similar to this:
I add the code into my databases.cfg, but still nothing. I'm stumped Any help would be appreciated
Yes, I can send console commands through sourcebans... My database.cfg does look like that. The username and pass should be the database user and pass info right?
L 06/25/2014 - 01:27:05: [sourcebans.smx] Could not connect to the database. ([2003]: Can't connect to MySQL server on 'localhost' (10061))
L 06/25/2014 - 01:32:03: SourceMod error session started
L 06/25/2014 - 01:32:03: Info (map "") (file "errors_20140625.log")
L 06/25/2014 - 01:32:03: [SM] Detected parse error(s) in file "C:\servers\eliteteamgaming\cstrike\addons\sourcemod\configs\databases.cfg"
L 06/25/2014 - 01:32:03: [SM] Line 45: Section declared without header
L 06/25/2014 - 01:32:03: Error log file session closed.
Should I change localhost to the hostlink instead?
L 06/25/2014 - 01:27:05: [sourcebans.smx] Could not connect to the database. ([2003]: Can't connect to MySQL server on 'localhost' (10061))
L 06/25/2014 - 01:32:03: SourceMod error session started
L 06/25/2014 - 01:32:03: Info (map "") (file "errors_20140625.log")
L 06/25/2014 - 01:32:03: [SM] Detected parse error(s) in file "C:\servers\eliteteamgaming\cstrike\addons\sourcemod\configs\databases.cfg"
L 06/25/2014 - 01:32:03: [SM] Line 45: Section declared without header
L 06/25/2014 - 01:32:03: Error log file session closed.
Should I change localhost to the hostlink instead?
Yes, you are defining the host for sourcebans as "localhost", which it isn't. Change the "host" section of your sourcebans entry in databases.cfg to your website hostname(eliteteamgaming.site.nfoservers.com).
EDIT: It also looks like you have a problem in your databases.cfg, make sure you have brackets open and close at appropriate places, and if necessary, start fresh with a new databases.cfg included in the sourcemod package.
L 06/25/2014 - 23:30:10: [sourcebans.smx] Failed to query database. (Cannot add or update a child row: a foreign key constraint fails (`eliteteamgaming_Sourcebans`.`sb_actions`, CONSTRAINT `action_server` FOREIGN KEY (`server_id`) REFERENCES `sb_servers` (`id`) ON DELETE CASCADE))
Great! You are halfway done, the game server can now communicate with the database. Since this is a new install, I would just say wipe and re-install the database, if you don't want to do that, we can try to work on this error you are getting
Which would be easier? Also, sorry, do I delete just the database, or delete the database and have to reupload and reinstall sourcebans to the directory?