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.
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 http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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
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
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_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 [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
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@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_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 [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
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@gmail.com] *Envoyé :* mercredi 28 mai 2014 16:31 *À :* miconda@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_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> [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_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@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://twitter.com/#%21/miconda -http://www.linkedin.com/in/miconda
-
Daniel-Constantin Mierla -
Igor Potjevlesch