You are not logged in.

Dear visitor, welcome to sourceserver.info. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

  • "KifferSports" started this thread

Posts: 25

wcf.user.option.userOption53: Ja

  • Send private message

1

Wednesday, October 14th 2015, 12:46am

SourceBans Ban List

Hallo Ihr Lieben,
Ich habe heute vergeblich versucht SourceBans auf meinem root ans laufen zu bekommen..
Die Seite selber läuft auch (http://ts.fts-clan.org/bans/)... Das Problem ist wenn ich jem. banne wird dieser Ban nicht auf der Homepage angezeigt...


Database läuft und Server wird auch richtig angezeigt.
Server-Id vom Sever ist 1.


Hier meine Server Config:

database.cfg

Quoted

"Databases"
{
"driver_default" "mysql"

"sourcebans"
{
"driver" "mysql"
"host" "localhost"
"database" "Stamm"
"user" "xxx"
"pass" "xxx"
//"timeout" "0"
"port" "3306"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
}


sourcebans.cfg

Quoted

/**
* sourcebans.cfg
*
* This file contains settings for the SourceBans Source Server Plugin
* @author SteamFriends Development Team
* @version 0.0.0.$Rev: 74 $
* @copyright SteamFriends (www.steamfriends.com)
* @package SourceBans
*/

"SourceBans"
{
"Config"
{
// Website address to tell where the player to go for unban, etc
"Website" "http://ts.fts-clan.org/bans/"

// Allow or disallow admins access to addban command
"Addban" "1"

// Allow or disallow admins access to unban command
"Unban" "1"

// The Tableprefix you set while installing the webpanel. (default: "sb")
"DatabasePrefix" "sb"

// How many seconds to wait before retrying when a players ban fails to be checked. Min = 15.0 Max = 60.0
"RetryTime" "45.0"

// How often should we process the failed ban queue in minutes
"ProcessQueueTime" "5"

// Should the plugin automaticaly add the server to sourcebans
// (servers without -ip being set on startup need this set to 0)
"AutoAddServer" "0"

// Enable backing up config files after getting admins from database (1 = enabled, 0 = disabled)
"BackupConfigs" "1"

// Enable admin part of the plugin (1 = enabled, 0 = disabled)
"EnableAdmins" "1"

// Require the admin to login once into website
"RequireSiteLogin" "0"

// This is the ID of this server (Check in the admin panel -> servers to find the ID of this server)
"ServerID" "1"
}

/*
* Generic menu options for if a reason isn't supplied in a ban
* Without a supplied reason the ban will never be written to the database
*/
"BanReasons"
{
"Hacking" "Hacking"
"Exploit" "General Exploit of Game/Map/Server"
"TK" "Team Killing"
"TF" "Team Flashing"
"CommSpam" "Spamming Mic/Chat"
"BadSpray" "Inappropriate Spray"
"BadLang" "Inappropriate Language"
"BadName" "Inappropriate Name"
"IgnoreAdmin" "Ignoring Admins"
"Stacking" "Team Stacking"
"Own Reason" "Own Reason"
}

/*
* Submenu options for when "Hacking" is selected
* If "Hacking" is removed from the menu above this will not be accessable
*/
"HackingReasons"
{
"Aimbot" "Aimbot"
"Antirecoil" "Anti Recoil"
"Wallhack" "Wallhack"
"Spinhack" "Spinhack"
"Speedhack" "Speedhack"
"Multi-Hack" "Multi-Hack"
"No Smoke" "No Smoke"
"No Flash" "No Flash"
}
}





Warum geht das nicht ?!?!?

danke für jede hilfe!

freak.exe_uLow?

Professional

Posts: 523

Occupation: Admin

wcf.user.option.userOption53: Ja

  • Send private message

2

Wednesday, October 14th 2015, 1:28am

Spoiler Spoiler

PHP Source code

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
"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"
        {
        "host"                "localhost"
        "database"            "DatenbankName"
        "user"                "Uername"
        "pass"                "DasPasswort"
        //"timeout"            "0"
        //"port"            "0"
    }
}

Bara

Professional

Posts: 834

wcf.user.option.userOption53: Ja

  • Send private message

3

Wednesday, October 14th 2015, 9:45am

@freak.exe_uLow?, Sinn hinter diesen Beitrag?

Wie im ersten Post zusehen besteht bereits ein Eintrag für sourcebans in der databases.cfg.

Interessant zu wissen wäre ob es error logs gibt.

  • "KifferSports" started this thread

Posts: 25

wcf.user.option.userOption53: Ja

  • Send private message

4

Wednesday, October 14th 2015, 1:15pm

Ja gibt es..

Quoted

"L 10/14/2015 - 12:42:41: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20"

freak.exe_uLow?

Professional

Posts: 523

Occupation: Admin

wcf.user.option.userOption53: Ja

  • Send private message

5

Wednesday, October 14th 2015, 2:07pm

@freak.exe_uLow?, Sinn hinter diesen Beitrag?

Wie im ersten Post zusehen besteht bereits ein Eintrag für sourcebans in der databases.cfg.

Interessant zu wissen wäre ob es error logs gibt.
Aso war spät am Abend und dachte ne klammer fehlt^^

Ähm er kann sich nicht verbinden, du hast was falsches in der database zu stehen...

  • "KifferSports" started this thread

Posts: 25

wcf.user.option.userOption53: Ja

  • Send private message

6

Wednesday, October 14th 2015, 2:41pm

ähm und kann man herausfinden was dort falsch ist ? :D

freak.exe_uLow?

Professional

Posts: 523

Occupation: Admin

wcf.user.option.userOption53: Ja

  • Send private message

7

Wednesday, October 14th 2015, 3:04pm

Mich wundert auch das du da Stamm zu stehen hast...^^ ähm, du musst das gleiche was du auch bei der Sourcebans Seite einegeben hast, in die Database.cfg eintragen dann sollte es eigentlich gehen.

Oder Klammer mal den Port aus sprich //"port" "3306"

Solltest du der Meinung sein das du alles richtig hast, und du ein Linux Server besitzten tust, gib das mal bei Putty ein.

MySQL queries

1
ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

This post has been edited 2 times, last edit by "freak.exe_uLow?" (Oct 14th 2015, 3:13pm)


  • "KifferSports" started this thread

Posts: 25

wcf.user.option.userOption53: Ja

  • Send private message

8

Wednesday, October 14th 2015, 3:20pm

in der config.php von der sourcebans seite steht:

Quoted

<?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', 'XXX'); // The username to connect with
define('DB_PASS', 'XXX'); // The password
define('DB_NAME', 'Stamm'); // Database name
define('DB_PREFIX', 'sb'); // The table prefix for SourceBans
define('DB_PORT','3306'); // The SQL port (Default: 3306)

//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)
?>



Die seite selber läuft auch ohne Probleme!

Stamm habe ich die datenbank gekannt...
und in der
databases.cfg steht:

Quoted

"Databases"
{
"driver_default" "default"

"sourcebans"
{
"driver" "mysql"
"host" "localhost"
"database" "Stamm"
"user" "XXX"
"pass" "XXX"
//"timeout" "0"
"port" "3306"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}

"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
}



das sollte doch so klappen, oder nicht?

EDIT:
auch mit ausgeklammerten port geht es nicht =(

This post has been edited 1 times, last edit by "fluxX" (Oct 14th 2015, 6:28pm)


freak.exe_uLow?

Professional

Posts: 523

Occupation: Admin

wcf.user.option.userOption53: Ja

  • Send private message

9

Wednesday, October 14th 2015, 3:38pm

Liegt dein Webserver auch auf deim Root?

Und hast du schon mal das hier versucht?

MySQL queries

1
ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

  • "KifferSports" started this thread

Posts: 25

wcf.user.option.userOption53: Ja

  • Send private message

10

Wednesday, October 14th 2015, 3:48pm

MUss ich dasfür in einen bestimmten ordner?

ln: failed to create symbolic link ‘/tmp/mysql.sock’: File exists
No command 'ln:' found, did you mean:
Command 'ln' from package 'coreutils' (main)
ln:: command not found

EDIT:
oder hats du evt. Zeit kurz auf unseren ts3 zu kommen ?
ip: ts.fts-clan.org

This post has been edited 1 times, last edit by "fluxX" (Oct 14th 2015, 6:28pm)


freak.exe_uLow?

Professional

Posts: 523

Occupation: Admin

wcf.user.option.userOption53: Ja

  • Send private message

11

Wednesday, October 14th 2015, 4:48pm

Problem ist behoben.

Er hatte das 2 Sachen nicht installiert, hier der fix:

MySQL queries

1
apt-get update && apt-get install zlib1g lib32z1

This post has been edited 2 times, last edit by "freak.exe_uLow?" (Sep 5th 2018, 9:04pm)


  • "KifferSports" started this thread

Posts: 25

wcf.user.option.userOption53: Ja

  • Send private message

12

Wednesday, October 14th 2015, 7:21pm

jop, danke für die Hilfe!

Similar threads

Used tags

Sourcebans