[Zope] RE: [Psycopg] Authentication Problem with Postgres

[Paul Zwarts]

Andre,

Hmmm... This is a bit over my head. I don't see why zope would be
sending something different after a restart. I've cross-posted this to
the zope list because there are some hard-hitters there that will know
more (if Frederico doesn't get to it first : ))

You are correct though, the dbase connections should be persistent (at
least they are for me). Perhaps you have manually coded your ZPsycopgDA
to do the password encrypting? Because I'm reasonably _sure_ the
connection string from within the zope management interface is
cleartext. Perhaps something between Zope, ZPsycopgDA and postgres is
going wrong. 

Sorry I cant help more,
Paul Zwarts

-----Original Message-----
From: andre@oratrix.nl [mailto:andre@oratrix.nl] On Behalf Of Andre
Schubert
Sent: Friday, November 23, 2001 11:33 AM
To: Paul Zwarts
Cc: psycopg@lists.initd.org
Subject: Re: [Psycopg] Authentication Problem with Postgres

Hi Paul,

Zope and Postgres are running on different machines. Postgres only
allows crypted session.
We have traced only crypted passwords.
I think the problem is that there is a wrong password crypted and then
sent to postgres, and after a restart the right password is crypted and
sent to postgres????
But why does Zope send a password again, i thought the connections of
Zope where persistent connections???
How can a track down connection-establishing??

Thanks as

Paul Zwarts schrieb:
> 
> Andre,
> 
> How is your encryption done? Zope authenticates using cleartext
locally
> AFAIK... and then again I could be wrong. But perhaps this is why you
> have the problem?
> 
> Postgres (IMHO) should be set to restrict access to only local
machines.
> That way encrypted passwords are not necessary because it can only
come
> from the machine running zope (same machine if postgres lives there as
> well)
> 
> Regards,
> Paul Zwarts
> 
> -----Original Message-----
> From: psycopg-admin@lists.initd.org
> [mailto:psycopg-admin@lists.initd.org] On Behalf Of Andre Schubert
> Sent: Friday, November 23, 2001 11:08 AM
> To: psycopg@lists.initd.org; pgsql-admin@postgresql.org
> Subject: [Psycopg] Authentication Problem with Postgres
> 
> Hi all,
> 
> sometimes i have a curios problem with my Zope.
> Without any errors in any logs Zope could not authenticate himself
with
> postgres.
> The error message is that there is a wrong password.
> After a restart of Zope everything works fine until the eror occurs
> again.
> 
> My sysop has traced the protcols before and after the error.
> Zope sends some data and then a crypted password with the salt.
> If the error is occured the password that Zope sends is crypted wrong.
> After a restart of Zope the password is right crypted.
> 
> Could anybody help or explain me this problem, it is very important
for
> the further use of Zope
> for our websites.
> 
> Thanks as
> _______________________________________________
> Psycopg mailing list
> Psycopg@lists.initd.org
> http://lists.initd.org/mailman/listinfo/psycopg
> 
> _______________________________________________
> Psycopg mailing list
> Psycopg@lists.initd.org
> http://lists.initd.org/mailman/listinfo/psycopg