[pgpool-hackers: 4549] Re: PgPool doesn't update password into the file mentioned in pool_passwd parameter

[Bo Peng]

Hi,

Fix is committed:

https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=8d4fb84c8002442d8ec8e5b8e7bee0ebe18a75ff

Thank you for reporting this issue.

On Tue, 3 Dec 2024 12:35:20 +0530
Sadhuprasad Patro <b.sadhu at gmail.com> wrote:

> Thank you Bo Peng...
> 
> On Tue, Dec 3, 2024 at 5:50 AM Bo Peng <pengbo at sraoss.co.jp> wrote:
> >
> > Hi,
> >
> > Thank you for reporting this issue.
> >
> > It is a bug of pg_enc and pg_md5.
> > I am working on fixing it.
> >
> > I will let you know once the fix has been committed.
> >
> > On Mon, 2 Dec 2024 12:18:32 +0530
> > Sadhuprasad Patro <b.sadhu at gmail.com> wrote:
> >
> > > Hi Hackers,
> > >
> > > Checked in PgPool 4.5 version.
> > >
> > > During the test, we modified the location of the "pool_passwd"
> > > parameter in pgpool.conf file and restarted the PGPOOL services.
> > > Then we executed the "pg_enc" utility to update the password but it is
> > > updating the password in old file "/etc/pgpool-II/pgpool.conf" rather
> > > than "/home/postgres/pool_passwd" new file.
> > >
> > >
> > > #-- modifying location
> > > [postgres at pgpgp01 ~]$ vi /etc/pgpool-II/pgpool.conf
> > > [postgres at pgpgp01 ~]$ cat /etc/pgpool-II/pgpool.conf|grep pool_passwd
> > > pool_passwd = '/home/postgres/pool_passwd'
> > >
> > > #-- restart pgpool
> > > [postgres at pgpgp01 ~]$ pgpool stop
> > > 2024-11-22 08:27:41.060: main pid 24051: LOG:  stop request sent to
> > > pgpool (pid: 5372). waiting for termination...
> > > .done.
> > > [postgres at pgpgp01 ~]$ pgpool -D -f /etc/pgpool-II/pgpool.conf
> > > -rw-rw-r--.  1 postgres postgres    0 Nov 22 08:27 pool_passwd
> > > [postgres at pgpgp01 ~]$ cat /home/postgres/pool_passwd
> > > [postgres at pgpgp01 ~]$
> > > [postgres at pgpgp01 ~]$ cat /etc/pgpool-II/pool_passwd
> > > pgpool:AESTceUCq7IXKAqtzX5L6t1Tw==
> > >
> > > #-- generate password
> > > [postgres at pgpgp01 ~]$ pg_enc -k .pgpoolkey -f
> > > /etc/pgpool-II/pgpool.conf -m -u test test
> > > trying to read key from file .pgpoolkey
> > > [postgres at pgpgp01 ~]$ cat /home/postgres/pool_passwd -- current
> > > "pool_passwd" location
> > > [postgres at pgpgp01 ~]$ cat /etc/pgpool-II/pool_passwd -- not current
> > > "pool_passwd" location
> > > pgpool:AESTceUCq7IXKAqtzX5L6t1Tw==
> > > test:AESKA9Z8LUAIaomz6Jl3fRLVQ==
> > >
> > >
> > > Why does Pgpool-II keep updating the old pool_passwd file even after I
> > > modified its location?
> > > Please help to understand this as a behavior or there is some issue...
> > > --
> > > thank u
> > >                SADHU PRASAD
> > > _______________________________________________
> > > pgpool-hackers mailing list
> > > pgpool-hackers at pgpool.net
> > > http://www.pgpool.net/mailman/listinfo/pgpool-hackers
> >
> >
> > --
> > Bo Peng <pengbo at sraoss.co.jp>
> > SRA OSS K.K.
> > TEL: 03-5979-2701 FAX: 03-5979-2702
> > URL: https://www.sraoss.co.jp/
> 
> 
> 
> -- 
> thank u
>                SADHU PRASAD


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS K.K.
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/