11 Jul
2012
11 Jul
'12
3:44 p.m.
For the files: I solved my problem by changing the
/usr/lib/kamailio/kamctl/kamdbctl.pgsql script to write all queries to
stdout instead sending it to the DB, e.g:
# execute sql command with optional db name
sql_query()
{
if [ $TRYONLY -eq 1 ] ; then
if [ $# -gt 1 ] ; then
shift
echo "$@"
else
cat
fi
else
if [ $# -gt 1 ] ; then
if [ -n "$1" ]; then
DB="$1"
else
DB=""
fi
shift
$CMD -d $DB -c "$@"
else
$CMD "$@"
fi
fi
}
And then call "TRYONLY=1 kamdbctl create"
regards
Klaus
On 11.07.2012 11:24, Klaus Darilion wrote:
Hi!
For some reason I need to the enter the SQL statements manually on the
DB server (I do not want to copy the scripts to the DB server and there
is no superuser access over the network)
Is there a simple method to get all the SQL commands to create the
kamailio database?
I see there are all the files in "/usr/share/kamailio/postgres/" and
lots of other SQL statements in /usr/lib/kamailio/kamctl/kamdbctl.pgsql.
Does anyone know of a simple method to get all the raw SQL queries?
Thanks
Klaus
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users