[Zope-DB] Re: [ADMIN] Zope and ZPsycopgDA almost working...
25 Mar 2003 13:39:36 -0500
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:email@example.com]
> > Sent: Tuesday, March 25, 2003 10:20 AM
> > To: Tamir Halperin
> > Cc: firstname.lastname@example.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 the system.
> 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.