• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Resolved Cron and mysqlcheck

sweetp

Basic Pleskian
I want to set a Cron job to optimise all my databases, so i tried running this command from a Scheduled Task:
mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --auto-repair --optimize --verbose --all-databases

But it always throws an error:
Task "mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --auto-repair --optimize --verbose --all-databases" completed with error in 0 seconds, output:

cat: /etc/psa/.psa.shadow: Permission denied
Enter password: mysqlcheck: Got error: 1045: Access denied for user 'admin'@'localhost' (using password: NO) when trying to connect


How can i set this Cron job, and have it run?
 
So it was actually a pretty simple solution.
I was adding the task on a specific webspace.

When I re-aded the task in Tools & Settings > Scheduled Tasks as a root user, it ran just fine.
:oops:
 
Back
Top