<font size=2 face="sans-serif">OK, I was able to get my new RT system
to quit timing out on create ticket by re-indexing the DB. I
still am struggling with the RTFM problem, i have checked and the Article
Text custom field exists in FM_CustomField, in RT the right to view article
text is enabled for everyone, yet when you click on an article, it still
is not showing article text. Any ideas, anyone?</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>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">From:</font>
<td><font size=1 face="sans-serif">Rezty Felty <rfelty2@hallmark.com></font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">To:</font>
<td><font size=1 face="sans-serif">rt-users@lists.bestpractical.com</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Date:</font>
<td><font size=1 face="sans-serif">08/17/2011 13:34</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Subject:</font>
<td><font size=1 face="sans-serif">[rt-users] Where is my error?</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Sent by:</font>
<td><font size=1 face="sans-serif">rt-users-bounces@lists.bestpractical.com</font></table>
<br>
<hr noshade>
<br>
<br>
<br><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><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
752 mv /data01/home/rfelty2/rt3_backup-20110813.sql.gz /data02/rt3/</font><font size=3>
</font><font size=2 face="sans-serif"><br>
753 cd /data02/rt3/</font><font size=3> </font><font size=2 face="sans-serif"><br>
754 gunzip rt3_backup-20110813.sql.gz</font><font size=3>
</font><font size=2 face="sans-serif"><br>
755 mysql -h localhost -u root -p*PW-Redacted* rt3 < rt3_backup-20110813.sql</font><font size=3>
</font><font size=2 face="sans-serif"><br>
757 vi /etc/my.cnf</font><font size=3> </font><font size=2 face="sans-serif"><br>
758 service mysqld restart</font><font size=3> </font><font size=2 face="sans-serif"><br>
759 mysql -h localhost -u root -p*PW-Redacted* rt3 < rt3_backup-20110813.sql</font><font size=3>
</font><font size=2 face="sans-serif"><br>
760 cd /data02/rt3</font><font size=3> </font><font size=2 face="sans-serif"><br>
761 mysql -h localhost -u root -p*PW-Redacted* rt3 < rt3_backup-20110813.sql</font><font size=3>
</font><font size=2 face="sans-serif"><br>
762 /data02/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
--action upgrade</font><font size=3> </font><font size=2 face="sans-serif"><br>
763 /data02/rt3/sbin/rt-setup-database --dba root -p*PW-Redacted*
--action upgrade</font><font size=3> </font><font size=2 face="sans-serif"><br>
764 /data02/rt3/sbin/rt-setup-database --action schema --datadir
etc --dba admin --prompt-for-dba-password</font><font size=3> </font><font size=2 face="sans-serif"><br>
765 /data02/rt3/sbin/rt-setup-database --action schema --datadir
etc --dba root --prompt-for-dba-password</font><font size=3> </font><font size=2 face="sans-serif"><br>
766 /data02/rt3/sbin/rt-setup-database --action acl
--datadir etc/upgrade/2.1.0 --dba root --prompt-for-dba-password</font><font size=3>
</font><font size=2 face="sans-serif"><br>
767 /data02/rt3/sbin/rt-setup-database --action insert
--datadir etc/upgrade/2.1.0 --dba root --prompt-for-dba-password</font><font size=3>
</font><font size=2 face="sans-serif"><br>
768 /data02rt3/sbin/rt-setup-database --action schema
--datadir etc/upgrade/2.1.30 --dba root --prompt-for-dba-password</font><font size=3>
</font><font size=2 face="sans-serif"><br>
769 /data02/rt3/sbin/rt-setup-database --action schema
--datadir etc/upgrade/2.1.30 --dba root --prompt-for-dba-password</font><font size=3>
</font><font size=2 face="sans-serif"><br>
770 /data02/rt3/sbin/rt-setup-database --action acl
--datadir etc/upgrade/2.1.30 --dba root --prompt-for-dba-password</font><font size=3>
</font><font size=2 face="sans-serif"><br>
771 /data02/rt3/sbin/rt-setup-database --action insert
--datadir etc/upgrade/2.1.30 --dba root --prompt-for-dba-password</font><font size=3>
</font><font size=2 face="sans-serif"><br>
772 /data02/rt3/sbin/rt-setup-database --action schema
--datadir etc/upgrade/2.2.0RC2 --dba root --prompt-for-dba-password</font><font size=3>
</font><font size=2 face="sans-serif"><br>
773 perl etc/upgrade/upgrade-mysql-schema.pl rt3 root *PW-Redacted*
sql.queries mysql -u root -p rt3 < sql.queries</font><font size=3> </font><font size=2 face="sans-serif"><br>
774 perl etc/upgrade/upgrade-mysql-schema.pl</font><font size=3>
</font><font size=2 face="sans-serif"><br>
775 perl ./etc/upgrade/upgrade-mysql-schema.pl</font><font size=3>
</font><font size=2 face="sans-serif"><br>
777 cd /data02/rt3/local/plugins/RT-FM/etc/upgrade/</font><font size=3>
</font><font size=2 face="sans-serif"><br>
778 perl ./upgrade-mysql-schema.pl</font><font size=3> </font><font size=2 face="sans-serif"><br>
779 perl ./upgrade-mysql-schema.pl rt3 root *PW-Redacted*</font><font size=3>
</font><font size=2 face="sans-serif"><br>
780 perl ./upgrade-mysql-schema.pl rt3 root *PW-Redacted*
> sql.queries</font><font size=3> </font><font size=2 face="sans-serif"><br>
782 service httpd restart</font><font size=3> </font><font size=2 face="sans-serif"><br>
783 vi /data02/rt3/etc/RT_SiteConfig.pm</font><font size=3>
</font><font size=2 face="sans-serif"><br>
784 service httpd restart</font><font size=3> </font><font size=2 face="sans-serif"><br>
785 perl -c /data02/rt3/etc/RT_SiteConfig.pm</font><font size=3>
</font><font size=2 face="sans-serif"><br>
798 cd /data02/RTFM-2.4.3/</font><font size=3> </font><font size=2 face="sans-serif"><br>
799 perl Makefile.PL</font><font size=3> </font><font size=2 face="sans-serif"><br>
800 make install</font><font size=3> </font><font size=2 face="sans-serif"><br>
804 /data02/rt3/sbin/rt-setup-database --action schema --datadir
etc/upgrade/2.1.0</font><font size=3> </font><font size=2 face="sans-serif"><br>
806 /data02/rt3/sbin/rt-setup-database --action --dba root
schema --datadir etc/upgrade/2.1.0</font><font size=3> </font><font size=2 face="sans-serif"><br>
807 /data02/rt3/sbin/rt-setup-database --action schema --dba
root --datadir etc/upgrade/2.1.0</font><font size=3> </font><font size=2 face="sans-serif"><br>
808 /data02/rt3/sbin/rt-setup-database --action acl --dba
root --datadir etc/upgrade/2.1.0</font><font size=3> </font><font size=2 face="sans-serif"><br>
809 /data02/rt3/sbin/rt-setup-database --action insert --dba
root --datadir etc/upgrade/2.1.0</font><font size=3> </font><font size=2 face="sans-serif"><br>
812 /data02/rt3/sbin/rt-setup-database --action schema --dba
root --dba-password *PW-Redacted* --datadir etc/upgrade/2.1.30</font><font size=3>
</font><font size=2 face="sans-serif"><br>
813 /data02/rt3/sbin/rt-setup-database --action acl --dba
root --dba-password *PW-Redacted* --datadir etc/upgrade/2.1.30</font><font size=3>
</font><font size=2 face="sans-serif"><br>
814 /data02/rt3/sbin/rt-setup-database --action insert --dba
root --dba-password *PW-Redacted* --datadir etc/upgrade/2.1.30</font><font size=3>
</font><font size=2 face="sans-serif"><br>
816 /data02/rt3/sbin/rt-setup-database --action schema --dba
root --dba-password *PW-Redacted* --datadir etc/upgrade/2.2.0RC2</font><font size=3>
</font><font size=2 face="sans-serif"><br>
817 /data02/rt3/sbin/rt-setup-database --action acl --dba
root --dba-password *PW-Redacted* --datadir etc/upgrade/2.2.0RC2</font><font size=3>
</font><font size=2 face="sans-serif"><br>
818 /data02/rt3/sbin/rt-setup-database --action insert --dba
root --dba-password *PW-Redacted* --datadir etc/upgrade/2.2.0RC2</font><font size=3>
</font><font size=2 face="sans-serif"><br>
820 perl etc/upgrade/upgrade-mysql-schema.pl rt3 root *PW-Redacted*
> sql.queries</font><font size=3> </font><font size=2 face="sans-serif"><br>
822 mysql -u root -p*PW-Redacted* rt3 < sql.queries</font><font size=3>
</font><font size=2 face="sans-serif"><br>
825 rm -rf /opt/rt3/var/mason_data/*</font><font size=3> </font><font size=2 face="sans-serif"><br>
826 service httpd restart</font><font size=3> </font><font size=2 face="sans-serif"><br>
840 chmod 777 ticketlist</font><font size=3> </font><font size=2 face="sans-serif"><br>
875 /data02/rt3/sbin/rt-setup-database --dba root --dba-password
*PW-Redacted* --action upgrade</font><font size=3> </font><font size=2 face="sans-serif"><br>
878 /data02/rt3/sbin/rt-setup-database --dba root --dba-password
*PW-Redacted* --action upgrade</font><font size=3> </font><font size=2 face="sans-serif"><br>
886 /data02/rt3/sbin/rt-setup-database --dba root --dba-password
*PW-Redacted* --action upgrade</font><font size=3> </font><font size=2 face="sans-serif"><br>
892 rm -fr /opt/rt3/var/mason_data/obj</font><font size=3>
</font><font size=2 face="sans-serif"><br>
893 service httpd restart</font><font size=3> </font><font size=2 face="sans-serif"><br>
898 tar -cvf www.tar www</font><font size=3> </font><font size=2 face="sans-serif"><br>
899 mv www.tar /data02/rt3/share/html/</font><font size=3>
</font><font size=2 face="sans-serif"><br>
901 tar -xvf www.tar</font><font size=3> </font><font size=2 face="sans-serif"><br>
911 vi RT_SiteConfig.pm</font><font size=3> </font><font size=2 face="sans-serif"><br>
912 tail -500 /data02/rt3/var/log</font><font size=3> </font><font size=2 face="sans-serif"><br>
915 tail -500 rt.log</font><font size=3> </font><font size=2 face="sans-serif"><br>
919 mv /data02/rt3/share/html/www.tar .</font><font size=3>
</font><font size=2 face="sans-serif"><br>
920 tar -xvf www.tar</font><font size=3> </font><font size=2 face="sans-serif"><br>
921 tail -500 ../logs/rt.log</font><font size=3> </font><font size=2 face="sans-serif"><br>
922 tail -500 /data02/rt3/var/log/rt.log</font><font size=3>
<br>
<br>
</font><font size=2 face="sans-serif"><br>
Cgi-bin errors from error log:</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
[root@s601445dc4vl150:~] cat /usr/local/httpd/logs/error_log|grep -i cgi-bin</font><font size=3>
<br>
</font><font size=2 face="sans-serif"><br>
[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><font size=3>
</font><font size=2 face="sans-serif"><br>
[root@s601445dc4vl150:~] ls /data02/var/www/cgi-bin/sl*</font><font size=3>
</font><font size=2 face="sans-serif"><br>
-rwxr-xr-x 1 root root 3268 Oct 17 2008 /data02/var/www/cgi-bin/sla_report.tmpl</font><font size=3>
</font><font size=2 face="sans-serif"><br>
-rwxr-xr-x 1 root root 5461 Oct 21 2008 /data02/var/www/cgi-bin/sla_report.new</font><font size=3>
</font><font size=2 face="sans-serif"><br>
-rwxrwxrwx 1 root root 5460 Oct 21 2008 /data02/var/www/cgi-bin/sla_report</font><font size=3>
<br>
</font><font size=2 face="sans-serif"><br>
[root@s601445dc4vl150:~] vi /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm</font><font size=3>
</font><font size=2 face="sans-serif"><br>
852 warn "[Mason] Cannot resolve file
to component: " .</font><font size=3> <br>
<br>
<br>
</font><font size=2 face="sans-serif"><br>
Help!</font><font size=3> <br>
<br>
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 <br>
Skype Rezty.Felty<br>
Googletalk Rezty@KC-Felty.Net </font><tt><font size=2>--------<br>
RT Training Sessions (</font></tt><a href=http://bestpractical.com/services/training.html><tt><font size=2>http://bestpractical.com/services/training.html</font></tt></a><tt><font size=2>)<br>
* Chicago, IL, USA — September 26 & 27, 2011<br>
* San Francisco, CA, USA — October 18 & 19, 2011<br>
* Washington DC, USA — October 31 & November 1, 2011<br>
* Melbourne VIC, Australia — November 28 & 29, 2011<br>
* Barcelona, Spain — November 28 & 29, 2011</font></tt>
<br>