Hi All,<br><br>First off - thank you for this module.<br><br>I have configured two redundant DB sources in my kamailio confiuration. The DB's are accessed from Kamailio for redundancy pruposes. <br>Kamailio and the primary DB are on the same hardware node. The secondary DB is on a remote host. <br>
If Kamailio is up and both MySQL DB's are up, the config works like a charm. If the primary or the secondary DB becomes unreachable while Kamailio is up, the config handles the exception and all works well.<br><br>However, if any of the DB servers becomes unreachable and Kamailio is restarted, Kamailio can no longer start. <br>
<br>Below is an excerpt from my config file:<br><br># -- sqlops params<br>modparam("sqlops","sqlcon","pridb=>mysql://root:@localhost/db_table")<br>modparam("sqlops","sqlcon","secdb=>mysql://<a href="http://root:@192.168.1.231/db_table">root:@192.168.1.231/db_table</a>")<br>
<br><br>/var/log/messages<br><br>Jun 26 06:16:00 test-ser /sbin/kamailio[20217]: ERROR:db_mysql:db_mysql_new_connection: driver error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)<br>
Jun 26 06:16:00 test-ser /sbin/kamailio[20217]: ERROR:core:db_do_init: could not add connection to the pool<br>Jun 26 06:16:00 test-ser /sbin/kamailio[20217]: ERROR:sqlops:sql_connect: failed to connect to the database [pridb]<br>
Jun 26 06:16:00 test-ser /sbin/kamailio[20217]: ERROR:core:init_mod_child: failed to initializing module sqlops, rank 1<br>Jun 26 06:16:00 test-ser /sbin/kamailio[20217]: ERROR:core:main_loop: init_child failed for UDP listener<br>
<br><br>What is the proper way of using multiple database servers with Kamailio?<br><br>Thanks in advance.<br><br><br>--JR<br>