BUG #17032: wrong password cause double connect and double error

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: rekgrpth(at)gmail(dot)com
Subject: BUG #17032: wrong password cause double connect and double error
Date: 2021-05-25 11:50:30
Message-ID: 17032-7ad69968e744de35@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17032
Logged by: RekGRpth
Email address: rekgrpth(at)gmail(dot)com
PostgreSQL version: 13.3
Operating system: docker alpine
Description:

1) create user test with password test and database test with owner test
2) add md5 auth for this user in pg_hba.conf like host test test
172.19.0.0/16 md5
3) compile test program src/postgres/src/test/examples/testlibpq.c
4) run test program with argument "host=postgres user=test password=wrong"
5) get double error on client side:
Connection to database failed: FATAL: password authentication failed for
user "test"
FATAL: password authentication failed for user "test"
6) and get double connection and double error on server side:
2021-05-25 16:49:42.868 +05 [46654] postgres(43832)
[unknown](at)[unknown]/[unknown] LOG: connection received: host=postgres
port=43832
2021-05-25 16:49:42.876 +05 [46654] postgres(43832) test(at)test/[unknown]
FATAL: password authentication failed for user "test"
2021-05-25 16:49:42.876 +05 [46654] postgres(43832) test(at)test/[unknown]
DETAIL: Password does not match for user "test".
Connection matched pg_hba.conf line 99: "host test test 172.19.0.0/16
md5"
2021-05-25 16:49:42.877 +05 [46655] postgres(43834)
[unknown](at)[unknown]/[unknown] LOG: connection received: host=postgres
port=43834
2021-05-25 16:49:42.878 +05 [46655] postgres(43834) test(at)test/[unknown]
FATAL: password authentication failed for user "test"
2021-05-25 16:49:42.878 +05 [46655] postgres(43834) test(at)test/[unknown]
DETAIL: Password does not match for user "test".
Connection matched pg_hba.conf line 99: "host test test 172.19.0.0/16 md5"

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kämpf 2021-05-25 12:03:01 AW: BUG #16858: clang10-devel packages are missing in SLES15 SP2 in general
Previous Message David Rowley 2021-05-25 00:52:40 Re: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1