[pgpool-hackers: 4163] bug: localhost entry in .pcppass does not match Unix domain socket connections

KAWAMOTO Masaya kawamoto at sraoss.co.jp
Wed Jun 1 15:15:22 JST 2022


Hi,

The document of PCP password file says that a hostname of localhost
matches Unix domain socket connections coming from the local  machie.
But, actually localhost only matches UNIX_DOMAIN_PATH defined in
src/include/pcp/pcp_stream.h.

The reproduction is as follows.
I built pgpool with UNIX_DOMAIN_PATH defined '/tmp'.
$ sudo mkdir /var/run/pgpool_pcp
$ sudo chown kawamoto:kawamoto /var/run/pgpool_pcp
$ pgpool_setup
$ vi etc/pgpool.conf
pcp_sochet_dir = '/var/run/pgpool_pcp'
$ ./startall
$ cat ~/.pcppass
localhost:11001:kawamoto:kawamoto
$ /usr/pcp_bug/bin/pcp_node_info -p 11001 -U kawamoto -w
ERROR: connection to socket "/tmp/.s.PGSQL.11001" failed with error "No such file or directory"
$ /usr/pcp_bug/bin/pcp_node_info -h /var/run/pgpool_pcp -p 11001 -U kawamoto -w
FATAL:  authentication failed for user "kawamoto"
DETAIL:  username and/or password does not match


I attach a patch.

Best regards.

-- 
KAWAMOTO Masaya <kawamoto ¡÷ sraoss.co.jp>
SRA OSS, Inc. Japan
-------------- next part --------------
¥Æ¥­¥¹¥È·Á¼°°Ê³°¤ÎźÉÕ¥Õ¥¡¥¤¥ë¤òÊݴɤ·¤Þ¤·¤¿...
¥Õ¥¡¥¤¥ë̾: pcppass.path
·¿:         application/octet-stream
¥µ¥¤¥º:     441 ¥Ð¥¤¥È
ÀâÌÀ:       ̵¤·
URL:        <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20220601/b0c1d203/attachment.obj>


More information about the pgpool-hackers mailing list