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
