3.0.3 to 3.4.2 upgrade issues / questions using RHEL4InstallGuide?

  • I used the RHEL4InstallGuide from
    http://wiki.bestpractical.com/index.cgi?RHEL4InstallGuide to get RT 3.0.3
    installed and working on my test virtual machine (under VMWare Workstation
    5).

  • I then went to my production box and did a “mysqldump --all-databases >
    filename.sql”

  • On the test virtual machine I did a “make dropdb” from the rt-3-0-3
    install directory to get rid of the stock database.

  • On the test virtual machine I then did a “mysql -f -p < filename.sql” to
    try and import my production database.

Can anyone help me sort out the following errors I got and help me determine
if I got an accurate import of my data?

Having never done this before: Do I need to drop some of these tables and
remove the duplicate entries first or is there a way to overwrite them?

-cut-
ERROR 1050 (42S01) at line 19: Table ‘columns_priv’ already exists
ERROR 1050 (42S01) at line 39: Table ‘db’ already exists
ERROR 1062 (23000) at line 63: Duplicate entry ‘%-test-’ for key 1
ERROR 1062 (23000) at line 64: Duplicate entry ‘%-test_%-’ for key 1
ERROR 1062 (23000) at line 65: Duplicate entry ‘localhost-rt3-rt_user’ for
key 1
ERROR 1062 (23000) at line 66: Duplicate entry ‘%-mysql-cXXXX’ for key 1
ERROR 1062 (23000) at line 67: Duplicate entry ‘%-rt3-cXXXX’ for key 1
ERROR 1062 (23000) at line 68: Duplicate entry ‘%-test-cXXXX’ for key 1
ERROR 1050 (42S01) at line 74: Table ‘func’ already exists
ERROR 1050 (42S01) at line 91: Table ‘host’ already exists
ERROR 1050 (42S01) at line 118: Table ‘tables_priv’ already exists
ERROR 1050 (42S01) at line 140: Table ‘user’ already exists
ERROR 1062 (23000) at line 179: Duplicate entry ‘localhost-root’ for key 1
ERROR 1062 (23000) at line 180: Duplicate entry ‘cgyXXXXXX-root’ for key 1
ERROR 1062 (23000) at line 181: Duplicate entry ‘localhost-’ for key 1
ERROR 1062 (23000) at line 182: Duplicate entry ‘cgyXXXXXX-’ for key 1
ERROR 1062 (23000) at line 183: Duplicate entry ‘%-cXXXX’ for key 1
ERROR 1062 (23000) at line 184: Duplicate entry ‘localhost-rt_user’ for key
1
ERROR 1050 (42S01) at line 190: Table ‘user_info’ already exists
-cut-

Once the import was done I was able to login with user accounts from my
production system and when viewing all the data everything seems in tact
visually.

Then I moved to the “rt-3.4.2” install directory and did:

./configure --with-web-user=apache --with-web-group=apache --with-fastcgi –
with-mysql

  • sbin/rt-test-dependencies --with-mysql --with-fastcgi --verbose | grep
    MISSING, which indicated “Test::WWW::Mechanize …MISSING”

  • So as instructed in the guide, did “perl
    sbin/rt-test-dependencies --with-mysql --with-fastcgi --install”. The last
    few lines read:
    -cut-
    Test::WWW::Mechanize is up to date.
    MYSQL dependencies:
    MAILGATE dependencies:
    CORE dependencies:
    -cut-

  • But then when I run “perl
    sbin/rt-test-dependencies --with-mysql --with-fastcgi --verbose | grep
    MISSING” again, I get:

-cut-
Test::WWW::Mechanize …MISSING
-cut-

So I am confused as to what is going on here?

I tried to ignore the error, moved my /opt/rt3 to another name, from the
3.4.2 install directory did a “make upgrade” followed by "
/opt/rt3/sbin/rt-setup-database --dba
root --prompt-for-dba-password --action schema --datadir
etc/upgrade/
/opt/rt3/sbin/rt-setup-database --dba
root --prompt-for-dba-password --action acl --datadir etc/upgrade/
/opt/rt3/sbin/rt-setup-database --dba
root --prompt-for-dba-password --action insert --datadir
etc/upgrade/
for 3.1.0 3.1.15 3.1.17 3.3.0 3.3.11.

With /opt/rt3/sbin/rt-setup-database --dba
root --prompt-for-dba-password --action insert --datadir etc/upgrade/3.1.0 I
am getting the error:

-cut-
DBI connect(‘dbname=rt3;host=localhost’,‘rt_user’,…) failed: Access denied
for user ‘rt_user’@‘localhost’ (using password: YES) at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 98
Connect Failed Access denied for user ‘rt_user’@‘localhost’ (using password:
YES)
-cut-

However, if I run mysql -p and use the same root password, I’m in… Ideas?

The information contained in this e-mail message is PRIVATE. It may contain confidential information and may be legally privileged. It is intended for the exclusive use of the addressee(s). If you are not the intended recipient, you are hereby notified that any dissemination, distribution or reproduction of this communication is strictly prohibited. If the intended recipient(s) cannot be reached or if a transmission problem has occurred, please notify the sender immediately by return e-mail and destroy all copies of this message.
Thank you.