MySQL process check with cron

Question

I can run this script fine from the terminal and I get the else but when I have cron set to run it every 5 minutes I am sent a email and the mysql server is restarted every 5 minutes. So I am guessing that the cron job does not have the correct permission to see if the process is running, so it restarts the server and sends an email. How would I get this script to execute from cron and be able to check if mysql process is running?

#!/bin/sh
UP=$(service mysql status | grep 'mysql start/running' | wc -l);
if [ "$UP" -ne 1 ];
then
        sudo service mysql start
        cat /var/db-backup/mysql_restart_email | msmtp someone@gmail.com
else
        echo "All is well.";
fi

Answer 1

sierracircle May 26, 2015

Here is my take on the same idea, but I made it so the script checks on other services (like Apache2)

https://github.com/sierracircle/services-checker

works fine on all my DO droplets for the last several months.

Reply Report

dirk2099 May 26, 2015

Same thing as above. Works great executing from the terminal but it thinks the service is down when executed from cron.
Reply Report

Answer 2

dirk2099 May 26, 2015

Same thing as above. Works great executing from the terminal but it thinks the service is down when executed from cron.
Reply Report

Answer 3

sierracircle May 27, 2015

when you set up the cronjob, are you running:

sudo crontab -e

Reply Report

dirk2099 May 27, 2015

I did not.
Reply Report
dirk2099 May 27, 2015

I tried using sudo and there was no difference.
Reply Report

sierracircle May 27, 2015

Run this:

sudo /etc/init.d/mysql stop

then this:

sudo service mysql start

Reply Report

dirk2099 May 27, 2015

Okay it is working now. Silly me did forget the sudo....

so this:

UP=$(service mysql status | grep 'mysql start/running' | wc -l);

becomes:

UP=$(sudo service mysql status | grep 'mysql start/running' | wc -l);

Thanks for all the help!

Reply Report

Answer 4

dirk2099 May 27, 2015

I did not.
Reply Report
dirk2099 May 27, 2015

I tried using sudo and there was no difference.
Reply Report

sierracircle May 27, 2015

Run this:

sudo /etc/init.d/mysql stop

then this:

sudo service mysql start

Reply Report

dirk2099 May 27, 2015

Okay it is working now. Silly me did forget the sudo....

so this:

UP=$(service mysql status | grep 'mysql start/running' | wc -l);

becomes:

UP=$(sudo service mysql status | grep 'mysql start/running' | wc -l);

Thanks for all the help!

Reply Report

Related

Question

MySQL process check with cron

Related

Leave a comment

Looking for something else?

Sign up for our newsletter

Related

Question

MySQL process check with cron

Related

Leave a comment

Related

question

deleted question

question

Quotas are not enabled on the filesystem, Quota editing has been disabled.

question

deleted question

question

Provider only uses ftp, not sftp. What is the best way of enabling temporary ftp into a file path?

Looking for something else?