[pgpool-general: 9040] Re: cannot get .pgppass file to work

[Sbob]

oh, [faceplant]

Thanks!



On 3/1/24 01:37, Bo Peng wrote:
> Hi,
>
>> $ cat ~/.pcppass
>> *:5432:postgres:postgres
>>
>>
>> $ pcp_node_info -w -p 5440 -U postgres -n 1
> It seems that the port is different.
>
> In pcp command you use 5440, but in .pcppass 5432 is specified.
>
> On Thu, 29 Feb 2024 22:55:17 -0700
> Sbob <sbob at quadratum-braccas.com> wrote:
>
>> All;
>>
>>
>> I cannot get .pcppass file to work
>>
>>
>> I setup my pcp.conf file to have the following:
>>
>>
>> $ pg_md5 postgres
>> e8a48653851e28c69d0506508fb27fc5
>>
>>
>>
>> $ cat /etc/pgpool-II/pcp.conf
>> # USERID:MD5PASSWD
>> postgres:e8a48653851e28c69d0506508fb27fc5
>>
>>
>>
>> $ cat ~/.pcppass
>> *:5432:postgres:postgres
>>
>>
>> $ chmod 0600 ~/.pcppass
>>
>> $ export  PCPPASSFILE=/var/lib/pgsql/.pcppass
>>
>>
>> $ pcp_node_info -w -p 5440 -U postgres -n 1
>> FATAL:  authentication failed for user "postgres"
>> DETAIL:  username and/or password does not match
>>
>>
>>
>> However passing in a pw works (using the password:  postgres)
>>
>> $ pcp_node_info -W -p 5440 -U postgres -n 1
>> Password:
>> 172.16.108.161 5432 2 0.333333 up up primary primary 0 none none
>> 2024-02-29 22:22:40
>>
>>
>>
>> what am I doing wrong?
>>
>>
>> Thanks in advance
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>