sql database problem

[yomega]

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


This is on a freshly installed Debian system with both mysql and sqlite installed I tried following several peoples walkthrough and none work exactly

I have 3 possible outcomes when I try to start TS3 server the first one is when i just execute it with no parameters

tts@thethreat:~/teamspeak3-server_linux-x86$ ./ts3server_linux_x86
Logging started
2010-01-01 21:14:26.521128|INFO |ServerLibPriv | | Server Version: 3.0.0-beta12 [Build: 9596]
2010-01-01 21:14:26.523471|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, (c)TeamSpeak Systems GmbH
2010-01-01 21:14:26.524564|INFO |DatabaseQuery | | dbPlugin version: 3.6.21
2010-01-01 21:14:27.660431|INFO |Accounting | | Licensing Information
2010-01-01 21:14:27.664493|INFO |Accounting | | type : Non-profit
2010-01-01 21:14:27.667837|INFO |Accounting | | starting date : Wed Dec 30 16:00:00 2009
2010-01-01 21:14:27.670883|INFO |Accounting | | ending date : Thu Dec 30 16:00:00 2010
2010-01-01 21:14:27.674054|INFO |Accounting | | max virtualservers: 10
2010-01-01 21:14:27.677096|INFO |Accounting | | max slots : 512
2010-01-01 21:14:27.780056|INFO |FileManager | | listening on 0.0.0.0:30033
2010-01-01 21:14:27.990207|INFO |VirtualServer | 1| listening on 0.0.0.0:9987
2010-01-01 21:14:27.995076|INFO |Query | | listening on 0.0.0.0:10011
^C

The next is when I load the ts3server.ini fil

tts@thethreat:~/teamspeak3-server_linux-x86$ ./ts3server_linux_x86 inifile=ts3server
Logging started
2010-01-01 21:14:37.868691|INFO |ServerLibPriv | | Server Version: 3.0.0-beta12 [Build: 9596]
2010-01-01 21:14:37.870603|CRITICAL|DatabaseQuery | | unable to load database plugin library, halting!

And last when I try to load both the ts3server file and the ts3db_mysql files

tts@thethreat:~/teamspeak3-server_linux-x86$ ./ts3server_linux_x86 inifile=ts3server dbplugin=ts3db_mysql
Logging started
2010-01-01 21:14:43.847438|INFO |ServerLibPriv | | Server Version: 3.0.0-beta12 [Build: 9596]
2010-01-01 21:14:43.854698|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
2010-01-01 21:14:43.855800|INFO |DatabaseQuery | | dbPlugin version: 1
2010-01-01 21:14:43.876877|ERROR |DatabaseQuery | | mysql_real_connect() failed with error: Unknown database 'test'
Segmentation fault

I beleive the last option takes me closest to starting the program but i have tryed several different database name and none seem to work
my ini files are as follows

ts3server.ini

machine_id=
default_voice_port=8801
voice_ip=70.74.197.59
licensepath=
filetransfer_port=30033
filetransfer_ip=70.74.197.59
query_port=10011
query_ip=70.74.197.59
dbplugin=ts3db_mysql
dbpluginparameter=
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
logpath=logs
logquerycommands=0
<blank line>

ts3db_mysql

[config]
host=localhost
port=8801
username=tts
password=
database=test
socket=
<blank line>

So is there a database name I should be using or do i need to make a new database name in mysql

[eckart]

maybe it is usefull to write the right name from the inifile to the commandline

./ts3server_linux_x86 inifile=ts3server.ini

[linuxx]

You need to create your database, and the user account. Then use that database in your INI.

Assuming you have mysql on the same box as TS3...

mysql -uroot -p   <<<Login as root>>>
CREATE DATABASE ts3db;
CREATE USER 'ts3dbUser'@'localhost' IDENTIFIED BY 'xPVHFxL7zUnZPReH';  <<<Make up your own password>>>
GRANT ALL PRIVILEGES ON `ts3db` . * TO 'ts3dbUser'@'localhost';

Then your ts3db_mysql.ini should be...

[config]
host=localhost
port=3306
username=ts3dbUser
password=xPVHFxL7zUnZPReH
database=ts3db
socket=

Linuxx

[yomega]

I solved it first i had to delete the ts3server.ini file and have the program remake it with the command

./ts3server_linux_x86 createinifile=1

then I used vim to add my ip address to the file and the command

./ts3server_linux_x86 inifile=ts3server.ini

and it worked