Re: Multiple connections over VPN password fail error

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Sanjay Minni <sanjay(dot)minni(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Cc: daniel(at)yesql(dot)se
Subject: Re: Multiple connections over VPN password fail error
Date: 2024-02-09 11:59:37
Message-ID: f749c1341e91460e915760118e939427c08e7435.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2024-02-09 at 15:04 +0530, Sanjay Minni wrote:
> for the second user/role over vpn
> even with md5 I get the error: 
> P3Error PostgreSQL password authentication failed for user "<seconduser>"
> am only able to connect if method is "trust". Why is this so
>
>   # IPv4 external connections thru VPN
>   #TYPE   DATABASE  USER   ADDRESS  METHOD
>       host   all       all      <ip>       scram-sha-256   (or "md5" - second user is only able to connect if this is "trust"

Please tell us the exact client software in use on the failing client.
Also, what is the error message
1) on the client side
2) in the PostgreSQL server log

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Millas 2024-02-09 15:29:13 Re: Partitioning options
Previous Message Sanjay Minni 2024-02-09 09:34:36 Re: Multiple connections over VPN password fail error