[pgpool-general: 6582] Re: Error "unable to decrypt password from pool_passwd

[Lionel Engel]

Hello again,

So I have noticed that I am starting the service (*service pgpool start*)
as root, but pgpool is run as postgres user.

Best regards,

Lionel Engel

Le mer. 5 juin 2019 à 08:14, Lionel Engel <lionel.engel6 at gmail.com> a
écrit :

> Hello,
>
> In attachment, you can find more logs of pgpool.
>
> I have had a look at this config example already. What is .pgpoolkey file
> format? How do we create it, with a encryption key generation?
>
> Best regards,
>
> Lionel Engel
>
> Le mer. 5 juin 2019 à 04:00, Bo Peng <pengbo at sraoss.co.jp> a écrit :
>
>> Hi,
>>
>> On Tue, 4 Jun 2019 08:43:04 +0200
>> Lionel Engel <lionel.engel6 at gmail.com> wrote:
>>
>> > Hello,
>> >
>> > I have an issue when I am starting pgpool on 2 servers in same PgPool
>> > cluster (watchdog).
>> >
>> > My PgPool standby server running on CentOS 6 with PgPool 4.0.5 is
>> returning
>> > an error that is saying "Could not get the password for user:postgres.
>> > Unable to decrypt password from pool_passwd."
>> >
>> > I have a .pgpoolkey file and I have used *pg_enc* tool to generate the
>> > SCRAM-SHA-256 encrypted password in *pool_passwd*.
>>
>> Could you show more logs of pgpool?
>>
>> Also you can find more details from the config example below:
>> http://www.pgpool.net/docs/latest/en/html/example-cluster.html
>>
>>
>> > What is wrong?
>> >
>> > Thank you in advance and best regards,
>> >
>> > Lionel Engel
>>
>>
>> --
>> Bo Peng <pengbo at sraoss.co.jp>
>> SRA OSS, Inc. Japan
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190605/5090b673/attachment.html>