Re: [OpenSIPS-Users] Is RPID being cached?
Hi Alan,
Indeed, there was a bug in the handling of NULL columns in the db_mysql
module. It is fixed now, so updating should solve it.
Thanks for the report and help,
Bogdan
Alan Frisch wrote:
> Bogdan,
>
> Thanks for the info. I load the RPID with the modparam("auth_db",
> "load_credentials", "rpid") and put it into $avp(s:rpid).
>
> As long as OpenSIPS is in forked mode, it works fine. But when I was
> running it in non-forked mode is when I saw the retention behavior.
> Seems the RPID would stick when the column was NULLed, only a restart
> of OpenSIPS would get it back to no value.
>
> A.F.
>
> On Fri, Jan 15, 2010 at 11:22 AM, Bogdan-Andrei Iancu
> wrote:
>
>> Hi Alan,
>>
>> rpid is in subscriber table and should have nothing to do with usrloc
>> (and db_mode).
>>
>> How do you load the rpid and where do you store it (what kind of variable) ?
>>
>> Regards,
>> Bogdan
>>
>>
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
--
Bogdan-Andrei Iancu
www.voice-system.ro
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Is RPID being cached?
Bogdan,
Thanks for the info. I load the RPID with the modparam("auth_db",
"load_credentials", "rpid") and put it into $avp(s:rpid).
As long as OpenSIPS is in forked mode, it works fine. But when I was
running it in non-forked mode is when I saw the retention behavior.
Seems the RPID would stick when the column was NULLed, only a restart
of OpenSIPS would get it back to no value.
A.F.
On Fri, Jan 15, 2010 at 11:22 AM, Bogdan-Andrei Iancu
wrote:
> Hi Alan,
>
> rpid is in subscriber table and should have nothing to do with usrloc
> (and db_mode).
>
> How do you load the rpid and where do you store it (what kind of variable) ?
>
> Regards,
> Bogdan
>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Is RPID being cached?
Hi Alan, rpid is in subscriber table and should have nothing to do with usrloc (and db_mode). How do you load the rpid and where do you store it (what kind of variable) ? Regards, Bogdan Alan Frisch wrote: > I was using memory only for usrloc. I played around with the > different modes, then switched back to memory only. Noticed that the > RPID would cache when I was testing in non-forked mode, but works as > expected when forked mode. > > Thanks for the help. > > On Thu, Jan 14, 2010 at 3:13 PM, Alex Balashov > wrote: > >> Depends on your db_mode for the registrar. >> >> On 01/14/2010 03:07 PM, Alan Frisch wrote: >> >> >>> Using OpenSIPs 1.6.1 and have noticed a peculiar issue. >>> >>> If a subscriber has a value in the RPID column, then that value is >>> changed to NULL it seems that OpenSIPs still retains the previous >>> number. >>> >>> For example: >>> >>> If RPID column is NULL (initially) ---> if ($avp(s:rpid))) returns FALSE >>> If RPID column is changed to eg. 1234567890 ---> if ($avp(s:rpid)) >>> returns TRUE and is 1234567890 >>> If RPID column is then changed back to NULL ---> if ($avp(s:rpid)) >>> returns TRUE and is 1234567890 >>> >>> Is this a bug or a feature? In either case, is there a way to get >>> OpenSIPs to only use the current DB value? >>> >>> Thanks! >>> >>> ___ >>> Users mailing list >>> Users@lists.opensips.org >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> >> -- >> Alex Balashov - Principal >> Evariste Systems >> Web : http://www.evaristesys.com/ >> Tel : (+1) (678) 954-0670 >> Direct : (+1) (678) 954-0671 >> >> ___ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > > ___ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > -- Bogdan-Andrei Iancu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Is RPID being cached?
I was using memory only for usrloc. I played around with the different modes, then switched back to memory only. Noticed that the RPID would cache when I was testing in non-forked mode, but works as expected when forked mode. Thanks for the help. On Thu, Jan 14, 2010 at 3:13 PM, Alex Balashov wrote: > Depends on your db_mode for the registrar. > > On 01/14/2010 03:07 PM, Alan Frisch wrote: > >> Using OpenSIPs 1.6.1 and have noticed a peculiar issue. >> >> If a subscriber has a value in the RPID column, then that value is >> changed to NULL it seems that OpenSIPs still retains the previous >> number. >> >> For example: >> >> If RPID column is NULL (initially) ---> if ($avp(s:rpid))) returns FALSE >> If RPID column is changed to eg. 1234567890 ---> if ($avp(s:rpid)) >> returns TRUE and is 1234567890 >> If RPID column is then changed back to NULL ---> if ($avp(s:rpid)) >> returns TRUE and is 1234567890 >> >> Is this a bug or a feature? In either case, is there a way to get >> OpenSIPs to only use the current DB value? >> >> Thanks! >> >> ___ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > -- > Alex Balashov - Principal > Evariste Systems > Web : http://www.evaristesys.com/ > Tel : (+1) (678) 954-0670 > Direct : (+1) (678) 954-0671 > > ___ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Is RPID being cached?
Depends on your db_mode for the registrar. On 01/14/2010 03:07 PM, Alan Frisch wrote: > Using OpenSIPs 1.6.1 and have noticed a peculiar issue. > > If a subscriber has a value in the RPID column, then that value is > changed to NULL it seems that OpenSIPs still retains the previous > number. > > For example: > > If RPID column is NULL (initially) ---> if ($avp(s:rpid))) returns FALSE > If RPID column is changed to eg. 1234567890 ---> if ($avp(s:rpid)) > returns TRUE and is 1234567890 > If RPID column is then changed back to NULL ---> if ($avp(s:rpid)) > returns TRUE and is 1234567890 > > Is this a bug or a feature? In either case, is there a way to get > OpenSIPs to only use the current DB value? > > Thanks! > > ___ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Alex Balashov - Principal Evariste Systems Web : http://www.evaristesys.com/ Tel : (+1) (678) 954-0670 Direct : (+1) (678) 954-0671 ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
