AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   SourceBans / SourceBans++ (https://forums.alliedmods.net/forumdisplay.php?f=152)
-   -   I really need help to get this working (https://forums.alliedmods.net/showthread.php?t=274374)

behrentzs 11-07-2015 02:46

I really need help to get this working
 
1 Attachment(s)
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)


All times are GMT -4. The time now is 14:53.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.