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

[Drew Barnes]

Are you running that on top of an existing rt3 database?  If so, follow 
the upgrade instructions in the README.


Derek Conniffe wrote:
> 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
>
>

-- 
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati