MySQL startup error: SQL files not found

[winetown]

Hi to all, i'm new here.

Until yesterday i was able to start, run and stop server using mysql database.

Today, at startup, i have the following error:

---------------------------------------------------------------
-------------- log started at 21-10-05 09:59 -------------
---------------------------------------------------------------
21-10-05 09:59:47,ALL,Info,server,      Server init initialized
21-10-05 09:59:47,ALL,Info,server,      Server version: 2.0.20.1 Linux
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/read_servers.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/new_server.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/read_server_privilege.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/new_server_privilege.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/read_server_privilege.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/new_server_privilege.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/read_server_privilege.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/new_server_privilege.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/read_server_privilege.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/new_server_privilege.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/read_server_privilege.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/new_server_privilege.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/read_server_privilege.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/new_server_privilege.sql
21-10-05 09:59:47,ALL,Info,server,      Starting VirtualServer id:0 with port:8767
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/edit_server.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/read_bans.sql
21-10-05 09:59:47,WARNING,Info,SERVER,  Default VirtualServer created
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/read_clients_name.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/new_client.sql
21-10-05 09:59:47,WARNING,Info,SERVER,  admin account info: username: admin password: u2uleq
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/read_clients_name.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/new_client.sql
21-10-05 09:59:47,WARNING,Info,SERVER,  superadmin account info: username: superadmin password: gt2pn7
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/read_channels.sql
21-10-05 09:59:47,ERROR,All,SQL,        SQL file not found mysql_sql/new_channel.sql

Note that the server starts, but each time it changes admin and superadmin passwords, because (i think), it uses sqlite instead of mysql db.

How can i return to use mysql?

[winetown]

More usefull info:

I'm using MySQL 4.0.25 on a fedora 4 machine.

This is mysql section in server.ini file:

DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=xx
Hostname=localhost
User_name=xxxx
Password=xxxxx
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/mysql/libmysqlclient_r.so.10.0.0
LibraryName=/usr/src/tss2_rc2/libsqlmy.so
Active=1

[marcelrx]

More usefull info:

I'm using MySQL 4.0.25 on a fedora 4 machine.

This is mysql section in server.ini file:

DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=xx
Hostname=localhost
User_name=xxxx
Password=xxxxx
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/mysql/libmysqlclient_r.so.10.0.0
LibraryName=/usr/src/tss2_rc2/libsqlmy.so
Active=1

Sure you have a folder "mysql_sql" in your teamspeak directory?

[winetown]

yes it is the directory that contains the mysql database structure. There is an other one for the sqllite db (called 'sqlite_sql'). They contain the same sql files (the same file's name) but they have differents contents.

[marcelrx]

yes it is the directory that contains the mysql database structure. There is an other one for the sqllite db (called 'sqlite_sql'). They contain the same sql files (the same file's name) but they have differents contents.

Yes thats ok. Has the user that start ts the rights to read the "mysql" folder?
Maybe chmod 777 the directory

[winetown]

I usualy start the server as root.
However i see a strange user for the TS server directory and sub-directory. It's "users" and it is not registered in my system

[root@localhost ~]# ll /usr/src/tss2_rc2/mysql_sql/
totale 188
-rw-r--r--  1 1000 users  319  9 mar  2004 create_bans.sql
-rw-r--r--  1 1000 users  381  9 mar  2004 create_channel_privileges.sql
-rw-r--r--  1 1000 users  722  9 mar  2004 create_channels.sql
-rw-r--r--  1 1000 users  416  9 mar  2004 create_clients.sql
-rw-r--r--  1 1000 users  143  9 mar  2004 create_nicks.sql
-rw-r--r--  1 1000 users 3431 19 ott 10:12 create_server_privileges.sql
-rw-r--r--  1 1000 users 1377  9 mar  2004 create_servers.sql
-rw-r--r--  1 1000 users  192  9 mar  2004 create_settings.sql
-rw-r--r--  1 1000 users   77  9 mar  2004 delete_ban_ip.sql
-rw-r--r--  1 1000 users   80  9 mar  2004 delete_ban.sql
-rw-r--r--  1 1000 users  135  9 mar  2004 delete_channel_privilege.sql
-rw-r--r--  1 1000 users  201  9 mar  2004 delete_channel.sql
-rw-r--r--  1 1000 users  193  9 mar  2004 delete_client.sql
-rw-r--r--  1 1000 users  310  9 mar  2004 delete_server.sql
-rw-r--r--  1 1000 users  233  9 mar  2004 edit_channel_privilege.sql
-rw-r--r--  1 1000 users  455  9 mar  2004 edit_channel.sql
-rw-r--r--  1 1000 users  114  9 mar  2004 edit_client_lastonline.sql
-rw-r--r--  1 1000 users  186  9 mar  2004 edit_client.sql
-rw-r--r--  1 1000 users 3447  9 mar  2004 edit_server_privilege.sql
-rw-r--r--  1 1000 users  970  9 mar  2004 edit_server.sql
-rw-r--r--  1 1000 users  176  9 mar  2004 new_ban.sql
-rw-r--r--  1 1000 users  255  9 mar  2004 new_channel_privilege.sql
-rw-r--r--  1 1000 users  534  9 mar  2004 new_channel.sql
-rw-r--r--  1 1000 users  228  9 mar  2004 new_client.sql
-rw-r--r--  1 1000 users 3520  9 mar  2004 new_server_privilege.sql
-rw-r--r--  1 1000 users  918  9 mar  2004 new_server.sql
-rw-r--r--  1 1000 users   60  9 mar  2004 read_active_servers.sql
-rw-r--r--  1 1000 users   58  9 mar  2004 read_bans.sql
-rw-r--r--  1 1000 users  137  9 mar  2004 read_channel_privilege.sql
-rw-r--r--  1 1000 users  598  9 mar  2004 read_channel_privileges.sql
-rw-r--r--  1 1000 users   97  9 mar  2004 read_channel.sql
-rw-r--r--  1 1000 users   66  9 mar  2004 read_channels.sql
-rw-r--r--  1 1000 users  698  9 mar  2004 read_client_channels_privileges.sql
-rw-r--r--  1 1000 users  124  9 mar  2004 read_client_login.sql
-rw-r--r--  1 1000 users   92  9 mar  2004 read_clients_id.sql
-rw-r--r--  1 1000 users   90  9 mar  2004 read_clients_name.sql
-rw-r--r--  1 1000 users   63  9 mar  2004 read_clients.sql
-rw-r--r--  1 1000 users   57  9 mar  2004 read_server_port.sql
-rw-r--r--  1 1000 users   99  9 mar  2004 read_server_privilege.sql
-rw-r--r--  1 1000 users   56  9 mar  2004 read_server.sql
-rw-r--r--  1 1000 users   26  9 mar  2004 read_servers.sql
-rw-r--r--  1 1000 users   57  9 mar  2004 remove_bans.sql
-rw-r--r--  1 1000 users  158  9 mar  2004 remove_moderatedattribs.sql
-rw-r--r--  1 1000 users   93  9 mar  2004 search_client.sql
-rw-r--r--  1 1000 users 1637  9 mar  2004 upgrade_1.sql
-rw-r--r--  1 1000 users 1870  9 mar  2004 upgrade_2.sql
-rw-r--r--  1 1000 users  627  9 mar  2004 upgrade_3.sql

[FoolyCooly]

i changed the directive in the server.ini file to specify the absolute path with the correct type of slashes for the o/s and it worked.


is it just me or is whoever set up the distro package out to cause frustration to people by using small niches?