search

TS3Tools / TS3UpdateScript

Automate all update processes for your TeamSpeak 3 server instances
GNU General Public License v3.0
189 stars 22 forks source link

Is this still active? #72

Closed federicovilla closed 6 years ago

federicovilla commented 6 years ago

Just asking because I tried to run the script to check any TS3 update....the script says that the server is up to date but the server version in TS3 server is different then my installed version. Thanks for any feedback

Sebbo94BY commented 6 years ago

Yes, this project is still active. The script is working like it should.

Can you please show the output of the script?

federicovilla commented 6 years ago

Thanks for feedback. Here you are the script output

Author: Sebastian Kraetzig info@ts3-tools.info Project: www.ts3-tools.info facebook: www.facebook.com/TS3Tools License: GNU GPLv3

Version: 3.11.7.3 (2015-03-14)

Please wait... Script is working... You are using the latest TS3 UpdateScript [ INFO ]

Searching for latest TeamSpeak 3 server release [ OK ] Searching for TeamSpeak 3 installation directories [ OK ]

#############################################################

  1. Directory: /home/ts3admin/teamspeak3-server #############################################################

Searching for installed version, architecture and owner [ INFO ] ############################################################# Latest Stable Release : 3.0.11.4 Installed Release : 3.0.11.4 (Build: Unknown) Installed Architecture : amd64 Installed Binary : Linux

    Installation Directory  : /home/ts3admin/teamspeak3-server
    Instance Log Directory  : /home/ts3admin/teamspeak3-server/logs
    Files Owner             : ts3admin (UID 1000)
    Files Group             : ts3admin (GID 1000)

    Database-Type           : SQLite
    ServerQuery IP:         : 178.79.160.25
    ServerQuery Port        : 10011
    TSDNS                   : Not running

    Waiting Time            : None/Immediately

#############################################################

Latest release is already installed. Nothing to do! [ INFO ] Cleaning up system [ INFO ] Finish! [ INFO ] Script execution time: 3s

Support the development of this script and donate: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=7ZRXLSC2UBVWE Thank you very much!

Sebbo94BY commented 6 years ago

Thanks. Do you use any parameters likes --set-release?

It should autom. return the latest version, when you run the command like this: ./TS3UpdateScript --check

federicovilla commented 6 years ago

Thanks for feedback...about your suggetion I get an error: Unregonized option: --set-release I tried: ./TS3UpdateScript.sh --check --set-release

federicovilla commented 6 years ago

By the way...I tried the following command to perform the update automate...but I got a message that my installation is up to date....sounds weird to me...sorry for that ./TS3UpdateScript --update-script

federicovilla commented 6 years ago

OK...removed previous versione and installed latest one from scratch....the script found the new TS version...but the update failed:

Temporary server passwords were not backuped, because you've disabled it or whether telnet nor expect is installed. TeamSpeak 3 server instance stopped for update process. Backup created successful. TeamSpeak 3 server instance was updated successful. Could not start TeamSpeak 3 server instance. ./TS3UpdateScript: line 2114: expect: command not found Due of the failed update, the TS3UpdateScript has created a debug report in /home/ts3admin/teamspeak3-server/20171225-2322-ts3us-debug-report.md Update failed. Rollback to the version '3.0.11.4'. TeamSpeak 3 server instance was started successful. Backup was deleted successful.

Cleaning up...

Summary of measured execution time for each step Total script: 32s Self-Test: 4s Collecting Information: 1s Validation: 0s Execution Mechanism: 27s Cleanup: 0s

Thanks for using this script! Support the development of this script and donate: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=7ZRXLSC2UBVWE ts3admin@vespa:~/TS3UpdateScript$

Sebbo94BY commented 6 years ago

I'm not sure, what you did, that it update your server even when there are required Linux packages missing:

./TS3UpdateScript: line 2114: expect: command not found

Please install expect - this is required.

federicovilla commented 6 years ago

Thanks for hint. I fixed the missing command...now this is what I got ( keep in mind that, for security reason, I have disabled password access in my server and I switched to public-private keys + passphrase): `Please wait... Script is working...

Performing self-tests as preventive measures against possible failures[ .. ]

                                                                  [ OK ]

Collecting necessary information for further tasks [ .. ]

                                                                  [ FAILED ]

1 TeamSpeak 3 server instance found...

Collecting as much as possible information for following TeamSpeak 3 server inst ance: /home/ts3admin/teamspeak3-server Validating collected information as preventive measures against possible failure s Wrong serveradmin password. Please set the correct one here: /home/ts3admin/team speak3-server/.password-file Could not collect some information. Please fix the above error(s) to continue.

Cleaning up...

Summary of measured execution time for each step Total script: 5s Self-Test: 4s Collecting Information: 1s Validation: 0s Cleanup: 0s `

Sebbo94BY commented 6 years ago

Now, you only need to set the correct serveradmin password:

Wrong serveradmin password. Please set the correct one here: /home/ts3admin/team speak3-server/.password-file

federicovilla commented 6 years ago

Seib, first of all let me say that I really appreciate your time and efforts. Thanks a lot. Getting back to the update: set up the serveradmin password...restarted the Update but failed; here you are the report

Please wait... Script is working...

Performing self-tests as preventive measures against possible failures [ OK ]

Collecting necessary information for further tasks [ OK ]

All collected information were validated successfully as preventive measures against possible failures [ INFO ]

1 TeamSpeak 3 server instance found...

Collecting as much as possible information for following TeamSpeak 3 server instance: /home/ts3admin/teamspeak3-server 1 instance for update process... ############################################################################ Do you want to update this instance to the following version? 3.0.13.8

    Installation Directory: /home/ts3admin/teamspeak3-server
    Installed Version: 3.0.11.4 (Build: 1439904634)
    Installed Platform: Linux
    Installed Architecture: amd64

    Instance Log Files: /home/ts3admin/teamspeak3-server/logs
    Instance TSDNS Binary: /home/ts3admin/teamspeak3-server/tsdns/tsdnsserver_linux_amd64
    TSDNS Status: Inactive

    Owner: ts3admin (UID: 1000)
    Group: ts3admin (GID: 1000)

    ServerQuery IP: 178.79.160.25
    ServerQuery Port: 10011

    Database Type: SQLite

############################################################################ Please answer: ([y]es/[n]o) y Trying to backup temporary server passwords. Please wait... Could not backup temporary server passwords. Don't worry. You may just don't had any. TeamSpeak 3 server instance stopped for update process. Backup created successful. TeamSpeak 3 server instance was updated successful. Could not start TeamSpeak 3 server instance. Due of the failed update, the TS3UpdateScript has created a debug report in /home/ts3admin/teamspeak3-server/20171228-2216-ts3us-debug-report.md Update failed. Rollback to the version '3.0.11.4'. TeamSpeak 3 server instance was started successful. Backup was deleted successful.

Cleaning up...

Summary of measured execution time for each step Total script: 67s Self-Test: 4s Collecting Information: 1s Validation: 0s Execution Mechanism: 62s Backuping temporary server passwords: 40s Formatting temporary server passwords for restore: 0s Cleanup: 0s

Sebbo94BY commented 6 years ago

For some reason, your server didn't start after the update. Can you please post the debug report?

Due of the failed update, the TS3UpdateScript has created a debug report in /home/ts3admin/teamspeak3-server/20171228-2216-ts3us-debug-report.md

Thanks!

federicovilla commented 6 years ago

