[SR-Users] Location issue

[Daniel-Constantin Mierla]

Hello,

thanks for giving feedback, we are considering removing the other 
options (with a first stage of making "db_ops_ruid" used by default), as 
it proves the way that works properly no matter of changes in call-id.

Cheers,
Daniel

On 11/06/14 05:45, Igor Potjevlesch wrote:
>
> Hello Daniel,
>
> It works fine with “db_op_rui”.
>
> Thank you.
>
> Regards,
>
> Igor.
>
> *De :*Igor Potjevlesch [mailto:igor.potjevlesch at gmail.com]
> *Envoyé :* mercredi 28 mai 2014 16:31
> *À :* miconda at gmail.com; 'Kamailio (SER) - Users Mailing List'
> *Objet :* RE: [SR-Users] Location issue
>
> Hello Daniel,
>
> Does it mean that the UAC sends its REGISTER just during the period 
> where Kamailio is restarting and, without response from Kamailio, the 
> UAC changes its Call-ID?
>
> I will try to use “db_op_ruid” during the next scheduled restart as it 
> looks to be more efficient for the DB usage. If doesn’t help, 
> “db_check_update” will certainly do the job.
>
> Many thanks for your suggestions.
>
> Regards,
>
> Igor.
>
> *De :*Daniel-Constantin Mierla [mailto:miconda at gmail.com]
> *Envoyé :* mercredi 28 mai 2014 15:57
> *À :* Igor Potjevlesch; 'Kamailio (SER) - Users Mailing List'
> *Objet :* Re: [SR-Users] Location issue
>
> Hello,
>
> typically the de-synchronization happens when the call-id is changed, 
> because there are various modes on matching the contact in the 
> database. Using ruid avoids this.
>
> Another option is to use:
>
> http://kamailio.org/docs/modules/stable/modules/usrloc.html#usrloc.p.db_check_update
>
> But I would go for ruid option, because it is also faster due to 
> single value key.
>
> Cheers,
> Daniel
>
> On 28/05/14 14:00, Igor Potjevlesch wrote:
>
>     Hello Daniel,
>
>     “db_mode” is set to 1 and “db_op_ruid” has the default value. So I
>     guess 0.
>
>     Do you think that setting “db_ops_ruid” to 1 will solve the issue?
>
>     I took a wireshark capture while the problem occured and saw that
>     Kamailio make an UPDATE request whereas the location database had
>     no more entry for the username.
>
>     Also, I look to the MySQL logs and see nothing in particular.
>
>
>     Regards,
>
>     Igor.
>
>     *De :*sr-users-bounces at lists.sip-router.org
>     <mailto:sr-users-bounces at lists.sip-router.org>
>     [mailto:sr-users-bounces at lists.sip-router.org] *De la part de*
>     Daniel-Constantin Mierla
>     *Envoyé :* mercredi 28 mai 2014 11:58
>     *À :* Kamailio (SER) - Users Mailing List
>     *Objet :* Re: [SR-Users] Location issue
>
>     Hello,
>
>     what is the value for db_mode parameter?
>
>     Can you try with db_ops_ruid set to 1:
>
>     http://kamailio.org/docs/modules/stable/modules/usrloc.html#usrloc.p.db_ops_ruid
>
>     Also, does database server logs point any error?
>
>     Cheers,
>     Daniel
>
>     On 28/05/14 11:35, Igor Potjevlesch wrote:
>
>         Hello,
>
>         I’m running Kamailio 4.1.3 and having a strange issue.
>
>         After a restart of Kamailio, some username are still in memory
>         and updated accordingly with usual re-REGISTER flow. But the
>         entries in location db is deleted. Kamailio tries to do a SQL
>         UPDATE which fails because of that.
>
>         So, for each username which are not in location DB, I must do
>         a “kamctl ul rm” and wait for the next REGISTER. The new
>         REGISTER will challenge the UAC for a new Authorization which
>         should result in an INSERT INTO instead of an UPDATE.
>
>         Can someone help me to solve this?
>
>         Regards,
>
>         Igor.
>
>
>
>
>         _______________________________________________
>
>         SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>
>         sr-users at lists.sip-router.org  <mailto:sr-users at lists.sip-router.org>
>
>         http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
>
>     -- 
>
>     Daniel-Constantin Mierla -http://www.asipto.com
>
>     http://twitter.com/#!/miconda  <http://twitter.com/#%21/miconda>  -http://www.linkedin.com/in/miconda
>
> -- 
> Daniel-Constantin Mierla -http://www.asipto.com
> http://twitter.com/#!/miconda  <http://twitter.com/#%21/miconda>  -http://www.linkedin.com/in/miconda

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140611/9f388c87/attachment.html>