[pgpool-hackers: 2938] Re: pg_md5: Usability

[Jesper Pedersen]

Hi,

On 08/09/2018 11:02 PM, Tatsuo Ishii wrote:
>> First my use-case; I need to create the pool_passwd before pgpool is
>> started, so I need to use
>>
>>   pg_md5 -m -f conf/pgpool.conf -u md5_user md5_password
>>
>> which I know is deprecated; I can't use -p, since this a
>> non-interactive script. Maybe there should be an option for an input
>> file with users / passwords in unencrypted format (user:password).
> 
> Sounds an idea.
> 

Thanks, I have logged that as Issue 422.

>> Attached is a small documentation patch, but if somebody could explain
>> the idea behind and use-cases for the w/o -m case (68675...) then I
>> can include that in my patch.
> 
> It's used to create pcp.conf which stores a password used by pcp
> commands.
> 

Thanks - the attached patch tries to expand on the documentation in this 
area.

It could be an idea to add support for the "user:md5XXX" syntax in 
pcp.conf too. That way the non-md5 syntax could be deprecated, and 
pg_md5 would only have to support one format.

I ran into some other issues with pg_md5, but those have been logged 
under Bug 419 and Bug 420.

Thanks for considering !

Best regards,
  Jesper
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0001-pg_md5-documentation_v2.patch
Type: text/x-patch
Size: 2174 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20180810/201bf6dc/attachment-0001.bin>