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

[Bo Peng]

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/