A simple ts3 serveradmin password recovery script (win + linux)

[Germeshausen.de]

@DeMiNe0,

you open the scripts in a editor and copy the sql commands and execute them in phpmyadmin, mysql administrator or within a php-script which connects to the database.

kind regards,
Sven

@Yannick,

what was the problem?

[dem.u]

Hello,

I have downloaded problem Having script and have packed on home/*** into main folder of Teamspeak ³. now I want to explain(carry out).sh and get the error message

:-> No look file or directory

in which ordner I have to do it now to stacks with it(thus) he finds?


*** german part deleted ***

[DeepSurfer]

or use an SQLlite Browser to look in the Databasefile

On local installed TS3 server start the SQLlite Browser and open the ts3database (its in the TS3server folder)

on root server download the ts3database file and open it with the SQLlite Browser.

http://sourceforge.net/projects/sqlitebrowser/

http://sqlitebrowser.sourceforge.net/screenshots.html

greets
Deep

PS: this is no advertise, only a information

[SilentStorm]

I tried this, but I only get this error:
Ich habe das jetzt mal ausprobiert. Bei mir kommt nur der Fehler:

clientsetserverquerylogin client_login_name=serveradmin
error id=512 msg=invalid\sclientID

Yes, I was logged in as serveradmin.
Tried on fresh installed beta 6 server (for testing purposes) on debian 5.

Und ja, ich habe mich vorher als serveradmin eingeloggt .
Probiert auf einem für Testzwecke neu aufgesetzten Beta 6 Server (auf Debian 5).

Thats what you get when you did select a virtual server already. clientsetserverquerylogin only works with no virtual Server selected.
just type "use 0" before using this command and it will work fine

[Stefan1200]

Thats what you get when you did select a virtual server already. clientsetserverquerylogin only works with no virtual Server selected.
just type "use 0" before using this command and it will work fine

Oh, thanks for the info. After thinking about it, I understand why .

[Luke76]

./ts3server_linux_amd64 serveradmin_password=your new SA-Password

[2coiNz]

Hi there...

First of all, nice script! But...

In great power lies great responsibility!

And that's my problem...

I share our root with one other person. Both of us have full root control and it's not possible to change this. The possibility is given but i wont change this out of other reasons not concerning ts3... he needs it!

Now I have a serious problem...
Because I never had time to get used to the ts3 permission system, i couldn't get the others used to it. Consequently I firstly have never given any rights on our ts3 servers...
that part is finished since i created a own servergroup for moderators.

now my partner suffering from megalomania uses all the time this script to regain access to the serverqueryadmin user. what really is getting on my nerves! he doesnt have any knowledge about the serverquery and the total ts3 permission system, so i don't see any reason why i should give him such powerful rights on a very important pillar of our community.

is there a possibility to prevent the usement of the script by editing or deleting the serverqueryadmin (clientid=1) and readding it, if I want to access the query?
Or would that cause the death of the function of the database?
is the serveradmin user imperative to the function of the whole ts3 instance?

[Romullo7]

Not, how do I windowns and linux? I unpack to folder and then?

HELP!!!

[Romullo7]

I'm not able to change the password of the admin server, which command to windows?

[Peterx3]

I cant do it. If I unpack the Folder on my Ts3 Root Folder, what than? Need help pls.

[sholverstar]

Hello i extrack tar.gz to my teamspeak3 directory (linux x86 via putty)

Can you explain me more detailed ??? there is 3 files ts3recover.sh sqlite3.exe serverdbs_de.bat

which file i should run and how ?

(it will helpful for nubs.)

[AKA-Shadow]

@DeMiNe0,

you open the scripts in a editor and copy the sql commands and execute them in phpmyadmin, mysql administrator or within a php-script which connects to the database.

kind regards,
Sven

@Yannick,

what was the problem?

Tried this with beta 23 and it tells me that I still have insufficient privilege.

My issue is that I copied the files into the beta 20 folder with the beta 23 and restarted the server. my original password now does not work even though nothing changed in my sql database in regards to the password.

I used this method and I still get the bad log in
error id=2568 msg=insufficient\sclient\spermissions failed_permid=4877 (31 ms)
Total: 31 ms

I used the ts3 generator also and still doesn't work.

[Winchester]

hello, thank you very much for the script, but when I run on my linux dedicated server is unix I get the following error:


bf: / storage / teamspeak / tsserver # sh ts3recover.sh
'S3recover.sh: line 3: syntax error near unexpected token `(
'S3recover.sh: line 3: `function pause () (

review the script and find the line 3 that the error and I get the following:

function pause () (
read-p "$*"}
i have to know the password of the server admin!!!

Thanks in advance
regards

[Lozzano]

I am getting exactly the same error as Winchester, is there any possible way to explain to us what we are doing wrong here? I am also just sh "thescript.sh" and getting this line 3 syntax error on my Debian box.

[Dziko83]

Hi,

I have a big problem and I dont found any information which can help me.. I lost my server token. The token which will create by the server after the first installation. I dont want to reinstall the whole server and create the subts3server once again.. Which options are available the get the token back or get a new one? I am currently very frustrated about my fail to didnt keep the servertoken on a save place .. :-/

I tried a shellscript (because I have a Linuxserver) named ts3recover (link) but this script didnt work correctly. Whenever I want to start the script with the command: ./ts3recover.sh they give back an error in the commandline:

./ts3recover.sh : No such file or directory


I hope someone can help me.. :-/

best regards.