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

Mike Williams mike at mikebwilliams.com
Fri Dec 15 22:09:26 CET 2006


If you have some time, the Asterisk - OpenSER integration section of the 
dokuwiki would really benefit from a tutorial about this.

Mike

On Thursday 14 December 2006 03:47, 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




More information about the Users mailing list