13 Apr
2006
13 Apr
'06
7:24 p.m.
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(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