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