Hello, On 03/12/2009 04:01 PM, Robert McGilvray wrote: > > I’m deploying Kamailio in an enterprise environment and I’m looking > for a better way to handle the mapping of external DIDs to SIP > usernames, number re-writing etc. I’m currently using ENUM in my test > setup but I’d prefer to go with SQL storage and have that data written > out to a faster database for lookups by Kamailio. I have a mix of > users that register directly to the proxy and also several PBXs that I > need to route blocks of numbers to through Cisco routers. For location > A I would need to route any four digit number that starts with a 3 > (3759), EXCEPT ones specifically defined in my database since they > might be mapped directly to a user. Also for any outbound call (9 > prefix) I need to check the DB to see if it’s local. > > If I move to DB storage how do I handle things like > parallel/sequential forking? ENUM makes it very easy – for example: > > 1.0.0.0.1 NAPTR 100 10 "u" "E2U+sip" "!^.*$!sip:8...@172.20.152.132!" . > > NAPTR 100 10 "u" "E2U+sip" "!^.*$!sip:901191986701#...@172.20.152.132!" . > > NAPTR 100 10 "u" "E2U+sip" "!^.*$!sip:901191996700#...@172.20.152.132!" . > > If I have a SIP user “...@domain.com” a simple location lookup works > for that, but I also need to be able to map a e.164 did to him, and a > short form with just the last 4 digits for my internal dialing. I > would need a database schema that does the equivalent to this: > > 0.1.5.3.3.9.2.4.1.9.1 NAPTR 100 10 "u" "E2U+sip" > "!^.*$!sip:b...@domain.com!" . > > 0.1.5.3 NAPTR 100 10 "u" "E2U+sip" "!^.*$!sip:b...@domain.com!" . > > Any suggestions? > alias_db module: http://kamailio.org/docs/modules/1.5.x/alias_db.html
Cheers, Daniel -- Daniel-Constantin Mierla http://www.asipto.com _______________________________________________ Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
