<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>To close the loop, this was the root cause of the problem. There are several configuration files that mySQL reads at startup, and later files in the chain overwrite settings from files earlier in the chain. I had to edit two or three config files on each
node to get mySQL to stop binding to 0.0.0.0 (netstat -tl is your friend!) but once I did the HAProxy clustered resource came back online.</p>
<p><br>
</p>
<p>Hopefully there's enough information in this thread to help those coming across this problem after me.<br>
</p>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>From:</b> Ian <ian.ninjabadger@gmail.com><br>
<b>Sent:</b> Wednesday, March 16, 2016 8:27 PM<br>
<b>To:</b> Cluster Labs - All topics related to open-source clustering welcomed<br>
<b>Subject:</b> Re: [ClusterLabs] Installed Galera, now HAProxy won't start</font>
<div> </div>
</div>
<div>
<div dir="ltr">> <span style="color:rgb(0,0,0); font-family:Calibri,Arial,Helvetica,sans-serif; font-size:16px">configure MariaDB server to bind to all available ports (</span><a id="LPlnk333944" title="Ctrl+Click or tap to follow the link" href="http://docs.openstack.org/ha-guide/controller-ha-galera-config.html" target="_blank" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:16px">http://docs.openstack.org/ha-guide/controller-ha-galera-config.html</a><span style="color:rgb(0,0,0); font-family:Calibri,Arial,Helvetica,sans-serif; font-size:16px">,
scroll to "Database Configuration," note that bind-address is 0.0.0.0.). If MariaDB binds to the virtual IP address, then HAProxy can't bind to that address and therefore won't start. Right?<br>
<br>
That is correct as far as my understanding goes. By binding to port 3306 on all IPs (0.0.0.0), you are effectively preventing HAProxy from being able to use port 3306 on its own IP and vice-versa.<br>
<br>
Try setting specific bind addresses for your Galera nodes; I would be surprised and interested if it didn't work.</span>
<div style="margin-bottom: 20px; overflow: auto; width: 100%; text-indent: 0px;" id="LPBorder_GT_14582223530820.24226156542707133">
<table style="width: 90%; background-color: rgb(255, 255, 255); position: relative; overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, 200);" id="LPContainer_14582223529760.18635545111156027" cellspacing="0">
<tbody>
<tr style="border-spacing: 0px;" valign="top">
<td colspan="2" style="vertical-align: top; position: relative; padding: 0px; display: table-cell;" id="TextCell_14582223530790.8341941186267002">
<div id="LPRemovePreviewContainer_14582223530800.00171591163649909"></div>
<div style="top: 0px; color: rgb(0, 120, 215); font-weight: 400; font-size: 21px; font-family: "wf_segoe-ui_light","Segoe UI Light","Segoe WP Light","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; line-height: 21px;" id="LPTitle_14582223530800.2833658574187965">
<a target="_blank" href="http://docs.openstack.org/ha-guide/controller-ha-galera-config.html" style="text-decoration: none;" id="LPUrlAnchor_14582223530800.4848516830663623">OpenStack Docs: Configuration</a></div>
<div style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: 400; font-family: "wf_segoe-ui_normal","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; font-size: 14px; line-height: 14px;" id="LPMetadata_14582223530810.9275760708237533">
docs.openstack.org</div>
<div style="display: block; color: rgb(102, 102, 102); font-weight: 400; font-family: "wf_segoe-ui_normal","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; font-size: 14px; line-height: 20px; max-height: 100px; overflow: hidden;" id="LPDescription_14582223530810.040930587970608556">
SELinux¶ Security-Enhanced Linux is a kernel module for improving security on Linux operating systems. It is commonly enabled and configured by default on Red Hat ...</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<br>
</div>
</div>
</div>
</body>
</html>