[Kamailio-Users] avpops OR sqlops

alex pappas rebel.pappas at gmail.com
Mon Dec 21 19:17:44 CET 2009


Hi Alex,

I tried :

if(!is_avp_set("$avp(s:lnp_prefix)")){
                                xlog("alx ------- The new rU $rU with prefix
$avp(s:lnp_prefix)  return code:$retcode ----------");
                        }

and it looks like is doing to right thing BUT why I don't see the avp value?
I need this value to added in the front of rU as portability prefix..

Any comments about the sqlops ?

Thank

Alex



On Mon, Dec 21, 2009 at 6:37 PM, Alex Balashov <abalashov at evaristesys.com>wrote:

> Alex,
>
> Try:  if(is_avp_set("$avp(s:lnp_prefix)"))
>
> --
> Sent from mobile device
>
>
> On Dec 21, 2009, at 11:19 AM, alex pappas <rebel.pappas at gmail.com> wrote:
>
>  Hi all,
>>
>> I'm trying to make an sql query through my kamailio script in order to
>> check for number portability. i have a table with 2 col
>> (phonenumber,prefix). I'm trying both modules avpops and sqlops but I'm not
>> able to retreive any data.
>>
>> modparam("avpops", "db_url","mysql://openser:openserrw@localhost
>> /openser")
>>
>> avp_db_query("SELECT prefix FROM ported WHERE
>> phonenumber='$rU'","$avp(s:lnp_prefix)")  ;The query run perfectly in
>> command line.
>>
>> The return code is always 1 but when I print $avp(s:lnp_prefix) I get no
>> result.
>>
>> I have 2 questions :
>>
>> 1. Which is the best way to check portability in my case
>> 2. What I'm doing wrong and I'm not getting any result from the query.
>>
>> Thank you ALL
>>
>> Alex
>>
>>
>> _______________________________________________
>> Kamailio (OpenSER) - Users mailing list
>> Users at lists.kamailio.org
>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20091221/921847e5/attachment.htm>


More information about the sr-users mailing list