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_chec...
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@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@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