[freeside-users] RT install failure

[Ivan Kohler]

On Fri, Aug 25, 2006 at 05:56:18PM -0500, Gerald V. Livingston II wrote:
> 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?

no

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