Mysql Oddity question regarding remote DB

[RikardF]

Hi i have a question about the mysql support.

I have my TS installed on Win machine and succeded to let it interact with a MYSQL DB placed on a remote server.

Reason is simple i want as much juice free from the TS server and be able to create a php form for Web admin the server settings direcly to the MYSQL.

Now. it seems the TS need a direct local access to the .sql files ?

Correct me if i'am wrong but it logs in nicely to my remote mysql but then yells about it cant gain access to the .sql here is a snippet from the log:


I installed the DLL needed for the mysql and it logs in fine to the mysql (Checked my logs )
---------------------------------------------------------------
-------------- log started at 02-06-04 17:27 -------------
---------------------------------------------------------------
02-06-04 17:27:10,ALL,Info,server, Server init initialized
02-06-04 17:27:10,ALL,Info,server, Server version: 2.0.20.1 Win32
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_read_servers.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_new_server.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_read_server_privilege.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_new_server_privilege.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_read_server_privilege.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_new_server_privilege.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_read_server_privilege.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_new_server_privilege.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_read_server_privilege.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_new_server_privilege.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_read_server_privilege.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_new_server_privilege.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_read_server_privilege.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_new_server_privilege.sql
02-06-04 17:27:10,ALL,Info,server, Starting VirtualServer id:0 with port:8767
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_edit_server.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_read_channels.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_new_channel.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_read_bans.sql
02-06-04 17:27:10,WARNING,Info,SERVER, Default VirtualServer created
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_read_clients_name.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_new_client.sql
02-06-04 17:27:10,WARNING,Info,SERVER, admin account info: username: admin password: farb16
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_read_clients_name.sql
02-06-04 17:27:10,ERROR,All,SQL, SQL file not found ts2_new_client.sql
02-06-04 17:27:10,WARNING,Info,SERVER, superadmin account info: username: superadmin password: 1jgijo
02-06-04 17:27:11,ALL,Info,server, Server init finished

________________________________________

Also i send my .INI settings:

[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=admin@tgbf.org
ISPLinkURL=na
ISPName=Private
ISPCountryNumber=2457
Enabled=1
PostURL=
ListPublic=1
UserAgent=teamspeak
[log]
access_r=0
access_u=0
channel_registerred=0
channel_unregisterred=0
sa=0
chat=0
kick_server=0
kick_channel=0
[Spam]
max_commands=10
in_seconds=2
[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=xxxxxx
Hostname=xxx.xxx.xxx.xxx
User_name=xxxxxx
Password=xxxxx
GetDriverFunc=getSQLDriverMYSQL
VendorLib=libmysql.dll
LibraryName=dbexpmysql.dll
Active=1


It would be very handy if it would be possible to set and save the mysql on a remote server to free off some memory of the DB and yet use the ones i allready have up .

CHeers

[McAfee]

you need to burrow some files from the sqlite folder.

[Broder]

http://www.teamspeak.org/forums/showthread.php?t=13502

[RikardF]

Basicly u are telling me to put this: "sqldir=C:/Programme/Teamspeak2_RC2_1/mysql_sql/"
and all should be fine . Excellent i will try that right away.

[RikardF]

Worked like a charm Case closed . Thx for the info ....