[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