Problema com o script de inicialização do MySQL [RESOLVIDO]

1. Problema com o script de inicialização do MySQL [RESOLVIDO]

José
toresmo

(usa Debian)

Enviado em 06/03/2012 - 17:19h

Olá pessoal,

acidentalmente deletei o arquivo /etc/init.d/mysql, utilizado para iniciar (ou parar) o serviço mysql. Desinstalei e instalei os pacotes mysql-client e mysql-server novamente, entrentanto o arquivo não está sendo criado. Alguém sabe uma solução para este problema?

Desde já agradeço.


  


2. tente usar esse

M4iir1c10
m4iir1c10

(usa Arch Linux)

Enviado em 06/03/2012 - 18:26h

copie esse para /etc/init.d/mysql


#!/sbin/runscript
# Copyright 1999-2006 Gentoo Foundation
# Distributed under the terms of the GNU General Public License v2
# $Header: /var/cvsroot/gentoo-x86/dev-db/mysql-init-scripts/files/mysql.rc6,v 1.2 2007/03/04 15:47:03 vivo Exp $

# external binaries used: which, sed, tac

# int in_list(char * elem, char * list)
function in_list() {
local elem=${1:-"none"}
local list=${2:-","}

[[ "${list}" == "${list/,${elem},/}" ]] \
&& return 1 \
|| return 0
}

function wdebug() {
if [[ "${DEBUG}" -ge "${1}" ]] ; then
shift
echo "dbg: ${@}"
fi
}

depend() {
use dns net localmount netmount nfsmount
}

do_escape() {
# Ihatethisreallyverymuch
#echo "$1" | sed -e "s|'| |" -e "s|=|='|" -e "s|$|'|"
echo "$1"
}

# int get_slot_config(srv_slot=0, srv_num)
get_slot_config() {
wdebug 4 ">>> get_slot_config()"

local srv srv_slot srv_num
srv_slot="${1:-"0"}"
srv_num="${2}"
MY_SUFFIX="-${srv_slot}"
# srv=array(0 => [srv_slot], 1 => [srv_num] )
srv=( ${srv_slot} ${srv_num} )

local tmp_eval="mysql_slot_${srv_slot}${srv_num:+"_"}${srv_num}[@]"
local conf_d_parameters="${!tmp_eval}"
if [[ "${srv_slot}" == "0" ]] ; then
MY_SUFFIX=''
# try some other default for the default server
[[ -z "${conf_d_parameters[@]}" ]] && conf_d_parameters=${mysql_slot[@]}
fi
[[ -z "${conf_d_parameters[@]}" ]] && conf_d_parameters=( )
basedir="" datadir="" pidfile="" socket=""
CHROOT="" NICE="" STARTUPTIMEOUT=5 STOPTIMEOUT=120

wdebug 3 "srv ${srv[@]}"
wdebug 3 "srv_slot ${srv_slot}"
wdebug 3 "srv_num ${srv_num}"
wdebug 3 "tmp_eval ${tmp_eval}"
wdebug 3 "conf_d_parameters ${conf_d_parameters[@]}"
wdebug 3 "MY_SUFFIX ${MY_SUFFIX}"

local tmp_eval="mysql_slot_${srv_slot}${srv_num:+"_"}${srv_num}[@]"
local conf_d_parameters="${!tmp_eval}"
# collations need to be defined *after* the character sets,
# so we will duplicate them
local collations=""
[[ ${conf_d_parameters[*]} == '()' ]] && conf_d_parameters=''

MY_CNF="/etc/mysql${MY_SUFFIX}/my.cnf"
# summa of unmanaged parameters
# some parameters may be present multiple times
unmanagedparams=""

# grab the parameters from conf.d/mysql definition
for my_default in ${conf_d_parameters[*]} ; do
case "${my_default}" in
nice=*)
NICE="${my_default#nice=}"
nice -n $NICE ls /tmp &>/dev/null || NICE=""
;;
mycnf=*) MY_CNF="${my_default#mycnf=}" ;;
startup_timeout=*)
STARTUPTIMEOUT="${my_default#startup_timeout=}" ;;
basedir=*) basedir="${my_default#basedir=}" ;;
datadir=*) datadir="${my_default#datadir=}" ;;
pid-file=*) pidfile="${my_default#pid-file=}" ;;
socket=*) socket="${my_default#socket=}" ;;
*collation*=)
collations="${collations} --$( do_escape "${my_default}" )"
;;
*=*)
# list of parameters we already have
# prepend "--" because my_print_defaults do it
unmanagedparams="${unmanagedparams} --$( do_escape "${my_default}" )"
;;
*)
unmanagedparams="${unmanagedparams} --${my_default}"
;;
esac
done

