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?