FW: import from rt2

RT Users
1

Thanks to everyone for directing me to the import tool. I’m newbie so I apologize for the follow-up question, but I’m stuck.

I am having a permissions problem when running rt-2.0-to-dumpfile.

./rt-2.0-to-dumpfile: bad interpreter: Permission denied

I am running the script as root and have also tried to chown the file to the owner of the database, su to that user, but get the same error. Any ideas? Thanks.-----Original Message-----
From: Cassily, Ryan
Sent: Tuesday, May 27, 2003 6:07 PM
To: Rt-Users@Lists. Fsck. Com (E-mail)
Subject: [rt-users] import from rt2

I am trying to import the database from an rt2 machine to an rt3 machine. I used the following commands:

./mysqldump -Fl --opt -u root rt2 > rt2-backup-file.sql
./mysql -u root rt3 < rt2-backup-file.sql

Now when I logon to the rt3 website as root, I do not get any priviledged options and cannot even change my password. I can log into rt3 as a regular user also, but there are no queues, etc. All the tables seemed to have imported successfully when I do a shell>mysqlshow rt3. Thanks in advance for your help.

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

2

Cassily, Ryan wrote:

./rt-2.0-to-dumpfile: bad interpreter: Permission denied

rt-2.0-to-dumpfile starts with a line like

#!/usr/bin/perl -w

Make sure that’s where your perl interpreter lives, and it’s executable.
�|� Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

3

Thanks a bunch! The perl statement worked.

Now I’m having a problem with the dumpfile-to-rt-3.0. The users import correctly but I get the following error on the groups:

Importing groups
g[Thu May 29 13:30:15 2003] [crit]: No such pseudo-hash field “HASH(0x8ca53a0)” at dumpfile-to-rt-3.0 line 131.
(/opt/rt3/lib/RT.pm:228)

Thanks in advance…From: mixo [mailto:mixo@beth.uniforum.org.za]
Sent: Wednesday, May 28, 2003 9:25 AM
To: Cassily, Ryan
Subject: Re: FW: [rt-users] import from rt2

Try :

perl rt-2.0-to-dumpfile

instead. Or, change the permissions on the script like

chmod +x rt-2.0-to-dumpfile

then, you can

      ./rt-2.0-to-dumpfile

Cassily, Ryan wrote:

Thanks to everyone for directing me to the import tool. I’m newbie so I apologize for the follow-up question, but I’m stuck.

I am having a permissions problem when running rt-2.0-to-dumpfile.

./rt-2.0-to-dumpfile: bad interpreter: Permission denied

I am running the script as root and have also tried to chown the file to the owner of the database, su to that user, but get the same error. Any ideas? Thanks.

-----Original Message-----
From: Cassily, Ryan
Sent: Tuesday, May 27, 2003 6:07 PM
To: Rt-Users@Lists. Fsck. Com (E-mail)
Subject: [rt-users] import from rt2

I am trying to import the database from an rt2 machine to an rt3 machine. I used the following commands:

./mysqldump -Fl --opt -u root rt2 > rt2-backup-file.sql
./mysql -u root rt3 < rt2-backup-file.sql

Now when I logon to the rt3 website as root, I do not get any priviledged options and cannot even change my password. I can log into rt3 as a regular user also, but there are no queues, etc. All the tables seemed to have imported successfully when I do a shell>mysqlshow rt3. Thanks in advance for your help.

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

4

Cassily, Ryan wrote:

Importing groups
g[Thu May 29 13:30:15 2003] [crit]: No such pseudo-hash field “HASH(0x8ca53a0)” at dumpfile-to-rt-3.0 line 131.

What version of the import tools do you have? That doesn’t
look like the latest (1.13).
�|� Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.