Re: How to debug authentication issues in Postgres

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 md5"

On Sat, Nov 28, 2020 at 7:34 PM Hemil Ruparel <hemilruparel2002(at)gmail(dot)com>
wrote:

> Yes. Password encryption is set to scram-sha-256.
>
> On Fri, Nov 27, 2020 at 10:36 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> wrote:
>
>> On 11/27/20 12:37 AM, Hemil Ruparel wrote:
>> > The log says:
>> > > FATAL: password authentication failed for user "centos"
>> > > DETAIL: Connection matched pg_hba.conf line 88: "host user
>> > password 0.0.0.0/0 <http://0.0.0.0/0> scram-sha-256"
>>
>> To me that looks like a strange line for pg_hba.conf and I don't see it
>> in the pg_hba.conf file you sent earlier.
>>
>> What is line 88 in your pg_hba.conf?
>>
>> >
>> > I can't understand where is the problem as both psql and pgadmin
>> connect
>> > without problems using the same password
>> >
>> > On Fri, Nov 27, 2020 at 1:46 PM Hemil Ruparel
>> > <hemilruparel2002(at)gmail(dot)com <mailto:hemilruparel2002(at)gmail(dot)com>> wrote:
>> >
>> > Sorry. This was the replication section:
>> > local replication all peer
>> > host replication all 127.0.0.1/32 <http://127.0.0.1/32>
>>
>> > scram-sha-256
>> > host replication all ::1/128
>> > scram-sha-256
>> >
>> > On Fri, Nov 27, 2020 at 1:41 PM Laurenz Albe
>> > <laurenz(dot)albe(at)cybertec(dot)at <mailto:laurenz(dot)albe(at)cybertec(dot)at>> wrote:
>> >
>> > On Fri, 2020-11-27 at 13:34 +0530, Hemil Ruparel wrote:
>> > > I have restarted postgres quite a few times to try making
>> > configuration changes and it
>> > > is always back up. I don't know how. Feels weird to me. I
>> > didn't add the line
>> > > "local replication all". It was there by default
>> >
>> > I don't believe that.
>> >
>> > This is how it looks by default:
>> >
>> > # Allow replication connections from localhost, by a user with
>> the
>> > # replication privilege.
>> > local replication all
>> > trust
>> > host replication all 127.0.0.1/32 <http://127.0.0.1/32>
>> > trust
>> > host replication all ::1/128
>> > trust
>> >
>> > Yours,
>> > Laurenz Albe
>> > --
>> > Cybertec | https://www.cybertec-postgresql.com
>> > <https://www.cybertec-postgresql.com>
>> >
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>>
>