Hello, I try to create a cron with the ispconfig backoffice. I made this Parent website : mysubdomain.com Minutes : 00 Hours : 1 Days of month : * Months : * Days of week : * Command to run (commands are executed via sh, urls via wget) : /var/www/mysubdomain.org/web/my_script_directory/script_db.sh log output : yes Active : yes my script : script.sh (chmod in 755) MAILTO="[email protected]" /usr/bin/mysql -e /usr/bin/mysql c1_myd_db < /var/www/my_subdomain.org/web/db_demo_client/c1_my_db_to_import.sql I look inside syslog : don't see the cron. Where is my mistake ?
I try to change this :/var/www/mysubdomain.org/web/my_script_directory/script_db.sh by this : /var/www/clients/client1/web8/web/db_demo_client/script_db.sh (script and ispconfig interface cron) always the same thing. Just a question : the cron must to work every hour, is it correct ? Tk
Hello, I do not understand when I launch the scron via sh script_db.sh, it works well but with ispconfig, I have always this error Code: (web8) CMD (/web/db_demo_client/script_db.sh >>/private/cron.log 2>>/private/cron_error.log #xxxxxxxx.org)
What error? The paths you show would be for a cron run in a jail, assuming the script is the same as above, do you have /usr/bin/mysql in your jail environment? Do you have it configured to not require a password for mysql inside the jail? Fwiw, I would not recommend storing your .sql files within your website document root, they would be more protected if kept under /private.