Here you are


# TS3tools TS3UpdateScript Debug Report

Date and time of report: 20171228-2216
TS3UpdateScript Installation Path: /home/ts3admin/TS3UpdateScript
TS3UpdateScript Version: 5.6.1
TS3UpdateScript Parameters: --check

## TS3UpdateScript output

Please copy and paste the output of the shell below this line and/or attach a debug file of this script.

## Operating System Details

Distributor ID: Debian
Description:    Debian GNU/Linux 8.10 (jessie)
Release:    8.10
Codename:   jessie

Linux vespa 4.9.68-x86_64-linode89 #1 SMP Mon Dec 11 16:09:29 UTC 2017 x86_64 GNU/Linux

### root User locale

LANG=en_US.UTF-8
LANGUAGE=
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

### ts3admin User locale

LANG=en_US.UTF-8
LANGUAGE=
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

## TS3 Update Details

Update path: 3.0.11.4 -> 3.0.13.8
Instance path: /home/ts3admin/teamspeak3-server
Type Of Files Storage: Local disk
ServerQuery IP: 178.79.160.25
ServerQuery Port: 10011
Installed TS3 Server Version: 3.0.11.4
Installed TS3 Server Build: 1439904634
Installed TS3 Server Platform: linux
TS3 Server Instance Log Path: /home/ts3admin/teamspeak3-server/logs
TS3 Server Architecture: amd64
*nix Owner: ts3admin (UID 1000)
*nix Group: ts3admin (GID 1000)
Database Type: SQLite
Update Text (Manually): The server will be updated to the version 3.0.13.8 right now.
Update Text (Cronjob): The server will be updated to version 3.0.13.8 in 5 minutes.
Ignore Clients: 1,
Ignore ServerGroups: 1,2,

## INI Files

### ts3server.ini

machine_id=1
default_voice_port=9987
voice_ip=178.79.160.25
licensepath=
filetransfer_port=30033
filetransfer_ip=178.79.160.25
query_port=10011
query_ip=178.79.160.25
query_ip_whitelist=query_ip_whitelist.txt
query_ip_blacklist=query_ip_blacklist.txt
dbplugin=ts3db_sqlite3
dbpluginparameter=
dbsqlpath=sql/
dbsqlcreatepath=create_sqlite/
dbconnections=10
logpath=logs
logquerycommands=0
dbclientkeepdays=30
logappend=0
query_skipbruteforcecheck=0

### Database INI-file

Database INI-file does not exist

## Log files

### Instance Log file

2017-12-28 21:05:27.728867|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.11.4 (2015-08-18 13:30:34)
2017-12-28 21:05:27.729549|INFO    |ServerLibPriv |   | SystemInformation: Linux 4.9.68-x86_64-linode89 #1 SMP Mon Dec 11 16:09:29 UTC 2017 x86_64 Binary: 64bit
2017-12-28 21:05:27.729740|INFO    |ServerLibPriv |   | Using hardware aes
2017-12-28 21:05:27.733869|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2017-12-28 21:05:27.733946|INFO    |DatabaseQuery |   | dbPlugin version: 3.6.21
2017-12-28 21:05:27.734303|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
2017-12-28 21:05:28.046552|INFO    |Accounting    |   | Licensing Information
2017-12-28 21:05:28.046646|INFO    |Accounting    |   | type              : Non-profit
2017-12-28 21:05:28.046696|INFO    |Accounting    |   | starting date     : Sat Dec  9 00:00:00 2017
2017-12-28 21:05:28.046727|INFO    |Accounting    |   | ending date       : Mon Apr 30 00:00:00 2018
2017-12-28 21:05:28.046753|INFO    |Accounting    |   | max virtualservers: 10
2017-12-28 21:05:28.046778|INFO    |Accounting    |   | max slots         : 512
2017-12-28 21:05:29.742681|INFO    |              |   | Puzzle precompute time: 1682
2017-12-28 21:05:29.742884|INFO    |FileManager   |   | listening on 178.79.160.25:30033
2017-12-28 21:05:29.814408|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: 127.0.0.1, 
2017-12-28 21:05:29.814727|INFO    |Query         |   | listening on 178.79.160.25:10011
2017-12-28 21:15:10.548967|INFO    |Query         |   | query from 4 178.79.160.25:33190 issued: login with account "serveradmin"(serveradmin)
2017-12-28 21:15:27.987247|INFO    |Query         |   | query from 5 178.79.160.25:33194 issued: login with account "serveradmin"(serveradmin)
2017-12-28 21:15:28.053937|INFO    |Query         |   | query from 6 178.79.160.25:33196 issued: login with account "serveradmin"(serveradmin)
2017-12-28 21:16:08.280932|INFO    |ServerMain    |   | Received signal SIGTERM, shutting down.

### Backtrace using gdb

spawn su -s /bin/bash -c cd /home/ts3admin/teamspeak3-server && export LD_LIBRARY_PATH=".:" && gdb ts3server_linux_x86 && cd - > /dev/null - ts3admin
GNU gdb (Debian 7.7.1+dfsg-5) 7.7.1
Copyright (C) 2014 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/>.
For help, type "help".
Type "apropos word" to search for commands related to "word"...
ts3server_linux_x86: No such file or directory.
(gdb) run -x start inifile=ts3server.ini
Starting program:  -x start inifile=ts3server.ini
No executable file specified.
Use the "file" or "exec-file" command.
(gdb) bt
No stack.
(gdb) 

### Virtual Server Log file(s)

### Permissions in /home/ts3admin/teamspeak3-server
federicovilla commented 6 years ago

Any idea or hint to fix this? Thanks a lot

Sebbo94BY commented 6 years ago

Sorry for the delay - I had vacation.

Can you please show the output of the directory: ls -lha /home/ts3admin/teamspeak3-server/

It looks like as the binary of the TS3 server is missing.

ts3server_linux_x86: No such file or directory.

federicovilla commented 6 years ago

Thanks for feedback, no problem. Here you are the folder content


