Re: [SR-Users] Location issue

Hello Daniel, It works fine with “db_op_rui”. Thank you. Regards, Igor. De : Igor Potjevlesch [mailto:igor.potjevlesch@gmail.com] Envoyé : mercredi 28 mai 2014 16:31 À : miconda(a)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@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_che… 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(a)lists.sip-router.org <mailto:sr-users-bounces@lists.sip-router.org> [mailto:sr-users-bounces@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… 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(a)lists.sip-router.org <mailto:sr-users@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