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)

BeNq! 11-08-2015 14:21

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
Why page is empty: http://testban.gameclan.pl/sban/index.php?p=banlist ?

Sarabveer 11-08-2015 14:22

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

Originally Posted by BeNq! (Post 2361123)

MariaDB is the culprit.

Trans_Am_00 11-09-2015 17:38

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
How do i use this
Code:

SourceBans Connection Debugger

Sarabveer 11-09-2015 17:39

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

Originally Posted by Trans_Am_00 (Post 2361543)
How do i use this
Code:

SourceBans Connection Debugger


Jakeey802 11-09-2015 20:47

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
Maybe try salting the default passwords

Kubad 11-10-2015 17:12

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
help me i trying command /addban and command say this [SourceBans] sm_addban failed

andre2843 11-12-2015 13:12

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
I have this error (Possible hacking attempt (URL Key mismatch) What solution?

Trans_Am_00 11-12-2015 17:51

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
Do i need this at server.cfg when using sb?
writeid
writeip

DarkDeviL 11-12-2015 19:00

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

Originally Posted by Trans_Am_00 (Post 2362503)
Do i need this at server.cfg when using sb?
writeid
writeip

Depends if you plan to use SourceBans alone or also the banned*.cfg files as well...

Trans_Am_00 11-12-2015 19:16

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

Originally Posted by arne1288 (Post 2362515)
Depends if you plan to use SourceBans alone or also the banned*.cfg files as well...

If i wanna use sb alone?

DarkDeviL 11-12-2015 21:37

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

Originally Posted by Trans_Am_00 (Post 2362518)
If i wanna use sb alone?

...then you shouldn't care about that commands at all.

ph 11-13-2015 06:55

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
--- Please ignore. found my answer.




How do I :-

Disable In-game chat notification, that this player has been previously banned ?


Example:

Code:

[SourceBans] Warning: Player "lovkal | trade.tf" has 1 previous SB bans on record.
How do I disable this message notification.

Trans_Am_00 11-13-2015 08:26

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
i should also remove this command if i wanna use sb alone?

exec banned_user.cfg
exec banned_ip.cfg

DarkDeviL 11-13-2015 10:02

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

Originally Posted by Trans_Am_00 (Post 2362637)
i should also remove this command if i wanna use sb alone?

exec banned_user.cfg
exec banned_ip.cfg

Then don't care about anything related to those files either, no matter what the commands are!

eric0279 11-16-2015 14:54

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

Originally Posted by abrandnewday (Post 2354393)
I just realized that I had that same issue. Ignore it and just edit the config.php file and add in the info for these:

PHP Code:

define('STEAMAPIKEY','');                // Steam API Key for Shizz
define('SB_WP_URL','');                       //URL of SourceBans Site 

Basically SourceBans tries to take the info you pop in for the API key and URL and put them in the config but there's apparently some code missing somewhere so it fails to do so. Manually adding it in fixes the issue. API is for the OpenID Steam login, and the URL is also for that I believe.

As for you Zastrelis, I'd quote your post but the forum just brings up an empty white text box so I can't quote it for some reason, but see above for the fix.

And putting "UNDEFINED INDEX" in giant letters is NOT helpful in any way.




I have reinstalled sourcebans (latest version stable) and i get same error:
config.php:
Quote:

<?php
/**
* config.php
*
* This file contains all of the configuration for the db
* that will
* @author SteamFriends Development Team
* @version 1.0.0
* @copyright SteamFriends (www.SteamFriends.com)
* @package SourceBans
*/
if(!defined('IN_SB')){echo 'You should not be here. Only follow links!';die();}

define('DB_HOST', 'localhost'); // The host/ip to your SQL server
define('DB_USER', 'sourcebans'); // The username to connect with
define('DB_PASS', '*********'); // The password
define('DB_NAME', 'sourcebans'); // Database name
define('DB_PREFIX', 'sb'); // The table prefix for SourceBans
define('DB_PORT','3306'); // The SQL port (Default: 3306)
define('STEAMAPIKEY',''); // Steam API Key for Shizz
define('SB_WP_URL',''); //URL of SourceBans Site

//define('DEVELOPER_MODE', true); // Use if you want to show debugmessages
//define('SB_MEM', '128M'); // Override php memory limit, if isn't enough (Banlist is just a blank page)
?>
Quote:

Notice: Undefined index: apikey in /usr/share/nginx/html/install/template/page.5.php on line 50

Notice: Undefined index: sb-wp-url in /usr/share/nginx/html/install/template/page.5.php on line 51

Sarabveer 11-17-2015 17:28

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
I must be the only one who actually had the installer setup config.php correctly.

It worked fine for me, and I redid it so many times.

Server Info:
Apache/2.4.17 (Win64) OpenSSL/1.0.2d PHP/5.6.15

Maybe cause Linux is messing with something, cause all the errors are from Linux servers, is the config.php set to 777?

sneaK 11-17-2015 18:33

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
I too had to manually input my Steam API key and URL post-installation. Not a huge deal, easy to identify and remedy.

eric0279 11-17-2015 19:27

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
chmod 777 config.php for install, yes and back to 644 after.

driz 11-17-2015 21:19

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

ijam_j 11-17-2015 23:59

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
Banned user using this command in console

Code:

sm_addban STEAM_0:0:1873983 0 Dumb
i get this error

Code:

L 11/18/2015 - 12:41:40: [SM] Native "SQL_TQuery" reported: Invalid database Han
dle 0 (error: 4)
L 11/18/2015 - 12:41:40: [SM] Displaying call stack trace for plugin "sourcebans
.smx":
L 11/18/2015 - 12:41:40: [SM]  [0]  Line 666, sourcebans.sp::CommandAddBan()

this is my error log

Code:

L 11/18/2015 - 11:50:30: [sourcebans.smx] Database failure: [1045]: Access denied for user 'sb'@'localhost' (using password: YES). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
this is my database.cfg

Code:

"sourcebans"
        {
                "driver"                        "mysql"
                "host"                                "256.93.8.10" //not real ip
                "database"                        "sourcebans"
                "user"                                "user"
                "pass"                                "pass"
                //"timeout"                        "0"
                "port"                        "3306"
        }

i dont remember setting username sb and localhost as ip. where do i fix that?

sourcemod site works and i can add servers. but i cant ban user.

ijam_j 11-18-2015 12:02

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
did anybody got sourcebans++ working? i tried sourcebans, sourcebans++ and sourcebans++ dev, none of them worked. i install on the same server as the dedicated server. web server using xampp.

ijam_j 11-18-2015 12:03

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
i noticed that the ban page is empty. and during installation, i get this error
Notice: Undefined index: apikey in C:\xampp\htdocs\sourcebans++beta\install\temp late\page.5.php on line 50

Notice: Undefined index: sb-wp-url in C:\xampp\htdocs\sourcebans++beta\install\temp late\page.5.php on line 51

help anybody.

ijam_j 11-18-2015 14:27

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
my banlist page is empty.

from the faq, i tried uncomment this line in C:\xampp\htdocs\sourcebans\config.php

Quote:

define('SB_MEM', '128M');
memory_limit in php.ini is

Quote:

memory_limit=128M
i also have check the box for 'No Country Research' in webpanel settings page.

i tried restarting apache, mysql and srcds server, but i still get empty ban list page.

Wilczek 11-18-2015 14:35

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

ijam_j 11-18-2015 19:24

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

Originally Posted by Wilczek (Post 2364244)
Got it working fine.

so i guess its my machine then. did you host it on windows or linux? if windows, are you using xampp or else? did you do any special settings other than the one in the manual?

i have tried reinstalling from scratch multiple times. same error everytime.

currently, i can ban player from sm_admin. banned players will be visible in dashboard. but not on ban list page.i cant ban disconnected players using sm_addban.

ban list page and unable to ban disconected players(using sm_addban) are the only issue im having. evereything else works fine.

i tried 3 method to fix empty ban list page from the faq, doesnt work. i have no clue how to fix sm_addban.

driz 11-18-2015 19:33

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

Originally Posted by ijam_j (Post 2364310)
so i guess its my machine then. did you host it on windows or linux? if windows, are you using xampp or else? did you do any special settings other than the one in the manual?

i have tried reinstalling from scratch multiple times. same error everytime.

currently, i can ban player from sm_admin. banned players will be visible in dashboard. but not on ban list page.i cant ban disconnected players using sm_addban.

ban list page and unable to ban disconected players(using sm_addban) are the only issue im having. evereything else works fine.

i tried 3 method to fix empty ban list page from the faq, doesnt work. i have no clue how to fix sm_addban.

can you paste your version of mysql. i've only ever seen blank ban/comms pages when using mariadb. if you are using mariadb (as i suspect) take a look @ https://forums.alliedmods.net/showpo...1&postcount=39

NiagaraDryGuy 11-18-2015 22:01

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

Originally Posted by ijam_j (Post 2364208)
i noticed that the ban page is empty. and during installation, i get this error
Notice: Undefined index: apikey in C:\xampp\htdocs\sourcebans++beta\install\temp late\page.5.php on line 50

Notice: Undefined index: sb-wp-url in C:\xampp\htdocs\sourcebans++beta\install\temp late\page.5.php on line 51

help anybody.

Open your config.php file, add in the site URL and your steam API key (there's two defines in there where the information should go during installation), and save the config.php file. For some reason, the installation does not forward the wp-url and apikey information to the config file. Adding it manually works.

ijam_j 11-18-2015 22:19

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

Originally Posted by driz (Post 2364312)
can you paste your version of mysql. i've only ever seen blank ban/comms pages when using mariadb. if you are using mariadb (as i suspect) take a look @ https://forums.alliedmods.net/showpo...1&postcount=39

That is exactly what my debug view looks like. And commenting the line 77 in C:\xampp\htdocs\sourcebans\includes\adodb\ado db-errorhandler.inc.php solves the problem. And yes, xampp uses MariaDB.

Thanks a lot. Im suprised i cant find this issue in google. I guess everybodys is using linux.

ijam_j 11-18-2015 22:26

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

Originally Posted by abrandnewday (Post 2364367)
Open your config.php file, add in the site URL and your steam API key (there's two defines in there where the information should go during installation), and save the config.php file. For some reason, the installation does not forward the wp-url and apikey information to the config file. Adding it manually works.

thanks. that works in eliminating the error.

ijam_j 11-18-2015 22:31

Re: [RELEASE] SourceBans++ (v1.5.3) [Updated: 2015-10-07]
 
by the way, what is the recommended way and supported by sourcebans to ban disconnected players? sm_addbans doesnt seems to work.

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 10:43.

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