#this next part logs an error if the message has no expires info
(scanner messages sent directly to proxy for instance)
if(is_present_hf("Expires"))
$avp(i:10) := $hdr(Expires);
else
$avp(i:10) := $ct.fields(expires);
if( $avp(i:10) == "0" )
{
...
Speaking of this, using a min_expires param to the registrar module seems to
defeat allowing users to unregister by sending a expires of zero. I seem to
remember it gets bumped to the min value. If true, I think there should be a
check added in the minimum time check to let zero sneak through as is and
remove the user from userloc table.
Richard
On Jul 8, 2010, at 5:33 AM, Premalatha Kuppan wrote:
> Hi,
>
> How do i check expiration for user, meaning to identify de-registration.
> When user is de-registred; then the request comes with expires=0; how to get
> this field and check in opensips.cfg file ?
>
> Any help ?
>
> Thanks,
> Prem
>
>
> On Wed, Jul 7, 2010 at 7:42 PM, Premalatha Kuppan <premala...@ngintech.com>
> wrote:
> Thanks to all.
>
> Its working now using $tu and avp_db_query.
>
> $var(x)=$(tu{uri.user});
> avp_db_query("INSERT INTO TESTTABLE (xxx,yyy,zzz)
> VALUES('$(var(x){s.select,0,_})','$(var(x){s.select,1,_})','$(var(x){s.select,2,_})')");
>
> Now, have to look how to remove these entries during de-registration.
>
> Thanks,
> Prem
>
>
>
> On Wed, Jul 7, 2010 at 5:05 PM, Bogdan-Andrei Iancu <bog...@voice-system.ro>
> wrote:
> Premalatha Kuppan wrote:
> > Thanks. Corrected teh opensips.cfg file
> >
> > But the problem was due to this. by default DB URL was NULL. Now i
> > have added the DB URL for avpops.
> > # default URL
> > modparam("avpops","db_url","mysql://user:pas...@host/database")
> >
> >
> >
> > But the value of $rU is NULL..am i placing it in wrong location?
>
> In REGISTER requests, the RURI has only domain part (sip:opensips.org)
> so it is normal to have $rU NULL. If you need to identity of the user
> who registered, according to SIP, you have to look at the TO URI - so
> use $tu to get TO uri and use the URI transformation if you want to
> split in in username and domain (see
> http://www.opensips.org/Resources/DocsCoreTran16#toc17 ).
>
>
> Regards,
> Bogdan
>
> > I want the userpart e.g: sip:userp...@domain is the request uri; i
> > need only userpart . I believe that would be stored in $rU; but tis
> > coming as NULL. Which variable or where should i place this command
> > for registration and de-registration.
> >
> > Any Idea ?
> >
> > On Wed, Jul 7, 2010 at 4:13 PM, mayamatakeshi <mayamatake...@gmail.com
> > <mailto:mayamatake...@gmail.com>> wrote:
> >
> >
> >
> > On Wed, Jul 7, 2010 at 7:32 PM, Premalatha Kuppan
> > <premala...@ngintech.com <mailto:premala...@ngintech.com>> wrote:
> >
> > Hi,
> >
> > Iam using avp_db_query, but opensips is dead with following error,
> >
> > During Registration, when the user is registered. I have to
> > parse and store th value in DB. So, included the avp_db_query
> > in this loop. Is this right one to do. I assume the value of
> > rU is NULL over here, probably its failing. Not sure :(
> >
> > Any insight ?
> >
> > if (is_method("REGISTER"))
> > {
> > # authenticate the REGISTER requests
> > (uncomment to enable auth)
> > if (!www_authorize("10.140.1.110", "subscriber"))
> > {
> > www_challenge("10.140.1.110", "0");
> > exit;
> > }
> >
> > # if (!db_check_to())
> > # {
> > # sl_send_reply("403","Forbidden auth ID");
> > # exit;
> > # }
> >
> > if (!save("location"))
> > sl_reply_error();
> >
> > $var(x) = $rU ;
> > avp_db_query("INSERT INTO TESTTABLE
> > (xxx,yyy,zzz)
> >
> > VALUES('$(var(x){s.select,0,_})','$var(x)({s.select,1,_})','$(var(x){s.select,2,_})'");
> > exit;
> > }
> >
> >
> > Jul 7 06:25:16 204548-4 /usr/local/sbin/opensips[17791]:
> > ERROR:avpops:fixup_db_query_avp: no db url defined to be used
> > by this function
> > Jul 7 06:25:16 204548-4 /usr/local/sbin/opensips[17791]:
> > *ERROR:core:fix_actions: fixing failed (code=-6) at cfg line 351*
> > Jul 7 06:25:16 204548-4 /usr/local/sbin/opensips[17791]:
> > ERROR:core:main: failed to fix configuration with err code -6
> >
> >
> > Clearly you misplaced the parenthesis:
> >
> >
> > $(var(x){s.select,0,_})',
> > '$var(x)({s.select,1,_})',
> > '$(var(x){s.select,2,_})'
> >
> >
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users@lists.opensips.org <mailto:Users@lists.opensips.org>
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Users mailing list
> > Users@lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
>
>
> --
> Bogdan-Andrei Iancu
> OpenSIPS Bootcamp
> 20 - 24 September 2010, Frankfurt, Germany
> www.voice-system.ro
>
>
> _______________________________________________
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
