[pgpool-general: 4585] Re: Using pcp_ command without password

[Abel Martín]

The correct syntax in your case would be (no need to export the
PCPPASSFILE variable for this test):

    $ PCPPASSFILE=/var/lib/postgresql/.pcppass pcp_node_info -h <host>
-U <user> -p <port> -w -n0

The contents of .pcppass should be:

    <host>:<port>:<user>:<password>

Cheers,
Abel Martin

2016-03-29 13:10 GMT+02:00 Alexandre Ellert <ellertalexandre at gmail.com>:
> I’m aware of the -w option.
> But stil fail even with exporting PCPPASSFILE variable.
>
> $ export PCPPASSFILE=/var/lib/postgresql/.pcppass
> $ pcp_node_info 0 -w -v -d
> DEBUG: recv: tos="m", len=8
> DEBUG: recv: tos="E", len=122
> FATAL:  authentication failed for user "postgres"
> DETAIL:  username and/or password does not match
>
>
>> Le 29 mars 2016 à 13:04, Abel Martín <abel.martin.ruiz at gmail.com> a écrit :
>>
>> Hi,
>>
>> The syntax for PCP has changed since version 3.5.0. Use --help to
>> check the new syntax.
>>
>> http://pgpool.net/mediawiki/index.php?title=pgpool-II_3.5_features&redirect=no#PCP_system_overhauling
>> http://www.pgpool.net/docs/latest/pgpool-en.html#pcp_common_options
>>
>> Cheers,
>> Abel Martin
>>
>> 2016-03-29 12:36 GMT+02:00 Alexandre Ellert <ellertalexandre at gmail.com>:
>>> Hello,
>>>
>>> My setup is a 2 nodes cluster with pgpool 3.5 / postgresql 9.5.
>>> I try to use a some pcp_ command in a script but can’t figure how to get it working.
>>>
>>> postgres at postgres-prod-1:~$ pcp_node_info 0 -w
>>> FATAL:  authentication failed for user "postgres"
>>> DETAIL:  username and/or password does not match
>>>
>>> postgres at postgres-prod-1:~$ cat $HOME/.pcppass
>>> postgres-prod-1.ivscloud.local:9898:postgres:PASSSWORD
>>>
>>> I tried the old way to pass user/password to pcp without success :
>>> postgres at postgres-prod-1:~$ pcp_node_info 0 postgres PASSWORD
>>> pcp_node_info: Warning: extra command-line argument "postgres" ignored
>>> pcp_node_info: Warning: extra command-line argument "PASSWORD" ignored
>>>
>>> I’m 100% sure my password is correct and pgpool is listening correctly on port 9898
>>> What is my mystake ?
>>>
>>> Thank you
>>>
>>> Alexandre
>>>
>>>
>>> _______________________________________________
>>> pgpool-general mailing list
>>> pgpool-general at pgpool.net
>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>