PDA

View Full Version : TS starts but does not edit DB.


Quinntum
08-08-2007, 16:35
Hello Everyone,

Ok I'm at a sticking point here.

Server info
CentOS 4.5
MySQL5 (local or on a different server)
TS version: ts2_server_rc2_202319.tar.bz2
Fresh DB, and TS

Server.ini info
[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=TeamSpeak
Hostname=localhost (depending if trying on local server or a different server)
User_name=xxxxxxxxx
Password=xxxxxxxx
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/mysql/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1

Log Errors (sorry this is a long one.)
08-08-07 08:25:07,ALL,Info,server, Server init initialized
08-08-07 08:25:07,ALL,Info,server, Server version: 2.0.23.19 Linux
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/read_servers.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/new_server.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
08-08-07 08:25:07,ALL,Info,server, Starting VirtualServer id:0 with port:8767
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/edit_server.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/read_channels.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/new_channel.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/read_bans.sql
08-08-07 08:25:07,ALL,Info,server, Started VirtualServer id:0 with port:8767
08-08-07 08:25:07,WARNING,Info,SERVER, Default VirtualServer created
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/read_clients_name.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/new_client.sql
08-08-07 08:25:07,WARNING,Info,SERVER, admin account info: username: admin password: 3g5ul4
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/read_clients_name.sql
08-08-07 08:25:07,ERROR,All,SQL, SQL file not found mysql_sql/new_client.sql
08-08-07 08:25:07,WARNING,Info,SERVER, superadmin account info: username: superadmin password: ycbzp4
08-08-07 08:25:08,ALL,Info,server, Server init finished
08-08-07 08:25:08,WARNING,Info,server, TeamSpeak Server daemon activated


Also everytime the server starts I get a different admin/superadmin pw. so its almost like its not creating it. BUT... the tables are created.. gggggrrrrrr

Ok, at this time when I try to connect to the server with Superadmin/admin I get login failed. When I check the DB tables, there is no info that has been created with in the tables. But the tables are there. Ts2_bans, ts2_channels, ts2_channel_privileges, ts2_clients, ts2_servers, ts2_server_privileges
All have rows 0, data length 0 index length 1kb

Any one have any ideas?

maxi1990
08-08-2007, 16:43
Look in your mysql_sql directory an check whether the files are there.

Quinntum
08-08-2007, 17:03
Look in your mysql_sql directory an check whether the files are there.

Ok this is really really strange. I know I've tested this before and have been banging my head on this one for the past few days.
I copied the scripts over from the sqlite_sql folder into the MySQL folder and it works. I was trying this before with MySQL 4.1.20 on a remote server and this did not work.

Now with a local MySQL 5 server and it works.

Thanks for your time Maxi