NOTE:
TO ALL WITH THE SAME PROBLEM - You do NOT have the mySQL prevelegies needed to acess the DB from remote, if you use a shared hosting plan. A VPS/VPS MYSQL IS NEEDED to run sourcebans properly.
Everything is set up, and running great, except "showing banned players" on the list?
This is my log:
HTML Code:
L 11/02/2015 - 03:00:47: [sourcebans.smx] plugins/basebans.smx was unloaded and moved to plugins/disabled/basebans.smx
L 11/02/2015 - 03:04:20: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '**awebsite***' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/02/2015 - 03:07:11: [sourcebans.smx] Query Failed: near "SET": syntax error
L 11/02/2015 - 03:07:11: [sourcebans.smx] Failed to retrieve overrides from the database, no such table: sb_overrides
L 11/02/2015 - 03:07:11: [sourcebans.smx] Failed to retrieve groups from the database, no such table: sb_srvgroups
L 11/02/2015 - 03:07:11: [sourcebans.smx] Failed to retrieve admins from the database, near "SELECT": syntax error
L 11/02/2015 - 03:15:41: [sourcebans.smx] Query Failed: near "SET": syntax error
L 11/02/2015 - 03:15:41: [sourcebans.smx] Failed to retrieve overrides from the database, no such table: sb_overrides
L 11/02/2015 - 03:15:41: [sourcebans.smx] Query Failed: near "SET": syntax error
L 11/02/2015 - 03:15:41: [sourcebans.smx] Failed to retrieve groups from the database, no such table: sb_srvgroups
L 11/02/2015 - 03:15:41: [sourcebans.smx] Query Failed: near "SET": syntax error
L 11/02/2015 - 03:15:41: [sourcebans.smx] Failed to retrieve admins from the database, near "SELECT": syntax error
L 11/02/2015 - 03:15:42: [sourcebans.smx] Verify Ban Query Failed: no such table: sb_bans
L 11/02/2015 - 03:16:27: [sourcebans.smx] Verify Ban Query Failed: no such table: sb_bans
L 11/02/2015 - 03:16:53: [sourcebans.smx] Verify Insert Query Failed: no such table: sb_bans
L 11/07/2015 - 03:49:44: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 03:49:45: [sourcebans.smx] plugins/basebans.smx was unloaded and moved to plugins/disabled/basebans.smx
L 11/07/2015 - 03:52:47: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 03:53:34: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 03:54:30: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 03:59:15: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 07:19:00: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 07:19:29: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 07:20:16: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 07:23:52: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 07:24:15: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 08:20:52: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 08:49:33: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 09:02:51: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 09:02:56: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 09:03:19: [sourcebans.smx] Database failure: [1045]: Access denied for user 'behrentzs'@'77.233.248.207' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 11/07/2015 - 18:06:02: [sourcebans.smx] Verify Insert Query Failed: Column 'sid' cannot be null
This is the website:
http://www.csgo-danmark.net/bans/index.php?p=home
Ports are open on my webhost. I asked them twice, just in case.
Help me, and i'll pray for you.
I ran the debug script, here is the result:
HTML Code:
[+] SourceBans "Error Connecting()" Debug starting for server dk23.speedgaming.pro:29015
[+] Trying to establish UDP connection
[+] UDP connection successfull!
[+] Trying to write to the socket
[+] Successfully requested server info. (That doesn't mean anything on an UDP stream.) Reading...
[+] Got an response! Server: [DK] CSGO-Danmark.net - [Hoejhus | Rank | Bhop | 1000 mbit/s]
[+] Trying to establish TCP connection
[+] TCP connection successfull!
[+] Trying to write to TCP socket and authenticate via rcon
[+] Successfully sent authentication request. Reading...
[+] Got an response!
[+] Password correct!
**UPDATE**
Communications Block List shows up and works, but player bans still does not show up.
(LOOK ATTACHCHMENT)