Greetings folks;<br><br>I've been attempting to get a working db_virtual failover setup going and am having some very basic functionality problems while in testing, I was wondering if someone could shed some light one what I, presumably, am doing wrong.<br>
<br>Appropriate sections of config look something like this:<br>------------------------<br>modparam("alias_db", "db_url", "virtual://set1")<br><br>modparam("db_virtual", "db_max_consec_retrys", 3)<br>
<br>modparam("db_virtual","db_urls","define set1 FAILOVER")<br>modparam("db_virtual","db_urls","mysql://<a href="http://opensips:password@192.168.0.100/aliasdb">opensips:password@192.168.0.100/aliasdb</a>")<br>
modparam("db_virtual","db_urls","mysql://<a href="http://opensips:password@192.168.0.200/aliasdb">opensips:password@192.168.0.200/aliasdb</a>")<br><br>if (alias_db_lookup("opensips_inbound", "d")) {<br>
# Do something<br> };<br>------------------------<br><br>I'm running the Debian package release, 1.6.0-1, from the <a href="http://leurent.eu">leurent.eu</a> repository.<br><br>If I start OpenSIPs and then on the .100 DB do an iptables REJECT to simulate a DB problem OpenSIPs will simply retry the alias lookup infinitely.<br>
<br>Curiously, if I set up the iptables block, THEN start OpenSIPs, and toggle the block on and off, the failure mode appears to work as it should, which really confuses me.<br><br>Have I got an issue with how I expect this to work? How I've got it set up? Or do we think my testing methodology is bunk?<br>
<br>My many thanks;<br><br> - Jock<br>