[rt-users] DBD Error: Can't find 'Users.MYI'

[RT-User]

Hi List,

after some hours of compiling and installing with the appreciated help of
Autrijus with the Lexicon package, I got it up and running. Almost ;)!

I am not able to login into rt3. The error.log provides an error that is
stated below:

> DBD::mysql::st execute failed: Can't find file: 'Users.MYI' 
> (errno: 2) at /usr/local/share/perl/5.6.1/DBIx/SearchBuilder/Handle.pm
line 410.

> RT::Handle=HASH(0x8dcb200) couldn't execute the query 'SELECT  * FROM
Users 
> WHERE Name = ?' at
/usr/local/share/perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 4

It seems that DBD is not able to find the users file. There is no such file
on the machine, but there is a Users.frm file in the database directory of
rt3 and of course the user.MYI in the database directory of mysql.

We are running:

Debian 3.0
Apache/1.3.26 (Unix) Debian GNU/Linux
perl v5.6.1 built for i386-linux

Any help about this is appreciated.

Thanks in advance!

-christian