Another option for MySQL 4.1

[Cwac]

Ok I was having no luck following the instructions that come with TS server for windows in porting over to MySQL. I was attempting to go to version 4.1. I downloaded a 3.23 dll for the MySQL client, updated my server.ini, but I kept getting an error about 'invalid username and password'. I went out and searched some Delphi forums and found alot of people with the same issue. Many suggested the same fix that the install instructions come with (which again did not help me) but some suggested another driver for dbexpress.

[Edit: price info removed]..However, it is supported, and works out of the box with any version of MySQL 3, 4 or 5! This requires no replacing client dll's for MySQL itself.

I was able to get ported over to MySQL 4.1 in a short time with the trial version of the driver. I have NOT tested this with actual users yet, I have only played around in the admin console, creating servers, changing permissions etc. I will continue to use this, and report back here on my progress for anyone interested.

I will also post installation instructions I created for this in the next post. Please do not blindly try this without backing up everything you have, or expecting this to work perfectly, again I have not really tested it yet

[Edit: explanation of fee] Ok well originally I saw the license fee on the site and assumed it was per seat. It suddenly struck me after writing this post that there was no reasonable way to expect a developer to add $70 to the cost of their product, so I wrote the company and duh, sure enough it is a one time fee to the developer. So if TS pays the $70 once, they can distribute the dll with TS server.... here is the response from crlabs pasted in:

-----------------------------------------------------------
Hello,

Thank you for your inquiry.
Our dbExpress driver for MySQL is licensed per developer-based
and by license agreement registered users can deploy DLLs with created
applications without royalty fee.

If you have any further questions please contact us at sales@crlab.com

Best regards, Janet Bulgakova
Sales and Marketing manager, Core Lab
sales@crlab.com
www.crlab.com

--------------------------------------------------------------

So... um.... TS... hint, hint

[Cwac]

[Edit: price info removed]This option is not yet available for general use, if you want to play around you can download and install a trial version at:

http://www.crlab.com/dbx/download.html

This does not expire, but has limits on the amount of rowsets it will return from a DB. It is sufficient for installing and testing a server, it would not be enough to truly run in a production environment...


prerequisite: Stop TS server.

The application should not be running during this process.


Step 1: Install MySQL

Go to:

http://dev.mysql.com/downloads/

Choose the version and OS you want and download the latest binary release (Windows versions are about half way down the page). After downloading simply launch the installer and follow the instructions. I suggest also choosing the option to install as a windows service.

Step 2: Create a User and DB

If you installed through the wizard it should have given you a root username and password. Log into mysql using this. From a command prompt this is done as:

mysql -u <username> -p<password>

notice the lack of space between -p and password. optionally you can only specify the -p and it will prompt you for a password without local echo for security.
You will now be in mysql, and can create an empty database for teamspeak. Assuming you want to call this database 'teamspeak' you would simply type:

CREATE DATABASE teamspeak;

Next you will probably want a user specifically for this database, rather than using your root user. Suppose you choose your username to be 'tsuser' and your password to be 'tspass' This can be accomplished with:

GRANT ALL ON teamspeak.* to tsuser IDENTIFIED BY 'tspass';


Step 3: Download and install the new dbexpress driver.

Again, this is found at:

http://www.crlab.com/dbx/download.html

You will be choosing the 'dbExpress driver for MySQL, Windows version...' link. This comes with an installer, simply run it. I changed the install directory to be a new subdirectory of TS, it doesn't really matter where you put it however.


Step 4: Configure Teamspeak

Now Teamspeak needs to be configured to use both the new driver, and the new database you created. Open your server.ini file in your main Teamspeak directory and add the following to the end of the file:

[----- copy below this line ---------]
[DBEXPRESS]
sqldir=mysql_sql/
Drivername=MySQL Direct (Core Lab)
Database=teamspeak
Hostname=localhost
User_name=tsuser
Password=tspass
GetDriverFunc=getSQLDriverMySQLDirect
VendorLib=libmySQL.dll
LibraryName=dbexpmda.dll
Active=1
[----- copy above this line ---------]

This assumes you used 'teamspeak' as the database name, 'tsuser' and 'tspass' as the username and password. Modify these values as neccessary.

The other important thing you need to do is take the sql text files that were used for the default SQLite DB in the sql_sqlite/ directory and put them in the mysql_sql/ directory. This directory by default only has the files neccessary to create the initial tables and values in MySQL. Keep in mind these core files exist in both directories, and you DO NOT want to overwrite the mysql versions when you copy and paste. The quick and dirty way is to go into the sql_sqlite directory, select all, copy, go into the sql_mysql directory and paste. When prompted to overwrite always choose NO.

Step 5: Start Teamspeak

It is assumed at this point that MySQL is running (which can be checked in the services tab if it is a service, or task manager if it is not). In the TS install directory double click on

server_windows.exe

It should take a moment to start as it creates all of the tables it needs and populates them. If there are any issues or it does not start, some cryptic messages will be outputted to the server.log file.

Good luck!

[DOMINATION]

How to Install MySQL correctly and setup TS server on it. It is written in very small steps so even a new user can set it up properly. http://forum.goteamspeak.com/showthread.php?t=25224

[DeMiNe0]

I can't get this to work for linux.

[DOMINATION]

The options on mine are for windows

[Rooter]

I can't get this to work for linux.

dbExpress Trial limitations

Windows DbxMda trial version can be used within 30 days starting from the moment of installation.

Linux Trial version of the driver is limited by number of the returned table columns. DbxMda trial version returns cursors with maximum 6 columns. Extra select-list columns are truncated.

This is why you are experiencing difficulty on Linux.

I went ahead and purchased a license for it a few months ago because of this very issue.