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

**MrSpoocy** · 29-12-2009, 21:23

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

what is wrong :/

**aeular** · 29-12-2009, 21:29

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

**MrSpoocy** · 29-12-2009, 21:33

ok i forget

thx

**mbyte** · 29-12-2009, 21:39

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** · 04-04-2012, 22:35

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:

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___** · 04-04-2012, 23:55

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** · 05-04-2012, 11:44

No, it's specially)) MySQL plugin just doesn't use my config file, that's why all settings are default.

Should I create the same theme in Windows section to get some help?

**pillbox1234567** · 10-04-2012, 19:52

If you search around the forums you should be able to find your solution. It has been answered recently.

**QweSteR** · 10-04-2012, 21:53

I was searching for my solution before posting my first message here. And I still don't know what's wrong with it. Please, if you know the solution give me a link or an advice.

**florian_fr40** · 11-04-2012, 09:16

Hello

The server try to point on a test database if there is no valide ts3db_mysql.ini

But before all, instead use the root user (without password, etc), create a new database on your mysql server (like e.g. ts3BDD with password and why no the same user)

Now check if your ts3db_mysql.ini file has a good name (I guess you have a windows seven or greater system). Check if the extension is .ini and NOT .ini.ini

After that write this :

Code:

[CONFIG]
host=localhost
port=3306
username=ts3BDD
password=<password>
database=ts3BDD
socket=

Now re try

**QweSteR** · 11-04-2012, 10:47

Hi again.
My new "ts3db_mysql.ini" NOT "ts3db_mysql.ini.ini", "ts3db_mysql.ini.txt" or something like that.

[CONFIG]
host=localhost
port=3306
username=qwester
password=parol
database=qwester
socket=

with empty line at the end (and without empty line it doesn't work anyway).

And my logs:

As you see it still doesn't work.

**florian_fr40** · 11-04-2012, 10:58

Are you allow to connect to this database with a tool like HeidiSQL ?

Also could you try to start your server like that :

Code:

ts3server_win64.exe dbplugin=ts3db_mysql dbsqlpath=sql/ dbsqlcreatepath=create_mysql/

And little question, do you try to start your server as Admin (right on exe file > Run as Admin)

**QweSteR** · 11-04-2012, 11:20

I don't use HeidiSQL and also don't know what is it. I use webserver with Mysql database and I can to connect to the database over my php script or PHPMyAdmin using parameters from ts3db_mysql.ini file.

Trying to start teamspeak server using

Code:

ts3server_win64.exe dbplugin=ts3db_mysql dbsqlpath=sql/ dbsqlcreatepath=create_mysql/

gives the same result.

I have created a link to ts3server_win64.exe inside teamspeak server folder and tried to start it as Admin but I got the same result as before. Well, the plugin just doesn't use its config file and I don't know why. If you need I can upload my teamspeak server folder with all files (.exe, .ini, etc.).

**florian_fr40** · 11-04-2012, 13:29

You talk about a webserver, do you mean a dedicated server (or vps) with a Teamspeak server and MySQL server ?

I suggest you to delete the ts3db_mysql.ini file and create a new one (just to avoid any broken file story)

**QweSteR** · 11-04-2012, 13:30

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.

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

Thread Tools

Rate This Thread

Display

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

Thread Information

Users Browsing this Thread

Similar Threads

Teamspeak 3 with MySQL Database

How do I set the MySQL database?

Need help Mysql database

MySQL-database

Posting Permissions