Date: Sun, 28 Mar 2021 16:44:43 +0200
From: Bzzzz <lazyvirus@gmx.com>
To: pgsql-novice@lists.postgresql.org
Subject: Re: Application trying to use wrong user when logging into the
 database
Message-ID: <20210328164443.699bba10@msi.defcon1.lan>
In-Reply-To: 
 <b9nwO9kDTQIb4LQmDtlpoRAaYMluRMZRNB3p1S5VyP8DXU7KEZ8H7e9krts_j1LLCfViul__c0rfv2EnIPXuvI8a1Dk0V3FobGGeNmxFuHA=@protonmail.com>
References: 
 <Wt5eqfXFsGBGpT6_-YFFDGuTpOheH21XUc2vodexpEarm11iuomdcCPCOhtJvUnMg35WVoWz72d7tpMmyvdJN-3WGqayIThKQlAFyxVrKRU=@protonmail.com>
	<20210328160004.58d5426d@msi.defcon1.lan>
	<b9nwO9kDTQIb4LQmDtlpoRAaYMluRMZRNB3p1S5VyP8DXU7KEZ8H7e9krts_j1LLCfViul__c0rfv2EnIPXuvI8a1Dk0V3FobGGeNmxFuHA=@protonmail.com>
Organization: Anyone, anywhere BUT in banana demokratik republik of france
 and UERSS.
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/20210328164443.699bba10%40msi.defcon1.lan>
Precedence: bulk

On Sun, 28 Mar 2021 14:21:29 +0000
Simon Connah <simon.n.connah@protonmail.com> wrote:


Rahhhh, it was sent directly to you instead of the ML :(((
re-sending it.

>=20
>=20
> =E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90 Original =
Message =E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90
>=20
> On Sunday, March 28th, 2021 at 15:00, Bzzzz <lazyvirus@gmx.com> wrote:
>=20
> > On Sun, 28 Mar 2021 13:44:59 +0000
> >=20
>=20
> > Simon Connah simon.n.connah@protonmail.com wrote:
> >=20
>=20
> > Hi,
> >=20
>=20
> > > But instead of using my
> > >=20
>=20
> > > applications role which I created in PostgreSQL it is trying to
> > > use my
> > >=20
>=20
> > > Linux user name "simon" and is failing authentication because of
> > > it.
> > >=20
>=20
> > > I'm just confused at the moment. At no point in time have I
> > > created a
> > >=20
>=20
> > > role called "simon" and I have never tried to connect to any of my
> > >=20
>=20
> > > databases using the role name "simon", so why is it trying to
> > >=20
>=20
> > > authenticate as "simon"?
> >=20
>=20
> > Read this and check you're not in this case :
> >=20
>=20
> > https://www.dbrnd.com/2016/12/postgresql-pg_ident-conf-to-map-operating=
-system-username-and-database-username-external-authentication-password/
> >=20
>=20
> > Jean-Yves
>=20
> Thank you for your reply. My pg_ident.conf file is completely empty
> (well all commented out at least). Do you really need to map a Linux
> system user to a PostgreSQL role to get this to work? Seems like a bit
> of a hack to me. I'm probably missing something simple again. I don't
> need external access to the database at the moment, although it is
> helpful knowledge to have for the future.
>=20
> This is all on my local machine so I've set pg_hba.conf to md5 for
> 127.0.0.1/32 which I assumed would just make it work.
>=20
> Simon.

Normal

> Do you really need to map a Linux
> system user to a PostgreSQL role to get this to work? =20

Not at all, as they have nothing in common, except if you use a system
user of course - this looks like just a facility.

> Seems like a bit
> of a hack to me. I'm probably missing something simple again. I don't
> need external access to the database at the moment, although it is
> helpful knowledge to have for the future. =20

As your file's empty, this can only come from your app (hehehe), so try
to launch it under another user to see if it takes the username of
the launcher by default, which seems to be the case (you launched it
under the Linux username 'simon', didn't you !?)

Check the docs to find what is the behavior of the js Pg driver.

Double check your configuration file has the right username _and_ that it
is effectively read by your app (trace each steps w/ prints or logs).

If nothing works, re-write your app in Cobol ;-p)

Jean-Yves