[Sir Joe]

Edit: I added it manually through the ban website and it worked it banned me from the game and showed up on the list.. what now?


This is my updated data base file.

"Databases"
{
    "driver_default"        "mysql"
    
    "sourcebans"
    {
        "driver"            "default"
        "host"                "67.212.186.146"
        "database"            "electri8_banned"
        "user"                "electri8_mishap2"
        "pass"                "my pass"
        //"timeout"            "0"
        "port"                    "3306"
    }

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

Heres an updated error log after I gave this a try.

L 05/12/2009 - 17:29:11: [sourcebans.smx] OnAdminMenuReady()
L 05/12/2009 - 17:29:11: [sourcebans.smx] Result of AddToTopMenu: 30
L 05/12/2009 - 17:29:11: [sourcebans.smx] Added Ban option to admin menu
L 05/12/2009 - 17:29:11: [sourcebans.smx] OnAllPluginsLoaded()
L 05/12/2009 - 17:29:11: [sourcebans.smx] OnAdminMenuReady()
L 05/12/2009 - 17:29:27: [sourcebans.smx] Database failure: [1045]: Access denied for user 'electri8_mishap2'@'68.232.160.156' (using password: YES)
L 05/12/2009 - 17:29:41: [sourcebans.smx] AdminMenu_Ban()
L 05/12/2009 - 17:29:41: [sourcebans.smx] AdminMenu_Ban()
L 05/12/2009 - 17:29:41: [sourcebans.smx] AdminMenu_Ban() -> Formatted the Ban option text
L 05/12/2009 - 17:29:42: [sourcebans.smx] AdminMenu_Ban()
L 05/12/2009 - 17:29:42: [sourcebans.smx] DisplayBanTargetMenu()
L 05/12/2009 - 17:29:42: [sourcebans.smx] AdminMenu_Ban() -> DisplayBanTargetMenu()
L 05/12/2009 - 17:29:44: [sourcebans.smx] MenuHandler_BanPlayerList()
L 05/12/2009 - 17:29:44: [sourcebans.smx] DisplayBanTimeMenu()
L 05/12/2009 - 17:29:44: [sourcebans.smx] MenuHandler_BanPlayerList()
L 05/12/2009 - 17:29:46: [sourcebans.smx] MenuHandler_BanTimeList()
L 05/12/2009 - 17:29:46: [sourcebans.smx] MenuHandler_BanTimeList()
L 05/12/2009 - 17:29:46: [sourcebans.smx] PrepareBan()

[Lebson506th]

That's not an error log, that is just telling you what is doing on.

Edit:

Except this line:

L 05/12/2009 - 17:29:27: [sourcebans.smx] Database failure: [1045]: Access denied for user 'electri8_mishap2'@'68.232.160.156' (using password: YES)

Double check the IP, username, and password you are using in the databases.cfg

[Sir Joe]

My mistake I uploaded the wrong text file this is the new one with the real error report, but im pretty sure im getting a connection because when I manually add a ban on the website it works shows the person bans me in game etc etc etc.

L 05/12/2009 - 18:17:27: SourceMod error session started
L 05/12/2009 - 18:17:27: Info (map "surf_xiv_v2a") (file "errors_20090512.log")
L 05/12/2009 - 18:17:27: [SM] Native "SQL_EscapeString" reported: Invalid database Handle 0 (error: 4)
L 05/12/2009 - 18:17:27: [SM] Displaying call stack trace for plugin "sourcebans.smx":
L 05/12/2009 - 18:17:27: [SM]   [0]  Line 2126, sourcebans.sp::UTIL_InsertBan()
L 05/12/2009 - 18:17:27: [SM]   [1]  Line 1820, sourcebans.sp::BanFromMenu()
L 05/12/2009 - 18:17:27: [SM]   [2]  Line 789, sourcebans.sp::HackingSelected()
L 05/12/2009 - 18:17:37: [SM] Native "SQL_EscapeString" reported: Invalid database Handle 0 (error: 4)
L 05/12/2009 - 18:17:37: [SM] Displaying call stack trace for plugin "sourcebans.smx":
L 05/12/2009 - 18:17:37: [SM]   [0]  Line 2126, sourcebans.sp::UTIL_InsertBan()
L 05/12/2009 - 18:17:37: [SM]   [1]  Line 1820, sourcebans.sp::BanFromMenu()
L 05/12/2009 - 18:17:37: [SM]   [2]  Line 789, sourcebans.sp::HackingSelected()

[NoS]

Nvm

[xikkub]

I added my server to the list and gave my steamid all the permissions, however, sm_admin still gives me the unauthorized message. My admins.cfg file is blank, and when i manually change it, it works. Why won't the web ui do this for me?

BTW: select * from sm_admins confirms that my username and steamid etc appear in the mysql database.

[Sir Joe]

Originally Posted by xikkub I added my server to the list and gave my steamid all the permissions, however, sm_admin still gives me the unauthorized message. My admins.cfg file is blank, and when i manually change it, it works. Why won't the web ui do this for me? BTW: select * from sm_admins confirms that my username and steamid etc appear in the mysql database.

I dont think this is a source ban problem as much as you just not editing the admins.

[Mu6o]

Hello to all.
I have a problem, on my server the steam id are changing i don`t know why.
So do you have to make rights on admin by name or ip, because i search everywhere and couldn`t find, exept for cstrike\addons\sourcemod\configs\admin.cfg but when i write them there from the mysql database, changes them back. So do you have? And if you don`t could you make?



P.S.:Sorry for my bad English

Originally Posted by xikkub I added my server to the list and gave my steamid all the permissions, however, sm_admin still gives me the unauthorized message. My admins.cfg file is blank, and when i manually change it, it works. Why won't the web ui do this for me? BTW: select * from sm_admins confirms that my username and steamid etc appear in the mysql database.

Your problem maybe is that you didn`t go to yoursite.com/sourcebans then admin panel, admins and make you admin on your server???
Just quessing

[Sir Joe]

Originally Posted by Mu6o Hello to all. I have a problem, on my server the steam id are changing i don`t know why. So do you have to make rights on admin by name or ip, because i search everywhere and couldn`t find, exept for cstrike\addons\sourcemod\configs\admin.cfg but when i write them there from the mysql database, changes them back. So do you have? And if you don`t could you make?

Steam ID's dont change unless you change accounts on steam it self, your ip will change if you use a router most routers have dynamic ip's and change every time they are turned off or reset, so you would add it by steam ID go into game and type status in console for example this is what a steam ID looks like when you type status STEAM_0:0:9278078 there are alot of other things in there but that is what you need.

[Mu6o]

I want to make my admins by IP AND NAMES
NO STEAM ID.

[Lebson506th]

Steam IDs change if you use no-steam servers.