components/mysql-5-7/Solaris/mysql_57
author Gipson Pulla <gipson.pulla@oracle.com>
Wed, 15 Mar 2017 23:29:04 -0700
branchs11u3-sru
changeset 7765 3495fc32877e
parent 6571 12a891fe6a39
permissions -rw-r--r--
25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris 25364635 Upgrade the version of MySQL 5.6 to 5.6.35 on Solaris 25372106 Upgrade the version of MySQL 5.7 to 5.7.17 on Solaris 24835634 Upgrade MySQL server 5.7 to 5.7.15 on Solaris 24688109 Upgrade MySQL 5.5 to 5.5.52 on Solaris 23227671 Upgrade MySQL 5.5 to 5.5.49 on Solaris 15818149 mysql stop method unsafe 18605985 Need to resolve dependencies between MySQL 5.5 database and client pkgs 23227615 Port fix for Bug 23022999 from MySQL 5.6 to 5.5 23227642 Port fix for Bug 23053990 from MySQL 5.6 to 5.5 21150630 mysql SMF instances should check to see if it's really online before returning 22959660 mysql SMF service must not hardcode pid-file, socket and log-error 24708946 Upgrade the version of MySQL 5.6 to 5.6.33 on Solaris 25236651 COMPONENT_ARCHIVE_URL for MySQL-5.6 Makefile is not working 24924801 problem in DATABASE/MYSQL 25427164 problem in DATABASE/MYSQL 25215584 problem in DATABASE/MYSQL 25427149 problem in DATABASE/MYSQL 24923761 problem in DATABASE/MYSQL 25427194 problem in DATABASE/MYSQL
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
6571
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
     1
#!/sbin/sh
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
     2
#
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
     3
# CDDL HEADER START
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
     4
#
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
     5
# The contents of this file are subject to the terms of the
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
     6
# Common Development and Distribution License (the "License").
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
     7
# You may not use this file except in compliance with the License.
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
     8
#
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
     9
# You can obtain a copy of the license at usr/src/OPENSOLARIS.LICENSE
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    10
# or http://www.opensolaris.org/os/licensing.
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    11
# See the License for the specific language governing permissions
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    12
# and limitations under the License.
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    13
#
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    14
# When distributing Covered Code, include this CDDL HEADER in each
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    15
# file and include the License file at usr/src/OPENSOLARIS.LICENSE.
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    16
# If applicable, add the following below this CDDL HEADER, with the
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    17
# fields enclosed by brackets "[]" replaced with your own identifying
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    18
# information: Portions Copyright [yyyy] [name of copyright owner]
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    19
#
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    20
# CDDL HEADER END
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    21
#
7765
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    22
# Copyright (c) 2016, 2017, Oracle and/or its affiliates. All rights reserved.
6571
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    23
#
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    24
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    25
. /lib/svc/share/smf_include.sh
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    26
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    27
# SMF_FMRI is the name of the target service. This allows multiple instances 
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    28
# to use the same script.
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    29
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    30
if [ -z $SMF_FMRI ]; then
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    31
        echo "SMF framework variables are not initialized."
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    32
        exit $SMF_EXIT_ERR
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    33
fi
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    34
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    35
getproparg() {
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    36
	val=`svcprop -p $1 $SMF_FMRI`
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    37
	[ -n "$val" ] && echo $val
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    38
}
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    39
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    40
MYSQLCNF=`getproparg mysql/cnf`
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    41
MYSQLBIN=`getproparg mysql/bin`
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    42
MYSQLDATA=`getproparg mysql/data`
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    43
LOG_ERROR=${MYSQLDATA}/`/usr/bin/uname -n`.err
7765
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    44
STARTTIMEOUT=180
6571
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    45
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    46
if [ -z "${MYSQLCNF}" ]; then
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    47
        echo "mysql/cnf property not set"
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    48
        exit $SMF_EXIT_ERR_CONFIG
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    49
fi
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    50
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    51
if [ -z "${MYSQLBIN}" ]; then
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    52
        echo "mysql/bin property not set"
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    53
        exit $SMF_EXIT_ERR_CONFIG
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    54
fi
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    55
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    56
if [ -z "${MYSQLDATA}" ]; then
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    57
	echo "mysql/data property not set"
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    58
	exit $SMF_EXIT_ERR_CONFIG
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    59
fi
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    60
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    61
if [ ! -d "${MYSQLDATA}" ]; then
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    62
	echo "mysql/data directory ${MYSQLDATA} is not a valid MySQL data directory"
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    63
	exit $SMF_EXIT_ERR_CONFIG
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    64
fi
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    65
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    66
if [ ! -d "${MYSQLDATA}"/mysql ]; then
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    67
	(
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    68
	exec 2>&1
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    69
	set -x
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    70
	"${MYSQLBIN}"/mysqld --initialize --user=mysql --datadir="${MYSQLDATA}" --log-error="${LOG_ERROR}"
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    71
	)
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    72
fi
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
    73
