RE: [Phpgroupware-users] install problems with postgres (same as bug #456)

[Phil Glaser]

Sounds similar to a problem I had under Red Hat. By default postmaster
listens only on a Unix domain socket. To change this, open
/var/lib/pgsql/data/postgresql.conf and modify the "tcpip-socket" option to
"true". you'll need to restart posgresql. You can check that postgresql is
listening on tcp/ip socket port 5432 (or other port if you've so configured)
by executing "nmap localhost".

BTW, if you're interested in the difference between a TCP/IP and Unix Domain
socket, see http://www.tldp.org/HOWTO/Secure-Programs-HOWTO/sockets.html and
http://world.std.com/~jimf/papers/sockets/sockets.html

Best of luck.

Philip Glaser
Principal and Software Architect
Sustainable Software Solutions, LLC
address@hidden
www.sustainsoft.com
973-951-9522




> -----Original Message-----
> From: address@hidden
> [mailto:address@hidden Behalf Of Moritz Lennert
> Sent: Wednesday, July 10, 2002 11:51 AM
> To: address@hidden
> Subject: Re: [Phpgroupware-users] install problems with postgres (same
> as bug #456)
>
>
> Hi again,
>
> I insist because I really would like to get phpgroupware to work,
> it seems such a great piece of software. So, no idea what might
> be going wrong ?
>
> Moritz
>
>
> On Tue, Jul 09, 2002 at 03:15:10PM +0200, Moritz Lennert wrote:
> > On Tue, Jul 09, 2002 at 12:57:14PM +0000, Guillaume Courtois wrote:
> > > >I have the same problem as related in bug 456 (also in
> Phpgroupware-users list message: "Installation and Configuration
> Questions":
> > > >
> > > >when I go try to enter the "Setup/Config Admin Login", I get
> the page with:
> > > >
> > > >******
> > > >Database error: Link-ID == false, connect failed
> > > >PostgreSQL Error: 0 ()
> > > >
> > > >Session halted.
> > > >*******
> > > >
> > > >Has a solution been found to this problem ?
> > >
> > > Did you authorize the local connection to postgres (the
> server must be started with the -i option) ?
> > >
> >
> > In /etc/postgresql/postgresql.conf
> >
> > tcpip_socket is set to 1 (which should be the equivalent of the
> -i option)
> >
> > and in /etc/postgresql/pg_hba.conf
> >
> > it says:
> >
> > local        all
> ident sameuser
> > host         all         127.0.0.1     255.0.0.0
> ident sameuser
> > host         all         0.0.0.0       0.0.0.0             reject
> >
> > Which should be alright since I'm just testing phpgroupware on
> localhost, not over a network.
> >
> > Moritz
>
>
>