<HTML>
<HEAD>
<TITLE>Re: [SR-Users] Setting avp from load_credentials</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>I believe I have got it going down the right path now ... I have a few users that don’t auth, as I have them listed as static entries in the location table as well as in the trusted table.<BR>
I was testing with one of those PBX’s that don’t auth, so it was throwing me off. Since its just a few hardcoded trusted, I am doing an if/else on $si and assigning $var(blah) that way, and everyone else has $aU assigned to $var(blah).<BR>
<BR>
ThIs all ties into my previous thread form which I am using $var(blah) on my get_profile_size for my quota/call-limit checks for my outbound call tracking.<BR>
$rU works across the board for the inbound.<BR>
<BR>
I am now back to determine what is the best way to store the call-limit values ... In the subscriber table as a new column or in the quota table that I was using before.<BR>
<BR>
Thank you again Alex for all the pointers; indeed the dialog module is the best way to handle this.<BR>
<BR>
-graham<BR>
<BR>
<BR>
On 10/1/11 1:45 PM, "Alex Balashov" <<a href="abalashov@evaristesys.com">abalashov@evaristesys.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Alternately, if you dislike any of these paradigms or find the order of operations inconvenient, just roll your own. That's what sqlops is for.<BR>
<BR>
--<BR>
This message was painstakingly thumbed out on my mobile, so apologies for brevity, errors, and general sloppiness.<BR>
<BR>
Alex Balashov - Principal<BR>
Evariste Systems LLC<BR>
260 Peachtree Street NW<BR>
Suite 2200<BR>
Atlanta, GA 30303<BR>
Tel: +1-678-954-0670<BR>
Fax: +1-404-961-1892<BR>
Web: <a href="http://www.evaristesys.com/">http://www.evaristesys.com/</a> <<a href="http://www.evaristesys.com/">http://www.evaristesys.com/</a>> <BR>
<BR>
On Oct 1, 2011, at 10:43 AM, "<a href="graham@g-rock.net">graham@g-rock.net</a>" <<a href="graham@g-rock.net">graham@g-rock.net</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>I know I am Auth'ing users, but apparently need to confirm the location of www_authorize. Thanks for the pointers Alex. <BR>
<BR>
Sent from my HTC on the Now Network from Sprint!<BR>
<BR>
----- Reply message -----<BR>
From: "Alex Balashov" <<a href="abalashov@evaristesys.com">abalashov@evaristesys.com</a>><BR>
Date: Sat, Oct 1, 2011 9:07 am<BR>
Subject: [SR-Users] Setting avp from load_credentials<BR>
To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) -Users Mailing List" <<a href="sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>><BR>
<BR>
Sure it is, but credentials only get loaded if you are doing proxy/www_authorize() beforehand. Are you?<BR>
<BR>
--<BR>
This message was painstakingly thumbed out on my mobile, so apologies for brevity, errors, and general sloppiness.<BR>
<BR>
Alex Balashov - Principal<BR>
Evariste Systems LLC<BR>
260 Peachtree Street NW<BR>
Suite 2200<BR>
Atlanta, GA 30303<BR>
Tel: +1-678-954-0670<BR>
Fax: +1-404-961-1892<BR>
Web: <a href="http://www.evaristesys.com">http://www.evaristesys.com</a> <<a href="http://www.evaristesys.com">http://www.evaristesys.com</a>> /<BR>
<BR>
On Oct 1, 2011, at 9:24 AM, Graham Wooden <<a href="graham@g-rock.net">graham@g-rock.net</a>> wrote:<BR>
<BR>
> Hi there,<BR>
> <BR>
> Just doing a quick test and this doesn’t appear to be working. Kamailio<BR>
> 1.5.5-notls. Snippet of code:<BR>
> <BR>
> modparam("auth_db", "load_credentials", "username")<BR>
> .<BR>
> .<BR>
> .<BR>
> xlog("username is $avp(s:username)\n");<BR>
> <BR>
> <BR>
> The result is '<null>'. Is this not available in the route{} ?<BR>
> <BR>
> Thanks,<BR>
> <BR>
> -graham<BR>
> <BR>
> <BR>
> <BR>
> <BR>
> <BR>
> _______________________________________________<BR>
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<BR>
> <a href="sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a> <<a href="mailto:sr-users@lists.sip-router.org">mailto:sr-users@lists.sip-router.org</a>> <BR>
> <a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a> <<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>> <BR>
<BR>
_______________________________________________<BR>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<BR>
<a href="sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><BR>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><BR>
<BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
</SPAN></FONT></BLOCKQUOTE>
</BODY>
</HTML>