After Upgrade to 3.12.1 no DB connection

Hello,

had to update the TS Server software yesterday, but no database connection is possible. Always get the error message that 127.0.0.1 is not available. But the problem is that 127.0.0.1 is nowhere in the configuration, but a different IP address. It worked before.

My start commando:
sh ./ts3server_startscript.sh start inifile=ts3server.ini

My INI-File:
machine_id=
default_voice_port=31337
voice_ip=0.0.0.0
licensepath=
filetransfer_port=30033
filetransfer_ip=0.0.0.0
query_port=10011
query_ip=0.0.0.0
query_ip_whitelist=query_ip_whitelist.txt
query_ip_blacklist=query_ip_blacklist.txt
dbplugin=ts3db_mariadb
dbpluginparameter=ts3db_mariadb.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mariadb/
dbconnections=10
logpath=logs
logquerycommands=0
dbclientkeepdays=30
logappend=0
query_skipbruteforcecheck=0

INI-File ts3db_mariadb.ini
[config]
server=192.168.0.150
port=3306
username=username
password=hardPassword
database=teamspeak

I had tried it with ’ ’ and without some symbols.

SSH output:
> TeamSpeak 3 server started, for details please view the log file
> teamspeak@Teamspeak:~$ 2020-04-03 12:49:27.260288|CRITICAL|ServerLibPriv | |Server() unable to initialize database

Logs:
2020-04-03 12:49:27.257812|INFO |ServerLibPriv | |TeamSpeak 3 Server 3.12.1 (2020-03-27 10:38:47)
2020-04-03 12:49:27.258016|INFO |ServerLibPriv | |SystemInformation: Linux 4.15.17-1-pve #1 SMP PVE 4.15.17-9 (Wed, 9 May 2018 13:31:43 +0200) x86_64 Binary: 64bit
2020-04-03 12:49:27.258038|WARNING |ServerLibPriv | |The system locale is set to “C” this can cause unexpected behavior. We advice you to repair your locale!
2020-04-03 12:49:27.258051|INFO |ServerLibPriv | |Using hardware aes
2020-04-03 12:49:27.259163|INFO |DatabaseQuery | |dbPlugin name: MariaDB plugin, version 3, ©TeamSpeak Systems GmbH
2020-04-03 12:49:27.259212|INFO |DatabaseQuery | |dbPlugin version: 2
2020-04-03 12:49:27.260248|ERROR |DatabaseQuery | |Could not connect to mariadb server: Can’t connect to MySQL server on ‘127.0.0.1’ (107)
2020-04-03 12:49:27.260288|CRITICAL|ServerLibPriv | |Server() unable to initialize database

Thanks for your help.

Replace it with this

host=192.168.0.150

2 Likes

Thanks a lot. Thats work for me. The server starts, but now i cant connect.

I had configurated port 31337.

sudo lsof -i -P -n | grep LISTEN

TS Server:
ts3server 372 teamspeak 21u IPv4 113385321 0t0 TCP *:30033 (LISTEN)
ts3server 372 teamspeak 32u IPv4 113385340 0t0 TCP *:10011 (LISTEN)
ts3server 372 teamspeak 35u IPv4 113385342 0t0 TCP *:10022 (LISTEN)
ts3server 372 teamspeak 36u IPv6 113385343 0t0 TCP *:10022 (LISTEN)

Existing server will ignore what you wrote in the ini file.

Check your log which port (UDP) is used and make sure forwarding is done right.
Check your logs for errors.

1 Like