[SR-Users] DB create statements

[Aft nix]

On Wed, Jul 11, 2012 at 3:24 PM, Klaus Darilion
<klaus.mailinglists at pernau.at> 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?
>

Hi,

You can look at this module. you can query a sql database from your kamailio.cfg

http://kamailio.org/docs/modules/stable/modules_k/sqlops.html

Cheers.
> 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



-- 
-aft