R: [Users] load from db table

Bogdan-Andrei Iancu bogdan at voice-system.ro
Thu Apr 13 11:24:37 CEST 2006


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 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
>  
>





More information about the sr-users mailing list