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

[Michal Matyska]

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