[Streetdeath]

Hello all,

"You will always get some code to add to /addons/sourcemod/configs/databases.txt"

You mean the databases.cfg or did I forget one?

My SourceBans does not work yet,
I now have the server added in SB, but it says "Error connecting"...

My homepage has a own database and my SourceBans has a own database, but from the same provider (Revido).
The Gameserver has a own database from Gamed!de.
Could this be a problem?

The Server ID is "1" in the sourcebans.cfg and the added Server in SB has 1 too (seen in the database).
The Server IP is correct too, i can join over SB in my Server, what could be wrong?

[Horsedick]

Originally Posted by Streetdeath My SourceBans does not work yet, I now have the server added in SB, but it says "Error connecting"...

What did the test config file say about opened ports from your webhost to the game server?
file name is sb_debug_connection.php

[Streetdeath]

Thanks for answer,

i cant find the file sb_debug_connection.php, i searched my complete ftp-server with total commander, i think my hoster gives me no access...
Needs the web-database external access?

My web-hoster gives no external access and gamed!de only charge...

[AeroAcrobat]

Hi,

I've the following problem with sourcebans:

I have a dedicated root server, lets name him dedi_server. On dedi_server is sourcebans running, everything is working. Now I have also a vps lets name him v_server. On v_server are the same plugins and configs like on the dedi_server but sourcebans is not working correctly...

If I ban myself on v_server through admin menu then I am banned but I am not showing up on the ban list in sourcebans and I can still connect to all other servers that are on dedi_server.

- sourcebans.cfg is configured right with the server ID "ServerID" "15", "AutoAddServer" "1" (+ip parameter is also set.)

- databeses.cfg

PHP Code:

    "sourcebans"
    {
        "driver"            "mysql"
        "host"            "here is ip of dedi_server"    // The host where your mysql server is located
        "database"    "sourcebans"        // The name of the database
        "user"            "root"                // The name of the user that the plugin should use to connect
        "pass"            "xxx"    // The password for this user
        "port"            "3306"
    } 


Spoiler

errors.log:

PHP Code:

L 03/13/2012 - 15:18:42: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 03/13/2012 - 15:18:42: [SM] Displaying call stack trace for plugin "sourcebans.smx":
L 03/13/2012 - 15:18:42: [SM]   [0]  Line 1400, D:\Program Files (x86)\Zend\Apache2\htdocs\sourcebans\trunk\game_upload\addons\sourcemod\scripting\sourcebans.sp::ProcessQueueCallback() 


sourcebans.log:

PHP Code:

L 03/13/2012 - 14:41:31: [sourcebans.smx] Database failure: [1045]: Access denied for user 'root'@'12.345.167.8' (using password: YES). See FAQ: http://www.sourcebans.net/node/20 


I did all stuff like it is told in FAQ:
GRANT ALL ON database etc.

also if I start cmd -> telnet 123.456.78.9
I get a response.

I have also acces with SQlyog from my pc, works also...
No Firewall.

> > > any Idea how to solve the problem ?

[AeroAcrobat]

Originally Posted by Streetdeath Thanks for answer, i cant find the file sb_debug_connection.php, i searched my complete ftp-server with total commander, i think my hoster gives me no access... Needs the web-database external access? My web-hoster gives no external access and gamed!de only charge...

http://www.sourcebans.net/public/sb_...connection.zip

[Powerlord]

