<div dir="ltr"><div><div><div><div>Thank you, Daniel<br></div>I am trying to do this.<br>modparam("auth_db", "load_credentials", "$avp(i:123)=call_limit")<br></div><div><br>After auth:<br><br></div>This from mysql log:<br>2016-10-18T07:14:02.598195Z 4451 Query select `password`,`call_limit` from `subscriber` where `username`='2000'<br>2016-10-18T07:14:02.599166Z 4451 Query select `username` from `subscriber` where `username`='' AND `domain`='172.21.0.150'<br><br></div>But when i want to see value of this avp in route[DIALOG]:<br>xlog("L_INFO", "Control Active Calls $avp(i:123)");<br></div><div><br>I call from 2000 to another peer аnd recieve null:<br>Oct 18 11:14:38 kamailio /usr/sbin/kamailio[11470]: INFO: <script>: Control Active Calls <null><br></div><br></div><br><div class="gmail_quote"><div dir="ltr">пн, 17 окт. 2016 г. в 13:44, Daniel-Constantin Mierla <<a href="mailto:miconda@gmail.com">miconda@gmail.com</a>>:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000" class="gmail_msg">
<p class="gmail_msg">Hello,</p>
<p class="gmail_msg">you can use sqlops module to load data from database and store in
an xavp.</p>
<p class="gmail_msg">If you want to load from subscriber table along with auth
credentials, look at load_credentials parameter from auth_db
module.</p>
<p class="gmail_msg">Cheers,<br class="gmail_msg">
Daniel<br class="gmail_msg">
</p></div><div bgcolor="#FFFFFF" text="#000000" class="gmail_msg">
<br class="gmail_msg">
<div class="m_6270426499417383080moz-cite-prefix gmail_msg">On 14/10/16 12:05, Ivan Dudko wrote:<br class="gmail_msg">
</div>
</div><div bgcolor="#FFFFFF" text="#000000" class="gmail_msg"><blockquote type="cite" class="gmail_msg">
<div dir="ltr" class="gmail_msg">
<div class="gmail_msg">Hello!<br class="gmail_msg">
<br class="gmail_msg">
I am trying to implement limit of active calls for
subscribers. And for each subscriber this limit must be
personal.<br class="gmail_msg">
<br class="gmail_msg">
I find example route in presentation of Daniel-Constantin
Mierla.<br class="gmail_msg">
And i need to set $xavp(caller=>active_calls) = 1;<br class="gmail_msg">
</div>
for each dialog. But i can't understand how to load this number
of active calls from some-thing similar of user profile or
subscriber table?<br class="gmail_msg">
<div class="gmail_msg"><br class="gmail_msg">
route[DIALOG] {<br class="gmail_msg">
<br class="gmail_msg">
if (is_method("CANCEL") || (has_totag() &&
is_method("INVITE|BYE|ACK"))) {<br class="gmail_msg">
dlg_manage();<br class="gmail_msg">
return;<br class="gmail_msg">
}<br class="gmail_msg">
<br class="gmail_msg">
if (is_method("INVITE") && !has_totag() &&
!isflagset(WITH_ACTIVE_CALLS_LIMIT)) {<br class="gmail_msg">
if( $xavp(caller[0]=>active_calls) != $null
&& $xavp(caller[0]=>active_calls) > 0 ) {<br class="gmail_msg">
if(!get_profile_size("caller", "$fU@$fd",
"$var(acsize)")) {<br class="gmail_msg">
send_reply("500", "No more active calls");<br class="gmail_msg">
exit;<br class="gmail_msg">
}<br class="gmail_msg">
if($var(acsize)>=$xavp(caller[0]=>active_calls)) {<br class="gmail_msg">
send_reply("403", "No more active calls");<br class="gmail_msg">
exit;<br class="gmail_msg">
}<br class="gmail_msg">
set_dlg_profile("caller", "$fU@$fd");<br class="gmail_msg">
}<br class="gmail_msg">
setflag(WITH_ACTIVE_CALLS_LIMIT);<br class="gmail_msg">
dlg_manage();<br class="gmail_msg">
}<br class="gmail_msg">
}<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
</div>
</div>
<br class="gmail_msg">
<fieldset class="m_6270426499417383080mimeAttachmentHeader gmail_msg"></fieldset>
<br class="gmail_msg">
</blockquote></div><div bgcolor="#FFFFFF" text="#000000" class="gmail_msg"><blockquote type="cite" class="gmail_msg"><pre class="gmail_msg">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="m_6270426499417383080moz-txt-link-abbreviated gmail_msg" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a class="m_6270426499417383080moz-txt-link-freetext gmail_msg" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br class="gmail_msg">
<pre class="m_6270426499417383080moz-signature gmail_msg" cols="72">--
Daniel-Constantin Mierla
<a class="m_6270426499417383080moz-txt-link-freetext gmail_msg" href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a class="m_6270426499417383080moz-txt-link-freetext gmail_msg" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Berlin, Oct 24-26, 2016 - <a class="m_6270426499417383080moz-txt-link-freetext gmail_msg" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a></pre>
</div>
_______________________________________________<br class="gmail_msg">
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br class="gmail_msg">
<a href="mailto:sr-users@lists.sip-router.org" class="gmail_msg" target="_blank">sr-users@lists.sip-router.org</a><br class="gmail_msg">
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br class="gmail_msg">
</blockquote></div>