Hi
Right now I have a single openser server configured to work with a single mysql database. I want to enhance availability by adding another openser server and use Mysql Cluster. When failover occurs, despite the fact that he databases have the same data, on one of the softphones i receive a message saying "User not found" and on the other softphone i receive a message saying "Security check failed". Do I need to change something in openser's configuration to make it work with mysql cluster?
Thanks in advanced
On Thursday 04 February 2010, Ricardo Coelho wrote:
Right now I have a single openser server configured to work with a single mysql database. I want to enhance availability by adding another openser server and use Mysql Cluster. When failover occurs, despite the fact that he databases have the same data, on one of the softphones i receive a message saying "User not found" and on the other softphone i receive a message saying "Security check failed". Do I need to change something in openser's configuration to make it work with mysql cluster?
Hi Ricardo,
i'm not aware of any options or general problems with mysql cluster and openser/ kamailio. But do you use also a clustered openser system? Then its a bit of a different story, there are some potentential configuration improvements like the authentification secret and nonce counter functionality there.
Cheers,
Henning
Hi Henning,
my system consists on 2 openser servers and two databases using MySql Cluster. Besides those problems i stated in the first message, when I change the parameter of modparam("usrloc", "db_mode", 2) to 3, the system stores the location of a user but after a few seconds it looses somes. Thanks for your help
Cheers, Ricardo
On Feb 4, 2010, at 4:28 PM, Henning Westerholt wrote:
On Thursday 04 February 2010, Ricardo Coelho wrote:
Right now I have a single openser server configured to work with a single mysql database. I want to enhance availability by adding another openser server and use Mysql Cluster. When failover occurs, despite the fact that he databases have the same data, on one of the softphones i receive a message saying "User not found" and on the other softphone i receive a message saying "Security check failed". Do I need to change something in openser's configuration to make it work with mysql cluster?
Hi Ricardo,
i'm not aware of any options or general problems with mysql cluster and openser/ kamailio. But do you use also a clustered openser system? Then its a bit of a different story, there are some potentential configuration improvements like the authentification secret and nonce counter functionality there.
Cheers,
Henning
On Thursday 04 February 2010, Ricardo Coelho wrote:
my system consists on 2 openser servers and two databases using MySql Cluster. Besides those problems i stated in the first message, when I change the parameter of modparam("usrloc", "db_mode", 2) to 3, the system stores the location of a user but after a few seconds it looses somes. Thanks for your help
Hi Ricardo,
try to set a common "secret" parameter for the auth module on both boxes, and disable the nonce_reuse (if this is available in your version). You could consult the auth module docs for more informations. With regards to the other problem, in db_mode 3 a deletion timer is periodically run. I'd try to enable query logging (if this is available in cluster) and investigate why this records disappear - if its deleted from openser or somewhere because of an error in cluster.
Cheers,
Henning
On 2/4/10 5:43 PM, Henning Westerholt wrote:
On Thursday 04 February 2010, Ricardo Coelho wrote:
my system consists on 2 openser servers and two databases using MySql Cluster. Besides those problems i stated in the first message, when I change the parameter of modparam("usrloc", "db_mode", 2) to 3, the system stores the location of a user but after a few seconds it looses somes. Thanks for your help
Hi Ricardo,
try to set a common "secret" parameter for the auth module on both boxes, and disable the nonce_reuse (if this is available in your version). You could consult the auth module docs for more informations. With regards to the other problem, in db_mode 3 a deletion timer is periodically run. I'd try to enable query logging (if this is available in cluster) and investigate why this records disappear - if its deleted from openser or somewhere because of an error in cluster.
also check if the time on both servers is synchronized.
Cheers, Daniel
-
Daniel-Constantin Mierla -
Henning Westerholt -
Ricardo Coelho