7765
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    74
getpidfile() {
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    75
 ret=$(${MYSQLBIN}/my_print_defaults --defaults-file=${MYSQLCNF} \
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    76
 mysqld | grep '^--pid-file=' | cut -d= -f2- | tail -1)
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    77
 [ -z "$ret" ] && ret="${MYSQLDATA}/$(/usr/bin/uname -n).pid"
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    78
 echo $ret
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    79
}
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    80
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    81
getsockfile() {
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    82
 ret=$(${MYSQLBIN}/my_print_defaults --defaults-file=${MYSQLCNF} \
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    83
 mysqld | grep '^--socket=' | cut -d= -f2- | tail -1)
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    84
 [ -z "$ret" ] && ret="/tmp/mysql.sock"
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    85
 echo $ret
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    86
}
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    87
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    88
PIDFILE=$(getpidfile)
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    89
SOCKFILE=$(getsockfile)
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    90
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    91
# ping function which return success when mysqld starts accepting connections
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    92
# or return failure in case of timeout after $STARTTIMEOUT seconds.
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    93
# using this function in mysql_start(), method waits/blocks to mysqld is really ready,
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    94
# which might take some time in case of recovery.
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    95
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    96
mysql_pinger() {    
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    97
    mysqld_safe_pid=$1
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    98
    timer=$STARTTIMEOUT
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
    99
    ret=0
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   100
    while [ $timer -gt 0 ]; do
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   101
        sleep 1
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   102
        "${MYSQLBIN}"/mysqladmin --no-defaults --socket=${SOCKFILE} --user=UNKNOWN_MYSQL_USER ping >/dev/null 2>&1 && break
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   103
	timer=$(expr $timer - 1)
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   104
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   105
	# Check if mysqld_safe is still alive, if not there is no hope
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   106
	if ! kill -0 $mysqld_safe_pid >/dev/null 2>&1 ; then
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   107
	    ret=1
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   108
	    break
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   109
	fi
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   110
    done
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   111
    
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   112
    # Did we timeout?
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   113
    if [ $timer = 0 ]; then
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   114
	echo "MySQL Database start up timeout after ${STARTTIMEOUT}s"
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   115
	ret=1
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   116
    fi
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   117
    return $ret
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   118
}
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   119
6571
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   120
# refresh method for this service is not defined because mysqld by itself
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   121
# cannot accept a HUP signal to reload the configuration file my.cnf
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   122
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   123
mysql_start() 	{
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   124
	(
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   125
	exec 2>&1
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   126
	set -x
7765
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   127
	"${MYSQLBIN}"/mysqld_safe --defaults-file="${MYSQLCNF}" --user=mysql --datadir="${MYSQLDATA}" --pid-file="${PIDFILE}" > /dev/null &
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   128
	
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   129
	if mysql_pinger $! ; then
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   130
            echo "Starting service MySQL"
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   131
        else
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   132
            echo "Failed to start service MySQL"
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   133
            exit $SMF_EXIT_ERR
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   134
        fi
3495fc32877e 25372130 Upgrade the version of MySQL 5.5 to 5.5.54 on Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents: 6571
diff changeset
   135
	
6571
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   136
	)
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   137
}
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   138
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   139
case "$1" in
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   140
'start')
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   141
	mysql_start 
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   142
	;;
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   143
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   144
*)
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   145
	echo "Usage: $0 start"
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   146
	exit 1
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   147
	;;
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   148
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   149
esac
12a891fe6a39 22112750 Add MySQL 5.7 to Solaris
Gipson Pulla <gipson.pulla@oracle.com>
parents:
diff changeset
   150
exit $SMF_EXIT_OK