How to troubleshoot authentication failure?

From: Kynn Jones <kynnjo(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: How to troubleshoot authentication failure?
Date: 2009-10-07 14:57:41
Message-ID: c2350ba40910070757k2313d5a9q1ffa2bc950cd2058@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have two Linux servers that are pretty similar to each other, and both are
running PostgreSQL servers, but in one server a certain Perl script succeeds
in connecting to the localhost server whereas in the other one the same
script fails. The error on the second server is of the form "fe_sendauth:
no password supplied".
I have verified all the possible reasons that I can think of for why this
script succeeds on one server but fails on the other. In all these respects
the two set ups are absolutely identical: same pg_hba.conf files, same
script parameters, same versions of Postgres, same everything.

I have run out of ideas!

How can I troubleshoot this further? Is there some way to have Postgres
dump excruciatingly thorough details about every single step of the
authentication sequence?

Any other suggestions would be greatly appreciated.

Thanks!

k

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-10-07 15:17:21 Re: How to troubleshoot authentication failure?
Previous Message Alvaro Herrera 2009-10-07 14:24:34 Re: Need help in spi_prepare errors