AlliedModders - [Release] SourceBans++ (v1.6.4) [Updated: 2021-10-06]

AlliedModders (https://forums.alliedmods.net/index.php)

- SourceBans / SourceBans++ (https://forums.alliedmods.net/forumdisplay.php?f=152)

- - Release SourceBans++ (v1.6.4) [Updated: 2021-10-06] (https://forums.alliedmods.net/showthread.php?t=263735)

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]

Quote:

Originally Posted by ijam_j (Post 2364377)

by the way, what is the recommended way and supported by sourcebans to ban disconnected players? sm_addbans doesnt seems to work.

Well, it works for me :P Ban is successfully added to the list and prevents player from connecting.

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]

Receiving an error on my website.

"Fatal error: mysqli error: [1054: Unknown column 'setting' in 'where clause'] in EXECUTE("SELECT value FROM `sb_settings` WHERE setting = 'config.debug';") in /home/****/public_html/bans/includes/adodb/adodb-errorhandler.inc.php on line 77"

Can anyone help?

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]

Quote:

Originally Posted by Wilczek (Post 2364431)

Well, it works for me :P Ban is successfully added to the list and prevents player from connecting.

dont know why but now sm_addban works. probably my faults.

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]

Quote:

Originally Posted by lnnocent (Post 2364584)

i also have an error related to adodb-errorhandler.inc.php on line 77. it is caused by mariadb. sourceban++ only support mysql and mariadb is not 100% compatible with mysql.

see my previous post for solutions.

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]

Hello,

why i get:

Quote:

L 11/21/2015 - 09:57:20: SourceMod error session started
L 11/21/2015 - 09:57:20: Info (map "de_dust2") (file "errors_20151121.log")
L 11/21/2015 - 09:57:20: [sourcecomms.smx] Lost connection to DB. Reconnect after delay.
L 11/21/2015 - 09:57:20: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms'
L 11/21/2015 - 09:57:20: [SourceSleuth.smx] SourceSleuth: Database query error: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_bans'
L 11/21/2015 - 09:57:20: [SM] Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4)
L 11/21/2015 - 09:57:20: [SM] Displaying call stack trace for plugin "SourceSleuth.smx":
L 11/21/2015 - 09:57:20: [SM] [0] Line 189, SourceSleuth.sp::SQL_CheckHim()
L 11/21/2015 - 09:58:06: [sourcecomms.smx] Lost connection to DB. Reconnect after delay.
L 11/21/2015 - 09:58:06: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms'
L 11/21/2015 - 09:58:52: [sourcecomms.smx] Lost connection to DB. Reconnect after delay.
L 11/21/2015 - 09:58:52: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms'
L 11/21/2015 - 09:59:38: [sourcecomms.smx] Lost connection to DB. Reconnect after delay.
L 11/21/2015 - 09:59:38: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms'
L 11/21/2015 - 10:00:25: [sourcecomms.smx] Lost connection to DB. Reconnect after delay.
L 11/21/2015 - 10:00:25: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms'
L 11/21/2015 - 10:01:11: [sourcecomms.smx] Lost connection to DB. Reconnect after delay.
L 11/21/2015 - 10:01:11: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms'
L 11/21/2015 - 10:01:57: [sourcecomms.smx] Lost connection to DB. Reconnect after delay.
L 11/21/2015 - 10:01:57: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms'
L 11/21/2015 - 10:02:43: [sourcecomms.smx] Lost connection to DB. Reconnect after delay.
L 11/21/2015 - 10:02:43: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms'
L 11/21/2015 - 10:03:22: [SourceSleuth.smx] SourceSleuth: Database query error: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_bans'

MySQL is allowed to externe.

User have GRANT Privileges, user/password is correctly.

Client %, localhost, IPDEDICATED and 127.0.0.1 has been added to GRANT privileges.

Mysql restarted.

debug sourcebans:

Quote:

[+] SourceBans "Error Connecting()" Debug starting for server 94.23.221.98:25815

[+] 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: EMC | DeathMatch by go-free.info

[+] 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!

server csgo is not on my dedicated server.

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]

Quote:

Originally Posted by eric0279 (Post 2365226)

Hello,

why i get:
MySQL is allowed to externe.

User have GRANT Privileges, user/password is correctly.

Client %, localhost, IPDEDICATED and 127.0.0.1 has been added to GRANT privileges.

Mysql restarted.

debug sourcebans:

server csgo is not on my dedicated server.

On Linux, localhost is always 127.0.0.1

You have to put 127.0.0.1 in databases.cfg

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]

no, server csgo and web server has not on same machine.

Fixed, work now

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]

Hi guys, i get this error :

Quote:

L 11/24/2015 - 12:25:35: [SM] Displaying call stack trace for plugin "sourcebans.smx":
L 11/24/2015 - 12:25:35: [SM] [0] Line 1071, D:\scripting\sourcebans.sp::VerifyInsert()

And I don't get why because players get banned but not kicked.

Thank you for your help.

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]

Quote:

Originally Posted by NeioWolf (Post 2365963)

Hi guys, i get this error :

And I don't get why because players get banned but not kicked.

Thank you for your help.

The error is on the line before that.

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]

im haven a problem and with no errors.

when i join a server its fine i have admin then on map change no one has admin they must rejoin to get there admin back.

anyway to fix this