PDA

View Full Version : Teamspeak Server with MySQL 5.0!!


sulcorp
09-08-2006, 23:21
This is where we all been waiting for!! ;)
AND HERE IT IS!!!! :eek: :D

Ok i'll tell ya what i did.
For me it worked at once! (also unbelievble)

I started with the installation of MySQL Server 5.0
Ran through the whole instance configuration.
I selected Latin as default language.
!! only use letters and numbers in password for root !!

Than i installed the MySQL Administrator (wich is a free tool that can be found at MySQL website)
I changed a few things at the startup variables.
Got to the security tab there and select "Safe User Create" and "Use Old Passwords".
I aplyed the settings and rebooted the server.

Now it was rebooted i started the MySQL administrator again and made the user "Teamspeak" (this can be changed offcourse).
After that i made an catalog for TS. went back to the user and assigned him ALL rights to the TS catalog.

Now your gonna install TS Server.
after you've done that go to the server.ini and add this at the bottum:

[DBEXPRESS]
sqldir=mysql_sql\
Drivername=mysql
Database=TeamspeakDatabase
Hostname=localhost
User_name=TeamspeakUsername
Password=TeampspeakUserPassword
GetDriverFunc=getSQLDriverMYSQL
VendorLib=libmySQL.dll
LibraryName=dbexpmysql.dll
Active=1

We still gonna need the libmySQL.dll from MySQL 3.23.58
This can be found in another topic ->here (http://forum.goteamspeak.com/showthread.php?t=25224&page=3).

Place it in the Teamspeak server root.

Now start the server for the first time.
Now you'll see the start passwords for admin and superadmin.

We're gonna convert the server.dbs to .SQL file now using the converter (wich also is somewhere on this site - admin where?- )

Now open the sql file and remove the first line and the last. (wich are infact 2 words)

Now ya need to import the SQL file in MySQL server.

(almost certain you have to edit some things in the SQL file. These will speak fo themselves.)
I advise to use PhpMyadmin for importing.

Done that?
Than your finished!!

(might get updated with more info)
Question just ask: Blitzer@sul-oss.org

Katana*GFR*
10-08-2006, 07:50
Nice find dude, great job!!

sulcorp
13-08-2006, 22:19
Pin this topic man.

howndawg
06-09-2006, 09:43
I am experiencing problems with this, here is my log file:

---------------------------------------------------------------
-------------- log started at 06-09-06 02:42 -------------
---------------------------------------------------------------
06-09-06 02:42:56,ALL,Info,server, Server init initialized
06-09-06 02:42:56,ALL,Info,server, Server version: 2.0.20.1 Win32
06-09-06 02:42:56,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
06-09-06 02:42:56,ERROR,All,SERVER, Start_Server: unable to open database
06-09-06 02:42:56,ERROR,All,GENERAL, critical error, shutdown initiated

Yet my username, database, and everything is correct..

howndawg
09-09-2006, 10:45
I got it working now.

Do you have any idea how to add ip's for allowed remote access?

Patchank
09-09-2006, 11:12
remote acces to sql database ?

howndawg
09-09-2006, 19:11
well i am using vBulletin, and i have vbTeamspeak, and i need my webhost to access the database. and its not working, so dont i need to add my webhosts ip to the server?

Patchank
09-09-2006, 19:38
thought VbTeamSpeak needed the server to be hosted with the server (same host, same db)

howndawg
10-09-2006, 06:25
it has a feature for remote database connection.

but for teamspeak, could i have TS hosted on a windows, connect to a database hosted on linux?

Bastian
14-09-2006, 09:09
As mySQL is platform independant, this should work flawlessly.

lissandro
09-01-2007, 17:59
Is anyone can atach the files of the converter? The related topic whose someone did it does not work anymore : (

Other thing, i have the database the user and now i need the converter to change the dbs to a sql file, with this done can i import this same file to the test squeme and my server will run with the mysql?

ANR Daemon
12-01-2007, 04:22
http://forum.goteamspeak.com/showthread.php?t=25224

2Mods: Please close this topic.

Gatts
19-08-2007, 20:12
Anyone have the server.dbs to .SQL converter as the link in the mysql 4.x guide is broken.

BHKai
19-08-2007, 21:02
Anyone have the server.dbs to .SQL converter as the link in the mysql 4.x guide is broken.
http://www.planetteamspeak.com/component/option,com_docman/task,doc_details/gid,31/Itemid,70/