I am making this thread because it took me forever to figure out how to make MySQL 4.0.25 work with TS. After searching the forums, I still really didn't come to an answer which suited my install. So this is a walkthrough for installing TS Server and MySQL 4.0.25 properly.
Install is on Windows Server 2003 (Will also work with 2000 and XP).
Files to Download:
-----------------------------------------------------------------
You need to download the Teamspeak Server:
ftp://ftp.freenet.de/pub/4players/te..._rc2_20201.exe
And
You need to Download MySQL 4.0.25:
http://www.completecreations.com/goteamspeak/mysql4.zip
-----------------------------------------------------------------
*******SKIP THIS IF YOU DOWNLOADED FILES ABOVE*******
If you downloaded the files above then ignore the following link.
If you need the proper mysql 3.x library dll (libmySQL.dll) ONLY click the link below:
http://www.completecreations.com/goteamspeak/lib.zip
************************************************
1. Install the Teamspeak Server
2. Run the server, this will create the server.ini file to be edited later
3. Close the server (Right click on icon in system tray)
4. Unzip and Install MySql 4.0.25 (Setup.exe)
5. Open Command Prompt (Start Menu ---> Run)
Type: cmd then press enter
Command Prompt will open....... Type the following in command prompt:
C:\mysql\bin\mysqld.exe --install (C:\mysql is the directory to mysql)
This installs MySql Server as a Windows Service
Close command Prompt
6. Open Control Panel ---> Administrative Tools ---> Services
7. Find the service named MySQL, Right Click it and click Start
Now Mysql is running
8. Open Command Prompt Again (Start --> Run --> cmd)
9. Type C:\mysql\bin\mysqladmin.exe -u root CREATE ts (C:\mysql is the directory to mysql)
This creates a database called ts
Type C:\mysql\bin\mysqladmin.exe -u root password new_password (C:\mysql is the directory to mysql)
This puts a password on your root account for MySQL.
Close Command Prompt
Your MySql Databse is setup and ready to go.
10. Open Teamspeak Directory
In the mysql4.zip file you downloaded there was a folder called:
MySQL 3.x Library dll
That folder contains a file in it called: libmySQL.dll
Take the file libmySQL.dll and move it to your teamspeak directory
This is the mysql 3.x Library you hear so much about.
(People who want just the library can download it from
http://www.completecreations.com/goteamspeak/lib.zip
11. Open the file server.ini in your teamspeak directory.
At the bottom you need to add the following:
Code:
[DBEXPRESS]
sqldir=mysql_sql\
Drivername=mysql
Database=ts
Hostname=127.0.0.1
User_name=root
Password=new_password
GetDriverFunc=getSQLDriverMYSQL
VendorLib=libmySQL.dll
LibraryName=dbexpmysql.dll
Active=1
12. Save The File and Close it
13. Open the folder sqlite_sql in the teamspeak directory and copy all
the files in it.
14. Open the folder mysql_sql in the teamspeak directory and paste all
the files in the folder. When it ask if you want to overwrite the existing
files, click no
15. Start the teamspeak server and enjoy.
16. If you are behind a firewall open the range of ports you will be using such as 8767 - last port you will be using.
17. If you are behind a router, make sure you forward the ports you will be using to the ip which you have the teamspeak server running under.
Example: Forward ports 8767-9000 to ip 192.168.15.3
*If you do not do this, nobody will be able to connect to your server.
18. To test your teamspeak server locally (same computer), instead of typing your IP address for the Server Address, type localhost:8767
Others can test off your IP as the server address but not you yourself.
Have any question then let me know, if this helped you, let me know also.
English
German
How to Install TS & MySQL 4 Properly
works nice for me :D
what's MySQL?
Linear Mode
