| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Hemil Ruparel <hemilruparel2002(at)gmail(dot)com> |
| Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: How to debug authentication issues in Postgres |
| Date: | 2020-11-28 15:56:55 |
| Message-ID: | b9022916-0cb2-44ff-27c5-0402c293b7b5@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/28/20 6:08 AM, Hemil Ruparel wrote:
> I commented out scram-sha-256 lines for IPv4 and IPv6. I still got
> authentication failure. The log output now says:
> FATAL: password authentication failed for user "centos"
> DETAIL: Connection matched pg_hba.conf line 89: "host database
> user 0.0.0.0/0 <http://0.0.0.0/0> md5"
>
You have to remember we have no idea of how you are trying to make the
connection. So where does this failure occur, with all connection
methods, just DataGrip, some other method?
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-11-28 15:58:26 | Re: How to debug authentication issues in Postgres |
| Previous Message | Hemil Ruparel | 2020-11-28 14:42:40 | Re: How to debug authentication issues in Postgres |