4 Feb
2010
4 Feb
'10
9:43 a.m.
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
4 Feb
4 Feb
11:28 a.m.
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
11:36 a.m.
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
11:43 a.m.
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
12:53 p.m.
On 2/4/10 5:43 PM, Henning Westerholt wrote:
On Thursday 04 February 2010, Ricardo Coelho wrote:
also check if the time on both servers is synchronized.
Cheers,
Daniel
--
Daniel-Constantin Mierla
eLearning class for Kamailio 3.0.0
Starting Feb 8, 2010
* http://www.asipto.com/
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.
5457
days inactive
5457
days old
4 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Henning Westerholt -
Ricardo Coelho