[pgpool-hackers: 3377] allow_clear_text_frontend_auth sometimes does not work

[Tatsuo Ishii]

Hi Usama,

While investigating:

https://www.pgpool.net/mantisbt/view.php?id=534

I think there might be a issue with allow_clear_text_frontend_auth in
certain case.

1) allow_clear_text_frontend_auth = on
2) user set md5 password in PostgreSQL
3) user set "password", instead of "md5" in pg_hba.conf

If all the conditions above are met, Pgpool-II always fails with
authentication.

2019-08-06 13:57:45: pid 16823: FATAL: clear text password authentication failed
2019-08-06 13:57:45: pid 16823: DETAIL: unable to get the password for user: "postgres"
2019-08-06 13:57:45: pid 16823: LOCATION: pool_auth.c:1018
2019-08-06 13:57:45: pid 16823: DEBUG: pool_write: to frontend: kind:E po:0
2019-08-06 13:57:45: pid 16823: LOCATION: pool_stream.c:461

The setting is above is valid and in fact if directly connecting to
PostgreSQL, auth succeeds.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp