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

[Sadhuprasad Patro]

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