[Users] Woo hoo! (was: The usrloc table, Oracle, and Asterisk)

[Lucio Maciel]

How usrloc handle the expire? it supports both Expire header and contact
expires "field"?

If openser handle this, you could do an avp_db_query() selecting the
expere field from usrloc saving it to an avp, and than use this avp to
do the update on sipfriends?

theres a little overhead, but you will got the rigth expire value.

On Thu, 2006-12-14 at 21:49 +0100, Jerome Martin wrote:
> Did you see my answer to "he usrloc table, Oracle, and Asterisk" ?
> 
> On Thu, 2006-12-14 at 18:47 -0200, Juan Carlos Castro y Castro wrote:
> > Bogdan-Andrei Iancu escreveu:
> > > first of all, instead of using Oracle triggers you can log this info 
> > > directly from OpenSER using  avp_db_query
> > >       http://www.openser.org/docs/modules/1.2.x/avpops.html#AEN268
> > > and pseudo-variables to get the src_ip ($si), src_port ($sp) and 
> > > expire header. See
> > >       http://www.openser.org/dokuwiki/doku.php/pseudovariables:devel
> > 
> > avp_db_query("UPDATE sipfriends SET ipaddr='$si', port='$sp', 
> > regseconds=$Ts+$hdr(expires) WHERE name='$au'");
> > 
> > makes me a happy man! Unified registry for OpenSER and Asterisk. Y-EAH!
> > 
> > _______________________________________________
> > Users mailing list
> > Users at openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> 
> 
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
> 

Lúcio Fernando Maciel
Telecom South America
R. Ramiro D'Ávilla, 20 sala 306
Porto Alegre - RS - Brasil
lucio at tesatelecom.com
+55 (51) 3061-5569
+55 (51) 8442-1079