Re: Zope and ZPsycopgDA almost working...

On Tue, 2003-03-25 at 12:21, Tamir Halperin wrote:
> Hi Robert. Thanks for the feedback. My comments and questions below...
>
> > -----Original Message-----
> > From: Robert Treat [mailto:xzilla@users.sourceforge.net]
> > Sent: Tuesday, March 25, 2003 10:20 AM
> > To: Tamir Halperin
> > Cc: pgsql-admin@postgresql.org; Zope Database Mailing List
> > Subject: Re: [ADMIN] Zope and ZPsycopgDA almost working...
> >
> > Sounds like your database might not be accepting outside connections.
>
> I agree. Psycopg seems to be saying exactly that from what appears to be a healthy Zope environment.
>
> > Check your postgresql.conf file and make sure tcpip_socket = true
>
> I have a /usr/local/share/postgresql/postgresql.conf.sample file but I don't see a postgresql.conf file anywhere in
thesystem. 
>
> I've confirmed that the sample file is reflecting the default setting of false.
>
> How do I go about overriding the tcpip_socket = false setting for this specific pgsql service?
>
> > You might also need to configure your pg_hba.conf to allow connections
> > from your windows box.
>
> Likewise, I don't see a pg_hba.conf file in my system.
>
> My pg_hba.conf.sample file seems to show a tabular view of permissions of some kind at the bottom:
>
> Type    database    user    ip-address    ip-mask        method
> -------------------------------------------------------------
> local    all        all                        trust
> host    all        all    127.0.0.1    255.255.255.255    trust
>
> Which modifications, if any, are needed to this table.
>
> How do I put them into effect seeing as how this is the sample file we're talking about.
>

According to the guys on IRC, *bsd puts the files in
/usr/local/pgsql/data; if not do a "find" for the files to figure out
where they are. Once you find them, you'll need to set tcpip_sockets =
true and you'll need to add a line like:
host    all        all    <zope box ip>    255.255.255.255    trust
to your pg_hba.conf

you'll need to do a pg_ctl reload once you make the changes.

Robert Treat