Hi Bogdan,
i setup my openser.cfg to store SIP messages into acc tables of mysql, using extra accounting to store also the body part of the message. Now i need that openser read into that db's table, in particular in some rows of db. If I use avp_db_load it works only over usr_preference table, instead I want it looks into acc table.
How can I do?
Thanks for help Davide
Hi,
see: http://www.voice-system.ro/docs/avpops/ar01s06.html#avp_db_load
the "db_scheme" example.
regards, bogdan
D'Addelfio Davide wrote:
Hi Bogdan,
i setup my openser.cfg to store SIP messages into acc tables of mysql, using extra accounting to store also the body part of the message. Now i need that openser read into that db's table, in particular in some rows of db. If I use avp_db_load it works only over usr_preference table, instead I want it looks into acc table.
How can I do?
Thanks for help Davide
Hello,
if you use cvs head (development) version, the avp_db_query() is an alternative to avp_db_load(), with more flexibility in making queries.
http://openser.org/docs/modules/1.1.x/avpops.html#AEN239
Note: you should take care and protect against sql injection.
Cheers, Daniel
On 04/11/06 17:11, Bogdan-Andrei Iancu wrote:
Hi,
see: http://www.voice-system.ro/docs/avpops/ar01s06.html#avp_db_load
the "db_scheme" example.
regards, bogdan
D'Addelfio Davide wrote:
Hi Bogdan,
i setup my openser.cfg to store SIP messages into acc tables of mysql, using extra accounting to store also the body part of the message. Now i need that openser read into that db's table, in particular in some rows of db. If I use avp_db_load it works only over usr_preference table, instead I want it looks into acc table. How can I do? Thanks for help Davide
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users