Query Admin deleted (serveradmin user)

[Tygra]

Hello,

Sorry for my bad english, but my main language is german. I hope you can understand my problem.

I'd deleted my first TeamSpeak 3 User which haves a password. Now i can't create a new one, with a permanent password.

I've lost my access to my TeamSpeak 3 Webinterface by Psychokiller.
It's not possible, to create a new query user with a permanently password.

What can I do, to solve this problem?

Take note: I'm not looking for a temporarily password, i need a fixed one for webinterface and bot access.

Regards,
Tygra

[florian_fr40]

Hello

To be sure, do you remove the serveradmin from the Admin Query group or just delete the serveradmin ?

In both case, there is several answer in this forum do you use the search function before posting...

[Tygra]

Hi,

No it's the Query Admin, which you get, when you start up the first time your serers you get a username like "serveradmin" and a password "xxxxxx". And this user, i've deleted.

And with Query Login it doesn't work.
I need the same user again with a password...

[florian_fr40]

Ok, the best way would to reset the Teamspeak server (so the database)

Before that, make a backup of your database.

1 - Open your database with a software
(e.g. SQLite Browser for SQLite database, or HeidiSQL for MySQL database)
2 - Insert a new user line in the "clients" table

INSERT INTO clients (server_id, client_unique_id, client_nickname, client_login_name, client_login_password, client_lastconnected, client_totalconnections) VALUES (0, "serveradmin", "serveradmin", "serveradmin", "<the password>", 0, 0);

To generate <the password>, you can use the tool from this thread : http://forum.teamspeak.com/showthrea...ord-Look-here!

3 - After that, you have to add this new serveradmin user in the Admin Query group, (in the "group_server_to_client" table)

INSERT INTO group_server_to_client VALUES('2', '0', '<the new ID>', '0');

<the new ID>, is the value in the client_id column (in the client table) for the new serveradmin user

4 - Don't forget to make a backup regulary

[Tygra]

Ok thanks a lot for your help!

Now, all is perfectly )

[tgp1994]

Hi everyone,

Somehow, my serveradmin user was erased from the clients table in my MySQL database. I was finally able to re-add it, although I can't seem to be able to execute any queries with it. I will always get an insufficient permissions error.

It just seems that the permissions for my primary client have also been messed up. I just noticed now that there seem to be two different Server Admin groups. Currently I have my user in the one with an id of 3, which seems to be as high as a user can go. Despite that, I can't seem to run any server-modifying queries with that user, either.

Does anyone know what I can do to get the serveradmin user back up and running?

Thanks,

Thread Merged

tgp1994

[florian_fr40]

Hello

I was finally able to re-add it,

What did you do exactly ?

Please recheck with the instructions from my previous post.

[tgp1994]

Hello


What did you do exactly ?

Please recheck with the instructions from my previous post.

Ugh. Firefox just lost three paragraphs of a post I was typing to you. Sorry, I'm going to shorten up my reply a bit. Basically, I had inserted a new client into the clients table, with a client_id of 1, cuid, and client_nickname with serveradmin, and a generated password for the password. After reading through your suggestions for fixing it, it looks like I failed to specify the login_name (sounds pretty important now that I think about it), and it looks like, for some reason, serveradmin was specified as the client_login_name for my own teamspeak user.

It looks like I already have the proper row in the group_server_to_client, however.

After adding serveradmin to the client_login_name, though, everything seems to be working for that user! Thank you!

For everyone else, here is an example of a proper row you can put in the clients table:

1 0 serveradmin serveradmin serveradmin W6ph5Mm5Pz8GgiULbPgzG37mj9g= 0 0 0 0 0 0

That password hash is basically "password". Don't expect to be able to log into my server with that

*** Off topic ***
One question though, would it be considered dangerous if I started giving my teamspeak user every permission available? Like, by dangerous, I mean giving myself the ability to seriously screw up permissions. It seems like that, even though that account is considered a server admin, I still can't assign myself every available permission.

P.S. Just thought of a second question, how can I view all of the available user groups when I'm editing permissions in the client?

[florian_fr40]

*** Off topic ***
About your questions, it's recommended to create a second identity and add this one in the query admin group (if you really want a "complet" access).

And in fact this also the answer for your second (with this second identity you'll can see all groups - query, template, normal). Be careful

[tgp1994]

*** Off topic ***
About your questions, it's recommended to create a second identity and add this one in the query admin group (if you really want a "complet" access).

And in fact this also the answer for your second (with this second identity you'll can see all groups - query, template, normal). Be careful

Alright, thanks