From: | Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com> |
---|---|
To: | Bzzzz <lazyvirus(at)gmx(dot)com> |
Cc: | pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Re: Application trying to use wrong user when logging into the database |
Date: | 2021-03-28 14:21:29 |
Message-ID: | b9nwO9kDTQIb4LQmDtlpoRAaYMluRMZRNB3p1S5VyP8DXU7KEZ8H7e9krts_j1LLCfViul__c0rfv2EnIPXuvI8a1Dk0V3FobGGeNmxFuHA=@protonmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Sunday, March 28th, 2021 at 15:00, Bzzzz <lazyvirus(at)gmx(dot)com> wrote:
> 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 :
>
> Jean-Yves
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.
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.
Simon.
From | Date | Subject | |
---|---|---|---|
Next Message | Bzzzz | 2021-03-28 14:44:43 | Re: Application trying to use wrong user when logging into the database |
Previous Message | Bzzzz | 2021-03-28 14:00:04 | Re: Application trying to use wrong user when logging into the database |