Search Postgresql Archives

Re: How to debug authentication issues in Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This seems extremely odd. I can connect to my database using python's psycopg2 library. Most likely this is either an extremely stupid mistake on my side, or worst case some edge condition jdbc doesnt handle?

On Sat, Nov 28, 2020 at 7:40 PM Hemil Ruparel <hemilruparel2002@xxxxxxxxx> wrote:
Line 88 is this line: host    database    user          0.0.0.0/0               scram-sha-256.

I might have forgotten to change one of the names in the earlier mails.

On Sat, Nov 28, 2020 at 7:38 PM Hemil Ruparel <hemilruparel2002@xxxxxxxxx> 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               md5"

On Sat, Nov 28, 2020 at 7:34 PM Hemil Ruparel <hemilruparel2002@xxxxxxxxx> wrote:
Yes. Password encryption is set to scram-sha-256.

On Fri, Nov 27, 2020 at 10:36 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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@xxxxxxxxx <mailto:hemilruparel2002@xxxxxxxxx>> 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.albe@xxxxxxxxxxx <mailto:laurenz.albe@xxxxxxxxxxx>> 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.klaver@xxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux