MySql error installing RT-3.5.5 - make initialize-database

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@rivertower.ie
Web: http://www.rivertowerhosting.com

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@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@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.

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