[freeside-users] RT install failure

Gerald V. Livingston II gerald.freeside at sysmatrix.net
Sun Aug 20 14:30:43 PDT 2006


NOTE: Attached is the output from the apache-ssl error log

Fresh 1.5.8-cvs install
Debian Sarge (fresh install)

Figured I'd install RT on this round.

/opt/rt3/var/session_data/ is freeside:freeside rwxrwx---
apache-ssl is running as freeside:freeside

I'm getting this when I click "Ticketing Main" to try to create the first RT user::

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/freeside/rt/Elements/SetupSessionCookie:90
/var/www/freeside/rt/autohandler:73
/var/www/freeside/autohandler:1

Do I need to finish the "Administration" part of setting up Freeside before this will work or is there something else going on? It appears to be a database error from looking at the output of the apache-ssl error log.

Thanks, 

Gerald
-------------- next part --------------
DBD::Pg::st execute failed: ERROR:  relation "users" does not exist
RT::Handle=HASH(0xab99970) couldn't execute the query 'SELECT  * FROM Users WHERE LOWER(Name) = LOWER(?)' at /usr/local/share
/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 505
        DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xab99970)', 'SELECT  * FROM Users WHERE LOWER(Name) = LOWE
R(?)', 'RT_System') called at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Record.pm line 1218
        DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0xacb1cb0)', 'SELECT  * FROM Users WHERE LOWER(Name)
= LOWER(?)', 'RT_System') called at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Record.pm line 1133
        DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0xacb1cb0)', 'LOWER(Name)', 'HASH(0x8961ebc)') called a
t /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Record/Cachable.pm line 137
        DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0xacb1cb0)', 'LOWER(Name)', 'HASH(0x8961ebc)'
) called at /opt/rt3/lib/RT/Record.pm line 392
        RT::Record::LoadByCols('RT::CurrentUser=HASH(0xacb1cb0)', 'Name', 'RT_System') called at /usr/local/share/perl/5.8.4/
DBIx/SearchBuilder/Record.pm line 1078
        DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0xacb1cb0)', 'Name', 'RT_System') called at /opt/rt3/lib
/RT/CurrentUser.pm line 254
        RT::CurrentUser::LoadByName('RT::CurrentUser=HASH(0xacb1cb0)', 'RT_System') called at /opt/rt3/lib/RT.pm line 152
        RT::Init() called at /usr/local/etc/freeside/handler.pl line 301
        HTML::Mason::handler('Apache=SCALAR(0x8acc0e8)') called at /dev/null line 0
        eval {...} called at /dev/null line 0
DBD::Pg::st execute failed: ERROR:  relation "users" does not exist
RT::Handle=HASH(0xab99970) couldn't execute the query 'SELECT  * FROM Users WHERE LOWER(Name) = LOWER(?)' at /usr/local/share
/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 505
        DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xab99970)', 'SELECT  * FROM Users WHERE LOWER(Name) = LOWE
R(?)', 'Nobody') called at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Record.pm line 1218
        DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0x8961e14)', 'SELECT  * FROM Users WHERE LOWER(Name)
= LOWER(?)', 'Nobody') called at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Record.pm line 1133
        DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0x8961e14)', 'LOWER(Name)', 'HASH(0x8961e38)') called a
t /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Record/Cachable.pm line 137
        DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0x8961e14)', 'LOWER(Name)', 'HASH(0x8961e38)'
) called at /opt/rt3/lib/RT/Record.pm line 392
        RT::Record::LoadByCols('RT::CurrentUser=HASH(0x8961e14)', 'Name', 'Nobody') called at /usr/local/share/perl/5.8.4/DBI
x/SearchBuilder/Record.pm line 1078
        DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0x8961e14)', 'Name', 'Nobody') called at /opt/rt3/lib/RT
/CurrentUser.pm line 254
        RT::CurrentUser::LoadByName('RT::CurrentUser=HASH(0x8961e14)', 'Nobody') called at /opt/rt3/lib/RT.pm line 156
        RT::Init() called at /usr/local/etc/freeside/handler.pl line 301
        HTML::Mason::handler('Apache=SCALAR(0x8acc0e8)') called at /dev/null line 0
        eval {...} called at /dev/null line 0


More information about the freeside-users mailing list