Could it be that the user that mysql runs as (mysql??) does not have permission to write to the folder /var/run/mysqld? Can you do the following in the system as root and report back?
su - <mysqluser> touch /var/run/mysqld/test Prakash On Aug 9, 2011, at 6:17 PM, Michael Szilagyi wrote: > I've recently started taking a look at pacemaker to get some kind of HA in a > mysql test environment. The grouping has a ocf:heartbeat:IPaddr2 and a > ocf:heartbeat:mysql monitor in it. The IP monitor spins up fine and properly > jumps around the cluster depending on which node is active. I'm having > issues getting mysql to spin up, however. > > Basically (so far) I've: > > Here is the definitions you can view when doing a crm configure edit: > > primitive p_novaSQL_IP ocf:heartbeat:IPaddr2 \ > params ip="172.17.0.96" nic="eth0" \ > op monitor interval="10s" > primitive p_mysql ocf:heartbeat:mysql \ > params binary="/usr/bin/mysqld_safe" config="/etc/mysql/my.cnf" > socket="/var/run/mysqld/mysock.sock" datadir="/var/lib/mysql" \ > op monitor interval="10s" timeout="30s" \ > op start interval="0" timeout="120" \ > op stop interval="0" timeout="120" \ > meta target-role="Started" > group g_sqlMonitor p_sql_IP p_mysql > property $id="cib-bootstrap-options" \ > dc-version="1.0.9-da7075976b5ff0bee71074385f8fd02f296ec8a3" \ > cluster-infrastructure="Heartbeat" \ > stonith-enabled="false" \ > last-lrm-refresh="1312926142" \ > no-quorum-policy="ignore" > > > Error reported from crm_mon: > p_novasql_start_0 (node=sql1, call=74, rc=-2, status=Timed Out): unknown exec > error > > Error reported from sql (/var/log/mysql/error.log) > 110809 14:57:22 [ERROR] Can't start server : Bind on unix socket: Permission > denied > 110809 14:57:22 [ERROR] Do you already have another mysqld server running on > socket: /var/run/mysqld/mysock.sock ? > 110809 14:57:22 [ERROR] Aborting > > > I've dug around but can't seem to find a resolution to this error. I've > looked at a couple quick & dirty examples for getting mysql up and running > with Pacemaker and the above seems to match with the config data. Any > ideas/suggestions would be greatly appreciated. > > -Mike. _______________________________________________ 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
