Results 1 to 3 of 3
27-08-2006, 00:51 #1-= TeamSpeak Lover =-
- Join Date
- Dec 2005
TeamSpeak 2.x with MySQL 5.x - Tutorial
OK this Field is very very random, and there have been lots of how-to's
However, none of them seem to be working, and any links they have are broken
This is the way I set it up, it may or may not work for you
(these steps are easiest in phpmyadmin btw)
1. In mysql 5, make a new database (named, for EG teamspeak)
2. Make a user, and give it a password
3. Grant that user full privileges over the database you just made
4. Now, you want to download the "MySQL-shared-compat"
Either Google for that (if this link dies) or you can get it from here
5. Install that binary
6. Now you can either read INSTALL.mysql or just follow what i say
Basically, at the end of server.ini add
[DBEXPRESS] sqldir=mysql_sql/ Drivername=mysql Database=*database Name* Hostname=localhost (or wherever the sql server is) User_name=*Username* Password=*Password* GetDriverFunc=getSQLDriverMYSQL VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0 LibraryName=./libsqlmy.so Active=1
It should launch OK, check your server.log for any errors
8. Now we have to fix the SQL files
http://forum.goteamspeak.com/showthread.php?t=26982 tells you how to do this
9. If you already have servers setup, and want to move them, this is the fun part
(this step is easiest run under windows)
go to http://forum.goteamspeak.com/showpos...57&postcount=3 and download the attached file
extract said file
Copy your server.dbs into the folder you extracted those files to, and run "run.bat"
you will now have a file called "dbdump.sql" - open it in word pad/notepad (or your preferred text editor)
Now delete the first line "BEGIN TRANSACTION;" (i had to do this, you may not)
you may also want to add "auto_increment" after each "primary key"
Under each "CREATE TABLE" (this was mentioned on the forums, I'm not sure if not having auto_increment will break the server, but i haven't thoroughly test with/without it)
10. After all that, you need to get that SQL file into your database (easily done with PHPMyAdmin)
If you ran your server before, delete all the tables before importing the SQL file, otherwise it wont work (the file lacks drop if exists)
11. Start your server, and you are done
Encrypting your passwords
Go to http://forum.goteamspeak.com/showthread.php?t=12365
post #5 and #7 are the ones you want
Also note, if you do this, you need to apply the same fix from step #8
I hope this helps some people out, as there are many problems in doing this
Also, this works with MySQL 5.x - and i would expect the compat file will also work with PHP 4.x - however i havent tested it
14-09-2006, 15:19 #2-= TeamSpeak User =-
- Join Date
- Sep 2006
- Budapest, Hungary
I have a lil problem with ts2 and mysql 5. I have the new teamspeak 184.108.40.206BETA, but I also tried the 220.127.116.11, on an Ubuntu 6.06.2 Server with Mysql 5.0.22 on it. I installed mysql with apt-get.
My problem is that when I started TS and I whatched the log file...
--------------------------------------------------------------- -------------- log started at 14-09-06 16.03 ------------- --------------------------------------------------------------- 14-09-06 16.03.07,ALL,Info,server, Server init initialized 14-09-06 16.03.07,ALL,Info,server, Server version: 18.104.22.168 Linux 14-09-06 16.03.07,WARNING,Info,SQL, created table ts2_servers 14-09-06 16.03.07,WARNING,Info,SQL, created table ts2_server_privileges 14-09-06 16.03.07,WARNING,Info,SQL, created table ts2_channels 14-09-06 16.03.07,WARNING,Info,SQL, created table ts2_channel_privileges 14-09-06 16.03.07,WARNING,Info,SQL, created table ts2_clients 14-09-06 16.03.07,WARNING,Info,SQL, created table ts2_bans 14-09-06 16.03.08,ALL,Info,server, Starting VirtualServer id:1 with port:8$ 14-09-06 16.03.08,ALL,Info,server, Started VirtualServer id:1 with port:87$ 14-09-06 16.03.08,WARNING,Info,SERVER, Default VirtualServer created 14-09-06 16.03.08,WARNING,Info,SERVER, admin account info: username: admin pas$ 14-09-06 16.03.08,WARNING,Info,SERVER, superadmin account info: username: supe$ 14-09-06 16.03.12,ALL,Info,server, Server init finished 14-09-06 16.03.12,WARNING,Info,server, TeamSpeak Server daemon activated
mysql> use teamspeak; Database changed mysql> show tables; Empty set (0.00 sec) mysql>
[Dbexpress] sqldir=/opt/tss2_rc2/mysql_sql/ Drivername=mysql Database=teamspeak Hostname=127.0.0.1 (also tried localhost) User_name=******** Password=******* GetDriverFunc=getSQLDriverMYSQL VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0 LibraryName=/opt/tss2_rc2/libsqlmy.so Active=1
I read many topics in the forum and other webpage forums but nothing.
Anybody has any advice?
14-09-2006, 20:09 #3-= TeamSpeak Lover =-
- Join Date
- Dec 2005
are you sure you installed the compatibility thing properly ?
thats the only thing i can think of, teamspeak sends the data to your compatability file, but that doesnt save it to the database, and it loses the data
Perhaps try to look at some logs for SQL, or try using the compat package i linked to
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By TS-Rent in forum [TeamSpeak 2] Server SupportReplies: 26Last Post: 27-09-2006, 18:43
By mcurge in forum [TeamSpeak 2] Server SupportReplies: 1Last Post: 14-03-2006, 14:50
By AnuBis in forum [TeamSpeak 2] General QuestionsReplies: 7Last Post: 02-02-2006, 00:53
By Butterbroetchen in forum [TeamSpeak 2] Server SupportReplies: 0Last Post: 09-09-2005, 12:54