<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello,</p>
<p>the avps are available only for the duration of a transaction.
They don't persist between register and invite. But you should
authenticate invites as well, not only registrations, and then the
avp will be loaded and set for invites.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<br>
<div class="moz-cite-prefix">On 19/10/16 10:36, Ivan Dudko wrote:<br>
</div>
<blockquote
cite="mid:CAMY-Hu_RA-8mEtd=ajT9ywOqmaNdJdOAjNMWod738tBoyWjtWw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Hello?<br>
<br>
Is avp value live only for one request dialog?<br>
</div>
Or i am doing this wrong?<br>
<br>
Or it lives until user is unregistered?<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr">вт, 18 окт. 2016 г. в 16:10, Ivan Dudko <<a
moz-do-not-send="true" href="mailto:ivan.dudko@gmail.com">ivan.dudko@gmail.com</a>>:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr" class="gmail_msg">
<div class="gmail_msg">And I check. While kamailio process
REGISTER request $avp(i:123) value equals table column
call_limit.<br class="gmail_msg">
</div>
But after that while it process INVITE request $avp(i:123)
is <null><br class="gmail_msg">
</div>
<br class="gmail_msg">
<div class="gmail_quote gmail_msg">
<div dir="ltr" class="gmail_msg">вт, 18 окт. 2016 г. в
11:59, Ivan Dudko <<a moz-do-not-send="true"
href="mailto:ivan.dudko@gmail.com" class="gmail_msg"
target="_blank">ivan.dudko@gmail.com</a>>:<br
class="gmail_msg">
</div>
</div>
<div class="gmail_quote gmail_msg">
<blockquote class="gmail_quote gmail_msg" style="margin:0 0
0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr" class="gmail_msg">
<div class="gmail_msg">
<div class="gmail_msg">
<div class="gmail_msg">
<div class="gmail_msg">Thank you, Daniel<br
class="gmail_msg">
</div>
I am trying to do this.<br class="gmail_msg">
modparam("auth_db", "load_credentials",
"$avp(i:123)=call_limit")<br class="gmail_msg">
</div>
<div class="gmail_msg"><br class="gmail_msg">
After auth:<br class="gmail_msg">
<br class="gmail_msg">
</div>
This from mysql log:<br class="gmail_msg">
2016-10-18T07:14:02.598195Z   4451 Query   select
`password`,`call_limit` from `subscriber` where
`username`='2000'<br class="gmail_msg">
2016-10-18T07:14:02.599166Z   4451 Query   select
`username` from `subscriber` where `username`='' AND
`domain`='172.21.0.150'<br class="gmail_msg">
<br class="gmail_msg">
</div>
But when i want to see value of this avp in
route[DIALOG]:<br class="gmail_msg">
xlog("L_INFO", "Control Active Calls $avp(i:123)");<br
class="gmail_msg">
</div>
<div class="gmail_msg"><br class="gmail_msg">
I call from 2000 to another peer аnd recieve null:<br
class="gmail_msg">
Oct 18 11:14:38 kamailio /usr/sbin/kamailio[11470]:
INFO: <script>: Control Active Calls
<null><br class="gmail_msg">
</div>
<br class="gmail_msg">
</div>
<br class="gmail_msg">
<div class="gmail_quote gmail_msg">
<div dir="ltr" class="gmail_msg">пн, 17 окт. 2016 г. в
13:44, Daniel-Constantin Mierla <<a
moz-do-not-send="true"
href="mailto:miconda@gmail.com" class="gmail_msg"
target="_blank">miconda@gmail.com</a>>:<br
class="gmail_msg">
</div>
</div>
<div class="gmail_quote gmail_msg">
<blockquote class="gmail_quote gmail_msg"
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_-6309277843444448265m_1050302245035115136m_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_-6309277843444448265m_1050302245035115136m_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 moz-do-not-send="true" class="m_-6309277843444448265m_1050302245035115136m_6270426499417383080moz-txt-link-abbreviated gmail_msg" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" class="m_-6309277843444448265m_1050302245035115136m_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_-6309277843444448265m_1050302245035115136m_6270426499417383080moz-signature gmail_msg" cols="72">--
Daniel-Constantin Mierla
<a moz-do-not-send="true" class="m_-6309277843444448265m_1050302245035115136m_6270426499417383080moz-txt-link-freetext gmail_msg" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" class="m_-6309277843444448265m_1050302245035115136m_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 moz-do-not-send="true" class="m_-6309277843444448265m_1050302245035115136m_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 moz-do-not-send="true"
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 moz-do-not-send="true"
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>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Berlin, Oct 24-26, 2016 - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
</body>
</html>