Hi and thanks for the reply.<br>I've found the problem, pacemaker haven't the privileges for create the file mysqld.sock, infact if I stop one server and create mysqld.sock with 777 and own mysql:mysql, after restart corosync, it works...<br>
but this is only a temporary solution because when corosync is stopped on that machine, it delete the file socks and I have again the error.<br>Someone can help me for resolve this problem with the privileges.<br>thanks<br>
<br><div class="gmail_quote">2011/6/10 Dejan Muhamedagic <span dir="ltr"><<a href="mailto:dejanmm@fastmail.fm">dejanmm@fastmail.fm</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi,<br>
<div class="im"><br>
On Fri, Jun 10, 2011 at 05:43:17PM +0200, Alfredo Parisi wrote:<br>
> Hi at all,<br>
> I've a problem on crm_mon. I've configured apache, drbd and mysql with the<br>
> guide of cluster labs(Cluster from Scratch) and <a href="http://mysql.com" target="_blank">mysql.com</a> (<br>
> <a href="http://dev.mysql.com/doc/refman/5.6/en/ha-drbd-install-mysql.html" target="_blank">http://dev.mysql.com/doc/refman/5.6/en/ha-drbd-install-mysql.html</a>).<br>
> I've copied /var/lib/mysql and my.cnf on drbd device, created a symbolic<br>
> link on /etc/my.cnf but mysql doesn't works.<br>
><br>
> This is my crm_mon:<br>
><br>
> Online: [ server2 server1 ]<br>
> ><br>
> > Resource Group: mysql<br>
> > fs_mysql (ocf::heartbeat:Filesystem): Started server2<br>
> > ClusterIP (ocf::heartbeat:IPaddr2): Started server2<br>
> > mysqld (ocf::heartbeat:mysql): Stopped<br>
> > WebSite (lsb:apache2): Stopped<br>
> > Master/Slave Set: ms_drbd_mysql<br>
> > Masters: [ server2 ]<br>
> > Slaves: [ server1 ]<br>
> ><br>
> > Failed actions:<br>
> > mysqld_start_0 (node=server2, call=15, rc=4, status=complete):<br>
> > insufficient privileges<br>
> > mysqld_start_0 (node=server1, call=15, rc=4, status=complete):<br>
> > insufficient privileges<br>
<br>
</div>Check the cluster log file for what exactly went wrong (look for<br>
messages from the mysql resource). Probably one of the mysql<br>
directories has wrong permissions.<br>
<br>
Thanks,<br>
<br>
Dejan<br>
<div><div></div><div class="h5"><br>
> ><br>
> ><br>
> And this is my crm configuration:<br>
><br>
> node server1 \<br>
> attributes standby="off"<br>
> node server2 \<br>
> attributes standby="off"<br>
> primitive ClusterIP ocf:heartbeat:IPaddr2 \<br>
> params ip="10.10.7.100" cidr_netmask="32" \<br>
> op monitor interval="30s"<br>
> primitive WebSite lsb:apache2<br>
> primitive drbd_mysql ocf:linbit:drbd \<br>
> params drbd_resource="r0" \<br>
> op monitor interval="15s"<br>
> primitive fs_mysql ocf:heartbeat:Filesystem \<br>
> params device="/dev/drbd/by-res/r0" directory="/data/" fstype="ext3"<br>
> primitive mysqld ocf:heartbeat:mysql \<br>
> params binary="/usr/bin/mysqld_safe" config="/etc/mysql/my.cnf"<br>
> user="mysql" group="mysql" log="/var/log/mysql.log"<br>
> socket="/var/run/mysqld/mysqld.sock" datadir="/data/mysql/data"<br>
<br>
> group mysql fs_mysql ClusterIP mysqld WebSite<br>
> ms ms_drbd_mysql drbd_mysql \<br>
> meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1"<br>
> notify="true"<br>
> colocation mysql_on_drbd inf: mysql ms_drbd_mysql:Master<br>
> order mysql_after_drbd inf: ms_drbd_mysql:promote mysql:start<br>
> property $id="cib-bootstrap-options" \<br>
> dc-version="1.0.9-unknown" \<br>
> cluster-infrastructure="openais" \<br>
> expected-quorum-votes="2" \<br>
> stonith-enabled="false" \<br>
> no-quorum-policy="ignore" \<br>
> last-lrm-refresh="1306924621"<br>
> rsc_defaults $id="rsc-options" \<br>
> resource-stickiness="100"<br>
><br>
> Thanks a lot for your help.<br>
<br>
</div></div>> _______________________________________________<br>
> Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
> <a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
><br>
> Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
> Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
> Bugs: <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
<br>
<br>
_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
</blockquote></div><br>