TS2 MySql 4 with 3.x dll

[runner23]

Ok this is getting really annoying.

I know I have the correct info in the server.ini file because if I set my forum to slave to the DB using the TS info it works. Yet all I can get out of TS is

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

DB Info

[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=mytestdb
Hostname=localhost:43306
User_name=test
Password=6589
GetDriverFunc=getSQLDriverMYSQL
VendorLib=libmysql.dll
LibraryName=dbexpmysql.dll
Active=1

Yes I have the 3.x dll in the ts2 folder. Yes I've tried old style hash login for compatibility didn't help. I'm not about to install any other version of MySql because I'm slaving db functions to have a real time backup of my vBulletin forum.

Is there a specific version dll that I need.

[runner23]

Ok for what ever reason having a password on the DB causes this whole issue. You obviously need better MySql support with version 3 or were in trouble.

But the installer I have seems to be missing quite a few .sql files to complete the setup under mysql. Downloading from the other mirror to see if its got the correct files in it.

Heres the server.ini

[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL
[Main Config]
ExternalIPDectection=1
HTTPServer Port=14534
HTTPServer Enabled=1
DateTimeFormat=dd-mm-yyyy hh:nn:ss
TCPQueryPort=51234
AllowedClientNameChars=
DisAllowedClientNameChars=()[]{}
BoundToIp1=
[WebPost]
AdminEmail=na
ISPLinkURL=na
ISPName=Private
ISPCountryNumber=0
Enabled=1
PostURL=
ListPublic=1
UserAgent=teamspeak
[log]
access_r=1
access_u=1
channel_registerred=1
channel_unregisterred=1
sa=1
chat=1
kick_server=1
kick_channel=1
[Spam]
max_commands=10
in_seconds=2
[DBEXPRESS]
sqldir=C:\Program Files\Teamspeak2_RC2ser\mysql_sql\
Drivername=mysql
Database=ts
Hostname=127.0.0.1
User_name=tsclient
Password=
GetDriverFunc=getSQLDriverMYSQL
VendorLib=libmySQL.dll
LibraryName=dbexpmysql.dll
Active=1

Heres the error log

03-10-06 03:42:52,ALL,Info,server,	Server init initialized
03-10-06 03:42:52,ALL,Info,server,	Server version: 2.0.20.1 Win32
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\read_servers.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\new_server.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\read_server_privilege.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\new_server_privilege.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\read_server_privilege.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\new_server_privilege.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\read_server_privilege.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\new_server_privilege.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\read_server_privilege.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\new_server_privilege.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\read_server_privilege.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\new_server_privilege.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\read_server_privilege.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\new_server_privilege.sql
03-10-06 03:42:52,ALL,Info,server,	Starting VirtualServer id:0 with port:8767
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\edit_server.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\read_channels.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\new_channel.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\read_bans.sql
03-10-06 03:42:52,WARNING,Info,SERVER,	Default VirtualServer created
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\read_clients_name.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\new_client.sql
03-10-06 03:42:52,WARNING,Info,SERVER,	admin account info: username: admin password: 8dyo2o
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\read_clients_name.sql
03-10-06 03:42:52,ERROR,All,SQL,	SQL file not found C:\Program Files\Teamspeak2_RC2ser\mysql_sql\new_client.sql
03-10-06 03:42:52,WARNING,Info,SERVER,	superadmin account info: username: superadmin password: yfwdya
03-10-06 03:42:52,ALL,Info,server,	Server init finished

Now looking though the directory structor the sqlite_sql has quite a few of the mentioned files. Course trying to use them just crashes the ts server.

Anyone have the missing SQL files???

[Reedy Boy]

I found it easiest just to download the Linux version and copy the mysql_sql folder into your team speak directory

There are some changes you have to make to some of the files

Or, use The Attachment at the end of the post

That is the uploaded version of mine that work


As for the DLL's

Ive recently just worked it out for someone else using various threads

Download and install http://crlab.com/dbx/dbxmda.exe

Get the dbexpmda.dll out of the directory, and stick it in the TS directory, also, putting the libmysql.dll is worth it (Download a new version or copy it from a MySQL Dir!) - It makes like a bit easier

Change the reference under library name to dbexpmda.dll and change GetDriverFunc to getSQLDriverMySQLDirect

Then

You need to change your config to

As Per Below

[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=mytestdb
Hostname=localhost:43306
User_name=test
Password=6589
GetDriverFunc=getSQLDriverMySQLDirect
VendorLib=libmysql.dll
LibraryName=dbexpmda.dll
Active=1

Hope this helps



Notes from where i've posted it before: http://forum.goteamspeak.com/showthread.php?t=33504




Sam




Edit: Oh, and that works with passwords

[runner23]

I found it easiest just to download the Linux version and copy the mysql_sql folder into your team speak directory

Tried that got a function not allowed error and hung TS server.

Will try your process to see if I can get it working.

Thanks

[runner23]

Alright I know have a successful DB connection.

Now need to connect my TS to a remote db and were good.

Thanks for the links and info. It was very helpful. This info really needs to be added to the MySql 4.x stickie and the stickie pruned.

[Reedy Boy]

No Problems

If i can help, feel free to ask



Sam