[pgpool-general: 7433] Re: Pgpool works on FIPS mode of VA - very important

[Tatsuo Ishii]

Hi Anusha,

> Hi Tatsuo,
> 
> I'm trying to move from md5 to AES for encryption. Getting below error on
> following
> https://www.pgpool.net/docs/latest/en/html/auth-aes-encrypted-password.html
> 
> Can you please help me with this?
> 
> *root at lcm-vrs-48-231 [ *~* ]# *pg_md5 fgdskj
> 
> 8a5bd11420a4cddfe904dd0a023074f0
> 
> *root at lcm-vrs-48-231 [ *~* ]# *pg_enc fhdslihjf
> 
> trying to read key from file /root/.pgpoolkey
> 
> encryption key not provided
> 
> *root at lcm-vrs-48-231 [ *~* ]# *cat /root/.pgpoolkey
> 
> cat: /root/.pgpoolkey: No such file or directory

You need to provide decription key to Pgpool-II: you need to create
~pgpool/.pgpoolkey file ("pgpool" should be replaced with the user
that is used to run pgpool). We don't recommend to run pgpool as root
for security reason.

For more details of .pgpoolkey see the manual:
https://www.pgpool.net/docs/latest/en/html/auth-aes-encrypted-password.html#AUTH-AES-DECRYPTION-KEY

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