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

[Bo Peng]

Thank you for your patch.
We will test your patch.

On Fri, 10 Aug 2018 13:52:50 -0400
Jesper Pedersen <jesper.pedersen at redhat.com> wrote:

> 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


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan