[SR-Users] DB create statements

[Klaus Darilion]

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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users