[pgpool-general: 8324] Re: Problems with pool_passwd

[Bo Peng]

Hello,

> pool_passwd = 'passwords.conf'
> This reports 'Password does not match for user "pgpool".' in the postgresql log file.

If you are using a relative path, please make sure passwords.conf exists in the same directory as pgpool.conf.
Otherwise, you need to specify an absolute path.

https://www.pgpool.net/docs/latest/en/html/runtime-config-connection.html#GUC-POOL-PASSWD

On Tue, 5 Jul 2022 16:55:13 +0000
Jon SCHEWE <jon.schewe at raytheon.com> wrote:

> I restarted pgpool between each of my tests.
> 
> 
> Jon Schewe
> 
> Principal Software Systems Technologist
> 
> C: +1 612.263.2718
> 
> O: +1 952.545.5720
> 
> jon.schewe at raytheon.com
> 
> Raytheon BBN
> 
> Raytheon Intelligence & Space
> 
> 5775 Wayzata Blvd. Suite 630
> 
> St. Louis Park, MN 55416
> 
> 
> RTX.com<https://www.rtx.com/> | LinkedIn<https://www.linkedin.com/company/raytheontechnologies> | Twitter<https://twitter.com/raytheontech> | Instagram<https://www.instagram.com/raytheontechnologies>
> 
> ________________________________
> From: Bo Peng <pengbo at sraoss.co.jp>
> Sent: Monday, July 4, 2022 03:10
> To: Jon SCHEWE <jon.schewe at raytheon.com>
> Cc: pgpool-general at pgpool.net <pgpool-general at pgpool.net>
> Subject: [External] Re: [pgpool-general: 8281] Re: Problems with pool_passwd
> 
> Hello,
> 
> > Well, I had it working, but not with the configuration that I thought I had installed.
> > I've gone back and done more testing and found the following:
> 
> If you modified passwords.conf, you need to restart Pgpool-II.
> 
> Regards,
> 
> > > > > I'm having some trouble using pool_passwd with pgpool-II 4.3.2.
> > > > > I'm using the attached pgpool.conf file where I have specified that the pool_passwd file is named "passwords.conf".
> > > > > This file exists and is readable only by the postgres user, which is the same user pgpool-II is running as.
> > > > > This file contains:
> > > > > sr_check_password = 'TEXTpass1'
> > > > > health_check_password = 'TEXTpass2'
> > > > > recovery_password = 'TEXTpass3'
> > > >
> > > > The format of "passwords.conf" should be:
> > > >
> > > >    <username>:<password>
> > > >
> > > >
> > > > If your pgpool.conf settings are:
> > > >
> > > > sr_check_user = 'pgpool'
> > > > sr_check_password=''
> > > > health_check_user = 'pgpool'
> > > > health_check_password = ''
> > > > recovery_user = 'postgres'
> > > > recovery_password = ''
> > > >
> > > > passwords.conf should be:
> > > >
> > > > pgpool:TEXTpasswordofpgpool
> > > > postgres:TEXTpasswordofpostgres
> > >
> > > Thank you for the corrections. I had assumed that the format of the passwords.conf file would be the same as pgpool.conf and that it would use the keys from the conf file.
> > > However I see that this is generic for any database user so it makes perfect sense as it is.
> > > Now everything is working.
> > > Thank you!
> >
> > Well, I had it working, but not with the configuration that I thought I had installed.
> > I've gone back and done more testing and found the following:
> >
> > This works:
> > --- pgpool.conf ---
> > pool_passwd = 'passwords.conf'
> > sr_check_user = 'pgpool'
> > sr_check_password='password1'
> > health_check_user = 'pgpool'
> > health_check_password = 'password1'
> > recovery_user = 'postgres'
> > recovery_password = 'password2'
> >
> >
> > This reports 'Password does not match for user "pgpool".' in the postgresql log file.
> > --- pgpool.conf ---
> > pool_passwd = 'passwords.conf'
> > sr_check_user = 'pgpool'
> > sr_check_password=''
> > health_check_user = 'pgpool'
> > health_check_password = ''
> > recovery_user = 'postgres'
> > recovery_password = ''
> >
> > --- passwords.conf ---
> > pgpool:TEXTpassword1
> > postgres:TEXTpassword2
> >
> >
> > This reports 'Password does not match for user "pgpool".' in the postgresql log file.
> > --- pgpool.conf ---
> > pool_passwd = 'passwords.conf'
> > sr_check_user = 'pgpool'
> > sr_check_password=''
> > health_check_user = 'pgpool'
> > health_check_password = ''
> > recovery_user = 'postgres'
> > recovery_password = ''
> >
> > --- passwords.conf ---
> > pgpool:password1
> > postgres:password2
> >
> >
> > Jon Schewe
> 
> 
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS, Inc. Japan
> https://www.sraoss.co.jp/


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