[freeside-users] RT Errors

Sales at MichianaWireless.Com Sales at MichianaWireless.Com
Mon Feb 26 02:11:29 PST 2007


I am running freeside 1.5.8
HTML::Mason
All modules listed on the RT page are installed.
Fedora core 5

After enabling internal RT I can no longer goto sysadmin and edit the
configuration to even disable it. I get the following error:

error:  ERROR: relation "queues" does not exist
executing SELECT id, name FROM queues WHERE disabled = 0 at
/usr/lib/perl5/site_perl/5.8.8/FS/TicketSystem/RT_External.pm line 222.
 
context:  ...   
218:  my($self) = @_; 
219:   
220:  my $sql = "SELECT id, name FROM queues WHERE disabled = 0"; 
221:  my $sth = $dbh->prepare($sql) or die $dbh->errstr. " preparing $sql"; 
222:  $sth->execute() or die $sth->errstr. " executing $sql"; 
223:   
224:  map { $_->[0] => $_->[1] } @{ $sth->fetchall_arrayref([]) }; 
225:   
226:  } 
...   
 
code stack:
/usr/lib/perl5/site_perl/5.8.8/FS/TicketSystem/RT_External.pm:222
/usr/lib/perl5/site_perl/5.8.8/FS/TicketSystem.pm:27
/usr/lib/perl5/site_perl/5.8.8/FS/Conf.pm:1497
/var/www/html/freeside/config/config.cgi:92
/var/www/html/freeside/autohandler:1

When I goto support/ticketing and click Ticketing Main I get:

error:  RT couldn't store your session.
This may mean that that the directory '/opt/rt3/var/session_data' isn't
writable or a database table is missing or corrupt.

 
context:  ...   
86:  }; 
87:  undef $cookies{$cookiename}; 
88:  } 
89:  else { 
90:  die loc("RT couldn't store your session.") . "\n" 
91:  . loc( 
92:  "This may mean that that the directory '[_1]' isn't writable or a
database table is missing or corrupt.", 
93:  $RT::MasonSessionDir 
94:  ) 
...   
 
code stack:  /var/www/html/freeside/rt/Elements/SetupSessionCookie:90
/var/www/html/freeside/rt/autohandler:73
/var/www/html/freeside/autohandler:1

I am wondering about this as I got this message when setting up:

After that, you need to initialize RT's database by running
 'make initialize-database'
make[1]: Leaving directory `/usr/src/freeside-1.5.8/rt'

But when I do the make initialize-database I get:

[root at billing freeside-1.5.8]# make initialize-database
make: *** No rule to make target `initialize-database'.  Stop.


What am I missing?

Thanks,
John




More information about the freeside-users mailing list