MySql database error installing RT 3.4.4

Hi all,

I’m just getting started with RT and I’m still installing and have come
up with an error while trying to install RT version 3.4.4.

I successfully installed all of the dependencies and then moved on to
installing the database (I’m using the default database names & user
access and the default install into the /usr/local/rt3 directory)

So I ran “make initialize-database” and entered the Mysql root’s
password and I’m getting a funny MySql error about renaming a database
(error below). I’m running
MySql version 4.1.10a.

Thanks for any help!

Derek

/usr/local/src/rt-3.4.4 # make initialize-database
/usr/bin/perl //usr/local/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-e18’ (errno:
-1) at //usr/local/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@rivertower.ie
Web: http://www.rivertowerhosting.com