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 \