<font size=2 face="sans-serif">I have a production RT 3.8.0 instance running
on a local Solaris server. I have been tasked with migrating it to
a remote vmware RHEL Linux instance and upgrading to RT 3.8.8 at the same
time. So I installed RT3.8.8 on the new server, and then did a MySQL
dump of the db from the existing server, and moved it over and imported
it to the new server, for my test instance for the migration. At
first, RTFM did not work, (it would show RTFM, and article titles, but
if you clicked on one, no article body), there were permission errors,
I had a few problems. I engaged RT support for 4 hours of paid support,
and we worked through all of those issues, and i documented all the steps
we took. Then RT on the new server was working right and we scheduled
a Saturday midnight cutover , the plan was to take another dump after shutting
down the existing prod RT instance, copy it over, do the DB transforms
for the upgrade, and all should be well. I did that, and RTFM would
not show article bodies again, screens timed out opening new tickets, the
server could not find cgi-bin, even though it was exactly in the location
the error logs said it was looking. Here are the commands I ran,
see if you can spot a step I missed, because I have to reschedule this
and try again:</font>
<br>
<br><font size=2 face="sans-serif"> 752 mv /data01/home/rfelty2/rt3_backup-20110813.sql.gz
/data02/rt3/</font>
<br><font size=2 face="sans-serif"> 753 cd /data02/rt3/</font>
<br><font size=2 face="sans-serif"> 754 gunzip rt3_backup-20110813.sql.gz</font>
<br><font size=2 face="sans-serif"> 755 mysql -h localhost
-u root -p*PW-Redacted* rt3 < rt3_backup-20110813.sql</font>
<br><font size=2 face="sans-serif"> 757 vi /etc/my.cnf</font>
<br><font size=2 face="sans-serif"> 758 service mysqld restart</font>
<br><font size=2 face="sans-serif"> 759 mysql -h localhost
-u root -p*PW-Redacted* rt3 < rt3_backup-20110813.sql</font>
<br><font size=2 face="sans-serif"> 760 cd /data02/rt3</font>
<br><font size=2 face="sans-serif"> 761 mysql -h localhost
-u root -p*PW-Redacted* rt3 < rt3_backup-20110813.sql</font>
<br><font size=2 face="sans-serif"> 762 /data02/rt3/sbin/rt-setup-database
--dba root --prompt-for-dba-password --action upgrade</font>
<br><font size=2 face="sans-serif"> 763 /data02/rt3/sbin/rt-setup-database
--dba root -p*PW-Redacted* --action upgrade</font>
<br><font size=2 face="sans-serif"> 764 /data02/rt3/sbin/rt-setup-database
--action schema --datadir etc --dba admin --prompt-for-dba-password</font>
<br><font size=2 face="sans-serif"> 765 /data02/rt3/sbin/rt-setup-database
--action schema --datadir etc --dba root --prompt-for-dba-password</font>
<br><font size=2 face="sans-serif"> 766 /data02/rt3/sbin/rt-setup-database
--action acl --datadir etc/upgrade/2.1.0 --dba root --prompt-for-dba-password</font>
<br><font size=2 face="sans-serif"> 767 /data02/rt3/sbin/rt-setup-database
--action insert --datadir etc/upgrade/2.1.0 --dba root --prompt-for-dba-password</font>
<br><font size=2 face="sans-serif"> 768 /data02rt3/sbin/rt-setup-database
--action schema --datadir etc/upgrade/2.1.30 --dba root --prompt-for-dba-password</font>
<br><font size=2 face="sans-serif"> 769 /data02/rt3/sbin/rt-setup-database
--action schema --datadir etc/upgrade/2.1.30 --dba root --prompt-for-dba-password</font>
<br><font size=2 face="sans-serif"> 770 /data02/rt3/sbin/rt-setup-database
--action acl --datadir etc/upgrade/2.1.30 --dba root --prompt-for-dba-password</font>
<br><font size=2 face="sans-serif"> 771 /data02/rt3/sbin/rt-setup-database
--action insert --datadir etc/upgrade/2.1.30 --dba root --prompt-for-dba-password</font>
<br><font size=2 face="sans-serif"> 772 /data02/rt3/sbin/rt-setup-database
--action schema --datadir etc/upgrade/2.2.0RC2 --dba root
--prompt-for-dba-password</font>
<br><font size=2 face="sans-serif"> 773 perl etc/upgrade/upgrade-mysql-schema.pl
rt3 root *PW-Redacted* sql.queries mysql -u root -p rt3 < sql.queries</font>
<br><font size=2 face="sans-serif"> 774 perl etc/upgrade/upgrade-mysql-schema.pl</font>
<br><font size=2 face="sans-serif"> 775 perl ./etc/upgrade/upgrade-mysql-schema.pl</font>
<br><font size=2 face="sans-serif"> 777 cd /data02/rt3/local/plugins/RT-FM/etc/upgrade/</font>
<br><font size=2 face="sans-serif"> 778 perl ./upgrade-mysql-schema.pl</font>
<br><font size=2 face="sans-serif"> 779 perl ./upgrade-mysql-schema.pl
rt3 root *PW-Redacted*</font>
<br><font size=2 face="sans-serif"> 780 perl ./upgrade-mysql-schema.pl
rt3 root *PW-Redacted* > sql.queries</font>
<br><font size=2 face="sans-serif"> 782 service httpd restart</font>
<br><font size=2 face="sans-serif"> 783 vi /data02/rt3/etc/RT_SiteConfig.pm</font>
<br><font size=2 face="sans-serif"> 784 service httpd restart</font>
<br><font size=2 face="sans-serif"> 785 perl -c /data02/rt3/etc/RT_SiteConfig.pm</font>
<br><font size=2 face="sans-serif"> 798 cd /data02/RTFM-2.4.3/</font>
<br><font size=2 face="sans-serif"> 799 perl Makefile.PL</font>
<br><font size=2 face="sans-serif"> 800 make install</font>
<br><font size=2 face="sans-serif"> 804 /data02/rt3/sbin/rt-setup-database
--action schema --datadir etc/upgrade/2.1.0</font>
<br><font size=2 face="sans-serif"> 806 /data02/rt3/sbin/rt-setup-database
--action --dba root schema --datadir etc/upgrade/2.1.0</font>
<br><font size=2 face="sans-serif"> 807 /data02/rt3/sbin/rt-setup-database
--action schema --dba root --datadir etc/upgrade/2.1.0</font>
<br><font size=2 face="sans-serif"> 808 /data02/rt3/sbin/rt-setup-database
--action acl --dba root --datadir etc/upgrade/2.1.0</font>
<br><font size=2 face="sans-serif"> 809 /data02/rt3/sbin/rt-setup-database
--action insert --dba root --datadir etc/upgrade/2.1.0</font>
<br><font size=2 face="sans-serif"> 812 /data02/rt3/sbin/rt-setup-database
--action schema --dba root --dba-password *PW-Redacted* --datadir etc/upgrade/2.1.30</font>
<br><font size=2 face="sans-serif"> 813 /data02/rt3/sbin/rt-setup-database
--action acl --dba root --dba-password *PW-Redacted* --datadir etc/upgrade/2.1.30</font>
<br><font size=2 face="sans-serif"> 814 /data02/rt3/sbin/rt-setup-database
--action insert --dba root --dba-password *PW-Redacted* --datadir etc/upgrade/2.1.30</font>
<br><font size=2 face="sans-serif"> 816 /data02/rt3/sbin/rt-setup-database
--action schema --dba root --dba-password *PW-Redacted* --datadir etc/upgrade/2.2.0RC2</font>
<br><font size=2 face="sans-serif"> 817 /data02/rt3/sbin/rt-setup-database
--action acl --dba root --dba-password *PW-Redacted* --datadir etc/upgrade/2.2.0RC2</font>
<br><font size=2 face="sans-serif"> 818 /data02/rt3/sbin/rt-setup-database
--action insert --dba root --dba-password *PW-Redacted* --datadir etc/upgrade/2.2.0RC2</font>
<br><font size=2 face="sans-serif"> 820 perl etc/upgrade/upgrade-mysql-schema.pl
rt3 root *PW-Redacted* > sql.queries</font>
<br><font size=2 face="sans-serif"> 822 mysql -u root -p*PW-Redacted*
rt3 < sql.queries</font>
<br><font size=2 face="sans-serif"> 825 rm -rf /opt/rt3/var/mason_data/*</font>
<br><font size=2 face="sans-serif"> 826 service httpd restart</font>
<br><font size=2 face="sans-serif"> 840 chmod 777 ticketlist</font>
<br><font size=2 face="sans-serif"> 875 /data02/rt3/sbin/rt-setup-database
--dba root --dba-password *PW-Redacted* --action upgrade</font>
<br><font size=2 face="sans-serif"> 878 /data02/rt3/sbin/rt-setup-database
--dba root --dba-password *PW-Redacted* --action upgrade</font>
<br><font size=2 face="sans-serif"> 886 /data02/rt3/sbin/rt-setup-database
--dba root --dba-password *PW-Redacted* --action upgrade</font>
<br><font size=2 face="sans-serif"> 892 rm -fr /opt/rt3/var/mason_data/obj</font>
<br><font size=2 face="sans-serif"> 893 service httpd restart</font>
<br><font size=2 face="sans-serif"> 898 tar -cvf www.tar www</font>
<br><font size=2 face="sans-serif"> 899 mv www.tar /data02/rt3/share/html/</font>
<br><font size=2 face="sans-serif"> 901 tar -xvf www.tar</font>
<br><font size=2 face="sans-serif"> 911 vi RT_SiteConfig.pm</font>
<br><font size=2 face="sans-serif"> 912 tail -500 /data02/rt3/var/log</font>
<br><font size=2 face="sans-serif"> 915 tail -500 rt.log</font>
<br><font size=2 face="sans-serif"> 919 mv /data02/rt3/share/html/www.tar
.</font>
<br><font size=2 face="sans-serif"> 920 tar -xvf www.tar</font>
<br><font size=2 face="sans-serif"> 921 tail -500 ../logs/rt.log</font>
<br><font size=2 face="sans-serif"> 922 tail -500 /data02/rt3/var/log/rt.log</font>
<br>
<br>
<br><font size=2 face="sans-serif">Cgi-bin errors from error log:</font>
<br>
<br><font size=2 face="sans-serif">[root@s601445dc4vl150:~] cat /usr/local/httpd/logs/error_log|grep
-i cgi-bin</font>
<br>
<br><font size=2 face="sans-serif">[Sat Aug 13 10:17:49 2011] [warning]:
[Mason] Cannot resolve file to component: /data02/var/www/cgi-bin/sla_report
(is file outside component root?) at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 852, <DATA> line 1662. (/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm:852)</font>
<br><font size=2 face="sans-serif">[root@s601445dc4vl150:~] ls /data02/var/www/cgi-bin/sl*</font>
<br><font size=2 face="sans-serif">-rwxr-xr-x 1 root root 3268 Oct 17 2008
/data02/var/www/cgi-bin/sla_report.tmpl</font>
<br><font size=2 face="sans-serif">-rwxr-xr-x 1 root root 5461 Oct 21 2008
/data02/var/www/cgi-bin/sla_report.new</font>
<br><font size=2 face="sans-serif">-rwxrwxrwx 1 root root 5460 Oct 21 2008
/data02/var/www/cgi-bin/sla_report</font>
<br>
<br><font size=2 face="sans-serif">[root@s601445dc4vl150:~] vi /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm</font>
<br><font size=2 face="sans-serif"> 852
warn "[Mason] Cannot resolve file to component: " .</font>
<br>
<br>
<br>
<br><font size=2 face="sans-serif">Help!</font>
<br>
<br><font size=3>Rezty Felty<br>
Hallmark Digital - Infrastructure<br>
816.559.1196<br>
<br>
<br>
MSN </font><a href=mailto:rustyfelty@hotmail.com target=_blank><font size=3 color=blue><u>rustyfelty@hotmail.com</u></font></a><font size=3><br>
YIM HiRez_L<br>
AIM HiRezL<br>
ICQ 1932818</font>
<br><font size=3>Skype Rezty.Felty<br>
Googletalk Rezty@KC-Felty.Net </font>