AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   SourceBans / SourceBans++ (https://forums.alliedmods.net/forumdisplay.php?f=152)
-   -   Release SourceBans++ (v1.6.3) [Updated: 2018-04-09] (https://forums.alliedmods.net/showthread.php?t=263735)

Wilczek 11-19-2015 05:26

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.

lnnocent 11-19-2015 15:45

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?

ijam_j 11-20-2015 06:32

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.

ijam_j 11-20-2015 06:34

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

Originally Posted by lnnocent (Post 2364584)
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?

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.

eric0279 11-21-2015 17:16

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.

Sarabveer 11-21-2015 17:37

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

eric0279 11-21-2015 18:22

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
no, server csgo and web server has not on same machine.

Fixed, work now

NeioWolf 11-24-2015 12:32

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.

asherkin 11-25-2015 04:10

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.

mufin 11-26-2015 10:16

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


All times are GMT -4. The time now is 00:18.

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