[rt-users] RT2 Installation with Mod_Perl assistance required :: RT Dies after enter username and password

[Jesse Vincent]

Try backing down to DBIx::SearchBuilder 0.99


On Wed, Jul 07, 2004 at 02:44:12PM +1000, John wrote:
> Sorry to bother everyone. I am going around in circles so if someone 
> could just point me in the right direction, I can let go of my tail.
> 
> Mandrake 8.1 (I know a little old, it is behind a firewall on a local 
> network)
> Apache 1.3.31 + Mod_Perl
> RT-2-0-15
> 
> 1/ Dependencies installed ok (with exception of Apache::Cookie which 
> gave me some trouble with the dependancy Apache::Test)
> 2/ Fixed Apache to mod_perl savvy (I think) and my only confirmation is 
> from the apache log:
> ... [notice] Apache/1.3.31 (Unix) mod_perl/1.29 configured -- resuming 
> normal operations
> 3/ Had a permission issue on the log file, fixed it and now...
> 4/ Login screen comes up ok (except RT image top left - minor issue). If 
> you enter the wrong username or password it tells you. BUT when the 
> right username or password is entered you get a SYSTEM ERROR with the 
> following detail
> <screen snip>
> System error
> 
> error:  Unsatisfied dependency chain in Joins Users_2 at 
> /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 889.
> 
> context:  ...  
> 885:  $seen_aliases{$join} = 1;
> 886:  }
> 887:  else {
> 888:  push ( @keys, $join );
> 889:  die "Unsatisfied dependency chain in Joins @keys"
> 890:  if $seen{"@keys"}++;
> 891:  }
> 892:  
> 893:  }
> ...  
> 
> code stack:  /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:889
> /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:316
> /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:109
> /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:400
> /opt/rt2_innes/lib/RT/Tickets.pm:996
> /opt/rt2_innes/WebRT/html/Elements/MyRequests:11
> /opt/rt2_innes/WebRT/html/index.html:9
> /opt/rt2_innes/WebRT/html/autohandler:58
> 
> raw error
> </screen snip>
> 
> The section of  Handle.pm where it fails for me (as per above) is as 
> follows, I don't know if this helps you point out where it is going 
> wrong or not...but I thought I would include incase it is helpful.
> 
> <Handle.pm_snip>
> 863  sub _BuildJoins {
>   864      my $self = shift;
>   865      my $sb   = shift;
>   866      my %seen_aliases;
>   867
>   868      $seen_aliases{'main'} = 1;
>   869
>   870      my $join_clause = $sb->{'table'} . " main ";
>   871
>   872      my @keys = ( keys %{ $sb->{'left_joins'} } );
>   873      my %seen;
>   874
>   875      while ( my $join = shift @keys ) {
>   876          if ( $seen_aliases{ 
> $sb->{'left_joins'}{$join}{'depends_on'} } ) {
>   877              $join_clause = "(" . $join_clause;
>   878              $join_clause .=
>   879                $sb->{'left_joins'}{$join}{'alias_string'} . " ON (";
>   880              $join_clause .=
>   881                join ( ') AND( ',
>   882                  values %{ $sb->{'left_joins'}{$join}{'criteria'} 
> } );
>   883              $join_clause .= ")) ";
>   884
>   885              $seen_aliases{$join} = 1;
>   886          }
>   887          else {
>   888              push ( @keys, $join );
>   889              die "Unsatisfied dependency chain in Joins @keys"
>   890                if $seen{"@keys"}++;
>   891          }
>   892
>   893      }
>   894      return ( join ( ", ", ( $join_clause, @{ $sb->{'aliases'} } 
> ) ) );
>   895
>   896  }
> </Handle.pm_snip>
> 
> Unfortunately there is no further information in the RT log file or 
> Apache error log file... they both think things are fine for some reason...
> Am I looking for another permission issue? or is it an apache config 
> problem? I am using Apache's DocumentRoot as follows:
> 
> <httpd.conf_snip>
> DocumentRoot /opt/rt2_innes/WebRT/html
> ServerName rt.example.com
> # PerlModule Apache::DBI
> PerlRequire /opt/rt2_innes/bin/webmux.pl
> <Location />
> SetHandler perl-script
> PerlHandler RT::Mason
> </Location>
> </httpd.conf_snip>
> 
> PerlModule Apache::DBI (as predicted in RTFM) stopped Apache from starting.
> 
> I have now tried Multiple installs of:
> OpenBSD, FreeBSD and now Mandrake. This time I think I am close...I can 
> almost see that nice RT screen....but no cigar yet :-(
> 
> Any help, advice,  solutions would be much appreciated... sleep patterns 
> way outa whack for over a week now...
> 
> Thanks to anybody who takes the time even if you are unable to assist in 
> my dilema.
> 
> Kind regards,
> 
> John
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com

--