mysqldump not available from cron

[sc4arc]

Hi All;

I have a script that generates nightly backups with mysqldump. It's run fine with MySQL4 but this week we updated to MySQL5.5 and now I get an error, "mysqldump: Got error: 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client when trying to connect"

Code: Select all

#!/bin/sh
#
umask 077

DBNAME=sc4arc_wp55
DBPWRD=<password>
DBHOST=sc4arc-wp55.db.sonic.net
DBUSER=${DBNAME}-all
BACKUPDIR=${HOME}/Backup

BACKUPFILE=${BACKUPDIR}/Backup-DB55-`date +%y%m%d`.sql
if [ -r ${BACKUPFILE} ]
then
  echo "File ${BACKUPFILE} already exists."
  exit 1
fi

mysqldump -h ${DBHOST} -u ${DBUSER} -p${DBPWRD} ${DBNAME} > ${BACKUPFILE}

exit 0

The script runs fine when I run it at the command prompt (that is, as user "sc4arc") but I guess that mysqldump doesn't like user "nobody" knowing the secret password. Any suggestions on how to make this work?

Thanks!

Peter

[augie]

Try giving "mysqldump" the full path ( /usr/local/bin/mysqldump ), it may not be in the PATH when the cron executes.

[sc4arc]

I'll try it, but I suspect that it was in some path, since the error message: "mysqldump: Got error: 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client when trying to connect" looks like it came from mysqldump. It's possible that there's more than one present...

If there's a better way to do this, I'm interested to learn how.

[sc4arc]

Nothing succeeds like success. Cron ran the script correctly this morning, using the full path.

Thanks, Augie! I'll watch for that in the future when I'm scripting.

[bobrk]

Yes, that shows that it was probably running the "wrong" mysqldump when you got the error message.

[sc4arc]

And the old version only accidentally ran correctly because of a series of coincidences. It was a fault waiting to happen...

[williamt]

/usr/bin/mysqldump is what you were running at first which is from version 3.23
/usr/local/bin/mysqldump is from version 5.0.16 which is a little old but understands the new authentication
protocol.