[rt-users] MySql error installing RT-3.5.5 - make initialize-database

[Derek Conniffe]

Hi all,

I was having this exact problem trying to install RT-3.4.4 but I saw 
that I lot of people are using the latest 3.5.5 so I thought that I'd 
give it a go too.

I'm geting an error when I run "make initialize-database" with RT-3.5.5 
(the make install went fine)

The errors I'm getting is:

CREATE INDEX Attachments2 ON Attachments (TransactionId)
Error on rename of './rt3/Attachments' to './rt3/#sql2-c78-1152' (errno: 
-1) at //opt/rt3/sbin/rt-setup-database line 205.
make: *** [initialize-database] Error 255

Any advise from anyone would be great!

Thanks,

Derek

P.S. I'm running MySql 4.1.10a on SuSE 9.1.

The whole output of make initialize-database is: -

# make initialize-database
/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba root 
--prompt-for-dba-password
In order to create or update your RT database,this script needs to 
connect to your mysql instance on localhost as root.
Please specify that user's database password below. If the user has no 
database
password, just press return.

Password:
Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
Problem with statement:

CREATE INDEX Attachments2 ON Attachments (TransactionId)
Error on rename of './rt3/Attachments' to './rt3/#sql2-c78-1152' (errno: 
-1) at //opt/rt3/sbin/rt-setup-database line 205.
make: *** [initialize-database] Error 255


-- 
Derek Conniffe
Rivertower Ltd
DID Number: 01 440 1806 (International: 00 353 1 440 1806)
Ireland: (Freephone) 1800 719 400
Ireland: (Local) 01 440 1800
United Kingdom: 0870 068 2368
International: 00 353 1 440 1800
Derek Conniffe Mobile: 086 856 3823 (International: 00 353 86 856 3823)
Fax: 01 201 0085 (International: 00 353 1 201 0085)
Email: Derek at rivertower.ie
Web: http://www.rivertowerhosting.com