Admin Server Query form Deleted

[Boxer88]

My Problem is I have accidentally the Admin Server Query FORM DELETED

client (id:3) was added to servergroup 'Admin Server Query'(id:2) by client 'serveradmin from 52.125.107.102:53654(id:1)

Deleted x.x and when I query the server console will now go inside the

login serveradmin *******
use sid=1
servergroupaddclient sgid=2 cldbid=3
quit

error id=0 msg=ok  (136 ms)
error id=0 msg=ok  (20 ms)
error id=2568 msg=insufficient\sclient\spermissions failed_permid=17306  (0 ms)
Total: 156 ms

just because I have since deleted from but there must be a solution without giving the new server to make.

Thanks in advance
*** german part deleted ***
*** This forum is english only! ***

[florian_fr40]

Hello

What do you mean by

My Problem is I have accidentally the Admin Server Query FORM DELETED

Did you delete the Query group ?
What is your server version ?

[Boxer88]

serveradmin from 52.125.107.102:53654(id:1) DELETED

beta 31 pre

[florian_fr40]

serveradmin from 52.125.107.102:53654(id:1) DELETED

Sorry I don't understand.
For me it's a server log line, do you mean that you have deleted this line in the log ?

If you talk about Admin query group and that you had deleted this group, the better solution is to restart with a clean server on a clean database.

[Boxer88]

The problem I have is deleted from the admin of the server query id1 and now when I give it the command to take the password and the server-id command but the command add command he did not take on

--- Merged ---

So when I first time as admin server query in the list will add my id in the list and your ServerAdmin from 56.321.154.56:56987 and I deleted it and I can not make more commanding

[florian_fr40]

Ok, if I good understand you, you had remove the serveradmin user of the Admin Query group, right ?

If it's the case, without re create a new Teamspeak instance,
1- Stop your server
2- Make a backup of your database
3- Edit your database (ts3server.sqlitedb if you use sqlite)
4- In "group_server_to_client" table add the user in the Admin query group :

INSERT INTO group_server_to_client VALUES('2', '0', '1', '0')

Normaly, after that the serveradmin account return in the Admin Query Group and you can use it.

[Boxer88]

VirtualServer Info servergroup 'ssa'(id:52) was added by 'sese'(id:3)
VirtualServer Info servergroup 'ssa'(id:52) was deleted by 'sese'(id:3)

that's what happened to me should I

[florian_fr40]

So, in fact, and if I good understand you, this just that the "ssa" group was deleted, and you want to recreate it, right ?

But this server group was the original "Server Admin" group ?

[Boxer88]

I've adimn given query. There's been regiestrit my id and another is from id from 12.125.147.65:5478 server admin and I have deleted because I did not know what that and then could not get the command

[florian_fr40]

Sorry I don't really understand what you want or where is exactly your ploblem. I send you a PM.

[Boxer88]

If I remember the first time as admin query so we registered the registered id of me and then we still have an id registered with the IP address I have deleted

--- Merged ---

I've done has worked ts3server.sqlitedb the file and have the server admin query again added to the list
PS: I have the server admin query from the list removed, but it has made me a thank you

just a tip if any of them is the red again, the heist of the server-admin query was deleted from the list ts3server.sqlitedb
*** german part deleted ***
*** This forum is english only! ***

!!! Closed Thread !!!

[BuffaoGalaxias]

dedicated - linux
client - windows

I accidentally deleted the group "admin server query" what do I have this group back without having to redo the server?
I'm not able to add me on the Query tab of tools, "tools / ServerQuery.

Please help me fix this without having to redo the entire server, because you have 10 servers teamspeak this same IP.

thanks!

[florian_fr40]

@BuffaoGalaxias
I guess you haven't a backup...

So, to recreate this group and his permissions without reset your teamspeak server :

1 - Stop your Teamspeak instance
2 - Open your database (depend of the type sqlite/mysql) with a soft
3 - Get the attached file, open it and copy/paste the SQL statement in a SQL editor of your soft
4 - Execute and re start your Teamspeak instance.

The Admin Server Query group was recreated and his permissions (by default).

IMPORTANT:
- Never add yourself in this sensible group (always create a second identity)
- Make a regular backup of your database.

[blue232]

Hey,

My Server Admin Query Account is deleted.
I dont know why, but he ist lost

How i can recover the Account?

Any Scripts?

I can´t edit my servers...

I hope you can help me

Sorry for this english, i come from germany

[Jordi]

http://forum.teamspeak.com/showthrea...991#post268991