[pgpool-hackers: 3081] Re: Pgpool-II 4.0 alpha2 show-stoppers

Jesper Pedersen jesper.pedersen at redhat.com
Fri Oct 19 20:08:51 JST 2018


Hi,

On 10/3/18 10:36 AM, Tatsuo Ishii wrote:
>> On 8/24/18 7:46 AM, Jesper Pedersen wrote:
>>>> Please add items if I missed something.
>>> 7) 0000419: pg_md5: -m removes users
>>>      - https://www.pgpool.net/mantisbt/view.php?id=419
>>
>> This will make its way into 4.0.0, correct ?
> 
> I believe so. Please let me know if you find any problem with pg_md5.
> 

So, this made its way into 4.0.0 which will corrupt pool_passwd;

pg_md5 -f conf/pgpool.conf -u user1 -m user1
pg_md5 -f conf/pgpool.conf -u user2 -m user2
pg_md5 -f conf/pgpool.conf -u user3 -m user3

cat conf/pgpool.conf
user1:md57d1b5a4329b6478e976508ab9a49ee3d
user2:md572881e285cdb0f9370dcdf1db0d9a869
user3:md516bd93afc66e593f3aeedecdf1201ee6

pg_enc -f conf/pgpool.conf -u user1 -m user1

cat conf/pgpool.conf
user1:AES1MLVcB4ex/cCqL24k1H8wQ==
a49ee3d
user2:md572881e285cdb0f9370dcdf1db0d9a869
user3:md516bd93afc66e593f3aeedecdf1201ee6

pg_enc -f conf/pgpool.conf -u user2 -m user2

cat conf/pgpool.conf
user1:AES1MLVcB4ex/cCqL24k1H8wQ==
a49ee3d
user2:md572881e285cdb0f9370dcdf1db0d9a869
user3:md516bd93afc66e593f3aeedecdf1201ee6
user2:AESFndsqgtIUnJSEr0yn1cTQA==


Pending patches:

http://www.sraoss.jp/pipermail/pgpool-hackers/2018-August/002955.html
http://www.sraoss.jp/pipermail/pgpool-hackers/2018-August/003017.html
http://www.sraoss.jp/pipermail/pgpool-hackers/2018-August/003025.html

Best regards,
  Jesper


More information about the pgpool-hackers mailing list