[Pacemaker] failed actions: insufficient privileges

[Dejan Muhamedagic]

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 at 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