[pgpool-hackers: 2975] Pgpool-II 4.0 vs. pool_passwd

Tatsuo Ishii ishii at sraoss.co.jp
Tue Aug 21 17:07:30 JST 2018


Hi Usama,

What are the password formats allowed in pool_passwd?

I know at least several formats:

1) md5

t-ishii:md5ce4cf1572c8167c097638820177cbc05

2) AES256

t-ishii:AESc7iO9vVbTxOaY+JSWTbPqA==

But what about clear text password? Do you suppose it is allowed in pool_passwd?

Also I wonder we can safely mix up md5/AES256 formats in pool_passwd
because I see corrpuption in pool_passwd if I update one of the
password.

t-ishii at tishii-CFSV7-1:/tmp/aaa$ cat etc/pool_passwd 
t-ishii:md5ce4cf1572c8167c097638820177cbc05
foo:md5fdba98970961edb29f88241b9d99d890

t-ishii at tishii-CFSV7-1:/tmp/aaa$ pg_enc -m -f etc/pgpool.conf -p
db password: 

trying to read key from file /home/t-ishii/.pgpoolkey
WARNING: pid 23000: pool key file "/home/t-ishii/.pgpoolkey" is not a text file

t-ishii at tishii-CFSV7-1:/tmp/aaa$ cat etc/pool_passwd 
t-ishii:AESc7iO9vVbTxOaY+JSWTbPqA==
77cbc05
foo:md5fdba98970961edb29f88241b9d99d890

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


More information about the pgpool-hackers mailing list