[Pacemaker] failed actions: insufficient privileges

[Alfredo Parisi]

yes, i'm using the same my.cnf and i'm working on ubuntu 10.10 server.
i've removed the mysql startup (update-rc.d -f mysql remove), so mysql is
managed only by pacemaker.
i've installed mysql-server by myself with phpmyadmin and php5.
on each mode there is an installation of mysql-server but the same my.cnf
file

2011/6/11 imnotpc <imnotpc at rock3d.net>

> On Saturday, June 11, 2011 14:29:54 Alfredo Parisi wrote:
> > If I start on mysql, in the /var/run/mysqld there is the .sock file...so
> I
> > think that the path is correct
>
> How are you starting mysql? I thought you said mysql couldn't write to that
> directory and you had to create the file yourself to get mysql to work.
>
> I can't give you any advice about cluster configuration since I'm a
> beginner
> myself, but I know a bit about mysql and I think the problem here is you
> are
> trying to create a mysql cluster configuration using 3 different sources:
> the
> mysql site, the defaults in the pacemaker mysql script, and the distro
> defaults. For some reason these all have very different default values for
> the
> parameters you need, and the configuration you posted doesn't match any of
> them.
>
> A few thoughts:
>
> Are you using the mysql installation that came with the distro, did you
> install mysql yourself on each node, or did you install it on the drbd
> device?
> Each of these will change the default values and the settings you need.
>
> If you're using mysql from the distro, what distro are you using? Distros
> based on openSUSE and Redhat use the pid and socket directories I listed
> earlier. You can change them, but then you break all the mysql tools and
> clients that came with the distro. If you're going to use the distro
> version
> of mysql I don't know of a good reason to change the defaults.
>
> According to the documentation you need to use the same my.cnf for all the
> nodes and it must reside on the drbd. It should also have the same settings
> as
> the default my.cnf on each node if possible since any other setting will
> break
> the tools on that node.
>
> My suggestion: Unless you need to compile your own mysqld, I would install
> the
> distro version on each node and use the distro defaults for both my.cfn and
> pacemaker.
>
> Jeff
>
>
>
>
> _______________________________________________
> 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/20110612/703f7cf4/attachment-0003.html>