--On 12. januar 2005 9:44 +0100 "Lars E. Pettersson" <lars@xxxxxxxx> wrote:
On Tue, 2005-01-11 at 21:10, Alexander Dalloz wrote:
That was Jason's quick guess. And having a look at the mysql init script
you will find following comment:
# If you've removed anonymous users, this line must be changed
to
# use a user that is allowed to ping mysqld.
ping="/usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping"
The update from January 5 does it in an even better way (see the
bugzilla mentioned earlier in th thread)
# Spin for a maximum of N seconds waiting for the server to come
up.
# Rather than assuming we know a valid username, accept an
"access
# denied" response as meaning the server is functioning.
if [ $ret -eq 0 ]; then
STARTTIMEOUT=10
while [ $STARTTIMEOUT -gt 0 ]; do
RESPONSE=`/usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping
2>&1` &&
break
echo "$RESPONSE" | grep -q "Access denied for user" &&
break
sleep 1
let STARTTIMEOUT=${STARTTIMEOUT}-1
done
if [ $STARTTIMEOUT -eq 0 ]; then
echo "Timeout error occurred trying to start MySQL
Daemon."
action $"Starting $prog: " /bin/false
else
action $"Starting $prog: " /bin/true
fi
else
action $"Starting $prog: " /bin/false
fi
I.e. an "Access denied for user" is also considered as an indication
that the server is up.
Lars
If that's the case then I'll update my server. Will see.
Sasa