R: [Users] load from db table

[D'Addelfio Davide]

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 at openser.org [mailto:users-bounces at openser.org] Per conto di Bogdan-Andrei Iancu
Inviato: martedì 11 aprile 2006 16.12
A: D'Addelfio Davide
Cc: users at 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 at openser.org
http://openser.org/cgi-bin/mailman/listinfo/users