[freeside-users] RT install failure

[Gerald V. Livingston II]

Thank you. I re-ran it and dug back up through the screen output. "failed
to connect to database as user freeside" during the create phase.

Turns out it's Debian's default postgresql security settings only allow one
to connect as the current UID. Eg. "root" cannot do a "psql -U freeside
..." and hope to have it work without tweaking the postgresql config.

I've got the basic freeside install done (again). Before I start adding
customers should I wipe it out and use backports to install PostgreSQL 8.x
and start from scratch again? The current version installed by Sarge is
7.4.x

Looks like the boss is actually going to allow me time to get this working
now (after 3+ years). The legacy billing system barfed more than once over
the last couple of billing cycles and there is no longer any support for
it.

Thanks again,

Gerald

On Fri, 25 Aug 2006 13:07:08 -0700 Ivan Kohler <ivan at 420.am> wrote:

> 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.