<div dir='auto'><div dir="auto">Thank you Richard.</div><div dir="auto"><br></div><div dir="auto">My understanding is in case opensips loaded any data from MYSQL into its memory then changing the original MYSQL data may require a reload using MI command.</div><div dir="auto"><br></div><div dir="auto">Is that correct?<br><div dir="auto"><br></div><div dir="auto">Our use case is just to administer the SIP users from external application like create , update and delete etc.</div><div dir="auto"><br></div><div dir="auto">Regards</div><div dir="auto">Karthik</div></div><div><br><div class="elided-text">On 14-Aug-2025 6:27 pm, Richard Robson <richard@rikrobson.co.uk> wrote:<br type="attribution"><blockquote style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
<br>
<br>
It wasn't clear from your original post what you wanted to change in the
<br>
DB, but if opensips access the DB live for any reason, then you will not
<br>
need to reload anything, however if it loads the DB into memory for a
<br>
specific module, like dispatcher, then you would need to reload.
<br>
<br>
<br>
Richard
<br>
<br>
On 14/08/2025 13:53, Karthikeyan wrote:
<br>
>
<br>
> Hi Richard,
<br>
>
<br>
> Thanks for the reply.
<br>
>
<br>
> Why we need to reload the MI modules from the app?
<br>
>
<br>
> We are just going to create / update / delete SIP users using external application , so do we really need to reload the modules?
<br>
>
<br>
> MI commands are only for administering OpenSIPS server and not for accessing MYSQL database. Correct?
<br>
>
<br>
> Regards
<br>
> Karthik
<br>
>
<br>
> -----Original Message-----
<br>
> From: Richard Robson <richard@rikrobson.co.uk>
<br>
> Sent: Thursday, 14 August 2025 14:42
<br>
> To: Karthikeyan <karthikeyanm@acldigital.com>; users@lists.opensips.org
<br>
> Cc: 'Ravichandran R' <ravichandranr@acldigital.com>
<br>
> Subject: Re: Users Digest, Vol 205, Issue 4
<br>
>
<br>
> CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
<br>
>
<br>
> you can yuse whatever you want to write the app/web portal etc.
<br>
>
<br>
> If you want a portal to modify the dB, then have a front end which can display the current data and accept the fresh data in an online form.
<br>
> then use, whatever backend to access and manipulate the database directly. Then you want the app to run the MI commands on the Host that needs changing.
<br>
>
<br>
> regards,
<br>
>
<br>
>
<br>
> Richard
<br>
>
<br>
> On 14/08/2025 13:30, Karthikeyan wrote:
<br>
>> Hi Richard,
<br>
>>
<br>
>> It would be nice if you can provide us some source to check OpenSIPS MYSQL integration with external application.
<br>
>>
<br>
>> Regards
<br>
>> Karthik
<br>
>>
<br>
>> -----Original Message-----
<br>
>> From: Users <users-bounces@lists.opensips.org> On Behalf Of
<br>
>> users-request@lists.opensips.org
<br>
>> Sent: Thursday, 14 August 2025 14:00
<br>
>> To: users@lists.opensips.org
<br>
>> Subject: Users Digest, Vol 205, Issue 4
<br>
>>
<br>
>> Send Users mailing list submissions to
<br>
>> users@lists.opensips.org
<br>
>>
<br>
>> To subscribe or unsubscribe via the World Wide Web, visit
<br>
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
<br>
>> or, via email, send a message with subject or body 'help' to
<br>
>> users-request@lists.opensips.org
<br>
>>
<br>
>> You can reach the person managing the list at
<br>
>> users-owner@lists.opensips.org
<br>
>>
<br>
>> When replying, please edit your Subject line so it is more specific than "Re: Contents of Users digest..."
<br>
>>
<br>
>>
<br>
>> Today's Topics:
<br>
>>
<br>
>> 1. OpenSIPS database API integration with external application
<br>
>> (Karthikeyan)
<br>
>> 2. Re: OpenSIPS database API integration with external
<br>
>> application (Richard Robson)
<br>
>> 3. Running openisps on EKS cluster . (Sasmita Panda)
<br>
>>
<br>
>>
<br>
>> ----------------------------------------------------------------------
<br>
>>
<br>
>> Message: 1
<br>
>> Date: Wed, 13 Aug 2025 14:23:52 +0200
<br>
>> From: "Karthikeyan" <karthikeyanm@acldigital.com>
<br>
>> To: <users@lists.opensips.org>
<br>
>> Cc: 'Ravichandran R' <ravichandranr@acldigital.com>,
<br>
>> karthikeyanm@acldigital.com
<br>
>> Subject: [OpenSIPS-Users] OpenSIPS database API integration with
<br>
>> external application
<br>
>> Message-ID: <000e01dc0c4d$21bad620$65308260$@acldigital.com>
<br>
>> Content-Type: text/plain; charset="utf-8"
<br>
>>
<br>
>>
<br>
>>
<br>
>> Team,
<br>
>>
<br>
>>
<br>
>>
<br>
>> We would like to integrate OpenSIPS MYSQL database with external application for creating / deleting and updating SIP users using Http API calls provided by OpenSIPS . Is it possible to do it?
<br>
>>
<br>
>>
<br>
>>
<br>
>> We have seen the following Module with respect to this. It this the correct way for API integration?
<br>
>>
<br>
>>
<br>
>>
<br>
>> https://opensips.org/docs/modules/3.5.x/pi_http.html
<br>
>>
<br>
>>
<br>
>>
<br>
>> Please help us on this.
<br>
>>
<br>
>>
<br>
>>
<br>
>> Regards
<br>
>>
<br>
>> Karthik
<br>
>>
<br>
>>
<br>
>>
<br>
>> -------------- next part -------------- An HTML attachment was
<br>
>> scrubbed...
<br>
>> URL:
<br>
>> <http://lists.opensips.org/pipermail/users/attachments/20250813/f463eb
<br>
>> 4b/attachment-0001.html>
<br>
>>
<br>
>> ------------------------------
<br>
>>
<br>
>> Message: 2
<br>
>> Date: Wed, 13 Aug 2025 16:08:13 +0100
<br>
>> From: Richard Robson <richard@rikrobson.co.uk>
<br>
>> To: Karthikeyan via Users <users@lists.opensips.org>
<br>
>> Subject: Re: [OpenSIPS-Users] OpenSIPS database API integration with
<br>
>> external application
<br>
>> Message-ID: <e7bd1258-b8ed-47fe-8f8e-9caca002bb6f@rikrobson.co.uk>
<br>
>> Content-Type: text/plain; charset="utf-8"; Format="flowed"
<br>
>>
<br>
>> When I have done this is the past, I have directly manipulated the DB from the app, with all the required sanity, syntax checks , etc. and then issues a reload of the relevant modules via the MI interfaced.
<br>
>>
<br>
>>
<br>
>> Richard
<br>
>>
<br>
>> On 13/08/2025 13:23, Karthikeyan via Users wrote:
<br>
>>> Team,
<br>
>>>
<br>
>>> We would like to integrate OpenSIPS MYSQL database with external
<br>
>>> application for creating / deleting and updating SIP users using Http
<br>
>>> API calls provided by OpenSIPS . Is it possible to do it?
<br>
>>>
<br>
>>> We have seen the following Module with respect to this. It this the
<br>
>>> correct way for API integration?
<br>
>>>
<br>
>>> https://opensips.org/docs/modules/3.5.x/pi_http.html
<br>
>>>
<br>
>>> Please help us on this.
<br>
>>>
<br>
>>> Regards
<br>
>>>
<br>
>>> Karthik
<br>
>>>
<br>
>>>
<br>
>>> _______________________________________________
<br>
>>> Users mailing list
<br>
>>> Users@lists.opensips.org
<br>
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
<br>
>> -------------- next part -------------- An HTML attachment was
<br>
>> scrubbed...
<br>
>> URL:
<br>
>> <http://lists.opensips.org/pipermail/users/attachments/20250813/9997ce
<br>
>> be/attachment-0001.html>
<br>
>>
<br>
>> ------------------------------
<br>
>>
<br>
>> Message: 3
<br>
>> Date: Thu, 14 Aug 2025 11:55:18 +0530
<br>
>> From: Sasmita Panda <spanda@3clogic.com>
<br>
>> To: OpenSIPS users mailling list <users@lists.opensips.org>
<br>
>> Subject: [OpenSIPS-Users] Running openisps on EKS cluster .
<br>
>> Message-ID:
<br>
>> <CALf-Q45DwsEn1vFjkvD3fF+F6VEOFZeQBCXu+PNQM-GB4o+yJA@mail.gmail.com>
<br>
>> Content-Type: text/plain; charset="utf-8"
<br>
>>
<br>
>> Hi All ,
<br>
>>
<br>
>> Is there anyone running opensips on EKS cluster nodes with carrier grade integration ?
<br>
>> Do let me now if this is recommended/achievable or not . If Yes , then help me with an issue .
<br>
>>
<br>
>> I have openisps service on an eks node and I have carrier integration with the node .
<br>
>> I have attached an elastic IP and whitelisted the IP with the carrier .
<br>
>>
<br>
>> Inbound calls from the carrier to my openisps Node is working perfectly fine but in the outbound call when the call lands on the carrier side the source port of opensips is going to some random port where the carrier expects a 5060 fixed port always .
<br>
>>
<br>
>> Do suggest if anybody has such experience .
<br>
>>
<br>
>> *Thanks & Regards*
<br>
>> *Sasmita Panda*
<br>
>> *Senior Network Testing and Software Engineer* *3CLogic ,
<br>
>> ph:07827611765*
<br>
>> -------------- next part -------------- An HTML attachment was
<br>
>> scrubbed...
<br>
>> URL:
<br>
>> <http://lists.opensips.org/pipermail/users/attachments/20250814/da79c4
<br>
>> ad/attachment-0001.html>
<br>
>>
<br>
>> ------------------------------
<br>
>>
<br>
>> Subject: Digest Footer
<br>
>>
<br>
>> _______________________________________________
<br>
>> Users mailing list
<br>
>> Users@lists.opensips.org
<br>
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
<br>
>>
<br>
>>
<br>
>> ------------------------------
<br>
>>
<br>
>> End of Users Digest, Vol 205, Issue 4
<br>
>> *************************************
<br>
>>
<br>
</p>
</blockquote></div><br></div></div>