[sr-dev] git:5.1:54c904e4: utils/kamctl: [pgsql] add missing options for pgsql_ro_query()

Module: kamailio Branch: 5.1 Commit: 54c904e4dc9dae3cd82e547e2328cad9381e48ec URL: https://github.com/kamailio/kamailio/commit/54c904e4dc9dae3cd82e547e2328cad… Author: Victor Seva <linuxmaniac(a)torreviejawireless.org> Committer: Victor Seva <linuxmaniac(a)torreviejawireless.org> Date: 2018-12-03T12:31:18+01:00 utils/kamctl: [pgsql] add missing options for pgsql_ro_query() Thanks Andreas Maus <maus+debianbug(a)ypbind.de> fix #1750 (cherry picked from commit 1894b378f975e7129024f6f10640c6c642e30a1b) --- Modified: utils/kamctl/kamctl.pgsql --- Diff: https://github.com/kamailio/kamailio/commit/54c904e4dc9dae3cd82e547e2328cad… Patch: https://github.com/kamailio/kamailio/commit/54c904e4dc9dae3cd82e547e2328cad… --- diff --git a/utils/kamctl/kamctl.pgsql b/utils/kamctl/kamctl.pgsql index 7e5abaef9a..1250dc0d7e 100644 --- a/utils/kamctl/kamctl.pgsql +++ b/utils/kamctl/kamctl.pgsql @@ -57,15 +57,17 @@ pgsql_query() { # input: sql query, optional pgsql command-line params pgsql_ro_query() { - mdbg "pgsql_ro_query: $PGSQL $2 -h $DBHOST -U $DBROUSER $DBNAME -c '$1'" + mdbg "pgsql_ro_query: $PGSQL $2 -A -q -t -h $DBHOST -U $DBROUSER $DBNAME -c '$1'" if [ -z "$DBPORT" ] ; then PGPASSWORD="$DBROPW" $PGSQL $2 \ + -A -q -t \ -h $DBHOST \ -U $DBROUSER \ $DBNAME \ -c "$1" else PGPASSWORD="$DBROPW" $PGSQL $2 \ + -A -q -t \ -h $DBHOST \ -p $DBPORT \ -U $DBROUSER \