pgsql: Field conninfo strings throughout src/bin/scripts. - Mailing list pgsql-committers

From Noah Misch
Subject pgsql: Field conninfo strings throughout src/bin/scripts.
Date
Msg-id E1bWlGS-0006n6-7B@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Field conninfo strings throughout src/bin/scripts.

These programs nominally accepted conninfo strings, but they would
proceed to use the original dbname parameter as though it were an
unadorned database name.  This caused "reindexdb dbname=foo" to issue an
SQL command that always failed, and other programs printed a conninfo
string in error messages that purported to print a database name.  Fix
both problems by using PQdb() to retrieve actual database names.
Continue to print the full conninfo string when reporting a connection
failure.  It is informative there, and if the database name is the sole
problem, the server-side error message will include the name.  Beyond
those user-visible fixes, this allows a subsequent commit to synthesize
and use conninfo strings without that implementation detail leaking into
messages.  As a side effect, the "vacuuming database" message now
appears after, not before, the connection attempt.  Back-patch to 9.1
(all supported versions).

Reviewed by Michael Paquier and Peter Eisentraut.

Security: CVE-2016-5424

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c400717172d77e5b07e51e04c5e5e13da181572e

Modified Files
--------------
src/bin/scripts/clusterdb.c  |  4 ++--
src/bin/scripts/createlang.c |  4 ++--
src/bin/scripts/droplang.c   |  4 ++--
src/bin/scripts/reindexdb.c  | 26 +++++++++++++-------------
src/bin/scripts/vacuumdb.c   | 44 +++++++++++++++++++++-----------------------
5 files changed, 40 insertions(+), 42 deletions(-)


pgsql-committers by date:

Previous
From: Noah Misch
Date:
Subject: pgsql: Introduce a psql "\connect -reuse-previous=on|off" option.
Next
From: Noah Misch
Date:
Subject: pgsql: Obstruct shell, SQL, and conninfo injection via database and rol