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

[Alexandre Ellert]

Thank you Abel, that works with the correct syntax !
My mistake was not to pass -h, -U and -p options. I was thinking the information written in PCPPASSFILE would have been used by default.

> Le 29 mars 2016 à 13:25, Abel Martín <abel.martin.ruiz at gmail.com> a écrit :
> 
> 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
>> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general