Problem with MySQL on TS3

[Siedler]

I have Installed Teamspeak3 on Debian Squeeze 6.0 64 bit with Tutorial; http://www.dermute.de/425-howto-teamspeak-3-mit-mysql

Teamspeak created also the database in MySQL, but use not really?

The Database is on standard configurations, and not used.

[florian_fr40]

Hello

Please post the ini files and the command that you use to start your server.
Also please your server log.

[Siedler]

Hello,

my ts3server.ini

machine_id=1
default_voice_port=9987
voice_ip=<ip>
licensepath=
filetransfer_port=30033
filetransfer_ip=<ip>
query_port=10011
query_ip=127.0.0.1
query_ip_whitelist=query_ip_whitelist.txt
query_ip_blacklist=query_ip_blacklist.txt
dbplugin=ts3db_mysql
dbpluginparameter=ts3db_mysql.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
dblogkeepdays=90
logpath=logs
logquerycommands=0
dbclientkeepdays=30

my ts3db_mysql.ini

[config]
host=localhost
port=3306
username=ts3user
password=<pw>
database=ts3
socket=

My command to start

./ts3server_startscript.sh restart inifile=ts3server.ini

if i use "stop" and "start", a blank TS3 Server starting?

2012-03-20 10:30:11.625945|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.3 (2012-03-17 06:12:11)
2012-03-20 10:30:11.627092|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2012-03-20 10:30:11.627152|INFO    |DatabaseQuery |   | dbPlugin version: 3.7.3
2012-03-20 10:30:11.627542|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
2012-03-20 10:30:11.793154|INFO    |Accounting    |   | Licensing Information
2012-03-20 10:30:11.793203|INFO    |Accounting    |   | type              : Non-profit
2012-03-20 10:30:11.793253|INFO    |Accounting    |   | starting date     : Mon Mar 19 00:00:00 2012
2012-03-20 10:30:11.793291|INFO    |Accounting    |   | ending date       : Wed Sep 19 00:00:00 2012
2012-03-20 10:30:11.793311|INFO    |Accounting    |   | max virtualservers: 10
2012-03-20 10:30:11.793325|INFO    |Accounting    |   | max slots         : 512
2012-03-20 10:30:11.807830|INFO    |FileManager   |   | listening on 0.0.0.0:30033
2012-03-20 10:30:11.877252|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: 127.0.0.1,
2012-03-20 10:30:11.877729|INFO    |Query         |   | listening on 0.0.0.0:10011

EDIT:

I did follow

./ts3server_startscript.sh stop inifile=ts3server.ini

then

./ts3server_startscript.sh start inifile=ts3server.ini

now it starts with MySQL Plugin.
But when i now write

./ts3server_startscript.sh restart inifile=ts3server.ini

it starts with SQLite?

[florian_fr40]

Try this :

./ts3server_startscript.sh stop
./ts3server_startscript.sh start inifile=ts3server.ini

[Siedler]

Now it Works, thanks.
But, how i can delete the other Server instances?
My Server is running now on ID1.

And, if i write "restart" instance 0 is auto starting.

[florian_fr40]

Sorry I don't really understand you.
Could you be a little bit more specific please.

[Siedler]

If i try

./ts3server_startscript.sh stop
./ts3server_startscript.sh start inifile=ts3server.ini

it works with MySQL.

If i write

./ts3server_startscript.sh restart inifile=ts3server.ini

then server is starting without MySQL :s

[florian_fr40]

Ha yes it's true

The easiest solution should be to add this on the COMMANDELINE_PARAMETER (at the top of the startscript file) :

COMMANDLINE_PARAMETERS="${2} inifile=ts3server.ini"

But you also can add this in the restart part (not recommended and this is for a specific cases )

restart)
                $0 stop && $0 start  || exit 1

BY

restart)
                $0 stop && $0 start ${COMMANDLINE_PARAMETERS} || exit 1

[Siedler]

How add COMMANDELINE_PARAMETER?
I dont know rly

EDIT:

Solved, Thanks