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 > > [email protected] > > http://openser.org/cgi-bin/mailman/listinfo/users > > > _______________________________________________ > Users mailing list > [email protected] > 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 [EMAIL PROTECTED] +55 (51) 3061-5569 +55 (51) 8442-1079 _______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
