[freeside-users] RT install failure

[Ivan Kohler]

It doesn't look like you have the RT tables.  Run "make create-rt" and 
ensure it creates the database tables sucessfully.

-- 
_ivan


On Sun, Aug 20, 2006 at 04:30:43PM -0500, Gerald V. Livingston II wrote:
> 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
> 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

> _______________________________________________
> freeside-users mailing list
> freeside-users at sisd.com
> http://420.am/cgi-bin/mailman/listinfo/freeside-users