if [[ ! -r "${MY_CNF}" ]] ; then
ewarn "Cannot access ${MY_CNF} !"
MY_CNF=""
my_defaults=""
else
local my_print_defaults="$(which my_print_defaults${MY_SUFFIX} 2>/dev/null)"
if [[ ! -x "${my_print_defaults}" ]] ; then
eerror "my_print_defaults NOT found or not executable"
my_defaults=""
else
my_defaults=$( ${my_print_defaults} \
--loose-verbose \
--config-file="${MY_CNF}" \
mysqld server )
fi
fi

# grab needed parameters from my.cnf, don't override the ones from
# conf.d/mysql
for my_default in ${my_defaults} ; do
case "${my_default}" in
--basedir=*)
[[ -z "${basedir}" ]] && basedir="${my_default#--basedir=}" ;;
--datadir=*)
[[ -z "${datadir}" ]] && datadir="${my_default#--datadir=}" ;;
--pid-file=*)
[[ -z "${pidfile}" ]] && pidfile="${my_default#--pid-file=}" ;;
--socket=*)
[[ -z "${socket}" ]] && socket="${my_default#--socket=}" ;;
--*collation*=)
# the order is inversed because we want the conf.d ones overriden
collations="$( do_escape "${my_default}" ) ${collations}"
;;
esac
done

# some parameters
basedir="${basedir:-"/usr"}"
datadir="${datadir:-"/var/lib/mysql${MY_SUFFIX}"}"
pidfile="${pidfile:-"/var/run/mysqld/mysqld${MY_SUFFIX}.pid"}"
socket="${socket:-"/var/run/mysqld/mysqld${MY_SUFFIX}.sock"}"
unmanagedparams="${unmanagedparams} ${collations}"

wdebug 3 "chroot dir => ${CHROOT}"
wdebug 3 "niceness => ${NICE}"
wdebug 3 "basedir => ${basedir}"
wdebug 3 "datadir => ${datadir}"
wdebug 3 "pidfile => ${pidfile}"
wdebug 3 "socket => ${socket}"
wdebug 3 "Unamanged => ${unmanagedparams}"

# extension for sleep tenth of seconds, not very portable so check it before
if sleep 0.01 ; then
STARTUPTIMEOUT=$(( STARTUPTIMEOUT * 10 ))
STOPTIMEOUT=$(( STOPTIMEOUT * 10 ))
TIMEUNIT=0.1
else
TIMEUNIT=1
fi

# push these out to the script
export MY_SUFFIX NICE MY_CNF pidfile datadir basedir socket CHROOT
export unmanagedparams STARTUPTIMEOUT STOPTIMEOUT TIMEUNIT
wdebug 4 "<<< get_slot_config() ok"
return 0
}

