Active IQ Unified Manager Discussions

OCUM 6.4P2 Database backup fails to create backup

NetappUser281
2,419 Views

Hello

 

We recently installed OCUM 6.4 and there were no errors during installation . Now when we configured the DB backup it has been failing since 2 days with the same reason.

 

Error:

"Daily database backup 'UM_6.4P2_backup_unix_12-27-2016-14-00.7z' creation failed. Reason: Failed to create database backup using mysql utility."

 

Any suggestions?

1 REPLY 1

Jeff_Yao
2,323 Views

try below to see if helps:

 

Cause 1: After recent upgrade, perform the following steps:

  1. Check to see if the link to /usr/bin/mysqldump has been removed. If so, add this link back during the upgrade script, as the link is removed but not added back.
  2. Check the output from the following command:
    ls -l /usr/bin | grep mysqldump
  3. If this gives no output, then run the following command to fix:
    ln -s /opt/mysql/server-5.6/bin/mysqldump /usr/bin/mysqldump

Cause 2: If the backup fails even though there is a link to the mysqldump, perform the following steps:

  1. In some cases, it might be necessary to add an additional entry for jboss into the /etc/sudoers file. Add the following line to the /etc/sudoers file:
    jboss ALL=(ALL) NOPASSWD: /usr/bin/mysqldump
    The resulting output will look similar to the following:
    [root@oum-xxx1 ocum-backup]# cat /etc/sudoers | grep jboss
    jboss ALL=(ALL) NOPASSWD: /usr/bin/mysqldump
    [root@oum-xxx1 ocum-backup]
  2. If the customer has run the upgrade on the vApp from 6.3 -> 6.3P1, check to see if the link to /usr/bin/mysqldump has been removed. If so, add this link back during the upgrade script, as the link is removed but not added back.
  3. Check the output from the following command:
    ls -l /usr/bin | grep mysqldump
  4. If this gives no output, then run the following command to fix:
    ln -s /opt/mysql/server-5.6/bin/mysqldump /usr/bin/mysqldump
Public