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