checkconfig() {
wdebug 4 ">>> checkconfig(\"${1}\")"
local datadir="${1}" pidfile="${2}" socket="${3}"

if [[ -n "${NOCHECK}" ]] ; then
rm -f "${pidfile}" "${socket}"
return 0
fi

if [[ ! -d "${datadir}" ]] ; then
eerror "MySQL datadir is empty or invalid"
eerror "Please check your my.cnf : ${MY_CNF}"
wdebug 4 "<<< checkconfig() KO"
return 1
fi

if [[ ! -d "${datadir}/mysql" ]] ; then
eerror "You don't appear to have the mysql database installed yet."
eerror "Please run /usr/bin/mysql_install_db to have this done..."
wdebug 4 "<<< checkconfig() KO"
return 1
fi

if [[ -f "${pidfile}" ]] ; then
kill -15 $(< ${pidfile}) 2>/dev/null
if [[ $? -eq 0 ]] ; then
# the process exist, we have a problem
eerror "\"${pidfile}\" is still present and the process is running."
eerror "Please stop it \"kill $(< ${pidfile})\" maybe ?"
wdebug 4 "<<< checkconfig() KO"
return 1
else
rm -f "${pidfile}"
fi
fi

if [[ -S "${socket}" ]] ; then
ewarn "Strange, the socket file already exist in \"${socket}\""
ewarn "it will be removed now and re-created by the MySQL server"
ewarn "BUT please make your checks."
rm -f "${socket}"
fi

wdebug 4 "<<< checkconfig() ok"
return 0
}

