update 3.0.1 + no connexion mysql

**flamme-demon** · 09-02-2012, 22:18

Hi everybody,

Me French, sorry little speak english.

After the update 3.0.0 RC1 ==> 3.0.1
I replaced all the files you tar.gz package, and since when I run my TS3 it uses the file ts3server.sqlitedb

Code:

[config]
   host=127.0.0.1
   port=3306
   username=login
   password=password
   database=teamspeak3
   socket=

Code:

machine_id=
default_voice_port=9987
voice_ip=88.190.XXX.XX
liscensepath=./licensekey.dat
filetransfer_port=30033
filetranser_ip=88.190.XXX.XX
query_port=10011
query_ip=88.190.XXX.XX
dbplugin=ts3db_mysql
dbpluginparameter=ts3db_mysql.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
logpath=logs
logquerycommands=1
listpublic=0

Code:

#!/bin/bash

TS_DIR="/home/ts3/teamspeak3/"
TS_USER="ts3"
RUN_SCRIPT="ts3server_minimal_runscript.sh"
INI_FILE="ts3server.ini"

start_ts() {
echo "Lancement du server TeamSpeak"
su $TS_USER $TS_DIR/$RUN_SCRIPT init=$TS_DIR/$INI_FILE > /dev/null &
}

stop_ts() {
echo "Arrêt du serveur TeamSpeak"
skill -KILL -u $TS_USER > /dev/null
}

case "$1" in
start)
start_ts
;;
stop)
stop_ts
;;
restart)
stop_ts
sleep 2
start_ts
;;
*)
echo "Usage du script : $0 {start|stop|restart}"
;;
esac

LOG 0

Code:

2012-02-09 22:04:26.628368|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.1 (2011-11-17 07:34:30)
2012-02-09 22:04:26.628919|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2012-02-09 22:04:26.628967|INFO    |DatabaseQuery |   | dbPlugin version: 3.7.3
2012-02-09 22:04:26.629240|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
2012-02-09 22:04:27.070887|INFO    |Accounting    |   | Licensing Information
2012-02-09 22:04:27.070980|INFO    |Accounting    |   | type              : Non-profit
2012-02-09 22:04:27.071073|INFO    |Accounting    |   | starting date     : Fri Jun  3 00:00:00 2011
2012-02-09 22:04:27.071136|INFO    |Accounting    |   | ending date       : Sun Jun  3 00:00:00 2012
2012-02-09 22:04:27.071196|INFO    |Accounting    |   | max virtualservers: 10
2012-02-09 22:04:27.071247|INFO    |Accounting    |   | max slots         : 512
2012-02-09 22:04:27.108844|INFO    |FileManager   |   | listening on 0.0.0.0:30033
2012-02-09 22:04:27.229039|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: 127.0.0.1,
2012-02-09 22:04:27.230260|INFO    |Query         |   | listening on 0.0.0.0:10011

LOG 1

Code:

2012-02-09 22:04:27.228679|INFO    |VirtualServer |  1| listening on 0.0.0.0:9987

