<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE-AT link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>For loading/updating large LNP datasets, you should use<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> perl /usr/share/perl5/NGCP/BulkProcessor/Projects/ETL/Lnp/process.pl<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>(rather than the http api).<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>br<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Von:</span></b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Edo [mailto:edo.ekunwe@gmail.com] <br><b>Gesendet:</b> Mittwoch, 15. Februar 2023 19:57<br><b>An:</b> spce-user@lists.sipwise.com<br><b>Betreff:</b> Re: [Spce-user] Spce-user Digest, Vol 44, Issue 2<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Thanks Marco, I will try that and report back.<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Thanks again<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Mon, Feb 13, 2023 at 11:00 AM <<a href="mailto:spce-user-request@lists.sipwise.com">spce-user-request@lists.sipwise.com</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><p class=MsoNormal>Send Spce-user mailing list submissions to<br> <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com" target="_blank">http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com</a><br>or, via email, send a message with subject or body 'help' to<br> <a href="mailto:spce-user-request@lists.sipwise.com" target="_blank">spce-user-request@lists.sipwise.com</a><br><br>You can reach the person managing the list at<br> <a href="mailto:spce-user-owner@lists.sipwise.com" target="_blank">spce-user-owner@lists.sipwise.com</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Spce-user digest..."<br><br><br>Today's Topics:<br><br> 1. Sipwise CE and MongoDB configuration (Edo)<br> 2. Re: Sipwise CE and MongoDB configuration (Marco Capetta)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Sun, 12 Feb 2023 22:04:32 -0600<br>From: Edo <<a href="mailto:edo.ekunwe@gmail.com" target="_blank">edo.ekunwe@gmail.com</a>><br>To: <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>Subject: [Spce-user] Sipwise CE and MongoDB configuration<br>Message-ID:<br> <<a href="mailto:CAFkRdGuzhvYqUZhJMODmg7RpxFErU2FhemHxg548dUMD3mu_qg@mail.gmail.com" target="_blank">CAFkRdGuzhvYqUZhJMODmg7RpxFErU2FhemHxg548dUMD3mu_qg@mail.gmail.com</a>><br>Content-Type: text/plain; charset="utf-8"<br><br>All, help needed to get this configuration working. See below problem<br>statement<br><br>Problem statement:<br><br><br>I am using Sipwise CE (version is not important at this point because I am<br>currently in research and development phase and I can upgrade to the latest<br>and greatest version to achieve this configuration)<br><br><br><br> 1. Connect Sipwise CE to a mongo database server for read only queries<br> 2. Create two or more groups of outbound peers with some identifier ?<br> say group A and group B<br> 3. Receive call from interconnected peer going to called number XXXX<br> 4. After all sipwise checks on dialed number, before an outbound<br> decision is made, query the mongoDB if the dialed number exists in the<br> mongodb<br> 1. If it exists, use outbound peer group A, else use outbound peer<br> group B<br><br><br>Any help will be greatly appreciated.<br><br><br>Thanks<br>-- <br>-----<br>Ekunwe<br>Tel: 601.497.3932<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230212/2fc2ad1c/attachment-0001.html" target="_blank">http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230212/2fc2ad1c/attachment-0001.html</a>><br><br>------------------------------<br><br>Message: 2<br>Date: Mon, 13 Feb 2023 10:10:50 +0100<br>From: Marco Capetta <<a href="mailto:mcapetta@sipwise.com" target="_blank">mcapetta@sipwise.com</a>><br>To: <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>Subject: Re: [Spce-user] Sipwise CE and MongoDB configuration<br>Message-ID: <<a href="mailto:3673e65b-0d4c-b487-af05-484fdebd7fb9@sipwise.com" target="_blank">3673e65b-0d4c-b487-af05-484fdebd7fb9@sipwise.com</a>><br>Content-Type: text/plain; charset="utf-8"; Format="flowed"<br><br>Hi Ekunwe,<br><br>there is no official configuration and support for an interconnection to <br>a Mongo DB.<br>On the other hand, you can achieve the same result using an already <br>existing module: LNP Local.<br>All you have to do is keep updated the internal LNP table manually or <br>through a CSV file import.<br><br>Regards<br><br>Marco<br><br><br><br>On 13/02/23 05:04, Edo wrote:<br>> All, help needed to get this configuration working. See below problem <br>> statement<br>><br>> Problem statement:<br>><br>><br>> I am using Sipwise CE (version is not important at this point because <br>> I am currently in research and development phase and I can upgrade to <br>> the latest and greatest version to achieve this configuration)<br>><br>><br>> 1. Connect Sipwise CE to a mongo database server for read only queries<br>> 2. Create two or more groups of outbound peers with some identifier ?<br>> say group A and group B<br>> 3. Receive call from interconnected peer going to called number XXXX<br>> 4. After all sipwise checks on dialed number, before an outbound<br>> decision is made, query the mongoDB if the dialed number exists in<br>> the mongodb<br>> 1. If it exists, use outbound peer group A, else use outbound<br>> peer group B<br>><br>><br>> Any help will be greatly appreciated.<br>><br>><br>> Thanks<br>> -- <br>> -----<br>> Ekunwe<br>> Tel: 601.497.3932<br>><br><br>-- <br>*Marco Capetta *<br>R&D Manager<br><br>Sipwise GmbH | an ALE Company <<a href="http://www.sipwise.com" target="_blank">http://www.sipwise.com</a>><br>c/o ALE International ? Austria Branch<br>Saturn Tower<br>Leonard-Bernstein-Stra?e 10<br>1220 Vienna, Austria<br><br>Email: <a href="mailto:mcapetta@sipwise.com" target="_blank">mcapetta@sipwise.com</a><br>Website: <a href="http://www.sipwise.com" target="_blank">www.sipwise.com</a> <<a href="http://www.sipwise.com" target="_blank">http://www.sipwise.com</a>><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230213/b5e4c9b4/attachment-0001.html" target="_blank">http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20230213/b5e4c9b4/attachment-0001.html</a>><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>Spce-user mailing list<br><a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br><a href="http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com" target="_blank">http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com</a><br><br><br>------------------------------<br><br>End of Spce-user Digest, Vol 44, Issue 2<br>****************************************<o:p></o:p></p></blockquote></div><p class=MsoNormal><br clear=all><o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>-- <o:p></o:p></p><div><div><div><p class=MsoNormal>-----<o:p></o:p></p></div><p class=MsoNormal>Ekunwe<br>Tel: 601.497.3932<o:p></o:p></p></div></div></div></body></html>