start() {
wdebug 4 ">>> start()"

MYSQL_GLOB_PID_FILE=${MYSQL_GLOB_PID_FILE:-"/var/run/svc-started-${SVCNAME/mysql/mysqld}"}
# servers are defined in /etc/conf.d/mysql
local serverlist=${!mysql_slot_*}
# provide default for empty conf.d/mysql
if [[ -z "${serverlist}" ]] ; then
serverlist=0
export mysql_slot_0=( )
fi
local retstatus timeout
local globretstatus=1
local srv_slot srv_num
# server MUST NOT share same location for these
local pidfilelist=',' datadirlist=',' socketlist=','
local ssd_thing=1
local mysqld_thing tmpnice

ebegin "Starting ${myservice}"
# try to start each server
for srv in ${serverlist[*]} ; do

srv_slot="${srv#mysql_slot_}"
if [[ "${srv_slot}" == "${srv_slot#*_}" ]] ; then
srv_num=''
else
srv_num="${srv_slot#*_}"
fi
srv_slot="${srv_slot%%_*}"

retstatus=0
get_slot_config "${srv_slot}" "${srv_num}" || retstatus=1

# checks
if ! checkconfig "${datadir}" "${pidfile}" "${socket}" ; then
retstatus=2 ; continue
fi
if in_list "${pidfile}" "${pidfilelist}" ; then
eerror "Sorry, won't start with same pid-file: ${pidfile}"
retstatus=3 ; continue
fi
if in_list "${datadir}" "${datadirlist}" ; then
eerror "Sorry, won't start with same datadir: ${datadir}"
retstatus=4 ; continue
fi
if in_list "${socket}" "${socketlist}" ; then
eerror "Sorry, won't start with same socket: ${socket}"
retstatus=5 ; continue
fi

einfo "Starting ${myservice} (${MY_CNF})"

mysqld_thing="${MY_CNF:+"--defaults-file="}${MY_CNF}"
mysqld_thing="${mysqld_thing} ${unmanagedparams}"
mysqld_thing="${mysqld_thing} --basedir=${basedir}"
mysqld_thing="${mysqld_thing} --datadir=${datadir}"
mysqld_thing="${mysqld_thing} --pid-file=${pidfile}"
mysqld_thing="${mysqld_thing} --socket=${socket}"

wdebug 2 "starting mysqld with: ${mysqld_thing}"

if [[ ${ssd_thing} -eq 1 ]] ; then
tmpnice="${NICE:+"--nicelevel "}${NICE}"
start-stop-daemon --quiet ${DEBUG/*/"--verbose"} --start \
--background ${tmpnice} --pidfile ${pidfile} \
--exec ${basedir}/sbin/mysqld${MY_SUFFIX} -- ${mysqld_thing} \
&& sleep ${TIMEUNIT}
retstatus=$?
else
tmpnice="${NICE:+"nice -n "}${NICE}"
${tmpnice} ${basedir}/sbin/mysqld${MY_SUFFIX} ${mysqld_thing} &
retstatus=0
fi

# only the first run is done by start-stop-daemon
ssd_thing=""

# wait for socket creation
wdebug 1
while ! [[ -S "${socket}" || "${STARTUPTIMEOUT}" -lt 1 || "${retstatus}" -ne 0 ]] ; do
STARTUPTIMEOUT=$(( STARTUPTIMEOUT - 1 ))
[[ ${DEBUG} -ge 1 ]] && echo -n "${STARTUPTIMEOUT},"
sleep ${TIMEUNIT}
done
wdebug 1 ""
if [[ ! -S "${socket}" ]] ; then
eerror "MySQL${MY_SUFFIX} NOT started (${retstatus})"
retstatus=1
else
globretstatus=0
pidfilelist="${pidfilelist}${pidfile},"
datadirlist="${datadirlist}${datadir},"
socketlist="${socketlist}${socket},"
echo "${srv_slot}${srv_num:+"_"}${srv_num}=${pidfile}" >> "${MYSQL_GLOB_PID_FILE}"
fi
done
# successfull if at least one mysqld started
wdebug 4 "<<< start()"
eend $globretstatus
}

stop() {
get_slot_config &> /dev/null
MYSQL_GLOB_PID_FILE=${MYSQL_GLOB_PID_FILE:-"/var/run/svc-started-${SVCNAME/mysql/mysqld}"}
local runwhat pidfile shutdown_elem
local PID cnt timeout=${STOPTIMEOUT:-"120"}
local retstatus=0
local shutdown_list="$(< "${MYSQL_GLOB_PID_FILE}" )"

ebegin "Stopping ${myservice}"
wdebug 5 "MYSQL_GLOB_PID_FILE: ${MYSQL_GLOB_PID_FILE}"
wdebug 5 "shutdown_list: ${shutdown_list}"
for shutdown_elem in ${shutdown_list} ; do
runwhat=${shutdown_elem%%=*}
pidfile=${shutdown_elem#*=}
timeout=${STOPTIMEOUT:-"120"}
PID=$(< "${pidfile}" )
wdebug 3 "runwhat ${runwhat}"
wdebug 3 "pidfile ${pidfile}"
wdebug 3 "timeout ${timeout}"
wdebug 3 "PID ${PID}"

einfo "Stopping mysqld (${runwhat})"

start-stop-daemon --quiet ${DEBUG/*/"--verbose"} --stop --pidfile "${pidfile}" &
wdebug 1 ""
while [[ -n "$PID" ]] \
&& $( ps -Ao pid | grep -q "^ *$PID$" ) \
&& [[ "${timeout}" -ge 1 ]]
do
timeout=$(($timeout - 1))
[[ ${DEBUG} -ge 1 ]] && echo -n "$(( $STOPTIMEOUT - $timeout )),"
sleep ${TIMEUNIT}
done
[[ "${timeout}" -lt 1 ]] && retstatus=1
done
sleep ${TIMEUNIT}
[[ "$retstatus" -eq 0 ]] && rm -f "$MYSQL_GLOB_PID_FILE"
eend ${retstatus}
}



3. Re: Problema com o script de inicialização do MySQL [RESOLVIDO]

José
toresmo

(usa Debian)

Enviado em 06/03/2012 - 18:37h

Já tinha conseguido corrigir o problema, mas muito obrigado pela resposta. Eu tinha feito uma confusão aqui. Os pacotes não estavam sendo instalados, por isso não estava gerando o arquivo (haviam pacotes desencontrados). Corrigi o problema com:

apt-get remove --purge mysql*
apt-clean
apt-autoclean
apt-get install mysql-server







Patrocínio

Site hospedado pelo provedor RedeHost.
Linux banner

Destaques

Artigos

Dicas

Tópicos

Top 10 do mês

Scripts