Removing SA via Admin Console?

[EnderGate]

We used to be able to remove (uncheck) a users SA through the admin html login, however since updating to the latest server version that now requires that users' password', Not effective...

[m&m's]

log in as superadmin and you can remove np ! you will be promted to confirm you realy want to deleat yes / no...... "no password" asked for !

[EnderGate]

Delete? No problem, I want to clear their SA status without their pw...

[m&m's]

Delete? No problem, I want to clear their SA status without their pw...

that window is the window were you can change there password !! or make a account and give them the password you made for them !! not log in to there account , and to me it sounds like you say "clear their account " = is deleating it / get rid of it / not needed anymore ? if this is not what your asking i dont understand what your saying :confused: you can remove sa by deleating there rights and they can still come in as (R) or (U) but not (SA) there name/password will no longer be linked to the sa ! they may have to reregister ? but i hve not tested that ... to know for sure !

[EnderGate]

I want to "UNCHECK" the SA radio box in the example pic, Never mind... forget it. We used to be able to remove ones SA status from here, not anymore. You know not what I refer to.

[Bloodmist]

What he is saying is,

He wants to remove the users Administrative rights, without removing or deleting the user, but the new TS version is requiring him to first type the players password before allowing the removal.

Pretty straight forward question he asked, perhaps you should read the questions before answering.

[m&m's]

when you deleat a sa the person can still log in but not as a (sa) so i was trying to say but it sounds to me he wants some thing else ? and if you look at his screen shot it's a pic of the client edit page , that page is to edit the password only !!!! you have to type in the password 2 time to change it , you dont have to know the password to change it only type something in both lines the same !!!!!!!! - edit= "change password" or delete and add client are your only choices in the superadmin manager !

[EnderGate]

OMG, Here let me make that really clear. I have pointed out in this picture the "SA (ServerAdmin) Radio check box (a box you check or not-check off (when it's not checked the box is cleared)"

m&m, thanks for your effort, but I fix computers, lol, not people. I am just notifing the powers to be, or maybe someone knows how I can remove a members SA without them being logged in, or without editing the d/b directly.

[Bones_taw]

I have seen the same problem as EnderGate. Only difference is I was typically trying to add SA rights.

The scenario is a user already has an account and you want to just Grant/UnGrant SA rights. When you go to the form and change the check box, then hit SAVE, it says "error occurred empty password". So you can't change the SA rights unless you also put in a password.

This is a BIG problem because you don't typically know the guys password and you don't want to change it because then he can't login till you get him the new password.

In previous version of the server, this problem did not exist.

[EnderGate]

Thanks, that is so obvious to me, I didn't think I needed to spell it out to veteran server admins.

[m&m's]

Thanks, that is so obvious to me, I didn't think I needed to spell it out to veteran server admins.

i dont have to proubles you have becuse i do it my way !!! i know the check box is there , and like i said you eather have to edit there password or deleat there account !

[Bones_taw]

That is the work around we are using, but it is a BIG problem because then the user can't login till he gets his new password.

[m&m's]

well then wate till he logs in and click his name and click server admin it will remove his (SA) ! ya a admin has to be on but you dont have to log in to the web admin !

[EnderGate]

Just to inform, attempted to edit an account's SA rights via the Web Console, knowing and using the users correct password, provides an error message as well

Yes we can do all that throught the Client, no worries really, just bringing it up, we love the program and wish to support it's further development...

[m&m's]

yep thats why i said you need to deleat it or change the password to uncheck the box , or wate for him to come in an take it away then !

[n00belit3]

Im having the same problem. I take it that when admins dont respond to a support topic its because they have no clue themselves on how to fix the problem. And m&m whats with all the exclamation points omg!!!!11!!!!1111

[m&m's]

Im having the same problem. I take it that when admins dont respond to a support topic its because they have no clue themselves on how to fix the problem. And m&m whats with all the exclamation points omg!!!!11!!!!1111

i like them !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!

[Bones_taw]

m&m, appreciate your replies, but we have a difference of opinion, You keep saying the same thing and the work around that we already know. You seem to think it is ok as is, I do not.

Probably you are not trying to manage a clan with 400 members. Waiting for someone to log in does not work because it is very inconvenient and just not realistic for a large number of users.

I also want to repeat that before a recent update, you used to be able to grant or revoke SA access from web admin without having to enter or change password. Which, makes me think this is a bug that crept in.

Can someone form TS org respond to this thread?

[m&m's]

ya i know we could remove befor hand ! thats why i stated the way i do it , ya it's a pain but , when thats all we got , what do ya do ! and there will not be a fix for this with ts3 in the works .. but dont quote me

[EnderGate]

Can someone form TS org respond to this thread?

It would be nice to just have the control an administrator should, un-restricted control.

Please :)

[Orion Pax]

Yeah I like the method that the previos version of TS used. I didnt notice that until now when I read this thread. Tho I only plan on having 10 people tops in mine, so the work around wont be a bother to me untill the dev team decides reflect apon this!

[Brain]

Well, you have to know the user's password or simply give him a new one. It's not a bug, it's a feature.

However if you have access to the TCPQuery port you can grant/remove SA using the sppriv command. You don't need to know/change the user password for that.

[Bones_taw]

Thanks Brain, I will try it.

[Bones_taw]

Using telnet and "fp" then "sppriv" works good, but only if the user is logged in.

If the user is not logged in, use "dbfp" and "dbuserchangeattribs".

A little painful using telnet, but at least you don't have to change their password.

[m&m's]

if your logging all users with the =1 in the server.ini you will have your (R) & (SA) users passwords in the server log , you can then place the own password in that feild and remove the (SA) check box .

[log]
access=1
access_r=1
access_u=1
channel_registerred=1
channel_unregisterred=0
sa=1
chat=0
kick_server=1
kick_channel=1

[Power_Greek]

dude can't you just wait till he's comming into your server than revoke his SA rights

[m&m's]

that would mean both have to be in server at same time

[Power_Greek]

tru but is that a problem than...
i am not sitting in a server becouse i don't want to be alone

[m&m's]

and if the dude is on when your asleep ? is it not eazy to open your log file and place his info in the boxes and do it at your conveance not at his when he happens to come in .

[BewareOfButtlic]

I dont think you guys really get it. People use Team-Speak because of its user-friendly interface and options. People DO NOT want to edit files in order to change stuff...

[m&m's]

I dont think you guys really get it. People use Team-Speak because of its user-friendly interface and options. People DO NOT want to edit files in order to change stuff...
yes we do get it but the posters befor did not like the other way of doing this so this is his only other option ,
1. you can deleat his account , he can come back as a (U) user , at that time if needed you can give him (R) back
2. change his password so he cant log back in lol becuse you can't uncheck the sa box in the web admin with out knowing his password but you can change in on him
3. go to the server and read the server.dbs file his password is in there most likely tward the bottom , copy it ! then log in to the servers web admin and uncheck his (SA) and place his password in the box and save
4. wate and wate and wate for him to come in when your there and revoke his admin then
those are your choices sorry if you don't like them but thats all there is like them or not , and most are eazy to find and do . most peps that run a good server run a log anyway ,so the info is allready there for them to use .ya the peps that run a server for there buddys off there home pc suporting 10 to 20 players may not log but it not that hard to do you only change a few =0 to =1 in the server.ini file [log] section takes about 5 seconds to do

[Brain]

#3 is unfortunately/fortunately not an option because even the most verbose debugging settings that you can use won't log passwords.

[m&m's]

#3 is unfortunately/fortunately not an option because even the most verbose debugging settings that you can use won't log passwords.
yep your right b i thougth at 1 time a had seen my sa's password in my server log. it was his nickname and login name not password DOH my bad , but i know his password so it dont matter , what am i going to get into it's my server lol . i was thinking the serve.log had same info as server.dbs file ! i ment to say .dbs i edited my above post

my 2 cents but i would just deleat there account if there not wanted as a (sa) any more then make them a (U) .. if you feel every person that comes in has to be a (R) then let them re-reg whats the big deal lol

i edited #3 to a new way to fix this but you have to have access to the server.dbs file !

[McAfee]

Another option is to change the DB directly using the sqlite client.
http://www.sqlite.org

You may use SQliteCC (GUI client) to make things easier. Should be as easy as using Excel.
http://bobmanc.home.comcast.net/sqlitecc.html

The table name is: ts2_clients
column name: b_client_privilege_serveradmin
Server Admin privilage is marked as "-1". To remove it, set to "0".

[Brain]

Forget about the SQLite client... you can do that convenientely (well, it's convenient for me) by using the TCPQuery interface.
The command is dbuserchangeattribs, it is easy to use. First you need to get the userid from the database before you can manipulate the user's SA privileges. Detailed help is available when you time "help dbuserchangeattribs" into the TCPQuery interface.
If the user is online you can also use sppriv. See "help sppriv" for detailed info and instructions on how to use that command.
You need superadmin privileges for both operations, however.

Good luck!

[McAfee]

I find using SQliteCC much easier. Plus, it may be usufull for changing other properties. Only downfall is the server might need to be restarted.

The TCP Query Port is a good option. Here is some HOWTO information:

help dbuserchangeattribs
Name
dbuserchangeattribs - Changes the SA-Status of a registered user
Usage
dbuserchangeattribs <DBUserID> <ServerAdminStatus>
After selecting a virtual server (-> sel) you can use this command to
change the ServerAdminStatus of a registered user. To get the
DBUserID use dbuserlist (-> dbuserlist) or dbuserid (-> dbuserid).
The ServerAdminStatus can be 1 or 0, 1: user is SA, 0: user isn't.
Example
dbuserid SatanClaus
> 1234
> OK
dbuserchangeattribs 1234 1
> OK
OK

NOTE: There seems to be an issue with backspaces. Everytime I use backspace to correct something the command becomes unvalid.
I'm using: 2.0.20.1 Win32 (server_windows_service.exe)

[SolomonXDK]

So do we have a solution for this?

I also am trying to figure this one out. Even when using SuperAdmin it says error if you dont enter a password. This is the case for both adding (SA) rights & removing (SA) rights. Is the only solution to issue the person a password along with their rights?

[TeamSpeaker]

The correct answer to the original question is: No, there is no way to do this in the TS http admin. I wish someone would close this thread, because I had to read all the way thru this only to find the answer was no.

[m&m's]

re-read post 31 i changed #3 to a new fix if you have access to the server.dbs file , that users pw is in plain text copy it down , then log in to the servers web admin and un-chech his (SA) and enter his password from the server.dbs file and save , now empty pw error and his sa is gone !

[ouchthathurt]

The correct answer to the original question is: No, there is no way to do this in the TS http admin. I wish someone would close this thread, because I had to read all the way thru this only to find the answer was no.
Thank you Very much. This is OBVIOUSLY a dead topic. THE ANSWER IS NO! M&M you were good about trying to offer alternative options but it is OBVIOUS that you spend way to much time on these forums. Just look at how many posts you have. I hope that the creators are aware of this issue and are looking to fix this problem with a future version.

[sgtbenc]

So M&M how do u know that they will not fix this in RC3?

[slick1]

OMG, Here let me make that really clear. I have pointed out in this picture the "SA (ServerAdmin) Radio check box (a box you check or not-check off (when it's not checked the box is cleared)"

m&m, thanks for your effort, but I fix computers, lol, not people. I am just notifing the powers to be, or maybe someone knows how I can remove a members SA without them being logged in, or without editing the d/b directly.
There is a way to find out everyone's password on your server. It is in the server.dbs file.

To find their password, you need to know their login name. Simple found. You remember where you found the person you wanted to grant/remove SA? That name is their login name. With knowing their login name, open the server.dbs file (with notepad), and hit CTRL-F, and search for their login name. Right after their login name, you will see their password.

You now can grant/remove SA without the user being online, and not affecting their login abilities.

Reason I know of this is because I recently got messed up because one of the players had an SA on their name and started to hand it out to everyone. Someone decided to ban everyone while I was gone, and I came in and found a trillion channels created, and no one online. After fixing the problem, I removed the ability to grant SA to anyone - except for myself thru the admin panel. I removed everyone's SA except the core council members that needed it, and it's a tight ship.

Good luck, and I hope this helped.

[slick1]

So the answer is really YES, as long as you have access to the server /shrug

[sgtbenc]

LOL. Old post, didn't someone aready reply to this?