[retsam]

Hopefully set up in a raid or backed up, id hope.

[Nail]

In SourceBans there is a page where all players on a server are found. Prompt, as it is possible to make, that each player became the reference, at a clique on which the administrator would pass to ban addition page and there already parametres

Nickname Steam ID IP Address

have been filled?

I want made bans from motd window in server
On my server 64 slots, and find player in admin menu very difficult and long. In motd window i can see all players on a server at once and to ban necessary in two clique.

For a server I have entered rcщn, therefore players ip SourceBans receives

[dunes]

hey guys

I still have a problem with running sourcebans 1.4.3. I read several times all problem posts in this thread and tried most of these solutions.

the gameserver is a root and the webserver is a v-server.

sourcebans.log

L 07/09/2009 - 18:08:23: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/10/2009 - 05:02:31: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/11/2009 - 05:02:34: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/12/2009 - 05:02:36: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/13/2009 - 05:08:55: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/14/2009 - 05:08:59: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/15/2009 - 17:25:38: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/16/2009 - 05:02:43: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/17/2009 - 18:46:01: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/18/2009 - 05:01:00: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/19/2009 - 05:01:00: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/20/2009 - 05:01:03: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/21/2009 - 05:01:05: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/22/2009 - 05:07:37: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.98' (using password: YES)
L 07/23/2009 - 05:08:03: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/24/2009 - 05:01:47: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/25/2009 - 05:01:15: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/26/2009 - 05:07:34: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)
L 07/27/2009 - 05:01:19: [sourcebans.smx] Database failure: [1045]: Access denied for user 'web0'@'78.143.54.99' (using password: YES)

here my database.cfg

"Databases"
{
 "driver_default"  "mysql"
 
 "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"    "89.110.157.111"
  "database"   "usr_web0_4"
  "user"    "web0"
  "pass"    "xxxxxx"
  //"timeout"   "0"
  "port"   "3306"
 }
}

I also double checked all user and passwords.

is it better to include the IP or the web adress of the server?? cos Im running two domains on that??

the strange thing is that Im running HLstatsX:CE on the same server and this is running without problems.

can any1 help or I just missed 1 thing in my config??

TIA

[Rads]

i had this problem i changed
1. my database name and
2. "driver" "mysql" back to default

[dunes]

I cant change the the database name itself cos of my v-server restrictions.

[DJ Tsunami]

The error is rather obvious, that user doesn't have access to the database from that IP. Grant your user access, or ask your webhost for help, as it has nothing to do with SourceBans.

[dunes]

it seems that the external access to the sql server is blocked. the setting in my web server control panel is right, to allow external access. but it wont work.
I wrote a mail to my host. hopefully he get it fixed fast.

[cyberthug]

im having probs now i updated to Version 1.4.3 from Version 1.4.2 but now most of my recently added admin dont have sm admin they get
[SM] You do not have access to this command. they have all flags that i have and they still get that error so what could it be ?

[Peace-Maker]

Originally Posted by Nail In SourceBans there is a page where all players on a server are found. Prompt, as it is possible to make, that each player became the reference, at a clique on which the administrator would pass to ban addition page and there already parametres have been filled? I want made bans from motd window in server On my server 64 slots, and find player in admin menu very difficult and long. In motd window i can see all players on a server at once and to ban necessary in two clique. For a server I have entered rcщn, therefore players ip SourceBans receives

Don't get that.. You're wanting to do bans out of the motd window watching sourcebans? Is there any question open or were you just telling us?

@ cyberthug:
There were no changes in 1.4.3 regarding the admin handling. Try restarting the server and check, if the admins are still in the admins.cfg. Do you have admin-flatfile.smx loaded?

[Nail]

I have not absolutely understood a question... As on my server 64 players and the big list corrected, in the standard menu the maximum only 10 names is deduced at once, it is more convenient to me to open motd window in which I will see all list of players at once and ban therefrom, having written the reason in a text kind.

It is necessary for me that in the list of players all names became references. Having cluck a name the admin gets in ban menu where fields ip, steam-id and a name are already filled. It is necessary to enter only the reason and ban time to add the player in ban-list

Prompt, whether it is possible to make it simply. If is not present, whether it is planned in following versions?

Sorry for my curve English