Re: [rt-users] Can't locate RT/Condition/.pm

2010-08-17 Thread Kevin Falcone
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

2010-08-17 Thread Dylan Choi
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

2010-08-16 Thread Kevin Falcone
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

2010-08-15 Thread Dylan Choi
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

2010-08-15 Thread Kevin Falcone
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

2010-08-15 Thread Dylan Choi
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!