Re: R: R: [Users] avp_db_load problem

[Daniel-Constantin Mierla]

On 04/14/06 15:04, D'Addelfio Davide wrote:

Hi daniel,

My version is 1.0.x, do you think is  wrong notation?

looks like, please check the readme file for 1.0.x:

http://openser.org/docs/modules/1.0.x/avpops.html

Cheers,
Daniel

-----Messaggio originale-----

Da: Daniel-Constantin Mierla [mailto:[EMAIL PROTECTED] Inviato: venerdì 14 aprile 2006 13.32

A: D'Addelfio Davide
Cc: Jayesh Nambiar; users@openser.org
Oggetto: Re: R: [Users] avp_db_load problem

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:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *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@openser.org
http://openser.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
Users@openser.org
http://openser.org/cgi-bin/mailman/listinfo/users