14 Dec
2006
14 Dec
'06
10:49 p.m.
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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users