Re: [rt-users] Can't locate RT/Condition/.pm
On Tue, Aug 17, 2010 at 10:14:33AM -0700, Dylan Choi wrote: > Sorry for my insufficient explanation ;) > > So when I ran "select * from Scrips", there were 2 "Autoreply" in the > table and the latter Autoreply didn't have ScripCondition, meaning it > was set to 0. The Creator/Created/LastUpdated/LastUpdatedBy fields are really interesting when you find strange data like that. > I may have to take a look at "upgrade-mysql-schema.pl" > script to see why Autoreply had been inserted even though it's already > existed in the table. upgrade-mysql-schema.pl won't insert new data into your Scrips table -kevin > On Mon, Aug 16, 2010 at 5:15 AM, Kevin Falcone > wrote: > > On Sun, Aug 15, 2010 at 11:19:17AM -0700, Dylan Choi wrote: > >> Thanks a bunch Kevin. Finally, httpd runs on the system and I was able > >> to see all the data from my old machine after I ran below sql. > >> > >> delete from Scrips where ScripCondition=0; > > > > It might have been better to select * from Scrips where ScripCondition > > = 0; and then go fix it in the UI. It isn't clear to me why you had > > blank condition scrips in the first place. > > > > -kevin > > > >> On Sun, Aug 15, 2010 at 6:35 AM, Kevin Falcone > >> wrote: > >> > On Sun, Aug 15, 2010 at 02:14:36AM -0700, Dylan Choi wrote: > >> >> Hello, > >> >> > >> >> I'm currently running RT(3.6.6) and trying to upgrade system hardwares > >> >> as well as RT itself. I have setup a latest RT(3.8.8) on my brand new > >> >> system and with just fresh setup, it works fine. However, since I've > >> >> restored dumped mysql data from RT 3.6.6 and upgraded database scheme > >> >> using "upgrade-mysql-schema.pl", httpd always fails to start. Below is > >> >> the error messages in error_log and there are no errors in rt.log > >> >> (/rt3/var/log/rt.log). I'm really trying to figure out why perl > >> >> can't locate RT::Condition modules when httpd starts. Please shed some > >> >> lights on me. Thanks ! > >> > > >> > One of your scrips has a blank condition, you'll need to find it and > >> > fix it. > >> > > >> > -kevin > >> > > >> >> I'm running RT 3.8.8 with following packages. > >> >> - CentOS 5.5 > >> >> - httpd-2.2.3-43 > >> >> - mod_perl-2.0.4-6 > >> >> - mysql-5.0.77-4 > >> >> > >> >> --- error_log > >> >> [Sun Aug 15 08:28:28 2010] [error] Require of RT::Condition:: > >> >> failed.\nCan't locate RT/Condition/.pm in @INC (@INC contains: > >> >> /data/www/rt3/bin/../local/lib /data/www/rt3/bin/../lib > >> >> /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi > >> >> /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl > >> >> /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi > >> >> /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl > >> >> /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 . > >> >> /etc/httpd) at (eval 1326) line 3.\n\nCompilation failed in require at > >> >> (eval 2) line 1.\n > >> >> [Sun Aug 15 08:28:28 2010] [error] Can't load Perl file: > >> >> /data/www/rt3/bin/webmux.pl for server foo.mydomain.com:0, exiting... > >> >> > >> >> > >> >> -Dylan > >> >> > >> >> RT Training in Washington DC, USA on Oct 25 & 26 2010 > >> >> Last one this year -- Learn how to get the most out of RT! > >> > > >> > > >> > RT Training in Washington DC, USA on Oct 25 & 26 2010 > >> > Last one this year -- Learn how to get the most out of RT! > >> > > >> > >> > >> > >> -- > >> - Dylan Choi > >> > >> RT Training in Washington DC, USA on Oct 25 & 26 2010 > >> Last one this year -- Learn how to get the most out of RT! > > > > > > RT Training in Washington DC, USA on Oct 25 & 26 2010 > > Last one this year -- Learn how to get the most out of RT! > > > > > > -- > - Dylan Choi > > RT Training in Washington DC, USA on Oct 25 & 26 2010 > Last one this year -- Learn how to get the most out of RT! pgp8yqmilpEFS.pgp Description: PGP signature RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!
Re: [rt-users] Can't locate RT/Condition/.pm
Sorry for my insufficient explanation ;) So when I ran "select * from Scrips", there were 2 "Autoreply" in the table and the latter Autoreply didn't have ScripCondition, meaning it was set to 0. I may have to take a look at "upgrade-mysql-schema.pl" script to see why Autoreply had been inserted even though it's already existed in the table. -Dylan On Mon, Aug 16, 2010 at 5:15 AM, Kevin Falcone wrote: > On Sun, Aug 15, 2010 at 11:19:17AM -0700, Dylan Choi wrote: >> Thanks a bunch Kevin. Finally, httpd runs on the system and I was able >> to see all the data from my old machine after I ran below sql. >> >> delete from Scrips where ScripCondition=0; > > It might have been better to select * from Scrips where ScripCondition > = 0; and then go fix it in the UI. It isn't clear to me why you had > blank condition scrips in the first place. > > -kevin > >> On Sun, Aug 15, 2010 at 6:35 AM, Kevin Falcone >> wrote: >> > On Sun, Aug 15, 2010 at 02:14:36AM -0700, Dylan Choi wrote: >> >> Hello, >> >> >> >> I'm currently running RT(3.6.6) and trying to upgrade system hardwares >> >> as well as RT itself. I have setup a latest RT(3.8.8) on my brand new >> >> system and with just fresh setup, it works fine. However, since I've >> >> restored dumped mysql data from RT 3.6.6 and upgraded database scheme >> >> using "upgrade-mysql-schema.pl", httpd always fails to start. Below is >> >> the error messages in error_log and there are no errors in rt.log >> >> (/rt3/var/log/rt.log). I'm really trying to figure out why perl >> >> can't locate RT::Condition modules when httpd starts. Please shed some >> >> lights on me. Thanks ! >> > >> > One of your scrips has a blank condition, you'll need to find it and >> > fix it. >> > >> > -kevin >> > >> >> I'm running RT 3.8.8 with following packages. >> >> - CentOS 5.5 >> >> - httpd-2.2.3-43 >> >> - mod_perl-2.0.4-6 >> >> - mysql-5.0.77-4 >> >> >> >> --- error_log >> >> [Sun Aug 15 08:28:28 2010] [error] Require of RT::Condition:: >> >> failed.\nCan't locate RT/Condition/.pm in @INC (@INC contains: >> >> /data/www/rt3/bin/../local/lib /data/www/rt3/bin/../lib >> >> /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi >> >> /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl >> >> /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi >> >> /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl >> >> /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 . >> >> /etc/httpd) at (eval 1326) line 3.\n\nCompilation failed in require at >> >> (eval 2) line 1.\n >> >> [Sun Aug 15 08:28:28 2010] [error] Can't load Perl file: >> >> /data/www/rt3/bin/webmux.pl for server foo.mydomain.com:0, exiting... >> >> >> >> >> >> -Dylan >> >> >> >> RT Training in Washington DC, USA on Oct 25 & 26 2010 >> >> Last one this year -- Learn how to get the most out of RT! >> > >> > >> > RT Training in Washington DC, USA on Oct 25 & 26 2010 >> > Last one this year -- Learn how to get the most out of RT! >> > >> >> >> >> -- >> - Dylan Choi >> >> RT Training in Washington DC, USA on Oct 25 & 26 2010 >> Last one this year -- Learn how to get the most out of RT! > > > RT Training in Washington DC, USA on Oct 25 & 26 2010 > Last one this year -- Learn how to get the most out of RT! > -- - Dylan Choi RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!
Re: [rt-users] Can't locate RT/Condition/.pm
On Sun, Aug 15, 2010 at 11:19:17AM -0700, Dylan Choi wrote: > Thanks a bunch Kevin. Finally, httpd runs on the system and I was able > to see all the data from my old machine after I ran below sql. > > delete from Scrips where ScripCondition=0; It might have been better to select * from Scrips where ScripCondition = 0; and then go fix it in the UI. It isn't clear to me why you had blank condition scrips in the first place. -kevin > On Sun, Aug 15, 2010 at 6:35 AM, Kevin Falcone > wrote: > > On Sun, Aug 15, 2010 at 02:14:36AM -0700, Dylan Choi wrote: > >> Hello, > >> > >> I'm currently running RT(3.6.6) and trying to upgrade system hardwares > >> as well as RT itself. I have setup a latest RT(3.8.8) on my brand new > >> system and with just fresh setup, it works fine. However, since I've > >> restored dumped mysql data from RT 3.6.6 and upgraded database scheme > >> using "upgrade-mysql-schema.pl", httpd always fails to start. Below is > >> the error messages in error_log and there are no errors in rt.log > >> (/rt3/var/log/rt.log). I'm really trying to figure out why perl > >> can't locate RT::Condition modules when httpd starts. Please shed some > >> lights on me. Thanks ! > > > > One of your scrips has a blank condition, you'll need to find it and > > fix it. > > > > -kevin > > > >> I'm running RT 3.8.8 with following packages. > >> - CentOS 5.5 > >> - httpd-2.2.3-43 > >> - mod_perl-2.0.4-6 > >> - mysql-5.0.77-4 > >> > >> --- error_log > >> [Sun Aug 15 08:28:28 2010] [error] Require of RT::Condition:: > >> failed.\nCan't locate RT/Condition/.pm in @INC (@INC contains: > >> /data/www/rt3/bin/../local/lib /data/www/rt3/bin/../lib > >> /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi > >> /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl > >> /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi > >> /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl > >> /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 . > >> /etc/httpd) at (eval 1326) line 3.\n\nCompilation failed in require at > >> (eval 2) line 1.\n > >> [Sun Aug 15 08:28:28 2010] [error] Can't load Perl file: > >> /data/www/rt3/bin/webmux.pl for server foo.mydomain.com:0, exiting... > >> > >> > >> -Dylan > >> > >> RT Training in Washington DC, USA on Oct 25 & 26 2010 > >> Last one this year -- Learn how to get the most out of RT! > > > > > > RT Training in Washington DC, USA on Oct 25 & 26 2010 > > Last one this year -- Learn how to get the most out of RT! > > > > > > -- > - Dylan Choi > > RT Training in Washington DC, USA on Oct 25 & 26 2010 > Last one this year -- Learn how to get the most out of RT! pgpFeIqjwI9l6.pgp Description: PGP signature RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!
Re: [rt-users] Can't locate RT/Condition/.pm
Thanks a bunch Kevin. Finally, httpd runs on the system and I was able to see all the data from my old machine after I ran below sql. delete from Scrips where ScripCondition=0; Thanks, Dylan On Sun, Aug 15, 2010 at 6:35 AM, Kevin Falcone wrote: > On Sun, Aug 15, 2010 at 02:14:36AM -0700, Dylan Choi wrote: >> Hello, >> >> I'm currently running RT(3.6.6) and trying to upgrade system hardwares >> as well as RT itself. I have setup a latest RT(3.8.8) on my brand new >> system and with just fresh setup, it works fine. However, since I've >> restored dumped mysql data from RT 3.6.6 and upgraded database scheme >> using "upgrade-mysql-schema.pl", httpd always fails to start. Below is >> the error messages in error_log and there are no errors in rt.log >> (/rt3/var/log/rt.log). I'm really trying to figure out why perl >> can't locate RT::Condition modules when httpd starts. Please shed some >> lights on me. Thanks ! > > One of your scrips has a blank condition, you'll need to find it and > fix it. > > -kevin > >> I'm running RT 3.8.8 with following packages. >> - CentOS 5.5 >> - httpd-2.2.3-43 >> - mod_perl-2.0.4-6 >> - mysql-5.0.77-4 >> >> --- error_log >> [Sun Aug 15 08:28:28 2010] [error] Require of RT::Condition:: >> failed.\nCan't locate RT/Condition/.pm in @INC (@INC contains: >> /data/www/rt3/bin/../local/lib /data/www/rt3/bin/../lib >> /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi >> /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl >> /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi >> /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl >> /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 . >> /etc/httpd) at (eval 1326) line 3.\n\nCompilation failed in require at >> (eval 2) line 1.\n >> [Sun Aug 15 08:28:28 2010] [error] Can't load Perl file: >> /data/www/rt3/bin/webmux.pl for server foo.mydomain.com:0, exiting... >> >> >> -Dylan >> >> RT Training in Washington DC, USA on Oct 25 & 26 2010 >> Last one this year -- Learn how to get the most out of RT! > > > RT Training in Washington DC, USA on Oct 25 & 26 2010 > Last one this year -- Learn how to get the most out of RT! > -- - Dylan Choi RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!
Re: [rt-users] Can't locate RT/Condition/.pm
On Sun, Aug 15, 2010 at 02:14:36AM -0700, Dylan Choi wrote: > Hello, > > I'm currently running RT(3.6.6) and trying to upgrade system hardwares > as well as RT itself. I have setup a latest RT(3.8.8) on my brand new > system and with just fresh setup, it works fine. However, since I've > restored dumped mysql data from RT 3.6.6 and upgraded database scheme > using "upgrade-mysql-schema.pl", httpd always fails to start. Below is > the error messages in error_log and there are no errors in rt.log > (/rt3/var/log/rt.log). I'm really trying to figure out why perl > can't locate RT::Condition modules when httpd starts. Please shed some > lights on me. Thanks ! One of your scrips has a blank condition, you'll need to find it and fix it. -kevin > I'm running RT 3.8.8 with following packages. > - CentOS 5.5 > - httpd-2.2.3-43 > - mod_perl-2.0.4-6 > - mysql-5.0.77-4 > > --- error_log > [Sun Aug 15 08:28:28 2010] [error] Require of RT::Condition:: > failed.\nCan't locate RT/Condition/.pm in @INC (@INC contains: > /data/www/rt3/bin/../local/lib /data/www/rt3/bin/../lib > /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi > /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl > /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi > /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl > /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 . > /etc/httpd) at (eval 1326) line 3.\n\nCompilation failed in require at > (eval 2) line 1.\n > [Sun Aug 15 08:28:28 2010] [error] Can't load Perl file: > /data/www/rt3/bin/webmux.pl for server foo.mydomain.com:0, exiting... > > > -Dylan > > RT Training in Washington DC, USA on Oct 25 & 26 2010 > Last one this year -- Learn how to get the most out of RT! pgpJyDB1vIuhH.pgp Description: PGP signature RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!
[rt-users] Can't locate RT/Condition/.pm
Hello, I'm currently running RT(3.6.6) and trying to upgrade system hardwares as well as RT itself. I have setup a latest RT(3.8.8) on my brand new system and with just fresh setup, it works fine. However, since I've restored dumped mysql data from RT 3.6.6 and upgraded database scheme using "upgrade-mysql-schema.pl", httpd always fails to start. Below is the error messages in error_log and there are no errors in rt.log (/rt3/var/log/rt.log). I'm really trying to figure out why perl can't locate RT::Condition modules when httpd starts. Please shed some lights on me. Thanks ! I'm running RT 3.8.8 with following packages. - CentOS 5.5 - httpd-2.2.3-43 - mod_perl-2.0.4-6 - mysql-5.0.77-4 --- error_log [Sun Aug 15 08:28:28 2010] [error] Require of RT::Condition:: failed.\nCan't locate RT/Condition/.pm in @INC (@INC contains: /data/www/rt3/bin/../local/lib /data/www/rt3/bin/../lib /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 . /etc/httpd) at (eval 1326) line 3.\n\nCompilation failed in require at (eval 2) line 1.\n [Sun Aug 15 08:28:28 2010] [error] Can't load Perl file: /data/www/rt3/bin/webmux.pl for server foo.mydomain.com:0, exiting... -Dylan RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!