Re: Application trying to use wrong user when logging into the database

From: Bzzzz <lazyvirus(at)gmx(dot)com>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Cc: Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com>
Subject: Re: Application trying to use wrong user when logging into the database
Date: 2021-03-28 14:00:04
Message-ID: 20210328160004.58d5426d@msi.defcon1.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sun, 28 Mar 2021 13:44:59 +0000
Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com> wrote:

Hi,

> But instead of using my
> applications role which I created in PostgreSQL it is trying to use my
> Linux user name "simon" and is failing authentication because of it.
> I'm just confused at the moment. At no point in time have I created a
> role called "simon" and I have never tried to connect to any of my
> databases using the role name "simon", so why is it trying to
> authenticate as "simon"?

Read this and check you're not in this case :
https://www.dbrnd.com/2016/12/postgresql-pg_ident-conf-to-map-operating-system-username-and-database-username-external-authentication-password/

Jean-Yves

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Simon Connah 2021-03-28 14:21:29 Re: Application trying to use wrong user when logging into the database
Previous Message Simon Connah 2021-03-28 13:44:59 Application trying to use wrong user when logging into the database