PDA

View Full Version : Teamspeak Server with MySQL 5.0!!


sulcorp
10-08-2006, 00: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, 08:50
Nice find dude, great job!!

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

howndawg
06-09-2006, 10: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, 11:45
I got it working now.

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

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

howndawg
09-09-2006, 20: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, 20:38
thought VbTeamSpeak needed the server to be hosted with the server (same host, same db)

howndawg
10-09-2006, 07: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, 10:09
As mySQL is platform independant, this should work flawlessly.

lissandro
09-01-2007, 18: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, 05:22
http://forum.goteamspeak.com/showthread.php?t=25224

2Mods: Please close this topic.

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

BHKai
19-08-2007, 22: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/

ucntkilme
03-08-2008, 07:02
sulcorp -- very good information here -- hoping you may be able to help me.

Many people using MySQL 5 are using ODBC method which I don't want to do...

Which is why I am very interested in your method.

I followed your instructions to the T -- except that I'm unable to find the dll in the post you gave (i found one but its on an FTP that you need username and password which its not displayed anywhere that i saw)..

basically, I have an already running web server on my local machine for testing purposes. My machine is a Windows XP machine...

Instead of running through the hassle of installing apache, php, mysql, etc I decided to go ahead and use xaamp from apachefriends.org -- much more streamlined installation process and does it all at once.

in PhpMyAdmin, it gives me the following values:
Server version: 5.0.51b-community
MySQL client version: 3.23.49

Which tells me that I am running the library files from 3.23 like is required (im guessing)..

in my server.ini file I've put this:

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

saved everything, restarted my server several times -- spent 4 hours trying to figure it out and never get anything but this:

---------------------------------------------------------------
-------------- log started at 02-08-08 22:54 -------------
---------------------------------------------------------------
02-08-08 22:54:46,ALL,Info,server, Server init initialized
02-08-08 22:54:46,ALL,Info,server, Server version: 2.0.23.19 Win32
02-08-08 22:54:46,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load libmySQL.dll
02-08-08 22:54:46,ERROR,All,SERVER, Start_Server: unable to open database
02-08-08 22:54:46,ERROR,All,GENERAL, critical error, shutdown initiated


Anything you need me to tell you please let me know -- i'm at the end of the rope on this but I need my TS to run on MySQL so i can create a few scripts ;)

Thanks,
-- man who has no hair, but used to.

ANR Daemon
11-08-2008, 18:11
Please do not post in this thread any more.
Keep MySQL related discussion in one thread.
One that pinned.

And to be honest - what you have against using ODBC connector? Rligious prohibitions?

That error you are getting whas the case why ODBC method exists. I was unable to load ANY libMySQL. From a wide range of MySQL distributions.