Results 1 to 6 of 6
Thread: Another option for MySQL 4.1
17-06-2005, 06:57 #1-= TeamSpeak User =-
- Join Date
- May 2005
Another option for MySQL 4.1
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:
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 email@example.com
Best regards, Janet Bulgakova
Sales and Marketing manager, Core Lab
So... um.... TS... hint, hint
Last edited by Cwac; 17-06-2005 at 18:00.
17-06-2005, 07:00 #2-= TeamSpeak User =-
- Join Date
- May 2005
[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:
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
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:
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 ---------]
Drivername=MySQL Direct (Core Lab)
[----- 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
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.
Last edited by Cwac; 17-06-2005 at 18:06.
25-08-2005, 06:37 #3DOMINATION Guest
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
Last edited by DOMINATION; 25-08-2005 at 11:13.
07-09-2005, 22:01 #4-= TeamSpeak Lover =-
- Join Date
- Aug 2003
I can't get this to work for linux.
08-09-2005, 03:35 #5DOMINATION Guest
The options on mine are for windows
04-10-2005, 04:42 #6-= TeamSpeak User =-
Originally Posted by DeMiNe0dbExpress Trial limitations
- Join Date
- Sep 2003
- Houston, Texas, U.S.A.
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.
I went ahead and purchased a license for it a few months ago because of this very issue.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By GhostfromTexas in forum [TeamSpeak 2] General QuestionsReplies: 1Last Post: 03-05-2005, 19:34
By Yahman in forum [TeamSpeak 2] General QuestionsReplies: 0Last Post: 13-09-2004, 01:50
By Ook in forum [TeamSpeak 2] General QuestionsReplies: 6Last Post: 02-06-2003, 11:45
By SirEd in forum [TeamSpeak 2] General QuestionsReplies: 4Last Post: 25-10-2002, 23:36