[pgpool-general: 1310] Re: pgpoolAdmin: Error Message pcp_node_count command error occurred.

[Nozomi Anzai]

Hi,
 
> Dear all,
> please help me.
> when I click pgpool-status menu in pgPoolAdmin. then I get this error:
> PgpoolAdmin: Error Message pcp_node_count command error occurred.
>
> But on Node-status menu: I get some information correctly:
>
> IP Address	Port	Status
> localhost	5432 	up
> 10.1.101.150	5432	Up

I feel this strange, because, if pcp_node_count failed, exit() is called
and pcp_node_info isn't executed (in pgpoolAdmin 3.2).
What is the versions of pgpool and pgpoolAdmin you use? If pgpoolAdmin is
old, could you try to reproduce with the latest version?

> I think the error comes from the PCP* commands. but when I run on the terminal:
> all PCP* commands is correctly, but they don't run properly on pgpooladmin

How is the result of pcp_node_count with full path?
PgpoolAdmin uses the value of "PCP Directory" in "pgpoolAdmin Setting"
when executing pcp commands.

> # pcp_node_count-d 10 localhost 9898 apache tunglan
> DEBUG: send: tos = "R", len = 44
> DEBUG: recv: tos = "r", len = 21, data = AuthenticationOK
> DEBUG: send: tos = "L", len = 4
> DEBUG: recv: tos = "l", len = 22, data = CommandComplete2
> DEBUG: send: tos = "X", len = 4
> 
> #pcp_node_count  -d 10  localhost  9898  apache  tunglan
> DEBUG: send: tos="R", len=44
> DEBUG: recv: tos="r", len=21, data=AuthenticationOK
> DEBUG: send: tos="L", len=4
> DEBUG: recv: tos="l", len=22, data=CommandComplete2
> DEBUG: send: tos="X", len=4
>
> -bash-3.2$pcp_node_info -d 0 localhost 9898 postgres tunglan 0
> DEBUG: send: tos="R", len=46
> DEBUG: recv: tos="r", len=21, data=AuthenticationOK
> DEBUG: send: tos="I", len=6
> DEBUG: recv: tos="i", len=55, data=CommandComplete
> localhost 5432 3 0.500000
> DEBUG: send: tos="X", len=4
>
> Everything is ok on terminal but not on pgPoolAdmin
> P/s: It is confirmed that the function of php_mstring and php_pgsql has been installed.
> "Multibyte Support" is "enabled"."PostgreSQL Support" is "enabled".
> please help me.thank you very much. 		 	   		  

-- 
Nozomi Anzai
SRA OSS, Inc. Japan