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.

Razzer2406

Trainee

  • "Razzer2406" started this thread

Posts: 70

Location: Hamburg

Occupation: Einzelhandelskaufmann

wcf.user.option.userOption53: Ja

  • Send private message

1

Wednesday, August 26th 2015, 2:07pm

Sourcbans 2.0 keine Verbindung zur MYSL

Hey ho,

ich bräuchte mal eure Hilfe bitte. Ich bin zurzeit dabei Sourcebans 2.0 auf unsere Server mit zuintrigieren. Wollte von 1.5 mal umsteigen.
Das ganze verwende ich zurzeit auf ein testserver.

Das Sourceban Webpanel ist auf merinen Vserver und der CSS-Server auf meinen Root. Die Mysql läuft Via root server.
Das Webpanel ist soweit richtig konfiguriet und verbindet sich ganz normal mit der Datenbank und weißt keine Fehler auf.
Die Sourcebans cfg wurde mit den Datenbank Präfix richtig eingestellt (sb2_).

Die Mysl Datenbank ist so konfiguriert das sie nur von Root aufgerufen werden kann und von Definierten IP Adressen außerhalb.

Ich nutze das Easy Wii panel für die Verwaltung meiner Server.(liegt auf den RootServer)


Database.cfg

Spoiler Spoiler

"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" "127.0.0.1"
"database" "sourcebans"
"user" "sb-game"
"pass" "password"
//"timeout" "0"
"port" "3306"
}
}



Sourcebans.cfg

Spoiler Spoiler

/**
* SourceBans Configuration File
*
* @author GameConnect
* @version 2.0.0
* @copyright SourceBans (C)2007-2013 GameConnect.net. All rights reserved.
* @package SourceBans
* @link http://www.sourcebans.net
*/

"SourceBans"
{
"Config"
{
// Website address to tell where the player to go for unban, etc
"Website" "http://www.elite-xtreme-gaming.net"

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

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

// The table prefix you set while installing the webpanel. Default: "sb_"
"DatabasePrefix" "sb2_"

// 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"

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

// If your game server is behind NAT or -ip is not set on startup,
// enter the public IP address or hostname of your game server below
"ServerIP" "217.79.181.97:27019"
}

/*
* Menu options for ban times
*/
"BanTimes"
{
"Permanent"
{
"flags" ""
"length" "0"
}
"10 Minutes"
{
"flags" ""
"length" "10"
}
"30 Minutes"
{
"flags" ""
"length" "30"
}
"1 Hour"
{
"flags" ""
"length" "60"
}
"4 Hours"
{
"flags" ""
"length" "240"
}
"1 Day"
{
"flags" ""
"length" "1440"
}
"1 Week"
{
"flags" ""
"length" "10080"
}
}

/*
* 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"
{
"1" "Hacking"
"2" "General Exploit of Game/Map/Server"
"3" "Team Killing"
"4" "Team Flashing"
"5" "Spamming Mic/Chat"
"6" "Inappropriate Spray"
"7" "Inappropriate Language"
"8" "Inappropriate Name"
"9" "Ignoring Admins"
"0" "Team Stacking"
"11" "Own Reason"
}

/*
* Submenu options for when "Hacking" is selected
* If "Hacking" removed from the menu above this will not be accessible
*/
"HackingReasons"
{
"1" "Aimbot"
"2" "Anti Recoil"
"3" "Wallhack"
"4" "Spinhack"
"5" "Speedhack"
"6" "Multi-Hack"
"7" "No Smoke"
"8" "No Flash"
}
}



Error Log

Spoiler Spoiler

L 08/26/2015 - 13:46:29: SourceMod error session started
L 08/26/2015 - 13:46:29: Info (map "de_dust2") (file "errors_20150826.log")
L 08/26/2015 - 13:46:29: [sourcebans.smx] Could not connect to the database. ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))


Sm Plugins List

Spoiler Spoiler

