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

[Ruslan Zakirov]

It's MySQL error. I never saw such error and can only suggest mysql
upgrade to 4.1.latest.

On 11/21/05, Derek Conniffe <derek at rivertower.ie> 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
>
>
> --
> 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
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
> Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
>
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at http://bestpractical.com/services/training.html
>


--
Best regards, Ruslan.