[Karotte]

Hey guys..i installed Sourcebans on my Webspace

"http://www.encore.storage-plan.org/sourcebans/"

on my Gameserver i installed it too.

database.cfg:

Spoiler

"Databases"
{
"driver_default" "mysql"
"Default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
}
"stamm_sql"
{
"driver" "sqlite"
"host" "localhost"
"database" "Stamm-DB"
"user" "root"
}
"sourcebans"
{
"driver" "default"
"host" "localhost"
"database" "encorest_sourcebans"
"user" "encorest_Karotte"
"pass" "*****"
//"timeout" "0"
"port" "3306"
}
}

I read, that "host" has to be the IP of my MYSQL, not "localhost". How can i find it?

I am customer of "www.storage-plan.org" with phpMyAdmin.

My problem is, on sourcebans, there is "Error Connecting".

[Donski]

If you're referring to the Error Connecting on your website, it has nothing to do with your databases.cfg file.

Just make sure the address is correct so it can query the server properly.

With a little stalking, found out that your server runs on 27105, but the one on your Sourcebans say 27015 (default). Try changing that.

[Karotte]

okey haha... yea i changed it, but still Error message :/

but could you tell me, how i can find the "host" for my database.cfg?

BTW: i am using sourcebans 1.5 and 1.4.11 on website, is that ok ?

[Karotte]

EDIT: i removed the Error now.. BUT if i ban on the server, nothing happens on the Website and if i add a ban on sourcebans, im not banned on the server... whats wrong?

Database.cfg

Spoiler

"Databases"
{
"driver_default" "mysql"
"Default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
}
"sourcebans"
{
"driver" "mysql"
"host" "84.201.35.94"
"database" "encorest_sourcebans"
"user" "****"
"pass" "****"
//"timeout" "0"
"port" "3306"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
}

My Webspace-Host said "84.201.35.94" is the IP from webspace, is that the "host" in database?
And why is that port 3306?

[que]

SAME PROBLEM HERE

[sixten_8_9@]

Mysql install correct in database??
check server log for connect/error mysql!!

all correct?

then add correct id
in sourcebans.cfg exempel picture here were u found id on website

[Karotte]

I dont know how to install mysql with sourcebans... my webspace with sourcebans ip is 84.201.35.94.
I dont know how to configurate my database.cfg ...

Database.cfg:

Spoiler

"Databases"
{
"driver_default" "mysql"
"Default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
}
"sourcebans"
{
"driver" "mysql"
"host" "84.201.35.94"
"database" "encorest_sourcebans"
"user" "****"
"pass" "****"
//"timeout" "0"
"port" "3306"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
}

sourcebans.cfg (in configs/ and configs/sourcebans/ because i dont know where to put in):

Spoiler

/**
* 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://www.encore.storage-plan.org/sourcebans/"

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

sourcebans.log:

Spoiler

L 04/11/2014 - 16:51:45: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '84.201.35.94' (110). See FAQ: http://www.sourcebans.net/node/20
L 04/12/2014 - 11:23:19: [sourcebans.smx] Database failure: [1045]: Access denied for user 'encorest_Karotte'@'lvps87-230-27-163.dedicated.hosteurope.de' (using password: YES).

"dedicated.hosteurope.de" is Host of Gameserver, and 84.201.35.94 is Host of Webspace (encorest_Karotte, encorest_sourcebans)

Please Help

[que]

Mysql install correct in database?? check server log for connect/error mysql!!

Where i/we can found this log in which folder?

[Karotte]

Originally Posted by que Where i/we can found this log in which folder?

you need to create the folder "logs" in addons/sourcemod because it isnt auto created. When you did it you can see logs after restart

[que]

@Karotte
Thanks for that.
I repaired my Web SourceBans (Last added bans)
If youre using DirectAdmin (at your website) you need to go there:
YourDomain / MySQL Management / DataBase Name / Access from Hosts and add " % "

Good Luck!