[pgpool-hackers: 4589] If reading password from .pcppass file fails, try to read it from prompt.

[Bo Peng]

Currently, if password cannot be retrieved from .pcppass file, pcp command fails with the following messages:

    FATAL:  authentication failed for user "<username>"
    DETAIL:  username and/or password does not match

If reading the password from the .pcppass file fails, it should fall back to prompting the user for input, similar to how PostgreSQL handles .pgpass.

Patch is attached. 
This patch also changes the following messages to be displayed without requiring the --debug option:

    WARNING: password file \"%s\" is not a plain file
    WARNING: password file \"%s\" has group or world access; permissions should be u=rw (0600) or less

Any comments?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pcppass.patch
Type: application/octet-stream
Size: 1712 bytes
Desc: pcppass.patch
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20250508/f6d2b1d8/attachment.obj>