MySQL connection works but...

[Rice_klowN]

I'm running TS Server on Windows 2K3 Server and connecting to MySQL 4.0.22 on a remote server running CentOS (Linux)

I don't get any log in errors or anything, but it never writes anything to the mysql server, just tries to access the files as you will see.

I get this error in the logs:

---------------------------------------------------------------
28-05-05 16:43:36,ALL,Info,server,	Server init initialized
28-05-05 16:43:36,ALL,Info,server,	Server version: 2.0.20.1 Win32
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/read_servers.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/new_server.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/read_server_privilege.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/new_server_privilege.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/read_server_privilege.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/new_server_privilege.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/read_server_privilege.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/new_server_privilege.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/read_server_privilege.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/new_server_privilege.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/read_server_privilege.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/new_server_privilege.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/read_server_privilege.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/new_server_privilege.sql
28-05-05 16:43:37,ALL,Info,server,	Starting VirtualServer id:0 with port:8767
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/edit_server.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/read_channels.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/new_channel.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/read_bans.sql
28-05-05 16:43:37,WARNING,Info,SERVER,	Default VirtualServer created
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/read_clients_name.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/new_client.sql
28-05-05 16:43:37,WARNING,Info,SERVER,	admin account info: username: admin password: (edit)
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/read_clients_name.sql
28-05-05 16:43:37,ERROR,All,SQL,	SQL file not found C:/ts2/mysql_sql/new_client.sql
28-05-05 16:43:38,WARNING,Info,SERVER,	superadmin account info: username: superadmin password: (edit)
28-05-05 16:43:38,ALL,Info,server,	Server init finished
28-05-05 16:44:26,ALL,Info,server,	Server shutdown initialized
28-05-05 16:44:26,ERROR,All,frmMain,	unable to detect external ip
28-05-05 16:44:28,ALL,Info,server,	Server shutdown finished
---------------------------------------------------------------

basically, it can't find the sql files... why is it looking for them???

Also, the error that says unable to detect external ip ALWAYS shows up... even when using the std setup with sqllite... even though it works fine if using the std setup.

Server running the TS Server:
Servermatrix Dual Xeon
Win2K3
13 IP addresses

section from server.ini:

[DBEXPRESS]
sqldir=C:/ts2/mysql_sql/
Drivername=mysql
Database=user_ts (edited)
Hostname=(IP Address)
User_name=(username)
Password=(password)
GetDriverFunc=getSQLDriverMySQL
VendorLib=libmysql.dll
LibraryName=dbexpmda.dll
Active=1

Using dbexpmysql.dll produced identical errors. I DO change the GetDriverFunc when using the different dll's

[Rice_klowN]

wait... are those files used by teamspeak as instruction files on using the database... I looked at the files for sqllite and they are sql commands... I'm going to rewrite them for mysql and see if that works.

[Rice_klowN]

Wait... I don't know if this can be done since i don't know how to run multiple queries in one command on a mysql < 4.1 server

Will test and see if I can get it working

[Rice_klowN]

Never dang mind! I'm an idiot.. I just copied all the sql files from the sqllite dir that were missing over to the mysql_sql dir and then edited the create_nicks and create_settings sql file for MySQL and it seems to work fine now. Will post back if I run into a problem

[TeamSpeaker]

I'm having the same problem here. I copied over those files too. Now the log doesn't show them as missing, but the admin and superadmin is not being created in the mysql database. What's going on here and why is it so hard to install with mySQL???


(Windows 2003)