[Pgpool-general] No nodes shown in pgPoolAdmin

[Tatsuo Ishii]

Dave,

Thank you for testing the instruction.

> I've followed the instructions at
> http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html
> for setting up a simple SR cluster. pgPool appears to be working fine;
> I can connect to it, and issues queries etc.
> 
> However, pgPoolAdmin doesn't list any nodes if clicking pgPool Status
> -> Node Info. There's just the two rows of buttons in the status
> section, with nothing in between them. Clicking on Node Status just
> gives a "please wait..." message which seems to be there indefinitely.
> In addition, clicking on Query Cache or Partitioning Rule, gives a
> completely empty response from the server.
> 
> pgPoolAdmin seems to work otherwise though - I can start/stop the
> process, edit the config files, and look at the process list.
> 
> The only errors I can see in the webserver log look like this:
> 
> [Sun Nov 14 10:55:36 2010] [error] [client 90.214.67.153] PHP
> Deprecated:  Function split() is deprecated in
> /var/www/html/innerLog.php on line 48
> 
> That appears to be unrelated (and goes away if split() is replaced
> with explode().
> 
> I've attached the pgPool log, which has some interesting messages that
> may be relevant, but don't mean much to me. Any hints would be
> appreciated.

What user id does your apache use(maybe "apache")? PgpoolAdmin need to
access PostgreSQL while health checking. I suspect that the user role
is not registered in PostgreSQL.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp