[SR-Users] Active calls limit

[Ivan Dudko]

Thank you, Daniel
I am trying to do this.
modparam("auth_db", "load_credentials", "$avp(i:123)=call_limit")

After auth:

This from mysql log:
2016-10-18T07:14:02.598195Z     4451 Query    select
`password`,`call_limit` from `subscriber` where `username`='2000'
2016-10-18T07:14:02.599166Z     4451 Query    select `username` from
`subscriber` where `username`='' AND `domain`='172.21.0.150'

But when i want to see value of this avp in route[DIALOG]:
xlog("L_INFO", "Control Active Calls $avp(i:123)");

I call from 2000 to another peer аnd recieve null:
Oct 18 11:14:38 kamailio /usr/sbin/kamailio[11470]: INFO: <script>: Control
Active Calls <null>


пн, 17 окт. 2016 г. в 13:44, Daniel-Constantin Mierla <miconda at gmail.com>:

> Hello,
>
> you can use sqlops module to load data from database and store in an xavp.
>
> If you want to load from subscriber table along with auth credentials,
> look at load_credentials parameter from auth_db module.
>
> Cheers,
> Daniel
>
> On 14/10/16 12:05, Ivan Dudko wrote:
>
> Hello!
>
> I am trying to implement limit of active calls for subscribers. And for
> each subscriber this limit must be personal.
>
> I find example route in presentation of Daniel-Constantin Mierla.
> And i need to set $xavp(caller=>active_calls) = 1;
> 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?
>
> route[DIALOG] {
>
>     if (is_method("CANCEL") || (has_totag() &&
> is_method("INVITE|BYE|ACK"))) {
>         dlg_manage();
>         return;
>     }
>
>     if (is_method("INVITE") && !has_totag() &&
> !isflagset(WITH_ACTIVE_CALLS_LIMIT)) {
>         if( $xavp(caller[0]=>active_calls) != $null &&
> $xavp(caller[0]=>active_calls) > 0 ) {
>             if(!get_profile_size("caller", "$fU@$fd", "$var(acsize)")) {
>                 send_reply("500", "No more active calls");
>                 exit;
>             }
>             if($var(acsize)>=$xavp(caller[0]=>active_calls)) {
>                 send_reply("403", "No more active calls");
>                 exit;
>             }
>             set_dlg_profile("caller", "$fU@$fd");
>         }
>         setflag(WITH_ACTIVE_CALLS_LIMIT);
>         dlg_manage();
>     }
> }
>
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierlahttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
> Kamailio Advanced Training, Berlin, Oct 24-26, 2016 - http://www.asipto.com
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20161018/0cc7fb62/attachment.html>