Hi Bogdan, I'm trying to setup my config file , did the same
modparam("avpops", "db_scheme", "scheme0:username_col=from;value_col=timestamp;value_type=string;table=acc") modparam("avpops","avp_aliases","timestamp=i:800")
if (method=="INVITE") avp_db_load("$from","$timestamp/$scheme0");
I'm not sure that is correct...
log gives me these errors
Apr 11 08:42:59 localhost /usr/sbin/openser[13752]: submit_query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'from='bob'' at line 1 Apr 11 08:42:59 localhost /usr/sbin/openser[13752]: db_query: Error while submitting query Apr 11 08:42:59 localhost /usr/sbin/openser[13752]: ERROR:avpops:load_avps: db_load failed
Any thought?
Thanks Davide
-----Messaggio originale----- Da: users-bounces@openser.org [mailto:users-bounces@openser.org] Per conto di Bogdan-Andrei Iancu Inviato: martedì 11 aprile 2006 16.12 A: D'Addelfio Davide Cc: users@openser.org Oggetto: Re: [Users] load from db table
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
Hi,
most probably the scheme definition doesn't match the acc table format. Try to see in the mysql logs what is the performed query and what is the problem
regards, bogdan
D'Addelfio Davide wrote:
Hi Bogdan, I'm trying to setup my config file , did the same
modparam("avpops", "db_scheme", "scheme0:username_col=from;value_col=timestamp;value_type=string;table=acc") modparam("avpops","avp_aliases","timestamp=i:800")
if (method=="INVITE") avp_db_load("$from","$timestamp/$scheme0");
I'm not sure that is correct...
log gives me these errors
Apr 11 08:42:59 localhost /usr/sbin/openser[13752]: submit_query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'from='bob'' at line 1 Apr 11 08:42:59 localhost /usr/sbin/openser[13752]: db_query: Error while submitting query Apr 11 08:42:59 localhost /usr/sbin/openser[13752]: ERROR:avpops:load_avps: db_load failed
Any thought?
Thanks Davide
-----Messaggio originale----- Da: users-bounces@openser.org [mailto:users-bounces@openser.org] Per conto di Bogdan-Andrei Iancu Inviato: martedì 11 aprile 2006 16.12 A: D'Addelfio Davide Cc: users@openser.org Oggetto: Re: [Users] load from db table
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
-
Bogdan-Andrei Iancu -
D'Addelfio Davide