<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi Daniel,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks for the response. </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
In my opinion, I thought RPC commands makes changes in DB as well. So, in that case I was thinking of adding RPC command for subscriber tables.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
But as you clear out things that RPC makes changes in memory only then there is no point to add to RPC command for subscriber table. Doing direct DB access will make more sense.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks,</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<p style="margin-top: 0px; margin-bottom: 0px;"><span style="color:rgb(0,111,201)">Surabhi Garg</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;"><span style="color:rgb(0,111,201)">Mobile - 91 783 888 7523 | Skype - surabhi.garg9</span><br>
</p>
</div>
</div>
</div>
</div>
<div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Daniel-Constantin Mierla <miconda@gmail.com><br>
<b>Sent:</b> Monday, July 12, 2021 12:04 PM<br>
<b>To:</b> Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>; Surabhi Garg <surabhi.garg@outlook.com><br>
<b>Subject:</b> Re: [SR-Users] Subscriber Management using JSONRPC over HTTP</font>
<div> </div>
</div>
<div>
<p style="margin-top: 0px; margin-bottom: 0px;">Hello,</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">the RPC commands usually target to change the data stored in Kamailio memory, like it is for location (kaamilio keeps the records in memory and use them from there, the database storage being only for ability
to restore on restart -- well, a matter of db_mode parameter, to be accurate).</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">If the records are used from database directly, there are no RPC commands, their management has to be done directly to database. This is the case for tables such as subscriber, dbaliases, speeddial.</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">Also, note that in some cases, when records are loaded from databases and can be changed in memory via RPC, they are not stored back to database, you still need to do that -- for example, dispatcher module.</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">Personally I do not think is useful to add such feature to Kamailio, it will add complexity and maintenance overhead (given that we support sql, no sql or different other backends like line-based text files),
and C is not the most flexible/easiest language to work with databases. Probably is better to have an external HTTP API server for such needs, in the same fashion of:</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"> * <a class="x_moz-txt-link-freetext" href="https://github.com/voipxswitch/kamailio-jsonrpc-client">
https://github.com/voipxswitch/kamailio-jsonrpc-client</a></p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">In many cases, at least for subscriber, the table is extended with new columns for having a richer user profile, and used via load_credentials modparam or sqlops.<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">Cheers,<br>
Daniel<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<div class="x_moz-cite-prefix">On 09.07.21 10:50, Surabhi Garg wrote:<br>
</div>
<blockquote type="cite">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Hi Alex,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
By subscriber management I mean, auth_db module which actually works on subscriber table to add or alter sip account for authentications.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style=""><a href="https://kamailio.org/docs/modules/4.4.x/modules/auth_db.html#auth_db.f.auth_check" title="https://kamailio.org/docs/modules/4.4.x/modules/auth_db.html#auth_db.f.auth_check" target="_blank" rel="noreferrer noopener" tabindex="-1">Auth_db
Module (kamailio.org)</a></span><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
So, similar like usrloc module which you mentioned having JSONRPC commands to alter Location table. </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
I am looking for JSONRPC Command for subscriber module as well.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="color:rgb(0,0,0); font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">As far as my understanding, currently there is no JSONRPC command available for subscriber table.</span><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
So, if this is currently a known not offered feature / limitation shall we raise it as feature request if others also agree to its usefulness. </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
What I'm seeking is more of an acknowledgment that this feature doesn't exist & have it's benefit. As I can see other community members either ends up directly interacting with DB for subscriber table provisioning. Maybe I can contribute on this too.<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div id="x_Signature">
<div>
<div id="x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px">
<span style="color:rgb(0,111,201)">Surabhi Garg</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px">
<span style="color:rgb(0,111,201)">Mobile - 91 783 888 7523 | Skype - surabhi.garg9</span><br>
</p>
</div>
</div>
</div>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<br>
<div dir="ltr">
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:10pt; color:rgb(0,0,0)">
<br>
</div>
<div>
<div id="x_x_Signature">
<div>
<div id="x_x_divtagdefaultwrapper" dir="ltr" style="font-size:10pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<div>
<div><span style="font-family:Calibri; font-size:10pt"></span></div>
</div>
</div>
</div>
</div>
</div>
<div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> sr-users
<a class="x_moz-txt-link-rfc2396E" href="mailto:sr-users-bounces@lists.kamailio.org">
<sr-users-bounces@lists.kamailio.org></a> on behalf of Alex Balashov <a class="x_moz-txt-link-rfc2396E" href="mailto:abalashov@evaristesys.com">
<abalashov@evaristesys.com></a><br>
<b>Sent:</b> 09 July 2021 01:27<br>
<b>To:</b> Kamailio (SER) - Users Mailing List <a class="x_moz-txt-link-rfc2396E" href="mailto:sr-users@lists.kamailio.org">
<sr-users@lists.kamailio.org></a><br>
<b>Subject:</b> Re: [SR-Users] Subscriber Management using JSONRPC over HTTP</font>
<div> </div>
</div>
<div dir="auto">I am not 100% sure what you mean by subscriber management, but if you mean what I think you mean, these might be the droids you’re looking for:
<div><br>
</div>
<div><a href="https://kamailio.org/docs/modules/5.5.x/modules/usrloc.html#idm771">https://kamailio.org/docs/modules/5.5.x/modules/usrloc.html#idm771</a><br>
<br>
<div dir="ltr">—
<div>Sent from mobile, with due apologies for brevity and errors.</div>
</div>
<div dir="ltr"><br>
<blockquote type="cite">On Jul 8, 2021, at 3:55 PM, Surabhi Garg <a class="x_moz-txt-link-rfc2396E" href="mailto:surabhi.garg@outlook.com">
<surabhi.garg@outlook.com></a> wrote:<br>
<br>
</blockquote>
</div>
<blockquote type="cite">
<div dir="ltr">
<div style=""><span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">Hi Team,</span></div>
<div style=""><br>
</div>
<div style=""><span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">Greetings!</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style=""><span style="">I was trying to use HTTP to do the subscriber management (CRUD operations) & for that I am using JSONRPC-S module (JSONRPC over HTTP). But like other modules e.g. dispatcher, location I am unable to find any RPC commands for doing
subscriber management (checked in auth_db) module. So is there a way to achieve subscriber management using JSONRPC over HTTP.</span><br>
</div>
<div style=""><span style=""><br>
</span></div>
<div style=""><font face="Segoe UI, system-ui, Apple
Color Emoji, Segoe UI Emoji, sans-serif"><span style="font-size:14px">Few HTTP examples which I am using for dispatcher module are given below. Similar commands I am looking for subscriber
management as well. </span></font></div>
<div style=""><font face="Segoe UI, system-ui, Apple
Color Emoji, Segoe UI Emoji, sans-serif"><span style="font-size:14px"><br>
</span></font></div>
<div style="">
<p class="x_x_x_p1" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px; margin:0px; font:13px
"Helvetica Neue"">
<span style="background-color:rgb(255,255,0)">curl <a class="x_moz-txt-link-freetext" href="http://localhost:8081/RPC">
http://localhost:8081/RPC</a> -H "Content-Type: application/json" -d " {\"jsonrpc\":\"2.0\",\"method\":\"dispatcher.add\", \"params\":[2, \<a class="x_moz-txt-link-rfc2396E" href="sip:127.0.0.1:5061\">"sip:127.0.0.1:5061\"</a>], \"id\": \"1\"}"</span></p>
<br>
</div>
<div style="">
<p class="x_x_x_p1" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px; margin:0px; font:13px
"Helvetica Neue"">
<span style="background-color:rgb(255,255,0)">curl <a class="x_moz-txt-link-freetext" href="http://localhost:8081/RPC">
http://localhost:8081/RPC</a> -H "Content-Type: application/json" -d " {\"jsonrpc\":\"2.0\",\"method\":\"dispatcher.remove\”, \"params\":[2, \<a class="x_moz-txt-link-rfc2396E" href="sip:127.0.0.1:5061\">"sip:127.0.0.1:5061\"</a>], \"id\": \"1\"}"</span></p>
<br>
</div>
<div style=""><br>
</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div id="x_x_x_Signature">
<div>
<div id="x_x_x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px">
<span style="color:rgb(0,111,201)">Surabhi Garg</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px; margin-top:0px; margin-bottom:0px">
<span style="color:rgb(0,111,201)">Mobile - 91 783 888 7523 </span><br>
</p>
</div>
</div>
</div>
</div>
<span>__________________________________________________________</span><br>
<span>Kamailio - Users Mailing List - Non Commercial Discussions</span><br>
<span> * <a class="x_moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">
sr-users@lists.kamailio.org</a></span><br>
<span>Important: keep the mailing list in the recipients, do not reply only to the sender!</span><br>
<span>Edit mailing list options or unsubscribe:</span><br>
<span> * <a class="x_moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a></span><br>
</div>
</blockquote>
</div>
</div>
</div>
</div>
<br>
<fieldset class="x_mimeAttachmentHeader"></fieldset>
<pre class="x_moz-quote-pre">__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
* <a class="x_moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:
* <a class="x_moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre class="x_moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="x_moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
<a class="x_moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="x_moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a></pre>
</div>
</div>
</body>
</html>