How to Install TS & MySQL 4 Properly

[DOMINATION]

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:

[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.

[DOMINATION]

Will you all make this a pin or make it stay at the top? This is a very valuable post. Thanks

[DOMINATION]

If somebody could translate this to German such as an admin or something then we could post in the German Windows Server forum as well. If you could send me this in german then I can post it up there. Thanks.

[muffin]

After carefully following the directions, I've noticed that the services won't start the MySQL however it is set to manual. Also, upon completing this tutorial, the TS server starts and closes immediately... any idea?


24-08-05 03:43:42,ALL,Info,server, Server init initialized
24-08-05 03:43:42,ALL,Info,server, Server version: 2.0.20.1 Win32
24-08-05 03:43:42,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
24-08-05 03:43:42,ERROR,All,SERVER, Start_Server: unable to open database
24-08-05 03:43:42,ERROR,All,GENERAL, critical error, shutdown initiated

[DOMINATION]

After carefully following the directions, I've noticed that the services won't start the MySQL however it is set to manual. Also, upon completing this tutorial, the TS server starts and closes immediately... any idea?


24-08-05 03:43:42,ALL,Info,server, Server init initialized
24-08-05 03:43:42,ALL,Info,server, Server version: 2.0.20.1 Win32
24-08-05 03:43:42,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
24-08-05 03:43:42,ERROR,All,SERVER, Start_Server: unable to open database
24-08-05 03:43:42,ERROR,All,GENERAL, critical error, shutdown initiated

The log shows that it did in fact find your database but the user/pass of the database was denied. Check and make sure you have these correct.

[muffin]

Thanks for the reply.

Last problem: I found my ip and port to use. I see the server is up and running. I can't connect as it says theres no reply from the server.


Is this my firewall responding?

[DOMINATION]

If you are running the server off your own machine you must connect to it like this: localhost:8767 instead of your IP. Other people will be able to conect through your IP though. If you would like, give me the IP in a Private message and I will try to connect.

[muffin]

Hmm, I am able to connect to my TS server however no1 else seems to be able to. I've added you to my msn contact list just waiting for you to accept me ^^


I'll send you a PM with my email so we can try to figure this out better =/

[DOMINATION]

I didnt receive your MSN request. I sent you a PM here in the forums

[upload]

it works for me but now i have a database without any user accounts(accept admin and superadmin), is there a way to get the sqlite DB file information into the mysql DB. so that all the user do not have to register again?

[DOMINATION]

http://forum.goteamspeak.com/showthr...t+sqlite+mysql

[upload]

http://forum.goteamspeak.com/showthr...t+sqlite+mysql

works perfectly, now i have a ohter question, i have 3 TS servers on 3 ip's. i would like to use 1 mysql database with the all information for the 3 server, i gues i have to change the sql files a bit to get it working does anybody has an idea?

i now that XCH uses something like this, they have multiple ts servers and you always login with ts2.xch.nl and username and password.

[cRaZyByTe]

Just change the table-names in the .sql files. I didn't tried this, but it should work.

[Marik]

what's MySQL?

[DOMINATION]

what's MySQL?

You kidding? Hope so. If your not, its a db server which can handle more queries faster and can handle a much larger load than sqlite.

Enjoy.