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
