Don't have your Server Admin Query password? Look here!

**Soljia** · 03-01-2010, 18:11

The Admin Server Query is always for every server. That's the way it was intended. If you are looking just to put people into Server Admin group with sql the command would be like this...

insert into group_server_to_client (group_id, server_id, id1, id2) values (2, 1, 6, 0);

The bolded 2 is the group_id. Server Admin group id for me is 6. So I'd put a 6 there.You can find the group id by going into TS3 client and under Server Groups (in permissions) there will be a number next to each group. Put that number in place of the 2. Then just follow the rest of the guide to get server id correct and client id. (which is shown as 1 and 6 respectively)

**GoNz0** · 03-01-2010, 18:12

Thanks for the help

**Soljia** · 03-01-2010, 18:28

Each virtual server made should give you a token to be Server Admin. Wouldn't it be easier to e-mail it to the customer or display it on their account page?

--- Merged ---

Wooo, I made sticky.

**ThaLegend** · 08-01-2010, 22:31

Hi Soljia,

I have an challenge for you

Do you know why the server replies this:

Code:

error id=0 msg=ok  (68 ms)
error id=2568 msg=insufficient\sclient\spermissions failed_permid=17283  (45 ms)
Total: 113 ms

after giving command:

Code:

login serveradmin xxxxxxxxx
use 1
servergroupaddclient sgid=2 cldbid=70
logout

Edit: I know why this error is given:
I accidently deleted all groups except for Server Admins and Guests
Any way on how to restore/recreate those groups :S:S

second edit:
I personally think that it's not that difficult to add new groups for Admin Server Query,
I mean those groups aren't unique to every server right?
Hope someone knows the solution to my prob

**Vashji** · 09-01-2010, 00:50

thanks for the password generator replaced it in mysql for the serveradmin user and it works like a charm +1

**Soljia** · 09-01-2010, 03:59

Originally Posted by ThaLegend

Hi Soljia,

I have an challenge for you

Do you know why the server replies this:

Code:

error id=0 msg=ok  (68 ms)
error id=2568 msg=insufficient\sclient\spermissions failed_permid=17283  (45 ms)
Total: 113 ms

after giving command:

Code:

login serveradmin xxxxxxxxx
use 1
servergroupaddclient sgid=2 cldbid=70
logout

Edit: I know why this error is given:
I accidently deleted all groups except for Server Admins and Guests
Any way on how to restore/recreate those groups :S:S

second edit:
I personally think that it's not that difficult to add new groups for Admin Server Query,
I mean those groups aren't unique to every server right?
Hope someone knows the solution to my prob

Actually, I'm in the (slow) process of adding more features, and this is one. Where you can import and export groups. Give me a day or so, I'll see what I can do.

**Peter** · 09-01-2010, 04:35

Hi,

first off, thanks for making these nice guids, some useful stuff here

Originally Posted by Soljia

Choose any user to be in the Admin Server Query group. [Using sqlite]

Can you please remove this? It is a very bad idea to put normal users into the Admin Server Query group, and it does not give them any powers within the client that a normal server admin doesn't already have, so all I see is potential danger and no benefit?

Also I would like to suggest, since you have multiple guides here, to split them up in separate threads, that way you could also put the actual documentation straight into the thread and not have to link to google docs. This should lead to your guides to be easier to find and to comments to each guide be easier to browse.

PS: Something you might want to point out about resetting the serveradmin password via sqlite is that this method works on a running server, the "easy" way that R. Ludwig posted is only viable if you are ok with restarting your server.

Thanks

**Soljia** · 09-01-2010, 14:38

I will indeed do this. As for removing in general, I'll just move it and put your warning on it. But I will make this thread solely for changing server admin password.

Originally Posted by Peter

Hi,

first off, thanks for making these nice guids, some useful stuff here

Can you please remove this? It is a very bad idea to put normal users into the Admin Server Query group, and it does not give them any powers within the client that a normal server admin doesn't already have, so all I see is potential danger and no benefit?

Also I would like to suggest, since you have multiple guides here, to split them up in separate threads, that way you could also put the actual documentation straight into the thread and not have to link to google docs. This should lead to your guides to be easier to find and to comments to each guide be easier to browse.

PS: Something you might want to point out about resetting the serveradmin password via sqlite is that this method works on a running server, the "easy" way that R. Ludwig posted is only viable if you are ok with restarting your server.

Thanks

**ThaLegend** · 09-01-2010, 18:52

Originally Posted by Soljia

Actually, I'm in the (slow) process of adding more features, and this is one. Where you can import and export groups. Give me a day or so, I'll see what I can do.

I will wait

Would be a cool feature since I deleted it

**Soljia** · 12-01-2010, 16:28

Having difficulties with the program. Arg. Also switching to the TS3QueryLib.

**Schlup** · 13-01-2010, 06:28

I've got a problem with this, I keep getting the error...

Code:

error id=520 msg=invalid\sloginname\sor\spassword

I know I'm putting the right password in when I am trying to login to server query via the client. I have the Authentication set to "Login command" and I run the following command:

Code:

login serveradmin fiQN50+x7Qj6CNOAY/amqRRiqBU=
use 1
servergroupaddclient sgid=2 cldbid=2

My only thought would be the = sign at the end, maybe that's causing a problem, but no matter how many I generate they ALL have the = sign at the end. Help me out, what could I be doing wrong here?

Here's my full output, I'm pulling a second error if I let it run long enough...though I'd be happy fixing these one at a time if needed.

Code:

error id=520 msg=invalid\sloginname\sor\spassword  (10 ms)
Total: 10 ms
error id=0 msg=ok  (180532 ms)
error id=0 msg=ok  (44 ms)
error id=2568 msg=insufficient\sclient\spermissions failed_permid=17282  (15 ms)
Total: 180591 ms
error id=0 msg=ok  (179841 ms)
Total: 179841 ms

P.S. I have manually entered those codes somebody else posted to put into your SQLite version if you started with Beta 1 and then upgraded (which I did), and I used sqlliteman to do the file editing as well. If you need me to run any other tests let me know.

Thanks in advance!

**Soljia** · 13-01-2010, 16:21

Originally Posted by Schlup

I've got a problem with this, I keep getting the error...

Code:

login serveradmin fiQN50+x7Qj6CNOAY/amqRRiqBU=
use 1
servergroupaddclient sgid=2 cldbid=2

The password that you are inputting is incorrect. You are currently inputting the encrypted password. You need to put in the password that you typed in originally that gave you that output.

**Schlup** · 13-01-2010, 23:34

Oh man, you rock, that was it! Thanks a million for helping me out with that, server query has been granted to myself now!

**ThaLegend** · 14-01-2010, 20:04

Can't I just copy the Admin Server Query Group from an fresh install?

**Schlup** · 14-01-2010, 20:19

Not positive but I highly doubt it...that would make the servers very unsecure and easily hackable.

Thread: Don't have your Server Admin Query password? Look here!

Thread Tools

Rate This Thread

Display

Thread Information

Users Browsing this Thread

Similar Threads

Jdawgg's Guid to Starting a TeamSpeak 2 SERVER

Administration page

No Web Admin log-in after 2.0.18.31 Win Server Update

Tags for this Thread

Posting Permissions