[eric0279]

I tried to 1 which corresponds to the ID in the panel but there is no change.

[NaRyan]

Having a problem with the version of sourcebans from the SVN.
I updated to that one since it fixes a XML problem.

however when I run the updater I get this error:

Duplicate column name 'steam_universe' 

SQL Query type: EXECUTE
Script: '/bans/updater/index.php'
SQL Query: ALTER TABLE `sb_mods` ADD `steam_universe` TINYINT NOT NULL DEFAULT '0' AFTER `modfolder`, ADD INDEX ( `steam_universe` );
SQL Params:

Setup...
Checking current database version... 354
Updating database to version: 356
Updating...
Running update: v355... Error executing: /updater/data/355.php. Stopping Update!
Update Failed.

Any ideas?

[eric0279]

For CSSource, no problem SourceBans correctly generates the files against with L4D2, no .... I do not think the problem comes from me after multiple tests on different dedicated servers.

[Peace-Maker]

Originally Posted by NaRyan Having a problem with the version of sourcebans from the SVN. I updated to that one since it fixes a XML problem. however when I run the updater I get this error: Duplicate column name 'steam_universe' SQL Query type: EXECUTE Script: '/bans/updater/index.php' SQL Query: ALTER TABLE `sb_mods` ADD `steam_universe` TINYINT NOT NULL DEFAULT '0' AFTER `modfolder`, ADD INDEX ( `steam_universe` ); SQL Params: Setup... Checking current database version... 354 Updating database to version: 356 Updating... Running update: v355... Error executing: /updater/data/355.php. Stopping Update! Update Failed. Any ideas?

Did you run the update twice and it errored before with a different error? You already got the steam_universe column in your sb_mods database table. Try running the queries in /updater/data/355.php manually in phpmyadmin and set the 'config.version' to 355 in your sb_settings database table. Rerun the updater afterwards.

Please report any other issues you might encounter, especially with the new override features!

[eric0279]

I have to open a ticket on the tracker?

[Rp.KryptoNite]

Using latest sourcemod release , Sourcebans couldnt add admins for some reason into the servers
but gives flags ,creates accounts &everything [exept ingame admin]

[Horsedick]

Originally Posted by Rp.KryptoNite Using latest sourcemod release , Sourcebans couldnt add admins for some reason into the servers but gives flags ,creates accounts &everything [exept ingame admin]

Are you sure ports are open for access from host to server? You can verify by using the test file located in this thread somewhere a few pages back I think I posted it.

[eric0279]

Originally Posted by Horsedick ok I don't think you understand.... basically the webhost needs to allow TCP/UDP for the game servers IP# and port 27015 or whatever you have it. You will have to ask the host to do this unless you have root access to the firewall. Now you can test this using the debug file which you will find here: http://www.sourcebans.net/public/sb_...connection.zip just extract that..edit the php and upload it to where your sourcebans web stuff is located then target it in your browser and it should show up if all ports are open or not. Also if you have access to the database stuff in the CP to the web host there is likely something there called Remote MySQL Host access - you put in the IP# or range of your game server there.

You talk about it?


Test :

[+] SourceBans "Error Connecting()" Debug starting for server 192.168.1.32:27015 [+] 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: [L4D2 FR] Server Not MODDED ! All GameMode ! jsigames.net [+] 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!

or from my GSP:

[+] SourceBans "Error Connecting()" Debug starting for server 91.121.231.225:27015 [+] 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: [L4D2 FR] Server Not MODDED ! Mode : Versus On ! jsigames.net [+] 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!

[Horsedick]

Originally Posted by eric0279 You talk about it? Test : or from my GSP:

aww ok I looked back a few posts... do this go into your databases.cfg file and below your sourcebans entry add "storage-local" right below it instead of where "default" is

so it would be like this:

"sourcebans" { "driver" "mysql" "host" "HOSTNAME" "database" "SOURCEBANSDB" "user" "USERNAME" "pass" "PASSWORDt" //"timeout" "0" "port" "3306" } "storage-local" { "driver" "sqlite" "database" "SOURCEBANSDB" }

[eric0279]

This doesn't change the problem ...

database.cfg :

"Databases"
{
    "driver_default"        "mysql"
    
    // When specifying "host", you may use an IP address, a hostname, or a socket file path

    "SOURCEBANSDB"
    {
        "driver"            "mysql"
        "host"                "web-1.jsigames.net"
        "database"            "SOURCEBANSDB"
        "user"                "my_user"
        "pass"                "my_pass"
        "port"                "3306"
    }
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "SOURCEBANSDB"
    }
    "default"
    {
        "driver"            "default"
        "host"                "localhost"
        "database"            "sourcemod"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
    "clientprefs"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
}