[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