<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Finally I was able to spot the problem.</div><div><br></div><div>It turns out that the resource was not properly configured. Somehow /etc/init.d/mysqld was working properly but resource.d/heartbeat/mysql was not. Even if I pointed both to the same configuration file, the script was ignoring some of the parameters I had set in the config file. It was quite useful to run directly the resource script setting the OCF variables as shown:</div><div><br></div><div><div>OCF_ROOT=/usr/lib/ocf</div><div>OCF_RESKEY_test_user=p_mon</div><div>OCF_RESKEY_config=/etc/my.cnf</div><div>OCF_RESKEY_test_table=monitor.boolean</div><div>OCF_RESKEY_group=mysql</div><div>OCF_RESKEY_test_passwd=p_mon</div><div>OCF_RESKEY_user=mysql</div><div>OCF_RESKEY_socket=/var/lib/mysql/mysql.sock</div><div>OCF_RESKEY_datadir=/opt/manhattan/mysql</div><div>OCF_RESKEY_binary=/usr/bin/mysqld_safe</div></div><div><br></div><div>The configuration for the mysql resource is now:</div><div><br></div><div><div>primitive p_mysqld_left ocf:heartbeat:mysql \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>params binary="/usr/bin/mysqld_safe" config="/etc/my.cnf" test_table="monitor.boolean" test_user="p_mon" test_passwd="p_mon" datadir="/opt/manhattan/mysql" socket="/var/lib/mysql/mysql.sock" user="mysql" group="mysql" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="15s" timeout="30s" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>op start interval="0" timeout="120s" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>op stop interval="0" timeout="120s" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>meta target-role="Started"</div></div><div><br></div><div>Best regards,</div><div><br></div><div>Rafa</div><div><br></div><div>
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; font-family: Helvetica; font-size: 12px; "><div><font class="Apple-style-span" face="Courier">-- <br>Rafael Porres Molina<br>Consultoría y Proyectos<br>Qindel Formación y Servicios S.L.<br><br>Móvil: (+34) 678650609<br>e-mail: <a href="mailto:rafael.porres@qindel.com">rafael.porres@qindel.com</a><br>Dirección: c/Julián Camarillo 29, Edificio D2, 4ºIzda, 28037 Madrid, SPAIN / ESPAÑA</font></div><div><font class="Apple-style-span" face="Courier"><br></font></div></div><br class="Apple-interchange-newline"></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br>
<br><br></body></html>