[Linux-HA] MySQL OCF RA robustness

[Christian Rishøj]

Hi,

Please consider the following patch for the MySQL OCF resource agent:

--- mysql.orig	2008-02-03 03:43:45.933966300 +0100
+++ mysql	2008-02-03 04:09:00.706816303 +0100
@@ -268,6 +268,20 @@
          chown -R $OCF_RESKEY_user:$OCF_RESKEY_group  
$OCF_RESKEY_datadir
      fi

+    pid_dir=`dirname $OCF_RESKEY_pid`
+    if [ ! -d $pid_dir ] ; then
+	ocf_log info "Creating PID dir: $pid_dir"
+	mkdir -p $pid_dir
+	chown $OCF_RESKEY_user:$OCF_RESKEY_group $pid_dir
+    fi
+
+    socket_dir=`dirname $OCF_RESKEY_socket`
+    if [ ! -d $socket_dir ] ; then
+	ocf_log info "Creating socket dir: $socket_dir"
+	mkdir -p $socket_dir
+	chown $OCF_RESKEY_user:$OCF_RESKEY_group $socket_dir
+    fi
+
      # Uncomment to perform permission clensing
      # - not convinced this should be enabled by default
      #

The RA was unable to start MySQL on my Ubuntu servers because the /var/ 
run directory seemingly is purged at boot time.

WIth best regards
Christian