Originally Posted by AeroAcrobat Hi, I've the following problem with sourcebans: I have a dedicated root server, lets name him dedi_server. On dedi_server is sourcebans running, everything is working. Now I have also a vps lets name him v_server. On v_server are the same plugins and configs like on the dedi_server but sourcebans is not working correctly... If I ban myself on v_server through admin menu then I am banned but I am not showing up on the ban list in sourcebans and I can still connect to all other servers that are on dedi_server. - sourcebans.cfg is configured right with the server ID "ServerID" "15", "AutoAddServer" "1" (+ip parameter is also set.) - databeses.cfg PHP Code:     "sourcebans"     {         "driver"            "mysql"         "host"            "here is ip of dedi_server"    // The host where your mysql server is located         "database"    "sourcebans"        // The name of the database         "user"            "root"                // The name of the user that the plugin should use to connect         "pass"            "xxx"    // The password for this user         "port"            "3306"     }  Spoiler errors.log: PHP Code: L 03/13/2012 - 15:18:42: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4) L 03/13/2012 - 15:18:42: [SM] Displaying call stack trace for plugin "sourcebans.smx": L 03/13/2012 - 15:18:42: [SM]   [0]  Line 1400, D:\Program Files (x86)\Zend\Apache2\htdocs\sourcebans\trunk\game_upload\addons\sourcemod\scripting\sourcebans.sp::ProcessQueueCallback()  sourcebans.log: PHP Code: L 03/13/2012 - 14:41:31: [sourcebans.smx] Database failure: [1045]: Access denied for user 'root'@'12.345.167.8' (using password: YES). See FAQ: http://www.sourcebans.net/node/20  I did all stuff like it is told in FAQ: GRANT ALL ON database etc. also if I start cmd -> telnet 123.456.78.9 I get a response. I have also acces with SQlyog. No Firewall. > > > any Idea how to solve the problem ?

root? ROOT? Please tell me you're not trying to connect to MySQL over the Internet as root and there's an error in your databases.cfg file causing that to show up in the error log...

Incidentally, MySQL may be blocking remote connections as root. I haven't checked the MySQL manual, but this is likely intentional behavior. Create a separate database user for SourceBans instead.

Edit: By default, MySQL only allows root connections from the local machine. For security reasons, since anyone that can log in as the root database user can execute commands on the server as the user the DB server is running as... and heaven forbid the DB server is running as the Linux root user/Windows SYSTEM user.

[AeroAcrobat]

yes root ^^ I will change it later bcs everything is setup new.

Databases.cfg:

Spoiler

PHP Code:

"Databases"
{
    "driver_default"        "mysql"
    
    // When specifying "host", you may use an IP address, a hostname, or a socket file path
    
    "default"
    {
        "driver"            "default"
        "host"            "localhost"
        "database"    "sourcemod"
        "user"            "root"
        "pass"            ""
        //"timeout"        "0"
        //"port"            "0"
    }
    
    "storage-local"
    {
        "driver"            "sqlite"
        "database"    "sourcemod-local"
    }

    "clientprefs"
    {
        "driver"            "sqlite"
        "host"            "localhost"
        "database"    "clientprefs-sqlite"
        "user"            "root"
        "pass"            ""
        //"timeout"        "0"
        //"port"            "0"
    }
    
    "sourcebans"
    {
        "driver"            "mysql"
        "host"            "xxx"    // The host where your mysql server is located
        "database"    "sourcebans"        // The name of the database
        "user"            "root"                // The name of the user that the plugin should use to connect
        "pass"            "xxx"    // The password for this user
        "port"            "3306"
    }
} 


I have tested a connection through php with another webhoster and it works...


EDIT: hell yeah... its working now. The ban is showing up on the weblist and so far no errors

But one question:
How can I configure SB so that a player is banned on all servers ? Because I was only banned on my vps but not on the dedicated server.

MANY THANKS!

[Horsedick]

Originally Posted by AeroAcrobat But one question: How can I configure SB so that a player is banned on all servers ? Because I was only banned on my vps but not on the dedicated server. MANY THANKS!

Rehash access to all servers and make sure you have all the servers checked for access by the user doing the banning or else it won't carry over to them.

[LiilCraZy]

I have a problem. So i did every step the manual told me but i get the error

Please delete the updater directory before using SourceBans

I've deleted the Install Directory. I don't know whats going on?

http://simplicity2g.org/sourcebans/

[Horsedick]

Originally Posted by LiilCraZy I have a problem. So i did every step the manual told me but i get the error Please delete the updater directory before using SourceBans I've deleted the Install Directory. I don't know whats going on? http://simplicity2g.org/sourcebans/

I replied to you in PM...this very same post you sent me. But I'll reply here too.

Are you sure you have all the ports open so you can get a connection to the server?

http://www.sourcebans.net/public/sb_...connection.zip

what does this say when you try it? Edit it to reflect the server IP# and port and RCON password if you want then upload it to the you're host and test the page to see if it gives any errors on the ports.