Remote MySQL Connection

[ADF-Sniper]

Hi All,

Love TS3 BETA

I am trying to move my TS server from sqllite to mysql.

I have used TS3 to create the tables and fields into a localhost mysql DB called "test" and runs fine as "localhost", "root", "NOPASSWORD"

But any other changes other then the abouve that I am using will not work.

I tried creating the following file....t3db_mysql.ini

[config]
host=localhost
port=9988
username=qwerty
password=qwerty
database=testing123
socket=
>BlankLine<

I assume Teamspeak3 automaticly runs the file t3db_mysql.ini as it is not defined in the ts3server.ini file or at command line.

I am sure I am missing something very simple.

Any help would be great help.

Nath

[BaDaSS]

Your using the wrong port, Heres the config.

[config]
host=localhost
port=3306
username=root
password=
database=test
socket=

Did you make a server .ini also?

name = ts3server.ini

machine_id=
default_voice_port=9987
voice_ip=your ip
filetransfer_ip=your ip
query_ip=your ip
filetransfer_port=30033
query_port=10011
licensepath=
dbplugin=ts3db_mysql
dbpluginparameter=/path/to/your/teamspeak3-server/ts3db_mysql.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
logpath=logs
logquerycommands=1

I hope this helps! .

[ANR Daemon]

You do not need to create ini for server.
First, fix your
t3db_mysql.ini

[config]
host=localhost
username=qwerty
password=qwerty
database=testing123

then... just launch server with
dbplugin=ts3db_mysql
and enjoy your MySQL based toy.

(Just curious, why every monkey tell people to do random things they don't need to do?)

[ADF-Sniper]

lol.....

Thank for the replys anyway.... I still cant find the solution, I can put dummy SQL details in the config file and still will not even give me a error creating or log into SQL.

Here is what I do....

I have a Dedicated server with all ports open and dedicated IP's.
I have a clean install of the server files.
I have my licensekey.dat in the main directory.
I have created the file "ts3server.ini"

machine_id=
default_voice_port=9988
voice_ip=118.127.10.168
filetransfer_ip=118.127.10.168
query_ip=118.127.10.168
filetransfer_port=30033
query_port=10011
licensepath=
dbplugin=ts3db_mysql
dbpluginparameter=ts3db_mysql.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
logpath=logs
logquerycommands=1

I have created the file "t3db_mysql.ini"

[config]
host=localhost
port=What ever port
username=aaaaaaaa
password=aaaaaaaa
database=aaaaaaaa
socket=

I have a aaa.bat file with the shell command...

ts3server_win32.exe inifile=ts3server dbplugin=ts3db_mysql

Still it persists to use the local DB "test" , "root" , "NoPassword" even when dummy details have been given.

I am not sure if t3db_mysql.ini is being called properly.

Nath

EDIT: I am currently running a server on port 9987.... hmmmm

[BaDaSS]

Change the default port in the .ini back to 9987, You can change the port later.

Make sure the dbpluginparameter=ts3db_mysql.ini is correct. Example: dbpluginparameter=/where/ever/teamspeak3-server_win32/ts3db_mysql.ini

aaa.bat file should look like this:

ts3server_win32.exe dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/ Do not include "inifile=ts3server"

Give that a try, But what do I know . . . I'm just a monkey!

[ANR Daemon]

Do you ever read what people write?
Delete ts3server.ini
Make t3db_mysql.ini as I said.

Rule of dumb: give only required information to a program. And never ever give empty parameters, unless you sure know they are required to be there and empty.

[ADF-Sniper]

I have spent a fair few hours on this and still no go. TS3 still wants to point to its default SQL details.

I doubt that its anything to do with the ini files.

Do we know that remote SQL connections acully work or even a localhost connection with different login, DB, and password?

I would put it down to this line not working.
dbpluginparameter=ts3db_mysql.ini

Nath

[BaDaSS]

I would put it down to this line not working.
dbpluginparameter=ts3db_mysql.ini

Nath

Your right. Where is the main folder? /usr/home/?

That line should look something like this:

dbpluginparameter=/usr/home/teamspeak3-server_win32/ts3db_mysql.ini

[ANR Daemon]

That line should not exist at all.

[ADF-Sniper]

I have now got it all running.... so happy...

For anyone else that may have problems ill put down each step I have taken. Note I renamed the two ini files to make things simple.

Create a batch file called "DBInstall.bat" edit and paste the following line.

ts3server_win32.exe inifile=ts3server.ini dbsqlcreatepath=create_mysql\

Create a batch file called "RunServer.bat" edit and paste the following line.

ts3server_win32.exe inifile=ts3server.ini

Now edit "ts3server.ini" Should look something like below with your servers IP

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

Now edit "ts3db_mysql.ini" Should look something like below with your MySql connection details.

[config]
host=clanhost.com.au
port=3306
username=clanhost_TS3DB
password=mysecretpassword
database=clanhost_TSClanhost

Now copy the licence file that Triton CI & Associates gave you into the main directory where your ts3server_win32.exe resides

Now the best bit.

1. Run DBInstall.bat and check your log file for any errors.... Should say DB Created.

2. Run RunServer.bat and all should be goood


Hope this helps somone
Nathum


My problem was... I was missing the line

inifile=ts3server.ini

When I was creating my DB and Running my Server.