Re: [stellation-res] Checkin of database abstraction layer

["Mark C. Chu-Carroll" <mcc@xxxxxxxxxxxxxxxxxxxxx>]

On Sat, 2002-08-31 at 01:27, Rodolfo M. Raya wrote:
> On Fri, 2002-08-30 at 17:57, Mark C. Chu-Carroll wrote:
> 
> 
>     Sorry... In the new code, it's using "postgres:" as the location prefix.
>     Try that, and see if it fixes it. (It's a bug either way, but it's a
>     simple-to-fix bug if it's just a null pointer caused by not handling an
>     unknown location prefix correctly.)
> 
> 
> Thanks for the tip. Tried again and now the error is different:
> 
> 
> Error Initializing database: org.eclipse.stellation.repos.database.DatabaseConnectionException: Error connecting to database serverConnection refused. Check that the hostname and port is correct, and that the postmaster is running with the -i flag, which enables TCP/IP networking.
> 
> It seems that I have a problem with postgres configuration but I don't know what it is. I will check what's wrong tomorrow.
> 
> If I can't fix my postgres setup, I will try to replace it with firebird.

That's a familiar problem. The default postgres installation runs 
the postmaster daemon in a mode where it's not listening for socket
connections. There's one line of the postgres config file that needs to
be changed:

In "/var/lib/pgsql/data/postgresql.conf", uncomment the line containing
tcpip_socket and setting the parameter to true. This provides the same
function formerly done using the -i parameter.

Then restart postgres ("service postgresql restart" as root), and it
should work.

	-Mark

-- 
Mark Craig Chu-Carroll,  IBM T.J. Watson Research Center  
*** The Stellation project: Advanced SCM for Collaboration
***		http://www.eclipse.org/stellation
*** Work Email: mcc@xxxxxxxxxxxxxx  ------- Personal Email:
markcc@xxxxxxxxxxx