[Kamailio-Users] Question about redirect if user is not online

[Ali Jawad]

Hi
Thanks for your suggestion

I did enter the username and the mobile number into the usr_preferences
table and tried the below 

####### AVPOPS Section
modparam("avpops","avp_url","mysql://openser:xyxyxy@xxxxxxxxxxxx/openser
")
modparam("avpops","avp_table","usr_preferences")

In the route statement I did add 

                if(avp_db_load("$ruri/username","s:callfwd")){
                    avp_pushto("$ruri","s:callfwd");
                    route(8);
                    exit;
                };

I got this error

Sep 23 09:21:03 [340] ERROR:avpops:parse_avp_db: error - bad avp flags
Sep 23 09:21:03 [340] ERROR:avpops:fixup_db_avp: parse failed Sep 23
09:21:03 [340] ERROR:core:fix_actions: fixing failed (code=-1) at cfg
line 307 Sep 23 09:21:03 [340] CRITICAL:core:fix_expr: fix_actions error

Did I miss anything >?



-----Original Message-----
From: Daniel-Constantin Mierla [mailto:miconda at gmail.com] 
Sent: 2008-09-23 11:53
To: Ali Jawad
Cc: users
Subject: Re: [Kamailio-Users] Question about redirect if user is not
online

Hello,

On 09/22/08 16:16, Ali Jawad wrote:
>
> Hi
> I got the below fixed, however I do need to achieve something else as 
> well. When I forward the call to asterisk I need asterisk to forward 
> it in turn to my cellphone number. Where an how should I re-write the 
> DID number of my SIP packet that acts as the destination URI to my 
> cell phone number.
>
>  
>
to be sure I understand your needs, if the user is not online, you want 
to send the call to user's mobile.

Perhaps you already have the mobile number in some table in database. 
You can use avp_db_query() to load it in an AVP (see avpops module for 
more).

avp_db_query("select __gsm_number__ from __your_table__ where 
username='$rU'", "$avp(s:gsm_number)");

if(is_avp_set("$avp(s:gsm_number)"))
{
    $rU = $avp(s:gsm_number);
    $rd = "__your_pstn_gw_ip__";
    t_relay();
    exit;
}

Hope it helps,
Daniel

-- 
Daniel-Constantin Mierla
http://www.asipto.com


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.