Plesk Panel upgrade fails: ERROR while trying to backup MySQL database

Refers to:

  • Plesk 11.5 for Linux
  • Plesk

Created:

2016-11-16 13:16:28 UTC

Modified:

2017-02-23 15:50:48 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Plesk Panel upgrade fails: ERROR while trying to backup MySQL database

Symptoms

Plesk Panel upgrade fails with the following error:

chown: changing ownership of `/var/lib/psa/dumps/mysql.preupgrade.11.5.30-11.5.30.20131211-190722.dump.gz': Operation not permitted
...
***** problem report *****
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again

Backup folder is located in NFS share .

Cause

During the upgrade process Plesk creates databases (psa, horde) dumps and prior dumping database it corrects permission for files in the backup folder. If backup folder is located in NFS share then Plesk fails to change permissions there.

Resolution

  1. Check dump folder location:

    # grep -i dumps /etc/psa/psa.conf
    DUMP_D /var/lib/psa/dumps

    # ll -d /var/lib/psa/dumps
    drwxrwxrwx 6 nfsnobody nfsnobody 20480 Dec 11 17:54 /var/lib/psa/dumps

    # mount | grep dump
    my.net:/net on /var/lib/psa/dumps type nfs (rw,addr=192.168.0.10)
  2. To verify the issue try to use chown utility on any file the dump directory:

    # chown psaadm:psaadm /var/lib/psa/dumps
    chown: changing ownership of `/var/lib/psa/dumps': Operation not permitted

Please make sure that user " psaadm " has full privileges for the dump directory. See example:

# ll -d /var/lib/psa/dumps
drwxr-xr-x 5 psaadm psaadm 4096 abr 1 2013 /var/lib/psa/dumps

As a workaround you can change value DUMP_D in psa.conf file and perform upgrade.

In order to complete the upgrade do the following:

  1. Back up /etc/psa/psa.conf configuration file

    # cp /etc/psa/psa.conf{,.orig}
  2. Changed the backup directory

    # grep -n DUMP /etc/psa/psa.conf
    83:DUMP_D /var/lib/psa/dumps
    84:DUMP_TMP_D /tmp
    # vi /etc/psa/psa.conf
    # grep -n DUMP /etc/psa/psa.conf
    83:DUMP_D /var/lib/psa/backup
    84:DUMP_TMP_D /tmp
  3. Run an upgrade:

    # /usr/local/psa/admin/sbin/autoinstaller
  4. When upgrade process will be finished, revert changes made in /etc/psa/psa.conf

Have more questions? Submit a request
Please sign in to leave a comment.