• The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Issue with 50plesk-daily job

ThomasL1

New Pleskian
Hi all,

i have an issue with the daily cronjob 50plesk-daily

After the last Update to version:

BS: Ubuntu 12.04 2 LTS
Panel Version: 11.0.9 Update #55


i got a email avery night with the following content:

Cron <root@xxxxxxxx> test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
run-parts: /etc/cron.daily/50plesk-daily exited with return code 7

Has anyone the same issue. Is there any solution ?

Kindly regards
Thomas
 
Usually content of this file is following:

# cat /etc/cron.daily/50plesk-daily
#!/bin/sh
### Copyright 1999-2012. Parallels IP Holdings GmbH. All Rights Reserved.

# install_statistics
/usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/DailyMaintainance/script.php >/dev/null 2>&1

# install_mysqldump
/usr/local/psa/bin/mysqldump.sh >/dev/null 2>&1

As you can see there are DailyMaintenance script execution and creation dump of databases.

You can try to run these commands and see what's happens in output. This might shed a light on reason of this "exited with return code 7"
 
I have split them up.

The error code comes from the 2. script

/usr/local/psa/bin/mysqldump.sh >/dev/null 2>&1

I run it in debug-mode and found the root-cause for that issue:

+ /usr/bin/mysqldump --user=admin --quote-names --databases psa myql
Warning: mysqldump: unknown variable 'local-infile=1'


I need local-infile to be able to LOAD LOCAL DATA into mysql Server. Switching that setting in my.cnf to loose-local-infile should solve that problem.

regards
Thomas
 
I have the same problem for 3 weeks now, the only difference is that I get exit status 1 instead of 7.

When I executed /opt/psa/bin/mysqldump.sh manually for the first time, I got the following error messages:
[: 1: -eq: unexpected operator
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent

To get rid of the "unexpected operator", I edited the mysqldump.sh script like this:
---
function report_problem()
[...]
- if [ $problems_occured -eq 0 ]; then
+ if [ -z "$problems_occured" ]; then
---
function mysql_test_connection()
[...]
- if [ "$?" -eq "0" ]; then
+ if [ "$?" = "0" ]; then
---
- [ "$attempts" -eq "1" ] || sleep 2
+ [ "$attempts" = "1" ] || sleep 2


After that, the "unexpected operator" was gone, but now I get the other error messages 3 times:
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent

I did some debugging (added "set -x" to the beginning of the script), here's the log:
[...]
+ mysql_direct mysql
+ [ 1 = 0 ]
+ [ 60 = 1 ]
+ sleep 2
+ + echomysql_direct mysql

+ [ 1 = 0 ]
+ [ 60 = 1 ]
+ sleep 2
+ echo
+ mysql_direct mysql
+ [ 1 = 0 ]
+ [ 60 = 1 ]
+ sleep 2
+ echo
+ mysql_direct mysql
+ [ 1 = 0 ]
+ [ 60 = 1 ]
+ sleep 2
+ p_echo failed
+ [ -n -o -n -o -z /dev/null ]
+ echo failed
+ return 1
+ die establish test connection
+ PACKAGE_SCRIPT_FAILED=establish test connection
+ [ X != X1 ]
+ printf \a\a
^G^G+ report_problem ERROR while trying to establish test connection Check the error reason(see log file: /dev/null), fix and try again
+ p_echo
+ [ -n -o -n -o -z /dev/null ]
+ echo
+ [ -z ]
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent
+ echo ***** problem report *****
+ p_echo ERROR while trying to establish test connection
+ [ -n -o -n -o -z /dev/null ]
+ echo ERROR while trying to establish test connection
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent
+ echo ERROR while trying to establish test connection
+ p_echo Check the error reason(see log file: /dev/null), fix and try again
+ [ -n -o -n -o -z /dev/null ]
+ echo Check the error reason(see log file: /dev/null), fix and try again
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent
+ echo Check the error reason(see log file: /dev/null), fix and try again
+ p_echo
+ [ -n -o -n -o -z /dev/null ]
+ echo
+ product_log_tail
+ [ -f /dev/null ]
+ return 0
+ send_error_report Problem: ERROR while trying to establish test connection Check the error reason(see log file: /dev/null), fix and try again
+ echo Problem: ERROR while trying to establish+ /opt/psa/admin/bin/send-error-report test connection Check the error reason(see log file: /dev/null), fix and try again
+ install
echo
[...]


Any hint what's going wrong here?
 
Back
Top