[SR-Users] Location issue

[Igor Potjevlesch]

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://www.linkedin.com/in/miconda
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140528/fdd3d2cc/attachment.html>