[dooch]

Originally Posted by Logo

i have the same problem.... anyone can help us ?

yes i have the same problem....

EDIT

Ok im getting to grips with this, its a nightmare to get going but the mysql errors are due to my webhost not allowing connection to the remote mysql server which TS is on.

My TS is on windows, my webhost is Linux so problems...

EDIT

One major problem which was giving me the mysql errors was "root" only had local host connections allowed!

So nearly there!!!!!

EDIT

Ok after wasting a day on this i still have a problem

I can register ONE person using this sytem, anymore and I get this error

Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO ts.ts2_clients SET i_client_server_id = '1', b_client_privilege_serveradmin = '-1', s_client_name = 'admin.2', s_client_password='whatever', dt_client_created='03012007003238000';

MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Wednesday, January 3rd 2007 @ 12:32:38 AM
Script : http://www.xxxxxxxx/forum/vbteamspeak.php
Referrer : http://www.xxxxxxx/forum/vbteamspeak.php
IP Address : xxxxxxx.251
Username : admin
Classname : vb_database

Any ideas??

Many Thanks!

EDIT

SOLUTION - GOT IT WORKING

Ok for the ppl out there that are trying to get this working with a LINUX webserver "virtual" host and a M$ dedicated box with TS here's how.

Delete all previous TS and start a fresh install of TS.
Run TS, make a note of the new SA and A passwords.
Close TS.
Add the two attached files to the TS directory (libmysql.dll and dbexpmda.dll)
Edit the server ini and add the following to the the bottom

[DBEXPRESS]
sqldir=mysql_sql\
Drivername=mysql
Database=yourdatabasename
Hostname=localhost
User_name=root
Password=yourpasswordhere
GetDriverFunc=getSQLDriverMySQL
VendorLib=libmysql.dll
LibraryName=dbexpmda.dll
Active=1

Then copy all the files from sqlite_sql to mysql_sql. When it says overwrite say NO, so its just the new files.

There is a handy program found on the goteamspeak forums to check your connection settings to the database. I used this program to add a few more users to check it was working. Refer to your mysql db to see if theyre being added.

If youre using xampp for the local mysql databse ensure root has all priv's and NOT just on local, change it to %.

Launch TS and check the server log to look for any errors. It should come back fine.

Then install the product etc.

Ensure you complete the options and the advanced options.

Job done.

This has taken me some serious handbanging but its an excellent product so was worth the headache and the 600 cigs i smoked!

INSTALLED

THANKS