R: [Users] avp_db_load problem

[Daniel-Constantin Mierla]

Hello,

what version of openser do you use. Looks like you use the avp notation 
from 1.1.x within a 1.0.x version.

Cheers,
Daniel


On 04/14/06 11:22, D'Addelfio Davide wrote:
>
> Hi Jayesh, I have a problem similar at yours, could you help me ?
>
>  
>
> I need to load data from acc table using avp_db_load. I setup my cfg 
> file in this way:
>
>  
>
> modparam("avpops", "db_scheme", 
> "scheme0:username_col=username;value_col=sip_callid;table=acc")
>
>  
>
> if (avp_db_load("$to", "$avp(s:sip_callid)/scheme0")) {
>
>    xlog("L_INFO","Lettura OK");
>
> };
>
>  
>
> But I have this error in the log:
>
>  
>
> Apr 14 01:07:55 localhost /usr/sbin/openser[6799]: 
> ERROR:avpops:parse_avp_db: unknow alias"avp(s:sip_callid)/scheme0"
>
> Apr 14 01:07:55 localhost /usr/sbin/openser[6799]: 
> ERROR:avpops:fixup_db_avp: parse failed Apr 14 01:07:55 localhost 
> /usr/sbin/openser[6799]: ERROR: fix_expr : fix_actions error
>
>  
>
> Any thought?
>
> Thanks for help
>
> Davide
>
>  
>
> ------------------------------------------------------------------------
>
> *Da:* users-bounces at openser.org [mailto:users-bounces at openser.org] 
> *Per conto di *Jayesh Nambiar
> *Inviato:* mercoledì 12 aprile 2006 0.06
> *A:* openser
> *Oggetto:* [Users] avp_db_load problem
>
>  
>
> Hi all,
>
> I was trying to do the following:
>
> Whenever a user presses *86 and then any number, first openser should 
> check
>
> in the subscriber table, whether the value for features column is 1. 
> (I've added an extra column features in the table subscriber with 
> datatype int).
>
> If the value is 0, he should be replied with the message Forbidden.
>
> I tried doing the following:
>
>  
>
> modparam("avpops","db_scheme",
>        "scheme1:username_col=username;value_col=features;table=subscriber")
>
>  
>
> if(uri=~"sip:\*86[0-9]*@") {
>                 log(1,"entered condition");
>                 if(avp_db_load("$fU", "$avp(s:features)/$scheme1")) {
>                 log(1,"db load succeeded");
>                 if(!avp_check("$avp(s:features)", "eq/1/g")) {
>                         sl_send_reply("403", "Forbidden");
>                         exit;
>                 };
>                 strip(3);
>                 log(1,"stripped");
>                 avp_db_query("insert into usr_preferences values('', 
> '$fU', '', 'callfwd', '', '$ruri', 'CURRENT_TIMESTAMP')");
>                 sl_send_reply("200", "OK");
>                 exit;
>         };
>
>         };
>
> But in the logs I only get "condition succeeded" which means it does 
> not do the avp_db_load() properly.
>
>  
>
> Can someone please help me in what should be the exact syntax to load 
> it from the db and then check the value.
>
>  
>
> thanks in advance,
>
> jayesh
>
> ------------------------------------------------------------------------
>
> Jiyo cricket on Yahoo! India cricket 
> <http://us.rd.yahoo.com/mail/in/mailcricket/*http:/in.sports.yahoo.com/cricket/>
> Yahoo! Messenger Mobile 
> <http://us.rd.yahoo.com/mail/in/mailmobilemessenger/*http:/in.mobile.yahoo.com/new/messenger/> 
> Stay in touch with your buddies all the time.
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>