Skip site navigation (1) Skip section navigation (2)

Re: [Fwd: [Zope-dev] Authentication Problem with Postgres]

From: Andre Schubert <andre(dot)schubert(at)geyer(dot)kabeljournal(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "psycopg(at)lists(dot)initd(dot)org" <psycopg(at)lists(dot)initd(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [Fwd: [Zope-dev] Authentication Problem with Postgres]
Date: 2001-11-26 09:56:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Tom Lane schrieb:
> Andre Schubert <andre(dot)schubert(at)geyer(dot)kabeljournal(dot)de> writes:
> > sometimes i have a curios problem with my Zope.
> > 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.
> If you've determined that in fact the wrong password is being sent
> from the client side, then it seems that there are only two
> possibilities: one, Zope is handing the wrong password to libpq,
> or two, there's something broken in the crypt library on your client
> machine.  libpq's handling of the password is so trivial that I find
> it hard to see how there could be such a problem inside libpq itself.
> If you're not convinced, I'd suggest adding some debug logging printout
> to libpq (look in fe-connect.c and fe-auth.c).  Try tracing the
> arguments and result of the actual crypt() call in fe-auth.c, and
> then work outwards if you need to.
> You didn't say what platform you're on, but on some platforms I believe
> that crypt() supports both traditional (DES variant) and MD5 encryption
> styles.  Possibly the problem is somehow related to choosing the wrong
> encryption style (where "wrong" = "not what the postmaster is using").

Zope(2.3.3) runs on a Immunix RedHat 6.2.
All Client Libraries are 7.1.3.
The Postgres-Server 7.1.3 runs on another Immunix RedHat 6.2 box.

thanks as

>                         regards, tom lane

In response to

pgsql-admin by date

Next:From: Luis AmigoDate: 2001-11-26 10:35:13
Subject: installing 7.2b3 on IRIX 6.5.13
Previous:From: Ian BarwickDate: 2001-11-25 17:01:54
Subject: Re: table permissions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group