[SM] Listing 19 plugins:
01 "SourceBans" (2.0.0-dev) by GameConnect
02 "Admin Help" (1.8.0-dev+5552) by AlliedModders LLC
03 "Player Commands" (1.8.0-dev+5552) by AlliedModders LLC
04 "Reserved Slots" (1.8.0-dev+5552) by AlliedModders LLC
05 "SourceBans: Admins" (2.0.0-dev) by GameConnect
06 "SourceBans: Bans" (2.0.0-dev) by GameConnect
07 "Basic Votes" (1.8.0-dev+5552) by AlliedModders LLC
08 "Sound Commands" (1.8.0-dev+5552) by AlliedModders LLC
09 "Anti-Flood" (1.8.0-dev+5552) by AlliedModders LLC
10 "Basic Chat" (1.8.0-dev+5552) by AlliedModders LLC
11 "Fun Commands" (1.8.0-dev+5552) by AlliedModders LLC
12 "Basic Commands" (1.8.0-dev+5552) by AlliedModders LLC
13 "Fun Votes" (1.8.0-dev+5552) by AlliedModders LLC
14 "Admin Menu" (1.8.0-dev+5552) by AlliedModders LLC
15 "Basic Comm Control" (1.8.0-dev+5552) by AlliedModders LLC
16 "Admin File Reader" (1.8.0-dev+5552) by AlliedModders LLC
17 "Nextmap" (1.8.0-dev+5552) by AlliedModders LLC
18 "Client Preferences" (1.8.0-dev+5552) by AlliedModders LLC
19 "Basic Info Triggers" (1.8.0-dev+5552) by AlliedModders LLC



MFG Razzer

DeaD_EyE

Administrator

Posts: 3,980

Location: Hagen

Occupation: Mechatroniker (didaktische Systeme)

wcf.user.option.userOption53: Nein

  • Send private message

2

Wednesday, August 26th 2015, 4:20pm

Source code

1
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))


>> [CS:S] Sourcebans-Fehler: Can't connect to local MySQL server through socket

Ich meine, dass man auch anstatt des Hosts in der databases.cfg auch den unix socket angeben kann. In der Unix-Welt macht man das dann normal so:

Source code

1
unix://path/socket


Ich habe keine Ahnung, ob sich die Programmierer von SourceMod an den POSIX-Standard halten. Normalerweise ist es ein Unding das System an die Anwendung anzupassen. Alternativ trägt man anstatt den localhost, die öffentliche IP des Servers als Host in die databases.cfg ein, was aber unschön ist und auch erfordert, dass die Datenbank außerhalb erreichbar ist, was ein Admin normalerweise nicht möchte.

Razzer2406

Trainee

  • "Razzer2406" started this thread

Posts: 70

Location: Hamburg

Occupation: Einzelhandelskaufmann

wcf.user.option.userOption53: Ja

  • Send private message

3

Wednesday, August 26th 2015, 10:25pm

Den Fehler hatte ich gefunden gehabt, ich habe die Database falsch benannt gehabt, da hat ein s gefehlt deswegen hat das nicht funktioniert, war etwas durchn find habe aber den nächsten Fehler entdeckt.

Den Fehler habe ich auch schon nach gesucht bei google und diverse Seiten die haben was von fix gesprochen, der wurde aber soweit durchgführt schon.

Fehler:

Spoiler Spoiler

L 08/26/2015 - 22:17:48: [sourcebans.smx] Failed to query database. (Unknown column 'ip' in 'where clause')

MadMakz

Super Moderator

Posts: 1,878

Location: ~#

wcf.user.option.userOption53: Ja

  • Send private message

4

Thursday, August 27th 2015, 3:23pm

Git master ist defekt (sourcebans.sp auto add feature)
https://github.com/GameConnect/SourceBans/issues/55
https://github.com/GameConnect/SourceBan…omment-53213174
https://github.com/GameConnect/SourceBan…omment-53346526
https://github.com/GameConnect/SourceBan…omment-42085708 (und folgend für Fix)

Oder du umgehst es indem du den/die Server zuvor selber im Panel anlegst.

Razzer2406

Trainee

  • "Razzer2406" started this thread

Posts: 70

Location: Hamburg

Occupation: Einzelhandelskaufmann

wcf.user.option.userOption53: Ja

  • Send private message

5

Sunday, August 30th 2015, 5:26pm

alles klar danke für die Hilfe MadMakz

Similar threads