<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word"><head><META content="text/html; charset=utf-8" http-equiv="Content-Type">
<meta content="text/html; charset=utf-8" http-equiv=Content-Type>
<meta content="Microsoft Word 11 (filtered medium)" name=Generator>
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head><BODY>
<DIV>
<div class=Section1>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'>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. <o:p></o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'>If I move to DB storage how do I handle things like
parallel/sequential forking? ENUM makes it very easy – for example:<o:p></o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'>1.0.0.0.1
NAPTR 100 10 "u" "E2U+sip"
"!^.*$!sip:8700@172.20.152.132!" .<o:p></o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'>
NAPTR 100 10 "u" "E2U+sip"
"!^.*$!sip:901191986701####@172.20.152.132!" .<o:p></o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'>
NAPTR 100 10 "u" "E2U+sip"
"!^.*$!sip:901191996700####@172.20.152.132!" .<o:p></o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'>If I have a SIP user “bob@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:<o:p></o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'>0.1.5.3.3.9.2.4.1.9.1 NAPTR 100 10 "u"
"E2U+sip" "!^.*$!sip:bobm@domain.com!" .<o:p></o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'>0.1.5.3
NAPTR 100 10 "u" "E2U+sip"
"!^.*$!sip:bobm@domain.com!" .<o:p></o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'>Any suggestions?<o:p></o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'>Thanks<o:p></o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'>Bob<o:p></o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face=Arial size=2><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font face="Times New Roman" size=3><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</DIV>
<DIV>
<HR>
</DIV>
<DIV STYLE="FONT-SIZE: 9pt; FONT-FAMILY: Courier New">This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.</DIV>
<DIV STYLE="FONT-SIZE: 9pt; FONT-FAMILY: Courier New">(W1)<BR></DIV>
<DIV STYLE="FONT-SIZE: 9pt; FONT-FAMILY: Courier New"><BR> </DIV></BODY></HTML>