Re: [SR-Users] get server parameters from DB when kamailio starts

Hi,

you can easily use command substitution e.g. -A $(hostname) in your script which starts kamailio or use mysql batch query to retrieve the result if you wish to store it in database.

Michal

Uri Shacked píše v Pá 10. 02. 2012 v 15:32 +0200:

thanks, it is good see there is a wayto start with -A... and it might make it easier a little (cause i use the define as the group the server belongs to). but, it doesn't help me fully in my case. i would like to have a generic start, and generic cfg file (it is much easier when you need to maintain). the best thing i would like to do is something like that:

let say i have "route on start" or "get data from DB on start"... then, i set something like:

get "myself" from list of kamailio servers" and set my group to "the value set on me"

it seems to me something very usefull, when you use 2 and more kamailio at different sites, and still want a generic code and functions.

if i was a programer... i might try to write some module :-)

thanks anyway, Uri

On Fri, Feb 10, 2012 at 2:51 PM, Daniel-Constantin Mierla miconda@gmail.com wrote: Hello,

    you can use defines to control the order (the values of NP
    servers), here is an example of defining NP servers (to str
    value, for sake of explanation):

    #!ifdef SRV1
    #!define NPSRV1 "abc"
    #!define NPSRV2 "xyz"
    #!else
    #!define NPSRV2 "abc"
    #!define NPSRV1 "xyz"
    #!endif

    and start kamailio with parameter '-A SRV1' for the first
    instance.

    Cheers,
    Daniel 



    On 2/10/12 6:28 AM, Uri Shacked wrote: 
    > Hi again...
    > (i do find myself ask many questions these days.... :-))
    > 
    > well, now here is one more:
    > 
    > i have 2 kamailio servers that i use in 2 locations. both
    > use the same
    > tables and DBURL.
    > each of my server turns to a number portability (NP) server
    > at its same
    > location.
    > for example, if server 1 has the call, it will turn to NP
    > server 1 with the
    > query, and if the query fails, it will then turn to NP
    > server 2.
    > the kamailio server 2 does the same. but, turns to NP server
    > 2 first and if
    > it fails, to NP server 1.
    > 
    > once this is understood....
    > 
    > here is my issue - i want to have 1 generic cfg file for my
    > 2 servers.
    > today, i use the same cfg file, but in server 1 i set it in
    > the cfg to its
    > group, and on server 2 the same but a different group....
    > 
    > i tried to understand how do i get each server to "pull" its
    > group from the
    > DB. something like "what is my group when my IP is X.Y.Z.Q ?
    > i raed the cfg_db module but didn't understand how to set it
    > on my cfg file
    > and on the DB.
    > 
    > what is the best way to do what i want?
    > hope i was clear....
    > 
    > BR,
    > thanks to all the guys that help me so far, i appriciate it
    > a lot!
    > Uri
    > 
    > 
    > 
    > 
    > _______________________________________________
    > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
    > sr-users@lists.sip-router.org
    > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

    -- 
    Daniel-Constantin Mierla -- http://www.asipto.com
    http://linkedin.com/in/miconda -- http://twitter.com/miconda

---

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users