[Zope-DB] RE: [ADMIN] Zope and ZPsycopgDA almost working...
Tue, 25 Mar 2003 12:21:21 -0500
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 =3D 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 =
How do I go about overriding the tcpip_socket =3D 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.
> Robert Treat
> On Tue, 2003-03-25 at 01:20, Tamir Halperin wrote:
> > I just figured out how to install ZPsycopgDA into zope on=20
> Windows. I configured it with all the connection string=20
> properties and attempted to add it to my zope folder. Here's=20
> what I got:
> > psycopg.OperationalError
> > could not connect to server: No connection could be made=20
> because the target machine actively refused it.
> > (0x0000274D)
> > Is the server running on host 192.168.1.102 and accepting
> > TCP/IP connections on port 5432?
> > I'm running pgsql 7.3.2 (with openssl installed but not=20
> specifically configured in any way since the installation) on=20
> FreeBSD 4.6. On another box I'm running Zope 2.5 on Win2K pro.
> > I'm not sure how to confirm that the answer to the above=20
> question is "yes". If it is found to be "no" I don't know how=20
> to change it. This is why I'm not sure which mail list to=20
> send this to so I'm sending it to both. Thanks so much in=20
> advance for you help.
> > Tamir