Create a second superadmin

[nsateam]

Hello!
I want to create a second super-server-admin account but i dont know how i create a new.

How i create a new superadmin account?

[florian_fr40]

Hello

1 - Create a new identity in your client
TS3Client => Settings => Identites

2 - Go to Connect on your server with this new identity
TS3Client => Connections => click on "more" button to chose the identity

3 - Add this user on Admin Query Group

login serveradmin <password>
use <serverID> ("or" use port=<virtual server port>)
servergroupaddclient sgid=2 cldbid=<database client ID>

4 - Create a login account for this user (identity)
TS3Client => Tools => ServerQuery login

Now you have a new "account" (identity) with query account

[rindorbrot]

Hi,
I'm the chosen Teamspeak Admin at my clan.
the teamspeak server is run by our leader, he also has the login dates for the serveradmin @ query.

he added me to the admin server query group (sgid=2)
but it seems like I only have administratively rights at the virtual server on which he added me to the group (sid=1)
but not at the other virtual servers we are running.

I know that if I connect to the different virtual servers it doesn't show I'm in the query server admin group because have a different cldbid on each virtual server.
but at the server query I am logging in with the login dates I assigned myself on the server where I am shown in the query server admin group.

so at the query I should have rights to administrate all virtual servers, even I don't show in the query server admin group on this specific virtual server.
or did I misunderstood this?

[Master_D]

The problem isn't solved in that way. The generated group-assignments are in relation to a specific virtual server. So you only have serverquery-access on this server (sid=1).

It is not possible to create a fully usable serverquery-account from within the client or serverquery atm. This is on todo, so it will be possible in the future. A Workaround for creating such an account is creating it within your database. After that, you have to restart your whole server.

[rindorbrot]

would you please care to explain how to create such a user directly in the database?
because until now I didn't had to do anything directly in the db

thanks in advance

and btw merry christmas xD

[Master_D]

insert into clients (client_id, server_id, client_unique_id, client_nickname, client_login_name, client_login_password, client_lastconnected, client_totalconnections, client_month_upload, client_month_download, client_total_upload, client_total_download) values (NULL, 0, '<query-UID>', '<query-Name>', '<query-loginname>', '<query-PW>', 0, 0, 0, 0, 0, 0);
insert into group_server_to_client (group_id, server_id, id1, id2) values (2, 0, <client-id>, 0);

This two SQL-Commands can be used to create a new Serverquery-account with query-admin-rights.
The query-PW has to be a Base64-encoded raw SHA1-Hash of your pw.
Example-Code for PHP:

base64_encode(sha1("value", true)); 

Please do this only, if your server is offline, otherwise the database can be damaged.

[Alcazar]

insert into group_server_to_client (group_id, server_id, id1, id2) values (<client-id>, 0, 1, 0);

That code is wrong ,should read
->

INSERT INTO `group_server_to_client` (group_id, server_id, id1, id2) VALUES (2, 0, <user_id>, 0);

[Master_D]

oh, i should have checked, what i've pasted

corrected.

[Screech]

What florian_fr40 first post works fine really. That is how query admin was intended to be used, from the query client or telnet. So by given an account query admin on any server, all the user needs to do is create a query login to work with the server as the "superadmin" account does.