Re: [HACKERS] User authentication bug?

> Hi,
>
> I was having trouble with user authentication, so I submerged myself in
> the source (UTSL ie. Use The Source luke ;) to see if I could figure out
> what I was doing wrong:
>
> While using passwords stored in pg_shadow (pg_user), I cannot connect to
> the backend using the 'password' authentication, I can connect using 'crypt'.
>
> Now, I found from the source that the routines that do crypt checking
> also seem to support plain passwords. But this code is never used,
> because apparently uaCrypt is never set for 'password', while my
> understanding is that this should be set when there is no password-file
> specified in pg_hba.conf.
>
> AlthoughcCheckPassword() seems to provide for this, it appears not to be
> working.
>
> Anybody knows what's going on here? I intent to fire up a debugger here
> to see if I can figure out what's wrong, but thought asking first doesn't
> do any harm.
>
> btw. is there anywhere a good description on how control flows during
> this phase of connecting? It all looks very difficult, with lots of
> function pointer being passed around etc.

Yes, very confusing.  Only Tom Lane understands it, I think.  Maybe
Tatsuo too.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)