<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt"><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><font size="3"><span style="font-family: arial,helvetica,sans-serif;">Hi all,</span><br style="font-family: arial,helvetica,sans-serif;"></font><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><div><font size="3"><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">I have a problem with using remote MySQL database server with two Asterisk (1.4.17)
servers. PhoneA registers with Asterisk#1 using realtime into MySQL on remote server and everything is working fine and when I call Phone A from Phone B (also registered with Asterisk#1) call is established. Problem is when I call </span></font><font size="3"><span style="font-family: arial,helvetica,sans-serif;">PhoneA
(which is registered with Asterisk#1) from PhoneC (which is registered
with Asterisk#2) and call fails because "cause 3 - No route to destination".</span></font><font size="3"><span style="font-family: arial,helvetica,sans-serif;"></span><br style="font-family: arial,helvetica,sans-serif;"><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">This is the record (among other data) for PhoneA in MySQL:</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">fullcontact/ipaddr/port/regserver</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">sip:361@10.2.4.15:5060;user=phone;transport=udp/10.2.4.15/5060/asterisk</span><br style="font-family: arial,helvetica,sans-serif;"><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">"sip show peers" on Asterisk#1</span><br style="font-family:
arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">Name/username Host Dyn Nat ACL Port Status Realtime</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">361/361 10.2.4.15 D 5060 OK (99 ms)</span><br style="font-family: arial,helvetica,sans-serif;"><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">"sip show peers" on Asterisk#2</span><br style="font-family:
arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">Name/username Host Dyn Nat ACL Port Status Realtime</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;"></span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">So, I have three questions:</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">1. Why is "Realtime" column on Asterisk#1 empty for PhoneA when it is registered by using realtime (is this normal condition?)</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">2. Why doesn't Asterisk#2
use IP address of PhoneA which exists in database<br>3. If I put this two Asterisk servers in failover mode (Linux HA) does this mean that no calls will be done until all phones register with secondary Asterisk server (e.g. if regexpire is 3600 sec, do I have to wait for one hour before phone reregister to the secondary server)?<br style="font-family: arial,helvetica,sans-serif;"></span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">I'm missing something, but I don't know what so I would be grateful for any directions. Should I do some kind of cache replication between this two Asterisk servers (if yes, how should I do it?)</span><br style="font-family: arial,helvetica,sans-serif;"><br style="font-family: arial,helvetica,sans-serif;"><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">Configuration on both Asterisk servers:</span><br
style="font-family: arial,helvetica,sans-serif;"><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">extconfig.conf</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">sippeers => mysql,asterisk,sipfriends</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">sipusers => mysql,asterisk,sipfriends</span><br style="font-family: arial,helvetica,sans-serif;"><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">res_mysql.conf</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">dbhost = 10.2.4.13</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">dbname = asterisk</span><br style="font-family:
arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">dbuser = xxx</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">dbpass = yyy</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">port = 3306</span><br style="font-family: arial,helvetica,sans-serif;"><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">sip.conf</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">dbhost = 10.2.4.13</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">dbname = asterisk</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">dbuser = xxx</span><br style="font-family:
arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">dbpass = yyy</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">port = 3306</span><br style="font-family: arial,helvetica,sans-serif;"><br style="font-family: arial,helvetica,sans-serif;"><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">Thanks</span><br style="font-family: arial,helvetica,sans-serif;"><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">Dubravko</span><br></font></div></div><font size="3"><br></font>
</div></div></div><br></div></div></div><br>
</body></html>