[Pacemaker] failed actions: insufficient privileges

[imnotpc]

On Sunday, June 12, 2011 07:35:25 Alfredo Parisi wrote:
> This is my file my.cnf
> #
> # The MySQL database server configuration file.
> #
> # You can copy this to one of:
> # - "/etc/mysql/my.cnf" to set global options,
> # - "~/.my.cnf" to set user-specific options.
> #
> # One can use all long options that the program supports.
> # Run program with --help to get a list of available options and with
> # --print-defaults to see which it would actually understand and use.
> #
> # For explanations see
> # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
> 
> # This will be passed to all mysql clients
> # It has been reported that passwords should be enclosed with ticks/quotes
> # escpecially if they contain "#" chars...
> # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
> [client]
> port        = 3306
> socket        = /var/run/mysqld/mysqld.sock
> 
> # Here is entries for some specific programs
> # The following values assume you have at least 32M ram
> 
> # This was formally known as [safe_mysqld]. Both versions are currently
> parsed.
> [mysqld_safe]
> socket        = /var/run/mysqld/mysqld.sock
> nice        = 0

You set a pid file in pacemaker but I don't see one here. Try adding "pid-
file=/var/run/mysqld/mysqld.pid" under [mysqld_safe]

Does it run if you use the default data directory?

Jeff