[Pacemaker] failed actions: insufficient privileges

[Alfredo Parisi]

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 <dejanmm at 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 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
>
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20110611/7a62df95/attachment-0003.html>