Can not start MySQL version. (Unknown database 'test')

[MrSpoocy]

ts3server.ini

machine_id=xxx.xxx.xxx.xxx
default_voice_port=9987
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
dbplugin=ts3db_mysql
dbpluginparameter=ts3db_mysql.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
logpath=logs
logquerycommands=0

ts3db_mysql.ini

[config]
host=localhost
port=3306
username=teamspeak
password=XXXXXXXXXX
database=teamspeak3
socket=

#~: ./ts3server_linux_amd64 inifile=ts3server.ini

2009-12-29 21:19:42.101322|INFO |ServerLibPriv | | Server Version: 3.0.0-beta11 [Build: 9559]
2009-12-29 21:19:42.107604|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
2009-12-29 21:19:42.107848|INFO |DatabaseQuery | | dbPlugin version: 1
2009-12-29 21:19:42.116737|ERROR |DatabaseQuery | | mysql_real_connect() failed with error: Unknown database 'test'
Segmentation fault

what is wrong :/

[aeular]

did you remember to add an extra empty line at the end of both configuration files?

[MrSpoocy]

ok i forget thx

[mbyte]

ts3db_mysql.ini
[config]
host=localhost
port=3306
username=teamspeak
password=XXXXXXXXXX
database=teamspeak3
***space white***

ts3server.ini
machine_id=xxx.xxx.xxx.xxx
default_voice_port=9987
voice_ip=0.0.0.0 =IP SERVER
licensepath=
filetransfer_port=30033
filetransfer_ip=0.0.0.0 =IP SERVER
query_port=10011
query_ip=0.0.0.0 =IP SERVER
dbplugin=ts3db_mysql
dbpluginparameter=ts3db_mysql.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
logpath=logs
logquerycommands=0


Edit by mod
Please don't use this outdated script anymore! The script got an overhaul long time ago.
Please use the minimal or startscript instead

nohup ./ts3server_linux_x86 inifile=ts3server.ini dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/ &

24/7

Soon

[QweSteR]

Hello, I have the same problem but in Windows (dont wanna to create similar theme there)
So, I use such command line (after cd C:\ts3server):

ts3server_win64.exe inifile=ts3server.ini

logs:

2012-04-04 21:09:33.197429|INFO |ServerLibPriv | | TeamSpeak 3 Server 3.0.3 (2012-03-17 06:12:11)
2012-04-04 21:09:33.198429|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
2012-04-04 21:09:33.198429|INFO |DatabaseQuery | | dbPlugin version: 1
2012-04-04 21:09:33.203429|ERROR |DatabaseQuery | | mysql_real_connect() failed with error: Unknown database 'test'
2012-04-04 21:09:33.203429|CRITICAL|ServerLibPriv | | Server() DatabaseError

ts3server.ini

machine_id=
default_voice_port=9987
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_mysql
dbpluginparameter=ts3db_mysql.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
dbconnections=10
logpath=logs
logquerycommands=0
dbclientkeepdays=30
logappend=0
<empty line>

ts3db_mysql.ini

[config]
host=localhost
port=3306
username=root
password=
database=teampseak
socket=
<empty line>

What's wrong?

[Maxe___]

Hey,

There is a typo in your ts3db_mysql.ini, maybe thats the fail, if your database is called teamspeak and not teampseak.

[config]
host=localhost
port=3306
username=root
password=
database=teampseak
socket=
<empty line>

Kind regards

[QweSteR]

I have virtual webserver on my computer (localhost), OS Windows 7 64bit. Moreover Teamspeak server works fine if I create database named 'test' (in this case plugin uses default settings (login: root, db: test, empty password)). As I said before I can to connect to my database on my PC, I have all permissions.

[florian_fr40]

Yep I understand that. And of course the server can connect to the database if test exists.

But the problem is it try to connect on test if it doesn't understand the ts3db_mysql.ini file.
It's why I suggested you to delete and recreate this one.