Re: Broken SSL tests in master - Mailing list pgsql-hackers

From Mithun Cy
Subject Re: Broken SSL tests in master
Date
Msg-id CAD__OujtKhMV9kQhQ2sgWV9EyzSv_Gwd7Kd=P1Lq+0z8xhW1RQ@mail.gmail.com
Whole thread Raw
In response to Re: Broken SSL tests in master  (Andreas Karlsson <andreas@proxel.se>)
Responses Re: Broken SSL tests in master  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Fri, Nov 25, 2016 at 12:03 PM, Andreas Karlsson <andreas@proxel.se> wrote:
> Another thought about this code: should we not check if it is a unix socket first before splitting the host? While I doubt that it is common to have a unix >socket in a directory with comma in the path it is a bit annoying that we no longer support this.

I think it is a bug.

Before this feature:

./psql postgres://%2fhome%2fmithun%2f%2c
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/home/mithun/,/.s.PGSQL.5444"?

After this feature:
./psql postgres://%2fhome%2fmithun%2f%2c
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/home/mithun//.s.PGSQL.5432"?
could not connect to server: Connection refused
Is the server running on host "" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "" (127.0.0.1) and accepting
TCP/IP connections on port 5432?

So comma (%2c) is misinterpreted as separator not as part of UDS path.

Reason is we first decode the URI(percent encoded character) then try to split the string into multiple host assuming they are separated by ','. I think we need to change the order here. Otherwise difficult the say whether ',' is part of USD path or a separator.

--
Thanks and Regards
Mithun C Y

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Random PGDLLIMPORTing
Next
From: Amit Langote
Date:
Subject: Re: Declarative partitioning - another take