/usr/lib/x86_64-linux-gnu/kamailio/kamctl/kamctl.pgsql is in kamailio-postgres-modules 4.2.0-2+deb8u3.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 | #
# $Id$
#
# control tool for maintaining Kamailio
#
#===================================================================
##### ----------------------------------------------- #####
### PGSQL specific variables and functions
#
##### ----------------------------------------------- #####
### load SQL base
#
if [ -f "$MYLIBDIR/kamctl.sqlbase" ]; then
. "$MYLIBDIR/kamctl.sqlbase"
else
echo "Cannot load SQL core functions '$MYLIBDIR/kamctl.sqlbase' - exiting ..."
exit -1
fi
##### ----------------------------------------------- #####
### binaries
if [ -z "$PGSQL" ] ; then
locate_tool psql
if [ -z "$TOOLPATH" ] ; then
echo "error: 'psql' tool not found: set PGSQL variable to correct tool path"
exit
fi
PGSQL="$TOOLPATH"
fi
# input: sql query, optional pgsql command-line params
pgsql_query() {
# if password not yet queried, query it now
prompt_pw "PgSQL password for user '$DBRWUSER@$DBHOST'"
mecho "pgsql_query: $PGSQL $2 -A -q -t -P fieldsep=' ' -h $DBHOST -U $DBRWUSER $DBNAME -c '$1'"
PGPASSWORD="$DBRWPW" $PGSQL $2 \
-A -q -t \
-P fieldsep=" " \
-h $DBHOST \
-U $DBRWUSER \
$DBNAME \
-c "$1"
}
# input: sql query, optional pgsql command-line params
pgsql_ro_query() {
mdbg "pgsql_ro_query: $PGSQL $2 -h $DBHOST -U $DBROUSER $DBNAME -c '$1'"
PGPASSWORD="$DBROPW" $PGSQL $2 \
-h $DBHOST \
-U $DBROUSER \
$DBNAME \
-c "$1"
}
DBCMD=pgsql_query
DBROCMD=pgsql_ro_query
DBRAWPARAMS="-A -q -t"
|