<div dir="ltr">Hi ,<div>Am trying to configure my sql on ubuntu according to this article :</div><div><a href="https://azure.microsoft.com/en-in/documentation/articles/virtual-machines-linux-classic-mysql-cluster/">https://azure.microsoft.com/en-in/documentation/articles/virtual-machines-linux-classic-mysql-cluster/</a><br></div><div><br></div><div>two node cluster </div><div><br></div><div><br></div><div>looking on corosync log :</div><div><br></div><div><div><br></div><div>Apr 12 11:01:09 corosync [TOTEM ] Totem is unable to form a cluster because of an operating system or network fault. The most common cause of this message is that the local firewall is configured improperly.</div><div>Apr 12 11:01:11 corosync [TOTEM ] Totem is unable to form a cluster because of an operating system or network fault. The most common cause of this message is that the local firewall is configured improperly.</div><div>Apr 12 11:01:13 corosync [TOTEM ] Totem is unable to form a cluster because of an operating system or network fault. The most common cause of this message is that the local firewall is configured improperly.</div><div>Apr 12 11:01:16 corosync [TOTEM ] Totem is unable to form a cluster because of an operating system or network fault. The most common cause of this message is that the local firewall is configured improperly.</div><div>Apr 12 11:01:18 corosync [TOTEM ] Totem is unable to form a cluster because of an operating system or network fault. The most common cause of this message is that the local firewall is configured improperly.</div><div>Apr 12 11:01:20 corosync [TOTEM ] Totem is unable to form a cluster because of an operating system or network fault. The most common cause of this message is that the local firewall is configured improperly.</div><div>Apr 12 11:01:22 corosync [TOTEM ] Totem is unable to form a cluster because of an operating system or network fault. The most common cause of this message is that the local firewall is configured improperly.</div><div>Apr 12 11:01:24 corosync [TOTEM ] Totem is unable to form a cluster because of an operating system or network fault. The most common cause of this message is that the local firewall is configured improperly.</div><div>Apr 12 11:01:27 corosync [TOTEM ] Totem is unable to form a cluster because of an operating system or network fault. The most common cause of this message is that the local firewall is configured improperly.</div><div>Apr 12 11:01:29 corosync [TOTEM ] Totem is unable to form a cluster because of an operating system or network fault. The most common cause of this message is that the local firewall is configured improperly.</div><div>Apr 12 11:01:31 corosync [TOTEM ] Totem is unable to form a cluster because of an operating system or network fault. The most common cause of this message is that the local firewall is configured improperly.</div></div><div><br></div><div><br></div><div><div><br></div><div>totem {</div><div> version: 2</div><div> crypto_cipher: none</div><div> crypto_hash: none</div><div> interface {</div><div> ringnumber: 0</div><div> bindnetaddr: 10.1.0.0</div><div> mcastport: 5405</div><div> ttl: 1</div><div> }</div><div> transport: udpu</div><div>}</div><div>logging {</div><div> fileline: off</div><div> to_logfile: yes</div><div> to_syslog: yes</div><div> logfile: /var/log/corosync/corosync.log</div><div> debug: off</div><div> timestamp: on</div><div> logger_subsys {</div><div> subsys: QUORUM</div><div> debug: off</div><div> }</div><div> }</div><div>nodelist {</div><div> node {</div><div> ring0_addr: 10.1.0.6</div><div> nodeid: 1</div><div> }</div><div> node {</div><div> ring0_addr: 10.1.0.7</div><div> nodeid: 2</div><div> }</div><div>}</div><div>quorum {</div><div> provider: corosync_votequorum</div><div>}</div></div><div><br></div><div><br></div><div><p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">If I initiate a tcpdump on node 2 and start either a
netcat or nmap I see packet arrives to destination host for port 5405 UDP
traffic</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">I do see Corosync listening on the IP/PORT</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">root@node-2:/home/dinor# netstat -an | grep -i 5405</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">udp
0 0 <a href="http://10.1.0.7:5405">10.1.0.7:5405</a>
0.0.0.0:*
</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><a name="_MailEndCompose"></a><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">root@node-1:/home/dinor# netstat -an | grep -i 5405</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">udp
0 0
<a href="http://10.1.0.6:5405">10.1.0.6:5405</a>
0.0.0.0:* </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">On node 1 I start a netcat to port 5405 via udp</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">netcat -D -4 -u 10.1.0.7 5405</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">In here you type some text and hit enter</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">On node 1 tcpdump we see data sent to IP 10.1.0.7</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">root@node-1:/var/log/corosync# tcpdump -n udp port
5405</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">tcpdump: verbose output suppressed, use -v or -vv for
full protocol decode</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">listening on eth0, link-type EN10MB (Ethernet),
capture size 65535 bytes</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">10:08:24.484533 IP 10.1.0.6.44299 > 10.1.0.7.5405:
UDP, length 26</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">On node 2 tcpdump I see the data arrive</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">root@node-2:/var/log/corosync# tcpdump -n udp port
5405</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">tcpdump: verbose output suppressed, use -v or -vv for
full protocol decode</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">listening on eth0, link-type EN10MB (Ethernet),
capture size 65535 bytes</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">10:08:24.484892 IP 10.1.0.6.44299 > 10.1.0.7.5405:
UDP, length 26</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">Tested also sending UDP packets from node 2 – all ok.</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">So connectivity seems to be ok.</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">Port scanner also shows the port as Open</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">root@node-1:/home/dinor# nmap -sUV 10.1.0.7 -p
5402-5405</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">Starting Nmap 5.21 ( <a href="http://nmap.org">http://nmap.org</a>
) at 2016-04-12 10:31 UTC</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">Nmap scan report for node-2 (10.1.0.7)</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">Host is up (0.00060s latency).</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">PORT
STATE SERVICE VERSION</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">5402/udp
closed unknown</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">5403/udp
closed unknown</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">5404/udp
closed unknown</span></p>
<p class="MsoNormal"><b><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">5405/udp open|filtered unknown</span></b></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">MAC Address: 12:34:56:78:9A:BC (Unknown)</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">Service detection performed. Please report any
incorrect results at <a href="http://nmap.org/submit/">http://nmap.org/submit/</a>
.</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">Nmap done: 1 IP address (1 host up) scanned in 79.07
seconds</span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"> </span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">There is no FW and no selinux enabled</span></p><p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"><br></span></p><p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif">help appreciated.</span></p><p class="MsoNormal"><span lang="EN-GB" style="font-size:12pt;font-family:Verdana,sans-serif"><br></span></p></div></div>