Dejan, They would have come from the centos repository.
Thanks, Amy -----Original Message----- From: Dejan Muhamedagic <[EMAIL PROTECTED]> Sent: Friday, February 15, 2008 10:38am To: [EMAIL PROTECTED] Cc: [email protected] Subject: Re: FW: Re: FW: Re: [Linux-HA] mysql OCF issue on CentOS 5.1 after upgrading to heartbeat 2.1.3-3 Hi, On Fri, Feb 15, 2008 at 09:25:22AM -0500, [EMAIL PROTECTED] wrote: > Dejan, > > I think the problem might be stemming from this addition to the 2.1.3 script > > < # Fill in some defaults if no values are specified > < HOSTOS=`uname` > < if [ "X${HOSTOS}" == "XOpenBSD" ];then > < OCF_RESKEY_binary_default="/usr/local/bin/mysqld_safe" > < OCF_RESKEY_config_default="/etc/my.cnf" > < OCF_RESKEY_datadir_default="/var/mysql" > < OCF_RESKEY_user_default="_mysql" > < OCF_RESKEY_group_default="_mysql" > < OCF_RESKEY_log_default="/var/log/mysqld.log" > < OCF_RESKEY_pid_default="/var/mysql/mysqld.pid" > < OCF_RESKEY_socket_default="/var/run/mysql/mysql.sock" > < OCF_RESKEY_test_user_default="root" > < OCF_RESKEY_test_table_default="mysql.user" > < OCF_RESKEY_test_passwd_default="" > < OCF_RESKEY_enable_creation_default=0 > < OCF_RESKEY_additional_parameters_default="" > < else > < OCF_RESKEY_binary_default="/usr/bin/safe_mysqld" > < OCF_RESKEY_config_default="/etc/my.cnf" > < OCF_RESKEY_datadir_default="/var/lib/mysql" > < OCF_RESKEY_user_default="mysql" > < OCF_RESKEY_group_default="mysql" > < OCF_RESKEY_log_default="/var/log/mysqld.log" > < OCF_RESKEY_pid_default="/var/run/mysql/mysqld.pid" > < OCF_RESKEY_socket_default="/var/lib/mysql/mysql.sock" > < OCF_RESKEY_test_user_default="root" > < OCF_RESKEY_test_table_default="mysql.user" > < OCF_RESKEY_test_passwd_default="" > < OCF_RESKEY_enable_creation_default=0 > < OCF_RESKEY_additional_parameters_default="" > < fi > > In 2.1.2 it was this > > # Fill in some defaults if no values are specified > : ${OCF_RESKEY_binary="/usr/bin/mysqld_safe"} > MYSQL_BINDIR=`dirname ${OCF_RESKEY_binary}` > > : ${OCF_RESKEY_config="/etc/my.cnf"} > : ${OCF_RESKEY_datadir="/var/lib/mysql"} > > : ${OCF_RESKEY_user="mysql"} > : ${OCF_RESKEY_group="mysql"} > > : ${OCF_RESKEY_log="/var/log/mysqld.log"} > : ${OCF_RESKEY_pid="/var/run/mysqld/mysqld.pid"} > : ${OCF_RESKEY_socket="/var/lib/mysql/mysql.sock"} > > : ${OCF_RESKEY_test_user="root"} > : ${OCF_RESKEY_test_table="mysql.user"} > : ${OCF_RESKEY_test_passwd=""} > > : ${OCF_RESKEY_enable_creation=0} I have here: $ hg diff -r STABLE-2.1.2 resources/OCF/mysql ... -# Fill in some defaults if no values are specified -: ${OCF_RESKEY_binary="/usr/bin/safe_mysqld"} <------ +: ${OCF_RESKEY_binary=${OCF_RESKEY_binary_default}} MYSQL_BINDIR=`dirname ${OCF_RESKEY_binary}` -: ${OCF_RESKEY_config="/etc/my.cnf"} -: ${OCF_RESKEY_datadir="/var/lib/mysql"} +: ${OCF_RESKEY_config=${OCF_RESKEY_config_default}} +: ${OCF_RESKEY_datadir=${OCF_RESKEY_datadir_default}} -: ${OCF_RESKEY_user="mysql"} -: ${OCF_RESKEY_group="mysql"} +: ${OCF_RESKEY_user=${OCF_RESKEY_user_default}} +: ${OCF_RESKEY_group=${OCF_RESKEY_group_default}} -: ${OCF_RESKEY_log="/var/log/mysqld.log"} -: ${OCF_RESKEY_pid="/var/run/mysql/mysqld.pid"} <------ -: ${OCF_RESKEY_socket="/var/lib/mysql/mysql.sock"} +: ${OCF_RESKEY_log=${OCF_RESKEY_log_default}} +: ${OCF_RESKEY_pid=${OCF_RESKEY_pid_default}} +: ${OCF_RESKEY_socket=${OCF_RESKEY_socket_default}} -: ${OCF_RESKEY_test_user="root"} -: ${OCF_RESKEY_test_table="mysql.user"} -: ${OCF_RESKEY_test_passwd=""} +: ${OCF_RESKEY_test_user=${OCF_RESKEY_test_user_default}} +: ${OCF_RESKEY_test_table=${OCF_RESKEY_test_table_default}} +: ${OCF_RESKEY_test_passwd=${OCF_RESKEY_test_passwd_default}} Lines starting with '-' are from 2.1.2. Looks like yours 2.1.2 doesn't match mine ;-) From where does your come? I guess that you then upgraded from a different build source. Thanks, Dejan > Thanks, > > Amy > -----Original Message----- > From: Dejan Muhamedagic <[EMAIL PROTECTED]> > Sent: Thursday, February 14, 2008 6:45pm > To: [EMAIL PROTECTED], [email protected] > Subject: Re: FW: Re: FW: Re: [Linux-HA] mysql OCF issue on CentOS 5.1 after > upgrading to heartbeat 2.1.3-3 > > Hi, > > On Thu, Feb 14, 2008 at 05:29:34PM -0500, [EMAIL PROTECTED] wrote: > > Dejan, > > > > I found it while going back through the output > > > > ++ dirname /usr/bin/safe_mysqld > > I just checked and at least this didn't change between 2.1.2 and > 2.1.3. Furthermore, I can't seem to recall any message about > command failing. Also, the pid default, at least in the > development repository didn't change between 2.1.2 and 2.1.3: in > both it is set to /var/run/mysql/mysqld.pid. > > Oh, well, glad that you figured out where was the problem. > > Thanks, > > Dejan > > > I ran it with a specified binary and it worked: > > > > # OCF_RESKEY_datadir="/replicated/mysql/data" > > OCF_RESKEY_pid="/var/run/mysqld/mysqld.pid" > > OCF_RESKEY_binary="/usr/bin/mysqld_safe" sh -x > > /usr/lib/ocf/resource.d/heartbeat/mysql start > > + . /usr/lib/ocf/resource.d/heartbeat/.ocf-shellfuncs > > ++ unset LC_ALL > > ++ export LC_ALL > > ++ unset LANGUAGE > > ++ export LANGUAGE > > +++ basename /usr/lib/ocf/resource.d/heartbeat/mysql > > ++ __SCRIPT_NAME=mysql > > ++ . /etc/ha.d/shellfuncs > > +++ prefix=/usr > > +++ exec_prefix=/usr > > +++ : /etc/ha.d > > +++ : /etc/ha.d/rc.d > > +++ : /etc/ha.d/conf > > +++ : /etc/ha.d/ha.cf > > +++ : /var/lib/heartbeat > > +++ : /var/run/heartbeat/rsctmp > > +++ : /var/lib/heartbeat/fifo > > +++ : /usr/lib/heartbeat > > +++ : /usr/share/heartbeat > > +++ : '%Y/%m/%d_%T ' > > +++ : /dev/null > > +++ : /etc/ha.d/resource.d > > +++ : /usr/share/doc/heartbeat > > +++ : mysql > > +++ : 'mysql[12558]' > > +++ : /var/run/ > > +++ : /var/lock/subsys/ > > +++ : /usr/sbin > > +++ export HA_DIR HA_RCDIR HA_FIFO HA_BIN > > +++ export HA_DEBUGLOG HA_LOGFILE HA_LOGFACILITY > > +++ export HA_DATEFMT HA_RESOURCEDIR HA_DOCDIR > > +++ MKTEMP=/bin/mktemp > > +++ TESTPROG=/usr/bin/test > > +++ > > PATH=/usr/lib/heartbeat:/usr/sbin:/usr/share/heartbeat:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin > > ++++ echo > > /usr/lib/heartbeat:/usr/sbin:/usr/share/heartbeat:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin > > ++++ sed -e s%::%% -e 's%:\.:%:%' -e 's%^:%%' -e 's%^\.:%%' > > +++ > > PATH=/usr/lib/heartbeat:/usr/sbin:/usr/share/heartbeat:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin > > +++ export PATH > > ++ '[' -z /usr/lib/ocf ']' > > ++ . /usr/lib/ocf/resource.d/heartbeat/.ocf-binaries > > +++ > > PATH=/usr/lib/heartbeat:/usr/sbin:/usr/share/heartbeat:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/sbin:/bin:/usr/sbin:/usr/bin > > +++ > > PATH=/usr/lib/heartbeat:/usr/sbin:/usr/share/heartbeat:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/ucb > > +++ export PATH > > +++ : /bin/gawk > > +++ : '/bin/grep -E' > > +++ : -a > > +++ : mailx > > +++ : /bin/mktemp > > +++ : /bin/ping > > +++ : /usr/bin/rpmbuild > > +++ : /bin/sh > > +++ : /usr/bin/test > > +++ : /usr/bin/test > > +++ : basename > > +++ : blockdev > > +++ : cat > > +++ : fsck > > +++ : fuser > > +++ : getent > > +++ : grep > > +++ : ifconfig > > +++ : iptables > > +++ : ip > > +++ : mdadm > > +++ : modprobe > > +++ : mount > > +++ : msgfmt > > +++ : netstat > > +++ : perl > > +++ : python > > +++ : raidstart > > +++ : raidstop > > +++ : route > > +++ : umount > > +++ : reboot > > +++ : poweroff > > +++ : wget > > +++ : whoami > > +++ : strings > > +++ : scp > > +++ : ssh > > +++ : swig > > +++ : /bin/mktemp > > +++ : gzip > > +++ : tar > > +++ : md5 > > +++ : drbdadm > > +++ : drbdsetup > > ++ . /usr/lib/ocf/resource.d/heartbeat/.ocf-returncodes > > +++ OCF_SUCCESS=0 > > +++ OCF_ERR_GENERIC=1 > > +++ OCF_ERR_ARGS=2 > > +++ OCF_ERR_UNIMPLEMENTED=3 > > +++ OCF_ERR_PERM=4 > > +++ OCF_ERR_INSTALLED=5 > > +++ OCF_ERR_CONFIGURED=6 > > +++ OCF_NOT_RUNNING=7 > > +++ OCF_RUNNING_MASTER=8 > > +++ OCF_FAILED_MASTER=9 > > ++ . /usr/lib/ocf/resource.d/heartbeat/.ocf-directories > > +++ prefix=/usr > > +++ exec_prefix=/usr > > +++ : /etc/init.d > > +++ : /etc/ha.d > > +++ : /etc/ha.d/rc.d > > +++ : /etc/ha.d/conf > > +++ : /etc/ha.d/ha.cf > > +++ : /var/lib/heartbeat > > +++ : /var/run/heartbeat/rsctmp > > +++ : /var/lib/heartbeat/fifo > > +++ : /usr/lib/heartbeat > > +++ : /usr/sbin > > +++ : %Y/%m/%d_%T > > +++ : /dev/null > > +++ : /etc/ha.d/resource.d > > +++ : /usr/share/doc/heartbeat > > +++ : mysql > > +++ : 'mysql[12558]' > > +++ : /var/run/ > > +++ : /var/lock/subsys/ > > ++ __ocf_set_defaults start > > ++ __OCF_ACTION=start > > ++ unset LANG > > ++ LC_ALL=C > > ++ export LC_ALL > > ++ '[' -z '' ']' > > ++ : 0 > > ++ '[' '!' -d /usr/lib/ocf ']' > > ++ '[' -z '' ']' > > ++ : mysql > > ++ '[' -z '' ']' > > ++ : We are being invoked as an init script. > > ++ : Fill in some things with reasonable values. > > ++ : default > > ++ return 0 > > ++ uname > > + HOSTOS=Linux > > + '[' XLinux == XOpenBSD ']' > > + OCF_RESKEY_binary_default=/usr/bin/safe_mysqld > > + OCF_RESKEY_config_default=/etc/my.cnf > > + OCF_RESKEY_datadir_default=/var/lib/mysql > > + OCF_RESKEY_user_default=mysql > > + OCF_RESKEY_group_default=mysql > > + OCF_RESKEY_log_default=/var/log/mysqld.log > > + OCF_RESKEY_pid_default=/var/run/mysql/mysqld.pid > > + OCF_RESKEY_socket_default=/var/lib/mysql/mysql.sock > > + OCF_RESKEY_test_user_default=root > > + OCF_RESKEY_test_table_default=mysql.user > > + OCF_RESKEY_test_passwd_default= > > + OCF_RESKEY_enable_creation_default=0 > > + OCF_RESKEY_additional_parameters_default= > > + : /usr/bin/mysqld_safe > > ++ dirname /usr/bin/mysqld_safe > > + MYSQL_BINDIR=/usr/bin > > + : /etc/my.cnf > > + : /replicated/mysql/data > > + : mysql > > + : mysql > > + : /var/log/mysqld.log > > + : /var/run/mysqld/mysqld.pid > > + echo OCF_RESKEY_pid is set to /var/run/mysqld/mysqld.pid > > OCF_RESKEY_pid is set to /var/run/mysqld/mysqld.pid > > + : /var/lib/mysql/mysql.sock > > + : root > > + : mysql.user > > + : > > + : 0 > > + : > > + case "$1" in > > + mysql_validate > > + '[' '!' -f /etc/my.cnf ']' > > + '[' '!' -d /replicated/mysql/data ']' > > + getent passwd mysql > > + '[' '!' 0 -eq 0 ']' > > + getent group mysql > > + '[' '!' 0 -eq 0 ']' > > + mysql_start > > + mysql_status > > + '[' '!' -e /var/run/mysqld/mysqld.pid ']' > > + ocf_log debug 'MySQL is not running' > > + '[' 2 -lt 2 ']' > > + __OCF_PRIO=debug > > + shift > > + __OCF_MSG='MySQL is not running' > > + case "${__OCF_PRIO}" in > > + __OCF_PRIO=DEBUG > > + '[' DEBUG = DEBUG ']' > > + ha_debug 'DEBUG: MySQL is not running' > > + '[' x = xyes ']' > > + '[' -n '' ']' > > + '[' -n /dev/null ']' > > + : appending to /dev/null > > ++ hadate > > ++ date '+%Y/%m/%d_%T ' > > + Echo 'mysql[12558]: 2008/02/14_17:26:08' 'DEBUG: MySQL is not running' > > + echo 'mysql[12558]: 2008/02/14_17:26:08' 'DEBUG: MySQL is not running' > > + return 7 > > + '[' 7 == 0 ']' > > + touch /var/log/mysqld.log > > + chown mysql:mysql /var/log/mysqld.log > > + chmod 0640 /var/log/mysqld.log > > + '[' -x /sbin/restorecon ']' > > + /sbin/restorecon /var/log/mysqld.log > > + '[' 0 -a '!' -d /replicated/mysql/data/mysql ']' > > + /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf > > --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock > > --datadir=/replicated/mysql/data --user=mysql > > + rc=0 > > + '[' 0 '!=' 0 ']' > > + start_wait=1 > > + '[' 1 = 1 ']' > > + mysql_status > > + '[' '!' -e /var/run/mysqld/mysqld.pid ']' > > + ocf_log debug 'MySQL is not running' > > + '[' 2 -lt 2 ']' > > + __OCF_PRIO=debug > > + shift > > + __OCF_MSG='MySQL is not running' > > + case "${__OCF_PRIO}" in > > + __OCF_PRIO=DEBUG > > + '[' DEBUG = DEBUG ']' > > + ha_debug 'DEBUG: MySQL is not running' > > + '[' x = xyes ']' > > + '[' -n '' ']' > > + '[' -n /dev/null ']' > > + : appending to /dev/null > > ++ hadate > > ++ date '+%Y/%m/%d_%T ' > > + Echo 'mysql[12558]: 2008/02/14_17:26:09' 'DEBUG: MySQL is not running' > > + echo 'mysql[12558]: 2008/02/14_17:26:09' 'DEBUG: MySQL is not running' > > + return 7 > > + rc=7 > > + '[' 7 = 0 ']' > > + '[' 7 '!=' 7 ']' > > + sleep 2 > > + '[' 1 = 1 ']' > > + mysql_status > > + '[' '!' -e /var/run/mysqld/mysqld.pid ']' > > ++ cat /var/run/mysqld/mysqld.pid > > + pid=12619 > > + '[' -d /proc -a -d /proc/1 ']' > > + '[' u12619 '!=' u -a -d /proc/12619 ']' > > + '[' 0 -eq 0 ']' > > + return 0 > > + rc=0 > > + '[' 0 = 0 ']' > > + start_wait=0 > > + sleep 2 > > + '[' 0 = 1 ']' > > + ocf_log info 'MySQL started' > > + '[' 2 -lt 2 ']' > > + __OCF_PRIO=info > > + shift > > + __OCF_MSG='MySQL started' > > + case "${__OCF_PRIO}" in > > + __OCF_PRIO=INFO > > + '[' INFO = DEBUG ']' > > + ha_log 'INFO: MySQL started' > > + '[' x = xyes ']' > > + '[' -n '' ']' > > + '[' -n '' ']' > > ++ hadate > > ++ date '+%Y/%m/%d_%T ' > > + Echo 2008/02/14_17:26:13 'INFO: MySQL started' > > + echo 2008/02/14_17:26:13 'INFO: MySQL started' > > 2008/02/14_17:26:13 INFO: MySQL started > > + '[' -n /dev/null ']' > > + : appending to /dev/null > > ++ hadate > > ++ date '+%Y/%m/%d_%T ' > > + Echo 'mysql[12558]: 2008/02/14_17:26:13' 'INFO: MySQL started' > > + echo 'mysql[12558]: 2008/02/14_17:26:13' 'INFO: MySQL started' > > + return 0 > > + exit 0 > > > > Thanks! > > > > Amy > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > Sent: Thursday, February 14, 2008 5:15pm > > To: Dejan Muhamedagic <[EMAIL PROTECTED]> > > Cc: [email protected] > > Subject: Re: FW: Re: FW: Re: [Linux-HA] mysql OCF issue on CentOS 5.1 after > > upgrading to heartbeat 2.1.3-3 > > > > Dejan, > > > > Here's another run > > > > # export OCF_ROOT=/usr/lib/ocf > > # OCF_RESKEY_datadir="/replicated/mysql/data" > > OCF_RESKEY_pid="/var/run/mysqld/mysqld.pid" sh -x > > /usr/lib/ocf/resource.d/heartbeat/mysql start > > > > + . /usr/lib/ocf/resource.d/heartbeat/.ocf-shellfuncs > > ++ unset LC_ALL > > ++ export LC_ALL > > ++ unset LANGUAGE > > ++ export LANGUAGE > > +++ basename /usr/lib/ocf/resource.d/heartbeat/mysql > > ++ __SCRIPT_NAME=mysql > > ++ . /etc/ha.d/shellfuncs > > +++ prefix=/usr > > +++ exec_prefix=/usr > > +++ : /etc/ha.d > > +++ : /etc/ha.d/rc.d > > +++ : /etc/ha.d/conf > > +++ : /etc/ha.d/ha.cf > > +++ : /var/lib/heartbeat > > +++ : /var/run/heartbeat/rsctmp > > +++ : /var/lib/heartbeat/fifo > > +++ : /usr/lib/heartbeat > > +++ : /usr/share/heartbeat > > +++ : '%Y/%m/%d_%T ' > > +++ : /dev/null > > +++ : /etc/ha.d/resource.d > > +++ : /usr/share/doc/heartbeat > > +++ : mysql > > +++ : 'mysql[12511]' > > +++ : /var/run/ > > +++ : /var/lock/subsys/ > > +++ : /usr/sbin > > +++ export HA_DIR HA_RCDIR HA_FIFO HA_BIN > > +++ export HA_DEBUGLOG HA_LOGFILE HA_LOGFACILITY > > +++ export HA_DATEFMT HA_RESOURCEDIR HA_DOCDIR > > +++ MKTEMP=/bin/mktemp > > +++ TESTPROG=/usr/bin/test > > +++ > > PATH=/usr/lib/heartbeat:/usr/sbin:/usr/share/heartbeat:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin > > ++++ echo > > /usr/lib/heartbeat:/usr/sbin:/usr/share/heartbeat:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin > > ++++ sed -e s%::%% -e 's%:\.:%:%' -e 's%^:%%' -e 's%^\.:%%' > > +++ > > PATH=/usr/lib/heartbeat:/usr/sbin:/usr/share/heartbeat:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin > > +++ export PATH > > ++ '[' -z /usr/lib/ocf ']' > > ++ . /usr/lib/ocf/resource.d/heartbeat/.ocf-binaries > > +++ > > PATH=/usr/lib/heartbeat:/usr/sbin:/usr/share/heartbeat:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/sbin:/bin:/usr/sbin:/usr/bin > > +++ > > PATH=/usr/lib/heartbeat:/usr/sbin:/usr/share/heartbeat:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/ucb > > +++ export PATH > > +++ : /bin/gawk > > +++ : '/bin/grep -E' > > +++ : -a > > +++ : mailx > > +++ : /bin/mktemp > > +++ : /bin/ping > > +++ : /usr/bin/rpmbuild > > +++ : /bin/sh > > +++ : /usr/bin/test > > +++ : /usr/bin/test > > +++ : basename > > +++ : blockdev > > +++ : cat > > +++ : fsck > > +++ : fuser > > +++ : getent > > +++ : grep > > +++ : ifconfig > > +++ : iptables > > +++ : ip > > +++ : mdadm > > +++ : modprobe > > +++ : mount > > +++ : msgfmt > > +++ : netstat > > +++ : perl > > +++ : python > > +++ : raidstart > > +++ : raidstop > > +++ : route > > +++ : umount > > +++ : reboot > > +++ : poweroff > > +++ : wget > > +++ : whoami > > +++ : strings > > +++ : scp > > +++ : ssh > > +++ : swig > > +++ : /bin/mktemp > > +++ : gzip > > +++ : tar > > +++ : md5 > > +++ : drbdadm > > +++ : drbdsetup > > ++ . /usr/lib/ocf/resource.d/heartbeat/.ocf-returncodes > > +++ OCF_SUCCESS=0 > > +++ OCF_ERR_GENERIC=1 > > +++ OCF_ERR_ARGS=2 > > +++ OCF_ERR_UNIMPLEMENTED=3 > > +++ OCF_ERR_PERM=4 > > +++ OCF_ERR_INSTALLED=5 > > +++ OCF_ERR_CONFIGURED=6 > > +++ OCF_NOT_RUNNING=7 > > +++ OCF_RUNNING_MASTER=8 > > +++ OCF_FAILED_MASTER=9 > > ++ . /usr/lib/ocf/resource.d/heartbeat/.ocf-directories > > +++ prefix=/usr > > +++ exec_prefix=/usr > > +++ : /etc/init.d > > +++ : /etc/ha.d > > +++ : /etc/ha.d/rc.d > > +++ : /etc/ha.d/conf > > +++ : /etc/ha.d/ha.cf > > +++ : /var/lib/heartbeat > > +++ : /var/run/heartbeat/rsctmp > > +++ : /var/lib/heartbeat/fifo > > +++ : /usr/lib/heartbeat > > +++ : /usr/sbin > > +++ : %Y/%m/%d_%T > > +++ : /dev/null > > +++ : /etc/ha.d/resource.d > > +++ : /usr/share/doc/heartbeat > > +++ : mysql > > +++ : 'mysql[12511]' > > +++ : /var/run/ > > +++ : /var/lock/subsys/ > > ++ __ocf_set_defaults start > > ++ __OCF_ACTION=start > > ++ unset LANG > > ++ LC_ALL=C > > ++ export LC_ALL > > ++ '[' -z '' ']' > > ++ : 0 > > ++ '[' '!' -d /usr/lib/ocf ']' > > ++ '[' -z '' ']' > > ++ : mysql > > ++ '[' -z '' ']' > > ++ : We are being invoked as an init script. > > ++ : Fill in some things with reasonable values. > > ++ : default > > ++ return 0 > > ++ uname > > + HOSTOS=Linux > > + '[' XLinux == XOpenBSD ']' > > + OCF_RESKEY_binary_default=/usr/bin/safe_mysqld > > + OCF_RESKEY_config_default=/etc/my.cnf > > + OCF_RESKEY_datadir_default=/var/lib/mysql > > + OCF_RESKEY_user_default=mysql > > + OCF_RESKEY_group_default=mysql > > + OCF_RESKEY_log_default=/var/log/mysqld.log > > + OCF_RESKEY_pid_default=/var/run/mysql/mysqld.pid > > + OCF_RESKEY_socket_default=/var/lib/mysql/mysql.sock > > + OCF_RESKEY_test_user_default=root > > + OCF_RESKEY_test_table_default=mysql.user > > + OCF_RESKEY_test_passwd_default= > > + OCF_RESKEY_enable_creation_default=0 > > + OCF_RESKEY_additional_parameters_default= > > + : /usr/bin/safe_mysqld > > ++ dirname /usr/bin/safe_mysqld > > + MYSQL_BINDIR=/usr/bin > > + : /etc/my.cnf > > + : /replicated/mysql/data > > + : mysql > > + : mysql > > + : /var/log/mysqld.log > > + : /var/run/mysqld/mysqld.pid > > + echo OCF_RESKEY_pid is set to /var/run/mysqld/mysqld.pid > > OCF_RESKEY_pid is set to /var/run/mysqld/mysqld.pid > > + : /var/lib/mysql/mysql.sock > > + : root > > + : mysql.user > > + : > > + : 0 > > + : > > + case "$1" in > > + mysql_validate > > + '[' '!' -f /etc/my.cnf ']' > > + '[' '!' -d /replicated/mysql/data ']' > > + getent passwd mysql > > + '[' '!' 0 -eq 0 ']' > > + getent group mysql > > + '[' '!' 0 -eq 0 ']' > > + mysql_start > > + mysql_status > > + '[' '!' -e /var/run/mysqld/mysqld.pid ']' > > + ocf_log debug 'MySQL is not running' > > + '[' 2 -lt 2 ']' > > + __OCF_PRIO=debug > > + shift > > + __OCF_MSG='MySQL is not running' > > + case "${__OCF_PRIO}" in > > + __OCF_PRIO=DEBUG > > + '[' DEBUG = DEBUG ']' > > + ha_debug 'DEBUG: MySQL is not running' > > + '[' x = xyes ']' > > + '[' -n '' ']' > > + '[' -n /dev/null ']' > > + : appending to /dev/null > > ++ hadate > > ++ date '+%Y/%m/%d_%T ' > > + Echo 'mysql[12511]: 2008/02/14_17:14:27' 'DEBUG: MySQL is not running' > > + echo 'mysql[12511]: 2008/02/14_17:14:27' 'DEBUG: MySQL is not running' > > + return 7 > > + '[' 7 == 0 ']' > > + touch /var/log/mysqld.log > > + chown mysql:mysql /var/log/mysqld.log > > + chmod 0640 /var/log/mysqld.log > > + '[' -x /sbin/restorecon ']' > > + /sbin/restorecon /var/log/mysqld.log > > + '[' 0 -a '!' -d /replicated/mysql/data/mysql ']' > > + /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf > > --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock > > --datadir=/replicated/mysql/data --user=mysql > > + rc=0 > > + '[' 0 '!=' 0 ']' > > + start_wait=1 > > + '[' 1 = 1 ']' > > + mysql_status > > + '[' '!' -e /var/run/mysqld/mysqld.pid ']' > > + ocf_log debug 'MySQL is not running' > > + '[' 2 -lt 2 ']' > > + __OCF_PRIO=debug > > + shift > > + __OCF_MSG='MySQL is not running' > > + case "${__OCF_PRIO}" in > > + __OCF_PRIO=DEBUG > > + '[' DEBUG = DEBUG ']' > > + ha_debug 'DEBUG: MySQL is not running' > > + '[' x = xyes ']' > > + '[' -n '' ']' > > + '[' -n /dev/null ']' > > + : appending to /dev/null > > ++ hadate > > ++ date '+%Y/%m/%d_%T ' > > + Echo 'mysql[12511]: 2008/02/14_17:14:27' 'DEBUG: MySQL is not running' > > + echo 'mysql[12511]: 2008/02/14_17:14:27' 'DEBUG: MySQL is not running' > > + return 7 > > + rc=7 > > + '[' 7 = 0 ']' > > + '[' 7 '!=' 7 ']' > > + sleep 2 > > + '[' 1 = 1 ']' > > + mysql_status > > + '[' '!' -e /var/run/mysqld/mysqld.pid ']' > > + ocf_log debug 'MySQL is not running' > > + '[' 2 -lt 2 ']' > > + __OCF_PRIO=debug > > + shift > > + __OCF_MSG='MySQL is not running' > > + case "${__OCF_PRIO}" in > > + __OCF_PRIO=DEBUG > > + '[' DEBUG = DEBUG ']' > > + ha_debug 'DEBUG: MySQL is not running' > > + '[' x = xyes ']' > > + '[' -n '' ']' > > + '[' -n /dev/null ']' > > + : appending to /dev/null > > ++ hadate > > ++ date '+%Y/%m/%d_%T ' > > + Echo 'mysql[12511]: 2008/02/14_17:14:29' 'DEBUG: MySQL is not running' > > + echo 'mysql[12511]: 2008/02/14_17:14:29' 'DEBUG: MySQL is not running' > > + return 7 > > + rc=7 > > + '[' 7 = 0 ']' > > + '[' 7 '!=' 7 ']' > > + sleep 2 > > + '[' 1 = 1 ']' > > + mysql_status > > + '[' '!' -e /var/run/mysqld/mysqld.pid ']' > > + ocf_log debug 'MySQL is not running' > > + '[' 2 -lt 2 ']' > > + __OCF_PRIO=debug > > + shift > > + __OCF_MSG='MySQL is not running' > > + case "${__OCF_PRIO}" in > > + __OCF_PRIO=DEBUG > > + '[' DEBUG = DEBUG ']' > > + ha_debug 'DEBUG: MySQL is not running' > > + '[' x = xyes ']' > > + '[' -n '' ']' > > + '[' -n /dev/null ']' > > + : appending to /dev/null > > ++ hadate > > ++ date '+%Y/%m/%d_%T ' > > + Echo 'mysql[12511]: 2008/02/14_17:14:31' 'DEBUG: MySQL is not running' > > + echo 'mysql[12511]: 2008/02/14_17:14:31' 'DEBUG: MySQL is not running' > > + return 7 > > + rc=7 > > + '[' 7 = 0 ']' > > + '[' 7 '!=' 7 ']' > > + sleep 2 > > > > Thanks! > > > > Amy > > > > -----Original Message----- > > From: Dejan Muhamedagic <[EMAIL PROTECTED]> > > Sent: Thursday, February 14, 2008 4:22pm > > To: [EMAIL PROTECTED] > > Subject: Re: FW: Re: FW: Re: [Linux-HA] mysql OCF issue on CentOS 5.1 after > > upgrading to heartbeat 2.1.3-3 > > > > Hi, > > > > On Thu, Feb 14, 2008 at 02:30:20PM -0500, [EMAIL PROTECTED] wrote: > > > Dejan, > > > > > > The pid is now looking in the right place > > > > > > pid=[/var/run/mysqld/mysqld.pid] > > > > > > Not sure why its still failing as I thought we'd fixed it when > > > you pointed out the /var/run/mysql directory. > > > > > > I did a test with the older version of the OCF I had installed > > > from 2.1.2 in place and it started fine with the rest of > > > heartbeat being 2.1.3. so its definately something in the new > > > OCF script. Also tried starting mysql as an lsb resource and > > > that was successful. > > > > Let's give it another try with the 'sh -x' from the command line. > > We must have missed something. > > > > Thanks, > > > > Dejan > > > > > > > > Thanks, > > > > > > Amy > > > > > > -----Original Message----- > > > From: Dejan Muhamedagic <[EMAIL PROTECTED]> > > > Sent: Thursday, February 14, 2008 1:20pm > > > To: [EMAIL PROTECTED] > > > Cc: [email protected] > > > Subject: Re: FW: Re: FW: Re: [Linux-HA] mysql OCF issue on CentOS 5.1 > > > after upgrading to heartbeat 2.1.3-3 > > > > > > Hi, > > > > > > On Thu, Feb 14, 2008 at 12:59:16PM -0500, [EMAIL PROTECTED] wrote: > > > > Dejan, > > > > > > > > Here's the /var/log/messages section > > > > > > > > Feb 14 12:56:59 utnode1 lrmd: [7057]: WARN: mysql_repl:start process > > > > (PID 7418) timed out (try 1). Killing with signal SIGTERM (15). > > > > Feb 14 12:56:59 utnode1 lrmd: [7057]: WARN: operation start[16] on > > > > ocf::mysql::mysql_repl for client 7060, its parameters: > > > > target_role=[started] CRM_meta_timeout=[20000] crm_feature_set=[1.0.9] > > > > pid=[/var/run/mysqld/mysqld.pid] datadir=[/replicated/mysql/data] : pid > > > > [7418] timed out > > > > Feb 14 12:56:59 utnode1 crmd: [7060]: ERROR: process_lrm_event: LRM > > > > operation mysql_repl_start_0 (16) Timed Out (timeout=20000ms) > > > > Feb 14 12:57:01 utnode1 crmd: [7060]: info: do_lrm_rsc_op: Performing > > > > op=mysql_repl_stop_0 key=1:39:252588e5-3f75-4f81-a4f0-df0d4a643d0b) > > > > Feb 14 12:57:01 utnode1 lrmd: [7057]: info: rsc:mysql_repl: stop > > > > Feb 14 12:57:01 utnode1 lrmd: [7057]: info: RA output: > > > > (mysql_repl:stop:stdout) OCF_RESKEY_pid is set to > > > > /var/run/mysqld/mysqld.pid > > > > > > This is what it should be set to, right? Then the RA fails and > > > loops here: > > > > > > if [ ! -e $OCF_RESKEY_pid ]; then > > > ocf_log debug "MySQL is not running" > > > return $OCF_NOT_RUNNING; > > > fi > > > > > > Sorry, I don't understand anymore. Where is the pid file actually > > > stored? Or is that here, for some reason, the value of > > > OCF_RESKEY_pid is wrong? > > > > > > Thanks, > > > > > > Dejan > > > > > > > > > > Feb 14 12:57:01 utnode1 crmd: [7060]: info: process_lrm_event: LRM > > > > operation mysql_repl_stop_0 (call=17, rc=0) complete > > > > Feb 14 12:57:03 utnode1 crmd: [7060]: info: do_lrm_rsc_op: Performing > > > > op=sendmail_stop_0 key=16:39:252588e5-3f75-4f81-a4f0-df0d4a643d0b) > > > > > > > > Thanks, > > > > > > > > amy > > > > > > > > -----Original Message----- > > > > From: Dejan Muhamedagic <[EMAIL PROTECTED]> > > > > Sent: Thursday, February 14, 2008 12:39pm > > > > To: [EMAIL PROTECTED] > > > > Cc: [email protected] > > > > Subject: Re: FW: Re: FW: Re: [Linux-HA] mysql OCF issue on CentOS 5.1 > > > > after upgrading to heartbeat 2.1.3-3 > > > > > > > > Hi, > > > > > > > > On Thu, Feb 14, 2008 at 11:47:48AM -0500, [EMAIL PROTECTED] wrote: > > > > > Dejan, > > > > > > > > > > Ran it with this: > > > > > > > > > > # export OCF_ROOT=/usr/lib/ocf > > > > > # OCF_RESKEY_datadir="/replicated/mysql/data" > > > > > OCF_RESKEY_pid="/var/run/mysqld/mysqld.pid" sh -x > > > > > /usr/lib/ocf/resource.d/heartbeat/mysql start > > > > > > > > Ok. Tried to read the code and it should be working, but as you > > > > tried it... I have nowhere to test it. Could you add after line > > > > 88 which says > > > > > > > > : ${OCF_RESKEY_pid=${OCF_RESKEY_pid_default}} > > > > > > > > just this echo command to make sure what's going on: > > > > > > > > echo OCF_RESKEY_pid is set to $OCF_RESKEY_pid > > > > > > > > Thanks, > > > > > > > > Dejan > > > > > > > > > > > > > > Thanks, > > > > > > > > > > Amy > > > > > > > > > > -----Original Message----- > > > > > From: Dejan Muhamedagic <[EMAIL PROTECTED]> > > > > > Sent: Thursday, February 14, 2008 11:38am > > > > > To: [EMAIL PROTECTED], [email protected] > > > > > Subject: Re: FW: Re: FW: Re: [Linux-HA] mysql OCF issue on CentOS 5.1 > > > > > after upgrading to heartbeat 2.1.3-3 > > > > > > > > > > Hi, > > > > > > > > > > This somehow drifted off the list. Let's try to keep it there. > > > > > > > > > > On Thu, Feb 14, 2008 at 10:18:32AM -0500, [EMAIL PROTECTED] wrote: > > > > > > Ok more info. > > > > > > > > > > > > I added the pid parameter through the gui and it does show in > > > > > > /var/lib/heartbeat/crm/cib.xml: > > > > > > > > > > > > <primitive class="ocf" type="mysql" provider="heartbeat" > > > > > > id="mysql_repl"> > > > > > > <instance_attributes id="mysql_repl_instance_attrs"> > > > > > > <attributes> > > > > > > <nvpair name="target_role" > > > > > > id="mysql_repl_target_role" value="started"/> > > > > > > <nvpair id="de970238-7dfb-4505-b623-5f316b3432454" > > > > > > name="datadir" value="/replicated/mysql/data"/> > > > > > > <nvpair id="b5dd43ba-297c-493a-999f-85ceb5f3f72f" > > > > > > name="pid" value="/var/run/mysqld/mysqld.pid"/> > > > > > > </attributes> > > > > > > </instance_attributes> > > > > > > </primitive> > > > > > > > > > > > > However when running by hand still getting this: > > > > > > > > > > How did you run it by hand? Did you add the new OCF_RESKEY_pid > > > > > parameter too? That should work. > > > > > > > > > > > Looking at the 2.1.2 OCF it used to have this: > > > > > > > > > > > > : ${OCF_RESKEY_pid="/var/run/mysqld/mysqld.pid"} > > > > > > > > > > > > The 2.1.3 OCF now has this: > > > > > > > > > > > > OCF_RESKEY_pid_default="/var/mysql/mysqld.pid" > > > > > > > > > > That's actually for OpenBSD. But still I can see that the default > > > > > was changed to > > > > > > > > > > OCF_RESKEY_pid_default="/var/run/mysql/mysqld.pid" > > > > > > > > > > which is a regression. > > > > > > > > > > > While it shouldn't be a problem to just set the parameter it > > > > > > does make it impossible to run 2 different versions of the > > > > > > heartbeat at the same time while doing a gradual upgrade (ie > > > > > > one machine in production and one machine out of production > > > > > > getting upgraded). > > > > > > > > > > > > Should this be reported as a bug? While I can work around it it > > > > > > does mean potential production downtime while switching servers > > > > > > around. > > > > > > > > > > Sorry about that. Perhaps it should be reverted back to what has > > > > > been there before. A bugzilla entry would be good too. > > > > > > > > > > Thanks, > > > > > > > > > > Dejan > > > > > > > > > > > > > > > > > Thanks, > > > > > > > > > > > > Amy > > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > From: Dejan Muhamedagic <[EMAIL PROTECTED]> > > > > > > Sent: Thursday, February 14, 2008 7:05am > > > > > > To: [EMAIL PROTECTED] > > > > > > Subject: Re: FW: Re: [Linux-HA] mysql OCF issue on CentOS 5.1 after > > > > > > upgrading to heartbeat 2.1.3-3 > > > > > > > > > > > > Hi, > > > > > > > > > > > > On Wed, Feb 13, 2008 at 02:54:38PM -0500, [EMAIL PROTECTED] wrote: > > > > > > > Dejan, > > > > > > > > > > > > > > Just a thought after reading other posts. Could the pacemaker > > > > > > > packages be needed as their functionality has been seperated > > > > > > > out? > > > > > > > > > > > > Not with the Heartbeat release 2.1.3. That release includes the > > > > > > CRM (pacemaker). > > > > > > > > > > > > > passwd and group both in the stard location /etc > > > > > > > > > > > > > > nssswitch.conf > > > > > > > passwd: files > > > > > > > shadow: files > > > > > > > group: files > > > > > > > > > > > > OK, this rules out a network delay. > > > > > > > > > > > > > Here is the output from the command line before I end it after > > > > > > > getting stuck at the same place: > > > > > > > > > > > > > > # OCF_RESKEY_datadir="/replicated/mysql/data" sh -x > > > > > > > /usr/lib/ocf/resource.d/heartbeat/mysql start > > > > > > > + . /usr/lib/ocf/resource.d/heartbeat/.ocf-shellfuncs > > > > > > [snip] > > > > > > > + /sbin/restorecon /var/log/mysqld.log > > > > > > > + '[' 0 -a '!' -d /replicated/mysql/data/mysql ']' > > > > > > > + /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf > > > > > > > --pid-file=/var/run/mysql/mysqld.pid > > > > > > > --socket=/var/lib/mysql/mysql.sock > > > > > > > --datadir=/replicated/mysql/data --user=mysql > > > > > > > + rc=0 > > > > > > > + '[' 0 '!=' 0 ']' > > > > > > > > > > > > It looks as if mysql started here... > > > > > > > > > > > > > + start_wait=1 > > > > > > > + '[' 1 = 1 ']' > > > > > > > + mysql_status > > > > > > > + '[' '!' -e /var/run/mysql/mysqld.pid ']' > > > > > > > + ocf_log debug 'MySQL is not running' > > > > > > > > > > > > but the status reports that it is not because it can't find the > > > > > > pid file. Please check where's the pid file and if mysql is > > > > > > running or not. This looks like a mysql setup problem. > > > > > > > > > > > > Thanks, > > > > > > > > > > > > Dejan > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > Linux-HA mailing list > > [email protected] > > http://lists.linux-ha.org/mailman/listinfo/linux-ha > > See also: http://linux-ha.org/ReportingProblems > > > > > > _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
