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(a)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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users