From: | Dhirendra Singh <dhirendraks(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Question about cert authentication method. |
Date: | 2022-11-25 10:06:00 |
Message-ID: | CAEyh4sZ3pSdpFFCR1x8gLDsrB3SbPHG2WarB+uJR75ZUOiR3dg@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi All,
I have a question about cert authentication method. I am using postgres
version 14.
Following is the entry i have in the pg_hba file.
hostssl all all 0.0.0.0/0 cert map=mymap
Following is the entry in the pg_ident file.
mymap test readonly
trying to connect to the server using psql. CN in the certificate is "test
(S114546)".
psql "host=localhost user='test (S114546)' dbname=appdb sslmode=verify-full
sslcert=certificate.crt sslkey=certificate.key sslrootcert=cacerts"
No mapping exist for "test (S114547)" in the pg_ident file.
The connection failed with following error.
psql: error: connection to server at "localhost", port 5432 failed: FATAL:
certificate authentication failed for user "test (S114546)"
Error in the server log is...
2022-11-25 09:26:52.169 UTC [62] LOG: no match in usermap "mymap" for user
"test (S114546)" authenticated as "test (S114546)"
2022-11-25 09:26:52.169 UTC [62] FATAL: certificate authentication failed
for user "test (S114546)"
2022-11-25 09:26:52.169 UTC [62] DETAIL: Connection matched pg_hba.conf
line 4: "hostssl all all 0.0.0.0/0 cert map=mymap"
I am expecting the connection to fail because user "test (S114546) does not
exist. but i am confused about the error message in the server log.
It says certificate authentication failed for user "test (S114546)". but
CN in the certificate matches with the user name in psql connection request.
So certificate authentication should pass. It should fail afterwards.
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2022-11-25 11:54:20 | Re: Question about cert authentication method. |
Previous Message | Dhirendra Singh | 2022-11-25 08:50:13 | Re: Difference between host, hostssl and hostnossl connection type |