ts3admin@vespa:~$ ls -lha /home/ts3admin/teamspeak3-server
total 17M
drwxr-xr-x 9 ts3admin ts3admin 4.0K Jan  7 18:54 .
drwxr-xr-x 6 ts3admin ts3admin 4.0K Dec 28 22:11 ..
-rw-r--r-- 1 root     root     4.2K Dec 25 23:22 20171225-2322-ts3us-debug-repor                                         t.md
-rw-r--r-- 1 root     root     4.2K Dec 25 23:29 20171225-2329-ts3us-debug-repor                                         t.md
-rw-r--r-- 1 root     root     5.8K Dec 28 22:16 20171228-2216-ts3us-debug-repor                                         t.md
-rw-r--r-- 1 ts3admin ts3admin  45K Oct 18  2015 CHANGELOG
drwxr-xr-x 3 ts3admin ts3admin 4.0K Sep 30  2014 doc
drwx------ 7 ts3admin ts3admin 4.0K Oct 18  2015 files
-rwxr-xr-x 1 ts3admin ts3admin 925K Oct 18  2015 libts3db_mariadb.so
-rwxr-xr-x 1 ts3admin ts3admin 1.6M Oct 18  2015 libts3db_sqlite3.so
-rw-r--r-- 1 ts3admin ts3admin  36K Oct 18  2015 LICENSE
-rw-r--r-- 1 ts3admin ts3admin 1.6K Dec 15 17:40 licensekey.dat
drwx------ 2 ts3admin ts3admin 4.0K Dec 28 22:16 logs
---------- 1 root     root       11 Dec 28 22:13 .password-file
-rw------- 1 root     root      12K Dec 28 22:06 .password-file.swp
-rw-r--r-- 1 ts3admin ts3admin    1 Oct 18  2015 query_ip_blacklist.txt
-rw-r--r-- 1 ts3admin ts3admin   10 Oct 18  2015 query_ip_whitelist.txt
drwxr-xr-x 2 ts3admin ts3admin 4.0K Sep 30  2014 redist
-rw-r--r-- 1 ts3admin ts3admin  112 Nov  2  2014 serverkey.dat
drwxr-xr-x 2 ts3admin ts3admin 4.0K Sep 30  2014 serverquerydocs
drwxr-xr-x 5 ts3admin ts3admin  12K Oct 18  2015 sql
-rw-r--r-- 1 root     root     3.4K Oct 18  2015 TEMP_ts3server_startscript.sh
-rwxr-xr-x 1 ts3admin ts3admin 8.2M Dec 25 23:22 ts3server
-rw-r--r-- 1 ts3admin ts3admin  448 Oct 12  2014 ts3server.ini
-rwxr-xr-x 1 ts3admin ts3admin 5.9M Oct 18  2015 ts3server_linux_amd64
-rwxr-xr-x 1 ts3admin ts3admin 1.2K Oct 18  2015 ts3server_minimal_runscript.sh
-rw-r--r-- 1 ts3admin ts3admin    6 Dec 28 22:16 ts3server.pid
-rw-r--r-- 1 ts3admin ts3admin 349K Jan  7 18:54 ts3server.sqlitedb
-rwxr-xr-x 1 ts3admin ts3admin 3.4K Oct 18  2015 ts3server_startscript.sh
drwxr-xr-x 2 ts3admin ts3admin 4.0K Sep 30  2014 tsdns
ts3admin@vespa:~$
Sebbo94BY commented 6 years ago

I'll setup a test environment like yours and test it as soon as possible. I'll update this issue as soon as I've some news.

federicovilla commented 6 years ago

Thanks a lot. I've installed the TS Server grabbnig the file from official web site using wget...just in case it could come in handy to know

Sebbo94BY commented 6 years ago

@federicovilla do you still have this issue with the latest TS3UpdateScript?

federicovilla commented 6 years ago

Hi Sebi, can I update the tool using the automate option --update-script?

federicovilla commented 6 years ago

Got the same errors:

Trying to backup temporary server passwords. Please wait... Could not backup temporary server passwords. Don't worry. You may just don't had any. TeamSpeak 3 server instance stopped for update process. Backup created successful. TeamSpeak 3 server instance was updated successful. Could not start TeamSpeak 3 server instance. Due of the failed update, the TS3UpdateScript has created a debug report in /home/ts3admin/teamspeak3-server/20180225-1919-ts3us-debug-report.md Update failed. Rollback to the version '3.0.11.4'. TeamSpeak 3 server instance was started successful. Backup was deleted successful.

Cleaning up...

Summary of measured execution time for each step Total script: 61s Self-Test: 4s Collecting Information: 2s Validation: 0s Execution Mechanism: 55s Backuping temporary server passwords: 40s Formatting temporary server passwords for restore: 0s Cleanup: 0s

Sebbo94BY commented 6 years ago

Yes, you can update the script using this parameter. :)

Can you please post the new /home/ts3admin/teamspeak3-server/20180225-1919-ts3us-debug-report.md?

federicovilla commented 6 years ago

Here you are:


# TS3tools TS3UpdateScript Debug Report

Date and time of report: 20180225-1919
TS3UpdateScript Installation Path: /home/ts3admin/TS3UpdateScript
TS3UpdateScript Version: 5.6.3
TS3UpdateScript Parameters: --check

## TS3UpdateScript output

Please copy and paste the output of the shell below this line and/or attach a debug file of this script.

## Operating System Details

Distributor ID: Debian
Description:    Debian GNU/Linux 8.10 (jessie)
Release:    8.10
Codename:   jessie

Linux vespa 4.14.12-x86_64-linode92 #1 SMP Fri Jan 5 15:34:44 UTC 2018 x86_64 GNU/Linux

### root User locale

LANG=en_US.UTF-8
LANGUAGE=
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

### ts3admin User locale

LANG=en_US.UTF-8
LANGUAGE=
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

## TS3 Update Details

Update path: 3.0.11.4 -> 3.1.0
Instance path: /home/ts3admin/teamspeak3-server
Type Of Files Storage: Local disk
ServerQuery IP: 178.79.160.25
ServerQuery Port: 10011
Installed TS3 Server Version: 3.0.11.4
Installed TS3 Server Build: 1439904634
Installed TS3 Server Platform: linux
TS3 Server Instance Log Path: /home/ts3admin/teamspeak3-server/logs
TS3 Server Architecture: amd64
*nix Owner: ts3admin (UID 1000)
*nix Group: ts3admin (GID 1000)
Database Type: SQLite
Update Text (Manually): The server will be updated to the version 3.1.0 right now.
Update Text (Cronjob): The server will be updated to version 3.1.0 in 5 minutes.
Ignore Clients: 1,
Ignore ServerGroups: 1,2,

## INI Files

### ts3server.ini

machine_id=1
default_voice_port=9987
voice_ip=178.79.160.25
licensepath=
filetransfer_port=30033
filetransfer_ip=178.79.160.25
query_port=10011
query_ip=178.79.160.25
query_ip_whitelist=query_ip_whitelist.txt
query_ip_blacklist=query_ip_blacklist.txt
dbplugin=ts3db_sqlite3
dbpluginparameter=
dbsqlpath=sql/
dbsqlcreatepath=create_sqlite/
dbconnections=10
logpath=logs
logquerycommands=0
dbclientkeepdays=30
logappend=0
query_skipbruteforcecheck=0

### Database INI-file

Database INI-file does not exist

## Log files

### Instance Log file

2018-02-25 18:10:11.653851|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.11.4 (2015-08-18 13:30:34)
2018-02-25 18:10:11.654046|INFO    |ServerLibPriv |   | SystemInformation: Linux 4.14.12-x86_64-linode92 #1 SMP Fri Jan 5 15:34:44 UTC 2018 x86_64 Binary: 64bit
2018-02-25 18:10:11.654101|INFO    |ServerLibPriv |   | Using hardware aes
2018-02-25 18:10:11.660780|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2018-02-25 18:10:11.660894|INFO    |DatabaseQuery |   | dbPlugin version: 3.6.21
2018-02-25 18:10:11.662364|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
2018-02-25 18:10:11.912781|INFO    |Accounting    |   | Licensing Information
2018-02-25 18:10:11.912861|INFO    |Accounting    |   | type              : Non-profit
2018-02-25 18:10:11.912914|INFO    |Accounting    |   | starting date     : Sat Dec  9 00:00:00 2017
2018-02-25 18:10:11.912953|INFO    |Accounting    |   | ending date       : Mon Apr 30 00:00:00 2018
2018-02-25 18:10:11.912978|INFO    |Accounting    |   | max virtualservers: 10
2018-02-25 18:10:11.913002|INFO    |Accounting    |   | max slots         : 512
2018-02-25 18:10:13.438768|INFO    |              |   | Puzzle precompute time: 1510
2018-02-25 18:10:13.439018|INFO    |FileManager   |   | listening on 178.79.160.25:30033
2018-02-25 18:10:13.488541|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: 127.0.0.1, 
2018-02-25 18:10:13.488796|INFO    |Query         |   | listening on 178.79.160.25:10011
2018-02-25 18:18:48.140051|INFO    |Query         |   | query from 4 178.79.160.25:48632 issued: login with account "serveradmin"(serveradmin)
2018-02-25 18:19:00.006850|INFO    |Query         |   | query from 5 178.79.160.25:48638 issued: login with account "serveradmin"(serveradmin)
2018-02-25 18:19:00.072381|INFO    |Query         |   | query from 6 178.79.160.25:48640 issued: login with account "serveradmin"(serveradmin)
2018-02-25 18:19:40.363319|INFO    |ServerMain    |   | Received signal SIGTERM, shutting down.

