public inbox for [email protected]  

help / color / mirror / Atom feed

From: hubert depesz lubaczewski <[email protected]>
To: Simon Connah <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Application trying to use wrong user when logging into the database
Date: Mon, 29 Mar 2021 11:47:59 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <Wt5eqfXFsGBGpT6_-YFFDGuTpOheH21XUc2vodexpEarm11iuomdcCPCOhtJvUnMg35WVoWz72d7tpMmyvdJN-3WGqayIThKQlAFyxVrKRU=@protonmail.com>
References: <Wt5eqfXFsGBGpT6_-YFFDGuTpOheH21XUc2vodexpEarm11iuomdcCPCOhtJvUnMg35WVoWz72d7tpMmyvdJN-3WGqayIThKQlAFyxVrKRU=@protonmail.com>

On Sun, Mar 28, 2021 at 01:44:59PM +0000, Simon Connah wrote:
> https://github.com/vitaly-t/pg-promise/wiki/Connection-Syntax#configuration-object
> 
> and have all the right data supplied. 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"?

Pg will try to connect as db user simon if you don't provide username to
log in as.

For example, if I'm logged in shell as depesz, and will try: psql -d xx,
it will try to login to db xx as user depesz.

To login as user "magic", I have to provide it expliticly: psql -U magic
-d xx.

Please show us your connection code from your app.

Best regards,

depesz

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Application trying to use wrong user when logging into the database
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox