Re: Zope and ZPsycopgDA almost working...

Hi Robert. Thanks for the feedback. My comments and questions below...

> -----Original Message-----
> From: Robert Treat [mailto:xzilla(at)users(dot)sourceforge(dot)net]
> Sent: Tuesday, March 25, 2003 10:20 AM
> To: Tamir Halperin
> Cc: pgsql-admin(at)postgresql(dot)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.

> Robert Treat
>
> On Tue, 2003-03-25 at 01:20, Tamir Halperin wrote:
> > I just figured out how to install ZPsycopgDA into zope on
> Windows. I configured it with all the connection string
> properties and attempted to add it to my zope folder. Here's
> what I got:
> >
> > psycopg.OperationalError
> > could not connect to server: No connection could be made
> 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
> specifically configured in any way since the installation) on
> 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
> question is "yes". If it is found to be "no" I don't know how
> to change it. This is why I'm not sure which mail list to
> send this to so I'm sending it to both. Thanks so much in
> advance for you help.
> >
> > Tamir