### Backtrace using gdb

spawn su -s /bin/bash -c cd /home/ts3admin/teamspeak3-server && export LD_LIBRARY_PATH=".:" && gdb ts3server_linux_x86 && cd - > /dev/null - ts3admin
GNU gdb (Debian 7.7.1+dfsg-5) 7.7.1
Copyright (C) 2014 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/>.
For help, type "help".
Type "apropos word" to search for commands related to "word"...
ts3server_linux_x86: No such file or directory.
(gdb) run -x start inifile=ts3server.ini
Starting program:  -x start inifile=ts3server.ini
No executable file specified.
Use the "file" or "exec-file" command.
(gdb) bt
No stack.
(gdb) 

### Virtual Server Log file(s)

### Permissions in /home/ts3admin/teamspeak3-server
Sebbo94BY commented 6 years ago

Thank you. I'll check, if I can find the issue and if I can reproduce it.

4N7 commented 6 years ago

This script is still broken and has been for some time now. I've lost confidence in this project and have started my own.. :'(

############################################################################
    Do you want to update this instance to the following version? 3.1.1

    Installation Directory: /../teamspeak
    Installed Version: 3.0.13.8 (Build: 1500452811)
    Installed Platform: Linux
    Installed Architecture: amd64

    Instance Log Files: /../teamspeak/logs/
    Instance TSDNS Binary: /../tsdns/tsdnsserver
    TSDNS Status: Inactive

    Owner: ts3 (UID: XXXXXXX)
    Group: ts3 (GID: XXXXXXX)

    ServerQuery IP: 127.0.0.1
    ServerQuery Port: 10011

    Database Type: SQLite
############################################################################
Please answer: ([y]es/[n]o) y
Trying to backup temporary server passwords. Please wait...
Could not backup temporary server passwords. Don't worry. You may just don't had any.
cat: ts3server.pid: No such file or directory
cat: ts3server.pid: No such file or directory
rm: cannot remove 'ts3server.pid': No such file or directory
TeamSpeak 3 server instance stopped for update process.
Backup created successful.
cp: cannot create regular file './ts3server': Text file busy
Could not update TeamSpeak 3 server instance. Do you have enough space on /../teamspeak'?
Due of the failed update, the TS3UpdateScript has created a debug report in /../XXXXXXXX-XXXX-ts3us-debug-report.md
Update failed. Rollback to the version '3.0.13.8'.
Could not start TeamSpeak 3 server instance.
The backup for this instance wasn't deleted. Backup can be found here: /tmp/../xxxxxxxxxxxxxxxxx/
Sebbo94BY commented 6 years ago

This looks more like as your TS3 server is broken. The Script itself is working as expected.

Please check your instance, if it‘s running fine and if your user ts3 has full permissions.

TS3 server files should be owned by this user and you should have started the TS3 server using this user.

Sent from my smartphone

Am 09.03.2018 um 16:05 schrieb siysco notifications@github.com:

This script is still broken for me too.

############################################################################ Do you want to update this instance to the following version? 3.1.1

Installation Directory: /../teamspeak Installed Version: 3.0.13.8 (Build: 1500452811) Installed Platform: Linux Installed Architecture: amd64

Instance Log Files: /../teamspeak/logs/ Instance TSDNS Binary: /../tsdns/tsdnsserver TSDNS Status: Inactive

Owner: ts3 (UID: XXXXXXX) Group: ts3 (GID: XXXXXXX)

ServerQuery IP: 127.0.0.1 ServerQuery Port: 10011

Database Type: SQLite ############################################################################ Please answer: ([y]es/[n]o) y Trying to backup temporary server passwords. Please wait... Could not backup temporary server passwords. Don't worry. You may just don't had any. cat: ts3server.pid: No such file or directory cat: ts3server.pid: No such file or directory rm: cannot remove 'ts3server.pid': No such file or directory TeamSpeak 3 server instance stopped for update process. Backup created successful. cp: cannot create regular file './ts3server': Text file busy Could not update TeamSpeak 3 server instance. Do you have enough space on /../teamspeak'? Due of the failed update, the TS3UpdateScript has created a debug report in /../XXXXXXXX-XXXX-ts3us-debug-report.md Update failed. Rollback to the version '3.0.13.8'. Could not start TeamSpeak 3 server instance. The backup for this instance wasn't deleted. Backup can be found here: /tmp/../xxxxxxxxxxxxxxxxx/ — You are receiving this because you were assigned. Reply to this email directly, view it on GitHub, or mute the thread.

4N7 commented 6 years ago

Yeah permissions are correct for the 'normal' user "ts3". Here's the debug log if you want it:

# TS3tools TS3UpdateScript Debug Report

Date and time of report: 20180309-1519
TS3UpdateScript Installation Path: ./TS3UpdateScript-master
TS3UpdateScript Version: 5.6.3
TS3UpdateScript Parameters: --check --delete-old-logs

## TS3UpdateScript output

Please copy and paste the output of the shell below this line and/or attach a debug file of this script.

## Operating System Details

Distributor ID: Debian
Description:    Debian GNU/Linux 9.3 (stretch)
Release:    9.3
Codename:   stretch

Linux XXXXXXXXX 4.9.0-6-amd64 #1 SMP Debian 4.9.82-1+deb9u3 (2018-03-02) x86_64 GNU/Linux

### root User locale

LANG=en_US.UTF-8
LANGUAGE=
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

### ts3 User locale

LANG=en_US.UTF-8
LANGUAGE=
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

## TS3 Update Details

Update path: 3.0.13.8 -> 3.1.1
Instance path: /home/ts3/ts/teamspeak
Type Of Files Storage: Local disk
ServerQuery IP: 127.0.0.1
ServerQuery Port: 10011
Installed TS3 Server Version: 3.0.13.8
Installed TS3 Server Build: 1500452811
Installed TS3 Server Platform: linux
TS3 Server Instance Log Path: /home/ts3/ts/teamspeak/logs/
TS3 Server Architecture: amd64
*nix Owner: ts3 (UID 1001)
*nix Group: ts3 (GID 1001)
Database Type: SQLite
Update Text (Manually): The server will be updated to the version 3.1.1 right now.
Update Text (Cronjob): The server will be updated to version 3.1.1 in 5 minutes.
Ignore Clients: 1,
Ignore ServerGroups: 1,2,

## INI Files

### ts3server.ini

ts3server.ini file does not exist

## Log files

### Instance Log file

2018-03-09 15:19:22.679014|INFO    |ServerLibPriv |   |TeamSpeak 3 Server 3.0.13.8 (2017-07-19 08:26:51)
2018-03-09 15:19:22.679118|INFO    |ServerLibPriv |   |SystemInformation: Linux 4.9.0-6-amd64 #1 SMP Debian 4.9.82-1+deb9u3 (2018-03-02) x86_64 Binary: 64bit
2018-03-09 15:19:22.679139|INFO    |ServerLibPriv |   |Using hardware aes
2018-03-09 15:19:22.679699|INFO    |DatabaseQuery |   |dbPlugin name:    SQLite3 plugin, Version 3, (c)TeamSpeak Systems GmbH
2018-03-09 15:19:22.679724|INFO    |DatabaseQuery |   |dbPlugin version: 3.11.1
2018-03-09 15:19:22.679905|INFO    |DatabaseQuery |   |checking database integrity (may take a while)
2018-03-09 15:19:23.316927|INFO    |Accounting    |   |Licensing Information
2018-03-09 15:19:23.316980|INFO    |Accounting    |   |type              : Non-profit
2018-03-09 15:19:23.317000|INFO    |Accounting    |   |starting date     : Wed Feb 28 00:00:00 2018
2018-03-09 15:19:23.317014|INFO    |Accounting    |   |ending date       : Mon Sep 10 00:00:00 2018
2018-03-09 15:19:23.317026|INFO    |Accounting    |   |max virtualservers: 10
2018-03-09 15:19:23.317036|INFO    |Accounting    |   |max slots         : 512
2018-03-09 15:19:24.740248|INFO    |              |   |Puzzle precompute time: 1404
2018-03-09 15:19:24.740638|INFO    |FileManager   |   |listening on 0.0.0.0:30033, :::30033
2018-03-09 15:19:24.747903|INFO    |CIDRManager   |   |updated query_ip_whitelist ips: 127.0.0.1/32, 94.23.235.222/32, 104.28.25.34/32, 
2018-03-09 15:19:24.749198|INFO    |Query         |   |listening on 0.0.0.0:10011, :::10011

### Backtrace using gdb

spawn su -s /bin/bash -c cd /home/ts3/ts/teamspeak && export LD_LIBRARY_PATH=".:" && gdb ts3server && cd - > /dev/null - ts3
GNU gdb (Debian 7.12-6) 7.12.0.20161007-git
Copyright (C) 2016 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/>.
For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from ts3server...(no debugging symbols found)...done.
(gdb) run -x start
Starting program: /home/ts3/ts/teamspeak/ts3server -x start
[tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]
[tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]
[tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
[tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]
2018-03-09 15:19:26.822846|INFO    |ServerLibPriv |   |TeamSpeak 3 Server 3.0.13.8 (2017-07-19 08:26:51)
2018-03-09 15:19:26.822945|INFO    |ServerLibPriv |   |SystemInformation: Linux 4.9.0-6-amd64 #1 SMP Debian 4.9.82-1+deb9u3 (2018-03-02) x86_64 Binary: 64bit
2018-03-09 15:19:26.822971|INFO    |ServerLibPriv |   |Using hardware aes
[New Thread 0x7ffff710c700 (LWP 12655)]
[tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]
[tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]
2018-03-09 15:19:26.839512|INFO    |DatabaseQuery |   |dbPlugin name:    SQLite3 plugin, Version 3, (c)TeamSpeak Systems GmbH
2018-03-09 15:19:26.839552|INFO    |DatabaseQuery |   |dbPlugin version: 3.11.1
2018-03-09 15:19:26.839703|INFO    |DatabaseQuery |   |checking database integrity (may take a while)
[New Thread 0x7ffff6bf2700 (LWP 12656)]
[New Thread 0x7ffff63f1700 (LWP 12657)]
[New Thread 0x7ffff5bf0700 (LWP 12658)]
[New Thread 0x7ffff53ef700 (LWP 12659)]
[New Thread 0x7ffff4bee700 (LWP 12660)]
[tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]
[tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]
[tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]
[tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]
[New Thread 0x7fffdfbe2700 (LWP 12661)]
[Thread 0x7fffdfbe2700 (LWP 12661) exited]
2018-03-09 15:19:27.522969|INFO    |Accounting    |   |Licensing Information
2018-03-09 15:19:27.523107|INFO    |Accounting    |   |type              : Non-profit
2018-03-09 15:19:27.523211|INFO    |Accounting    |   |starting date     : Wed Feb 28 00:00:00 2018
2018-03-09 15:19:27.523322|INFO    |Accounting    |   |ending date       : Mon Sep 10 00:00:00 2018
2018-03-09 15:19:27.523419|INFO    |Accounting    |   |max virtualservers: 10
2018-03-09 15:19:27.523520|INFO    |Accounting    |   |max slots         : 512
[New Thread 0x7ffff41db700 (LWP 12662)]
[New Thread 0x7fffdf3e1700 (LWP 12663)]
2018-03-09 15:19:27.538153|ERROR   |DatabaseQuery |   |invalid parameter found :server_id:
2018-03-09 15:19:27.538313|ERROR   |DatabaseQuery |   |sqlite3_prepare failed near ":tablename": syntax error
2018-03-09 15:19:27.538429|ERROR   |DatabaseQuery |   |db_open() select * from :tablename: where id = :id: and server_id=:server_id:; error: near ":tablename": syntax error
2018-03-09 15:19:27.538541|ERROR   |VirtualSvrMgr |   |unable to load default virtualserver values
2018-03-09 15:19:27.538649|ERROR   |ServerLibPriv |   |Server() error while starting servermanager, error: database error
[Thread 0x7ffff41db700 (LWP 12662) exited]
[Thread 0x7fffdf3e1700 (LWP 12663) exited]
[Thread 0x7ffff4bee700 (LWP 12660) exited]
[Thread 0x7ffff53ef700 (LWP 12659) exited]
[Thread 0x7ffff5bf0700 (LWP 12658) exited]
[Thread 0x7ffff63f1700 (LWP 12657) exited]
[Thread 0x7ffff6bf2700 (LWP 12656) exited]
[tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]
[tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]
[Thread 0x7ffff710c700 (LWP 12655) exited]
[Inferior 1 (process 12651) exited normally]
(gdb) bt
No stack.
(gdb) 

### Virtual Server Log file(s)

### Permissions in /home/ts3/ts/teamspeak

/home/ts3/ts/teamspeak/
total 13M
drwxr-xr-x 9 ts3  ts3  4.0K Mar  9 15:19 .
drwxr-xr-x 4 ts3  ts3  4.0K Aug 29  2017 ..
-rw-r--r-- 1 ts3  ts3   21K Mar  9 14:30 20180309-1430-ts3us-debug-report.md
-rw-r--r-- 1 ts3  ts3   20K Mar  9 14:34 20180309-1434-ts3us-debug-report.md
-rw-r--r-- 1 ts3  ts3   21K Mar  9 14:40 20180309-1440-ts3us-debug-report.md
-rw-r--r-- 1 ts3  ts3   21K Mar  9 14:48 20180309-1448-ts3us-debug-report.md
-rw-r--r-- 1 ts3  ts3   21K Mar  9 14:53 20180309-1453-ts3us-debug-report.md
-rw-r--r-- 1 ts3  ts3   21K Mar  9 15:01 20180309-1501-ts3us-debug-report.md
-rw-r--r-- 1 ts3  ts3   19K Mar  9 15:16 20180309-1516-ts3us-debug-report.md
-rw-r--r-- 1 root root 8.3K Mar  9 15:19 20180309-1519-ts3us-debug-report.md
-rw-r--r-- 1 ts3  ts3   53K Mar  9 15:19 CHANGELOG
drwxr-xr-x 3 ts3  ts3  4.0K Aug 29  2017 doc
drwx------ 4 ts3  ts3  4.0K Aug 29  2017 files
-rwxr-xr-x 1 ts3  ts3  978K Mar  9 15:19 libts3db_mariadb.so
-rwxr-xr-x 1 ts3  ts3  2.1M Mar  9 15:19 libts3db_sqlite3.so
-rw-r--r-- 1 ts3  ts3   67K Mar  9 15:19 LICENSE
-rw-r--r-- 1 ts3  ts3  1.7K Mar  1 02:27 licensekey.dat
drwx------ 2 ts3  ts3  164K Mar  9 15:19 logs
---------- 1 ts3  ts3    13 Sep 30 16:06 .password-file
-rw-r--r-- 1 ts3  ts3     1 Aug 29  2017 query_ip_blacklist.txt
-rw-r--r-- 1 ts3  ts3    37 Aug 29  2017 query_ip_whitelist.txt
drwxr-xr-x 2 ts3  ts3  4.0K Aug 29  2017 redist
-rw-r--r-- 1 ts3  ts3   112 Aug 29  2017 serverkey.dat
drwxr-xr-x 2 ts3  ts3  4.0K Aug 29  2017 serverquerydocs
drwxr-xr-x 5 ts3  ts3   12K Aug 29  2017 sql
-rwxr-xr-x 1 ts3  ts3  8.2M Dec 22 15:53 ts3server
-rw-r--r-- 1 ts3  ts3     0 Mar  9 14:30 .ts3server_license_accepted
-rwxr-xr-x 1 ts3  ts3   129 Mar  9 15:19 ts3server_minimal_runscript.sh
-rw-r--r-- 1 ts3  ts3     6 Mar  9 15:19 ts3server.pid
-rw-r--r-- 1 ts3  ts3  341K Mar  9 15:19 ts3server.sqlitedb
-rw-r--r-- 1 ts3  ts3   32K Mar  9 15:19 ts3server.sqlitedb-shm
-rw-r--r-- 1 ts3  ts3  2.1K Mar  9 15:19 ts3server.sqlitedb-wal
-rwxr-xr-x 1 ts3  ts3  2.6K Mar  9 15:19 ts3server_startscript.sh
-rw-r--r-- 1 ts3  ts3     0 Mar  9 15:19 .ts3updatescript.lock
drwxr-xr-x 2 ts3  ts3  4.0K Aug 29  2017 tsdns
-rw-r--r-- 1 ts3  ts3   540 Aug 29  2017 upgrade_EXPERMINENTAL_CUSTOM.sh

/home/ts3/ts/teamspeak/tsdns
total 940K
drwxr-xr-x 2 ts3 ts3 4.0K Aug 29  2017 .
drwxr-xr-x 9 ts3 ts3 4.0K Mar  9 15:19 ..
-rw-r--r-- 1 ts3 ts3 3.4K Mar  9 15:19 README
-rwxr-xr-x 1 ts3 ts3 917K Mar  9 15:19 tsdnsserver
-rw-r--r-- 1 ts3 ts3 2.8K Mar  9 15:19 tsdns_settings.ini.sample
-rw-r--r-- 1 ts3 ts3 2.8K Mar  9 15:19 USAGE

/home/ts3/ts/teamspeak/sql
total 652K
drwxr-xr-x 5 ts3 ts3  12K Aug 29  2017 .
drwxr-xr-x 9 ts3 ts3 4.0K Mar  9 15:19 ..
-rw-r--r-- 1 ts3 ts3   65 Mar  9 15:19 ban_delete.sql
-rw-r--r-- 1 ts3 ts3  360 Mar  9 15:19 ban_insert.sql
-rw-r--r-- 1 ts3 ts3   48 Mar  9 15:19 ban_list.sql
-rw-r--r-- 1 ts3 ts3   52 Mar  9 15:19 binding_delete.sql
-rw-r--r-- 1 ts3 ts3   63 Mar  9 15:19 bindings_insert.sql
-rw-r--r-- 1 ts3 ts3   44 Mar  9 15:19 bindings_list.sql
-rw-r--r-- 1 ts3 ts3  497 Mar  9 15:19 channel_delete_bulk.sql
-rw-r--r-- 1 ts3 ts3  415 Mar  9 15:19 channel_delete.sql
-rw-r--r-- 1 ts3 ts3  309 Mar  9 15:19 channel_insert_bulk_fixup.sql
-rw-r--r-- 1 ts3 ts3   78 Mar  9 15:19 channel_insert_bulk_mapping.sql
-rw-r--r-- 1 ts3 ts3  178 Mar  9 15:19 channel_insert_bulk.sql
-rw-r--r-- 1 ts3 ts3   97 Mar  9 15:19 channel_insert.sql
-rw-r--r-- 1 ts3 ts3  191 Mar  9 15:19 channel_properties_bulk_insert.sql
-rw-r--r-- 1 ts3 ts3  254 Mar  9 15:19 channel_server_list_properties_bulk.sql
-rw-r--r-- 1 ts3 ts3   79 Mar  9 15:19 channel_server_list.sql
-rw-r--r-- 1 ts3 ts3  113 Mar  9 15:19 channel_update_parentid.sql
-rw-r--r-- 1 ts3 ts3   96 Mar  9 15:19 client_clear_traffic_stats.sql
-rw-r--r-- 1 ts3 ts3   67 Mar  9 15:19 client_count_by_serverid.sql
-rw-r--r-- 1 ts3 ts3  346 Mar  9 15:19 client_delete_prune.sql
-rw-r--r-- 1 ts3 ts3  859 Mar  9 15:19 client_delete.sql
-rw-r--r-- 1 ts3 ts3   76 Mar  9 15:19 client_get_by_id.sql
-rw-r--r-- 1 ts3 ts3   91 Mar  9 15:19 client_get_by_name_or_uid.sql
-rw-r--r-- 1 ts3 ts3  343 Mar  9 15:19 client_get_by_serverid_bulk.sql
-rw-r--r-- 1 ts3 ts3   76 Mar  9 15:19 client_get_by_serverid_limit.sql
-rw-r--r-- 1 ts3 ts3   51 Mar  9 15:19 client_get_by_serverid.sql
-rw-r--r-- 1 ts3 ts3   92 Mar  9 15:19 client_get_by_uid.sql
-rw-r--r-- 1 ts3 ts3   50 Mar  9 15:19 client_get.sql
-rw-r--r-- 1 ts3 ts3  151 Mar  9 15:19 clientid_get_by_name_pw_serverid.sql
-rw-r--r-- 1 ts3 ts3  121 Mar  9 15:19 clientid_get_by_name_pw.sql
-rw-r--r-- 1 ts3 ts3   75 Mar  9 15:19 client_insert_bulk_mapping.sql
-rw-r--r-- 1 ts3 ts3  318 Mar  9 15:19 client_insert_bulk.sql
-rw-r--r-- 1 ts3 ts3  189 Mar  9 15:19 client_insert.sql
-rw-r--r-- 1 ts3 ts3  188 Mar  9 15:19 client_properties_bulk_insert.sql
-rw-r--r-- 1 ts3 ts3  158 Mar  9 15:19 client_update_login_info.sql
-rw-r--r-- 1 ts3 ts3  107 Mar  9 15:19 client_update_name.sql
-rw-r--r-- 1 ts3 ts3  199 Mar  9 15:19 client_update_stats.sql
-rw-r--r-- 1 ts3 ts3  302 Mar  9 15:19 client_update_traffic_stats.sql
-rw-r--r-- 1 ts3 ts3  104 Mar  9 15:19 complain_delete_all.sql
-rw-r--r-- 1 ts3 ts3   91 Mar  9 15:19 complain_delete_prune.sql
-rw-r--r-- 1 ts3 ts3  160 Mar  9 15:19 complain_delete.sql
-rw-r--r-- 1 ts3 ts3   54 Mar  9 15:19 complain_get_by_serverid.sql
-rw-r--r-- 1 ts3 ts3  267 Mar  9 15:19 complain_insert.sql
drwxr-xr-x 2 ts3 ts3 4.0K Aug 29  2017 create_mariadb
drwxr-xr-x 2 ts3 ts3 4.0K Aug 29  2017 create_sqlite
-rw-r--r-- 1 ts3 ts3   81 Mar  9 15:19 custom_delete_by_clientid.sql
-rw-r--r-- 1 ts3 ts3  100 Mar  9 15:19 custom_get_by_ident.sql
-rw-r--r-- 1 ts3 ts3   82 Mar  9 15:19 custom_get_by_id.sql
-rw-r--r-- 1 ts3 ts3  131 Mar  9 15:19 custom_insert.sql
-rw-r--r-- 1 ts3 ts3  71K Mar  9 15:19 defaults.sql
-rw-r--r-- 1 ts3 ts3  158 Mar  9 15:19 group_delete.sql
-rw-r--r-- 1 ts3 ts3   69 Mar  9 15:19 group_id_get_by_name.sql
-rw-r--r-- 1 ts3 ts3   74 Mar  9 15:19 group_insert_bulk_snapshot_get_mapping.sql
-rw-r--r-- 1 ts3 ts3  169 Mar  9 15:19 group_insert_bulk_snapshot.sql
-rw-r--r-- 1 ts3 ts3   81 Mar  9 15:19 group_insert.sql
-rw-r--r-- 1 ts3 ts3   75 Mar  9 15:19 group_member_delete_by_groupid.sql
-rw-r--r-- 1 ts3 ts3  107 Mar  9 15:19 group_member_delete.sql
-rw-r--r-- 1 ts3 ts3  120 Mar  9 15:19 group_member_detail_get_by_groupid.sql
-rw-r--r-- 1 ts3 ts3  110 Mar  9 15:19 group_member_get.sql
-rw-r--r-- 1 ts3 ts3  152 Mar  9 15:19 group_member_insert_bulk.sql
-rw-r--r-- 1 ts3 ts3   99 Mar  9 15:19 group_member_insert.sql
-rw-r--r-- 1 ts3 ts3   49 Mar  9 15:19 group_members_get_by_groupid.sql
-rw-r--r-- 1 ts3 ts3   72 Mar  9 15:19 group_members_get_by_id.sql
-rw-r--r-- 1 ts3 ts3   51 Mar  9 15:19 group_members_get_by_serverid.sql
-rw-r--r-- 1 ts3 ts3   57 Mar  9 15:19 group_rename.sql
-rw-r--r-- 1 ts3 ts3   51 Mar  9 15:19 groups_get_by_serverid.sql
-rw-r--r-- 1 ts3 ts3   69 Mar  9 15:19 groups_get_by_serverid_type.sql
-rw-r--r-- 1 ts3 ts3   21 Mar  9 15:19 groups_get.sql
-rw-r--r-- 1 ts3 ts3   39 Mar  9 15:19 info_delete.sql
-rw-r--r-- 1 ts3 ts3   68 Mar  9 15:19 info_get_by_ident.sql
-rw-r--r-- 1 ts3 ts3   58 Mar  9 15:19 info_insert.sql
-rw-r--r-- 1 ts3 ts3  131 Mar  9 15:19 message_delete.sql
-rw-r--r-- 1 ts3 ts3  133 Mar  9 15:19 message_get_by_clientid.sql
-rw-r--r-- 1 ts3 ts3  117 Mar  9 15:19 message_get_unread_by_clientid.sql
-rw-r--r-- 1 ts3 ts3  305 Mar  9 15:19 message_insert.sql
-rw-r--r-- 1 ts3 ts3  103 Mar  9 15:19 message_list_by_clientid.sql
-rw-r--r-- 1 ts3 ts3  161 Mar  9 15:19 message_update_flag.sql
-rw-r--r-- 1 ts3 ts3 2.3K Mar  9 15:19 perm_copy_default_permissions.sql
-rw-r--r-- 1 ts3 ts3   65 Mar  9 15:19 perm_delete_by_groupid.sql
-rw-r--r-- 1 ts3 ts3  105 Mar  9 15:19 perm_delete_by_permid.sql
-rw-r--r-- 1 ts3 ts3  896 Mar  9 15:19 perm_delete_by_serverid.sql
-rw-r--r-- 1 ts3 ts3   39 Mar  9 15:19 perm_get_by_id.sql
-rw-r--r-- 1 ts3 ts3   52 Mar  9 15:19 perm_get_by_serverid.sql
-rw-r--r-- 1 ts3 ts3  151 Mar  9 15:19 perm_group_copy.sql
-rw-r--r-- 1 ts3 ts3  389 Mar  9 15:19 perm_group_get_mapping.sql
-rw-r--r-- 1 ts3 ts3  440 Mar  9 15:19 perm_group_perm_copy.sql
-rw-r--r-- 1 ts3 ts3  278 Mar  9 15:19 perm_insert_bulk.sql
-rw-r--r-- 1 ts3 ts3  176 Mar  9 15:19 perm_insert.sql
-rw-r--r-- 1 ts3 ts3  927 Mar  9 15:19 permission_load_channel_group_total.sql
-rw-r--r-- 1 ts3 ts3  399 Mar  9 15:19 permission_load_other.sql
-rw-r--r-- 1 ts3 ts3 1.9K Mar  9 15:19 permission_load_server_and_channel_group_total.sql
-rw-r--r-- 1 ts3 ts3  925 Mar  9 15:19 permission_load_server_group_total.sql
-rw-r--r-- 1 ts3 ts3  433 Mar  9 15:19 perm_rename.sql
-rw-r--r-- 1 ts3 ts3   93 Mar  9 15:19 perm_update_get_groups.sql
-rw-r--r-- 1 ts3 ts3   66 Mar  9 15:19 properties_delete_by_id.sql
-rw-r--r-- 1 ts3 ts3   55 Mar  9 15:19 properties_delete_by_string_id.sql
-rw-r--r-- 1 ts3 ts3  152 Mar  9 15:19 properties_insert_by_id.sql
-rw-r--r-- 1 ts3 ts3  183 Mar  9 15:19 properties_insert_by_string_id.sql
-rw-r--r-- 1 ts3 ts3   68 Mar  9 15:19 properties_list_by_id.sql
-rw-r--r-- 1 ts3 ts3   56 Mar  9 15:19 properties_list_by_string_id.sql
-rw-r--r-- 1 ts3 ts3   66 Mar  9 15:19 revocations_delete.sql
-rw-r--r-- 1 ts3 ts3  104 Mar  9 15:19 revocations_getlist.sql
-rw-r--r-- 1 ts3 ts3  223 Mar  9 15:19 revocations_insert_bulk.sql
-rw-r--r-- 1 ts3 ts3  104 Mar  9 15:19 server_clear_traffic_stats.sql
-rw-r--r-- 1 ts3 ts3  188 Mar  9 15:19 server_delete_get_qa_clients.sql
-rw-r--r-- 1 ts3 ts3 1.3K Mar  9 15:19 server_delete.sql
-rw-r--r-- 1 ts3 ts3   52 Mar  9 15:19 server_get_byid.sql
-rw-r--r-- 1 ts3 ts3   56 Mar  9 15:19 server_get_byport.sql
-rw-r--r-- 1 ts3 ts3  140 Mar  9 15:19 server_insert.sql
-rw-r--r-- 1 ts3 ts3   67 Mar  9 15:19 server_list_by_machine_id.sql
-rw-r--r-- 1 ts3 ts3   22 Mar  9 15:19 server_list.sql
-rw-r--r-- 1 ts3 ts3 1.1K Mar  9 15:19 server_snapshot_delete_failed.sql
-rw-r--r-- 1 ts3 ts3 1.1K Mar  9 15:19 server_snapshot_delete.sql
-rw-r--r-- 1 ts3 ts3   85 Mar  9 15:19 server_update_autostart.sql
-rw-r--r-- 1 ts3 ts3   87 Mar  9 15:19 server_update_machine_id.sql
-rw-r--r-- 1 ts3 ts3   75 Mar  9 15:19 server_update_port.sql
-rw-r--r-- 1 ts3 ts3  276 Mar  9 15:19 server_update_traffic_stats.sql
-rw-r--r-- 1 ts3 ts3   72 Mar  9 15:19 token_delete_by_key.sql
-rw-r--r-- 1 ts3 ts3   74 Mar  9 15:19 token_get_by_key.sql
-rw-r--r-- 1 ts3 ts3  340 Mar  9 15:19 token_insert.sql
-rw-r--r-- 1 ts3 ts3   48 Mar  9 15:19 token_list.sql
-rw-r--r-- 1 ts3 ts3  541 Mar  9 15:19 update_12.sql
-rw-r--r-- 1 ts3 ts3 3.4K Mar  9 15:19 update_13.sql
-rw-r--r-- 1 ts3 ts3  402 Mar  9 15:19 update_14.sql
-rw-r--r-- 1 ts3 ts3   73 Mar  9 15:19 update_15.sql
-rw-r--r-- 1 ts3 ts3  197 Mar  9 15:19 update_16.sql
-rw-r--r-- 1 ts3 ts3  158 Mar  9 15:19 update_17.sql
-rw-r--r-- 1 ts3 ts3   57 Mar  9 15:19 update_18.sql
-rw-r--r-- 1 ts3 ts3   26 Mar  9 15:19 update_19.sql
-rw-r--r-- 1 ts3 ts3   61 Mar  9 15:19 update_20.sql
-rw-r--r-- 1 ts3 ts3   51 Mar  9 15:19 update_21.sql
-rw-r--r-- 1 ts3 ts3   64 Mar  9 15:19 update_22.sql
-rw-r--r-- 1 ts3 ts3   92 Mar  9 15:19 update_23.sql
-rw-r--r-- 1 ts3 ts3  209 Mar  9 15:19 update_24.sql
-rw-r--r-- 1 ts3 ts3  312 Mar  9 15:19 update_25.sql
-rw-r--r-- 1 ts3 ts3   26 Mar  9 15:19 update_26.sql
-rw-r--r-- 1 ts3 ts3   26 Mar  9 15:19 update_27.sql
-rw-r--r-- 1 ts3 ts3   93 Mar  9 15:19 update_database_version.sql
-rw-r--r-- 1 ts3 ts3  121 Mar  9 15:19 update_mariadb_26.sql
-rw-r--r-- 1 ts3 ts3  235 Mar  9 15:19 update_mariadb_27.sql
-rw-r--r-- 1 ts3 ts3  979 Mar  9 15:19 update_permissions_12.sql
drwxr-xr-x 2 ts3 ts3 4.0K Aug 29  2017 updates_and_fixes
-rw-r--r-- 1 ts3 ts3  211 Mar  9 15:19 update_sqlite_27.sql

/home/ts3/ts/teamspeak/sql/updates_and_fixes
total 28K
drwxr-xr-x 2 ts3 ts3 4.0K Aug 29  2017 .
drwxr-xr-x 5 ts3 ts3  12K Aug 29  2017 ..
-rw-r--r-- 1 ts3 ts3 3.7K Mar  9 15:19 convert_mysql_to_mariadb.sql
-rw-r--r-- 1 ts3 ts3 5.1K Mar  9 15:19 mariadb_fix_latin_utf8.sql

/home/ts3/ts/teamspeak/sql/create_mariadb
total 32K
drwxr-xr-x 2 ts3 ts3 4.0K Aug 29  2017 .
drwxr-xr-x 5 ts3 ts3  12K Aug 29  2017 ..
-rw-r--r-- 1 ts3 ts3 9.6K Mar  9 15:19 create_tables.sql
-rw-r--r-- 1 ts3 ts3  874 Mar  9 15:19 drop_tables.sql

/home/ts3/ts/teamspeak/sql/create_sqlite
total 32K
drwxr-xr-x 2 ts3 ts3 4.0K Aug 29  2017 .
drwxr-xr-x 5 ts3 ts3  12K Aug 29  2017 ..
-rw-r--r-- 1 ts3 ts3 9.2K Mar  9 15:19 create_tables.sql
-rw-r--r-- 1 ts3 ts3 1.1K Mar  9 15:19 drop_tables.sql

/home/ts3/ts/teamspeak/redist
total 308K
drwxr-xr-x 2 ts3 ts3 4.0K Aug 29  2017 .
drwxr-xr-x 9 ts3 ts3 4.0K Mar  9 15:19 ..
-rwxr-xr-x 1 ts3 ts3 300K Mar  9 15:19 libmariadb.so.2
Sebbo94BY commented 6 years ago

Thanks for the debug report, @siysco.

Backtrace using gdb shows clearly, that you have a database issue.

This issue indicates usually, that you have a wrong database driver: [tcsetpgrp failed in terminal_inferior: Inappropriate ioctl for device]

And this shows, that your SQLite database is corrupt:

2018-03-09 15:19:27.538153|ERROR   |DatabaseQuery |   |invalid parameter found :server_id:
2018-03-09 15:19:27.538313|ERROR   |DatabaseQuery |   |sqlite3_prepare failed near ":tablename": syntax error
2018-03-09 15:19:27.538429|ERROR   |DatabaseQuery |   |db_open() select * from :tablename: where id = :id: and server_id=:server_id:; error: near ":tablename": syntax error
2018-03-09 15:19:27.538541|ERROR   |VirtualSvrMgr |   |unable to load default virtualserver values
2018-03-09 15:19:27.538649|ERROR   |ServerLibPriv |   |Server() error while starting servermanager, error: database error

I recommend you to install a new TS3 Server instance and then migrate the existing virtual servers to this new instance. Take a snapshot of the virtual servers and deploy them on the new server.

4N7 commented 6 years ago

Oh, nice. Thanks for identifying that for me. DB never was my strong suit... I have some reading to do. Let me figure this out and I'll report back.