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

[Alexandre Ellert]

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