Regarding Sourcebans on my VDS

Ask questions about dedicated servers here and we and other users will do our best to answer them. Please also refer to the self-help section for tutorials and answers to the most commonly asked questions.
Post Reply
behrentzs
New to forums
New to forums
Posts: 5
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Sun Nov 15, 2015 6:44 am

Regarding Sourcebans on my VDS

Post by behrentzs »

Hello everyone :)

I'm running a couple of CS:GO servers on my VDS, and everything is good so far.
I really wanted to get Sourcebans going, so i setup a website, and got it installed with no problems at all. But when i went in to try it out - it was not working so well. I was able to ban players, but they would not show up on the banlist, in the websection. Also, they would be unbanned after server restart.

Im getting nothing in my logs.
The strange thing is, that i have the exact same thing going, with a server, hosted from a gsp, and here everything is smooth, with bans showing up and all.

The database.cfg is the same, and i DID remember to set the server ID in the sourcebans.cfg
I would really appreciate some help.

My databases.cfg

Using this:

Code: Select all

"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"	"csgodanmark.hosted.nfoservers.com"	// The host where your mysql server is located
"database"	"behrentzs_sbnew"	// The name of the database
"user"	"xxxxx"	// The name of the user that the plugin should use to connect
"pass"	"xxxx"	// The password for this user
"port"	"3306"


}
This is from the GPS provided server, that are working:

Code: Select all

This is the databases.cfg, from the server it works on. 

"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"	"steam"
"user"	"root"
"pass"	""
//"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"
}

"sourcebans"
{
"driver"	"mysql"
"host"	"csgodanmark.hosted.nfoservers.com"	// The host where your mysql server is located
"database"	"behrentzs_sbnew"	// The name of the database
"user"	"xxx"	// The name of the user that the plugin should use to connect
"pass"	"xxx"	// The password for this user
}

}
Thanks!
User avatar
rlm850
This is my homepage
This is my homepage
Posts: 141
Joined: Thu Dec 10, 2009 12:17 am
Location: Staten Island, NY
Contact:

Re: Regarding Sourcebans on my VDS

Post by rlm850 »

Well, this is the thing.. I would suggest you visit your NFO control panel, and view your website package.
Click on the Databases tab, and ensure that external connections are allowed for your "behrentzs_sbnew" database.

But I viewed your website.. both of your ban installs.
http://csgodanmark.hosted.nfoservers.com/bans
http://csgodanmark.hosted.nfoservers.com/bans2

All the bans are currently visible, and they wouldn't write to the table if external connections weren't enabled and your game server was on a different IP from the web server. However, you stated this is not the case - here:
I was able to ban players, but they would not show up on the banlist, in the websection.
Was there something I missed?
behrentzs
New to forums
New to forums
Posts: 5
Joined: Sun Nov 15, 2015 6:44 am

Re: Regarding Sourcebans on my VDS

Post by behrentzs »

Hey rlm850 - and thanks for your reply!
Was there something I missed?
The bans visible, is from the server hosted with another host then nfo.
None of the bans from any of my nfo servers shows up.

External connections is enabled for all of the databases.
User avatar
rlm850
This is my homepage
This is my homepage
Posts: 141
Joined: Thu Dec 10, 2009 12:17 am
Location: Staten Island, NY
Contact:

Re: Regarding Sourcebans on my VDS

Post by rlm850 »

behrentzs wrote: The bans visible, is from the server hosted with another host then nfo.
None of the bans from any of my nfo servers shows up.
Visit: /csgo/addons/sourcemod/configs/sourcebans.cfg

You want to make sure your "database prefix" is correct (the same one your Denmark servers themselves are using).

If it is not correct, fix it.
If It is correct, I'm assuming this is the past timeline:

A) CS:GO servers currently in DK running fine
B) Order VDS and web hosting from NFO - trying to add servers on VDS to sourcebans on NFO hosting
C) Carried out below process, in no particular order:
  1. Installed sourcebans plugin
  2. Input server information into sourcebans "servers" admin page
  3. sourcemod/configs/databases.cfg-sourcebans.cfg updated with correct info
To be honest, what interests me is the 2 sourcebans installs, one 1.5 one 1.4 -- are these running on the same database? (Which is the reason for me wondering if you have your DatabasePrefix set to the correct one on the sourcebans table.

What interests me even more, is that your Denmark servers are reporting no addons installed (no metamod no sourcemod), but they are running the sourcebans plugin.. perhaps you are making changes as I am typing this?
behrentzs
New to forums
New to forums
Posts: 5
Joined: Sun Nov 15, 2015 6:44 am

Re: Regarding Sourcebans on my VDS

Post by behrentzs »

I checked my database prefix on all servers, and they are all set to the right number, listed on the website, in admin-->server (sourcebans adminpanel)

You're correct assuming about the timeline.

Those 2 different versions, is nothing, dont mind it. They are running on different databases, and im only using the one http://csgodanmark.hosted.nfoservers.com/bans.
I have two installs, as i tried 2 different versions of SB, and have not deleted the 2nd "bans2" yet.

:D
behrentzs
New to forums
New to forums
Posts: 5
Joined: Sun Nov 15, 2015 6:44 am

Re: Regarding Sourcebans on my VDS

Post by behrentzs »

Nobody?
Post Reply