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 bog...@voice-system.ro 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 bog...@voice-system.ro 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 abalas...@evaristesys.com 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
[OpenSIPS-Users] Is RPID being cached?
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
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
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 abalas...@evaristesys.com 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