[rt-users] Problem with installation of RT2. [mysql]

[shimi]

Hi list!

I've tried to install that god damn thing over the past few hours :) 

First of all I would like to say that this CPAN thing is amazing, although 
I did have some problem  with the apache and mysql test suits. The apache 
failed where the wise script decided to load all the modules in 
httpd.conf, regardless wether the HAVE_MODULE has been in the compile 
options. That, of course, caused it to fail. That's how the conf was 
distributed in RH7.3. Anyways, I removed all the AddModules and it went 
fine.

Next, the MySQL issue. The test didn't work either. I told it to connect 
to my DB host, but, he probably thought that he's much smarter than I am, 
and decided to go to the socket way, with, of course, no success, as there 
is no MySQL server running on this machine. After running MySQL especially 
on this machine with the databases exported via NFS, the test went fine.

make testdeps - fine.

make install started installing the databases... and.. uhm.

[quote]
Now populating database schema.
Enter the mysql password for requesttracker: 
Creating database schema.
DBD::mysql::st execute failed: Can't create table 
'./requesttracker/#sql-266b_5da.frm' (errno: 140) at tools/initdb line 
166, <SCHEMA> line 267.
Problem with statement:
 CREATE UNIQUE INDEX Links1 ON Links (Base, Target, Type)

Can't create table './requesttracker/#sql-266b_5da.frm' (errno: 140) at 
tools/initdb line 168, <SCHEMA> line 267.
make: *** [initdb.rtuser] Error 255
[/quote]


using the mysql client to connect to mysql:
Your MySQL connection id is 3787 to server version: 4.0.4-beta


anyone has any idea on what could be it? don't tell me it's the mysql... 
that would be really weird. any other software on earth that I have works 
fine there...

-- 

  Best regards,
     Shimi


----

   "Outlook is a massive flaming horrid blatant security violation, which
    also happens to be a mail reader."

   "Sure UNIX is user friendly; it's just picky about who its friends are."