He seems to run 2 servers (or of the two log files). But I do not capture how this is possible: (

**florian_fr40** · 09-02-2012, 22:25

Hello

There is no 2 servers. From this version you have a log file for the Teamspeak Instance and a log file for each virtual server.
Please => read the changelog

Why create a such script to start your Teamspeak server.
Instead this script (using the minimal_run_script), you could simply use the startscript

Code:

./ts3server_startscript.sh start inifile=ts3server.ini

Plus, there is an error in your script (init=)

**flamme-demon** · 09-02-2012, 22:32

Originally Posted by florian_fr40

Hello

There is no 2 servers. From this version you have a log file for the Teamspeak Instance and a log file for each virtual server.
Please => read the changelog

Why create a such script to start your Teamspeak server.
Instead this script (using the minimal_run_script), you could simply use the startscript

Code:

./ts3server_startscript.sh start inifile=ts3server.ini

Plus, there is an error in your script (init=)

I modified my script and put it in / bin / bash!
I used the command line start ./ts3server_minimal_runscript.sh inifile = ts3server.ini

Code:

2012-02-09 22:29:26.663157|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.1 (2011-11-17 07:34:30)
2012-02-09 22:29:26.665406|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
2012-02-09 22:29:26.665475|INFO    |DatabaseQuery |   | dbPlugin version: 1
2012-02-09 22:29:27.040890|INFO    |Accounting    |   | Licensing Information
2012-02-09 22:29:27.040971|INFO    |Accounting    |   | type              : Non-profit
2012-02-09 22:29:27.041027|INFO    |Accounting    |   | starting date     : Fri Jun  3 00:00:00 2011
2012-02-09 22:29:27.041067|INFO    |Accounting    |   | ending date       : Sun Jun  3 00:00:00 2012
2012-02-09 22:29:27.041124|INFO    |Accounting    |   | max virtualservers: 10
2012-02-09 22:29:27.041167|INFO    |Accounting    |   | max slots         : 512
2012-02-09 22:29:27.058657|WARNING |PermGroupMgr  |   | cldbid: 1, assigned to unknown gid: 9, ignoring!
2012-02-09 22:29:27.059761|INFO    |FileManager   |   | listening on 0.0.0.0:30033
2012-02-09 22:29:27.139416|INFO    |VirtualServer |  1| listening on 88.190.XXX.XX:9987
2012-02-09 22:29:27.139861|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: 127.0.0.1,
2012-02-09 22:29:27.140248|INFO    |Query         |   | listening on 88.190.XXX.XX:10011
2012-02-09 22:29:27.432972|ERROR   |Accounting    |   | too many slots hosted, shutting down!
2012-02-09 22:29:27.578618|INFO    |VirtualServer |  1| stopped

**florian_fr40** · 09-02-2012, 22:43

But why add this script in you bash Folder. It's useles.

1 - Check all Teamspeak process and kill all (to search : "ps -aux | grep ts3", to kill "kill -9 <process ID>)
2 - Go into the serve folder.
3 - Start your server with the startscript

**flamme-demon** · 09-02-2012, 22:49

Process :
678 pts/0 S+ 0:00 grep ts3

Bug kill process :
kill: kill 678 failed: no such process

Code:

USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
root         1  0.0  0.1   2024   692 ?        Ss   00:01   0:00 init [2]
root        30  0.0  0.0    100    16 ?        S    00:01   0:00 [init-logger]
daemon     172  0.0  0.0   1800   472 ?        Ss   00:01   0:00 /sbin/portmap
root       233  0.0  0.2  28316  1380 ?        Sl   00:01   0:00 /usr/sbin/rsyslogd -c4
root       245  0.0  0.1   5484   960 ?        Ss   00:01   0:00 /usr/sbin/sshd
root       270  0.0  0.1   1740   544 ?        S    00:01   0:00 /bin/sh /usr/bin/mysqld_safe
mysql      381  0.0  3.5 137592 18496 ?        Sl   00:01   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-fi
root       382  0.0  0.1   1664   536 ?        S    00:01   0:00 logger -t mysqld -p daemon.error
root       398  0.0  0.5   8384  2840 ?        Ss   00:01   0:00 sshd: root@pts/0
root       547  0.0  0.3   5768  1828 ?        Ss   00:01   0:00 /usr/lib/postfix/master
postfix    549  0.0  0.3   5784  1740 ?        S    00:01   0:00 pickup -l -t fifo -u -c
postfix    550  0.0  0.3   5828  1788 ?        S    00:01   0:00 qmgr -l -t fifo -u
root       558  0.0  0.3   4488  1796 ?        Ss   00:01   0:00 /usr/sbin/ntpd -p /var/run/ntpd.pid -g -u 104:109
daemon     591  0.0  0.0   2152   420 ?        Ss   00:01   0:00 /usr/sbin/atd
root       613  0.0  0.1   2284   852 ?        Ss   00:01   0:00 /usr/sbin/cron
root       628  0.0  1.4  34868  7780 ?        Ss   00:01   0:00 /usr/sbin/apache2 -k start
www-data   647  0.0  0.7  34868  4076 ?        S    00:01   0:00 /usr/sbin/apache2 -k start
www-data   648  0.0  0.7  34868  4068 ?        S    00:01   0:00 /usr/sbin/apache2 -k start
www-data   649  0.0  0.7  34868  4068 ?        S    00:01   0:00 /usr/sbin/apache2 -k start
www-data   650  0.0  0.7  34868  4068 ?        S    00:01   0:00 /usr/sbin/apache2 -k start
www-data   651  0.0  0.7  34868  4068 ?        S    00:01   0:00 /usr/sbin/apache2 -k start
root       681  0.0  1.0  25496  5492 ?        Sl   00:01   0:00 /usr/bin/python /usr/bin/fail2ban-server -b -s /var/run/fail2ban/fail2ban.sock
root       699  0.0  0.4   3764  2260 pts/0    Ss   00:01   0:00 -zsh
root       732  0.0  0.1   2344   928 pts/0    R+   00:03   0:00 ps -aux

No TS3 service

**florian_fr40** · 09-02-2012, 23:12

Ok so go into your server folder
Follow the step 2 and 3 from my previous post

If you still get the same error message about the hosted slots, make sure that your licence is no reached with another Teamspeak instance (I don't think so) and that your virtual server has no more 512 slots.

Sometime, you have to wait some minutes before restart your server

**flamme-demon** · 13-02-2012, 14:43

Originally Posted by florian_fr40

Ok so go into your server folder
Follow the step 2 and 3 from my previous post

If you still get the same error message about the hosted slots, make sure that your licence is no reached with another Teamspeak instance (I don't think so) and that your virtual server has no more 512 slots.

Sometime, you have to wait some minutes before restart your server

I do not know how I solved my concern but, by restarting the server last night it set out again and I do not know why: (

Thread: update 3.0.1 + no connexion mysql

Thread Tools

Rate This Thread

Display

update 3.0.1 + no connexion mysql

Thread Information

Users Browsing this Thread

Similar Threads

MySQL 12-15 DB Update.

MySQL Update Server 9

Connexion

Error bei Update auf MySQL

LoG Connexion

Posting Permissions