[Pgpool-general] No nodes shown in pgPoolAdmin

[Tatsuo Ishii]

> Yes, it's apache:
> 
> $ ps -ef |grep apache
> ec2-user 10291 10272  0 08:50 pts/1    00:00:00 grep apache
> apache   15411 13816  0 Nov14 ?        00:00:00 /usr/sbin/httpd
> ...
> apache   18658     1  0 Nov14 ?        00:00:02 /usr/local/bin/pgpool
> -f /usr/local/etc/pgpool.conf -F /usr/local/etc/pcp.conf -D -d -n
> apache   18659 18658  0 Nov14 ?        00:00:00 pgpool: wait for
> connection request
> ...
> 
> The user is present in PostgreSQL however:
> 
> postgres=# select * from pg_user;
>  usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  |
> valuntil | useconfig
> ----------+----------+-------------+----------+-----------+----------+----------+-----------
>  postgres |       10 | t           | t        | t         | ******** |
>          |
>  apache   |    16394 | f           | f        | f         | ******** |
>          |
> (2 rows)
> 
> The pg_hba.conf file has:
> 
> # TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD
> 
> # "local" is for Unix domain socket connections only
> local   all             all                                     trust
> # IPv4 local connections:
> host    all             all             127.0.0.1/32            trust
> # IPv6 local connections:
> host    all             all             ::1/128                 trust
> # Open Season!
> host    all             all             0.0.0.0/0               md5
> 
> So, the apache user should be able to connect via the Unix socket or
> loopback addresses.
> 
> Do you have any other ideas, or can I provide any more information?

Ok. Do you see any error messages in PostgreSQL log? If so, could you
please give it to me?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp