Skip to main content
NetApp Stage KB

AIQUM backup fails with mysql error access for jboss user denied

Views:
Visibility:
Public
Votes:
0
Category:
active-iq-unified-manager
Specialty:
OM
Last Updated:

Applies to

  • Active IQ Unified Manager (AIQUM)
  • Installed on RHEL or deployed as OVA

Issue

  • Backup fails always
  • No backups created
  • No error in graphical interface

Error in ocumserver.log
 

2021-03-01 09:55:00,074 INFO  [oncommand] [taskScheduler-4] [Backup|ScheduleBackup] [c.n.d.i.backup.MysqlDumpOperation] Starting mysql full dump process
2021-03-01 09:55:00,075 INFO  [oncommand] [taskScheduler-4] [Backup|ScheduleBackup] [c.n.d.i.backup.MysqlDumpOperation] Locking the instance for backup
2021-03-01 09:55:00,075 INFO  [oncommand] [taskScheduler-4] [Backup|ScheduleBackup] [c.n.d.i.backup.MysqlDumpOperation] Instance is locked
2021-03-01 09:55:00,075 INFO  [oncommand] [taskScheduler-4] [Backup|ScheduleBackup] [c.n.d.i.backup.MysqlDumpOperation] Running command /usr/bin/mysqldump --login-path=jboss --ignore-table=ocum.managementstation --delete-master-logs --flush-logs --add-drop-table --routines --triggers --databases --single-transaction mysql management sanscreen acquisition ocum ocum_view ocum_report ocum_report_birt ocum_data_collector netapp_model_view netapp_model netapp_performance vmware_model_view vmware_model vmware_performance scalemonitor opm -r /opt/netapp/data/ocum-backup/database-dumps-repo/ocum_mysql_full_backup_1614588900074.sql by user jboss
2021-03-01 09:55:00,105 ERROR [oncommand] [taskScheduler-4] [Backup|ScheduleBackup] [c.n.d.i.backup.MysqlDumpOperation] Error occured while taking mysql dump. Error message:
2021-03-01 09:55:00,105 ERROR [oncommand] [taskScheduler-4] [Backup|ScheduleBackup] [c.n.d.i.backup.MysqlDumpOperation] mysqldump: Got error: 1045: Access denied for user 'jboss'@'localhost' (using password: YES) when trying to connect

2021-03-01 09:55:00,105 INFO  [oncommand] [taskScheduler-4] [Backup|ScheduleBackup] [c.n.d.i.backup.MysqlDumpOperation] Unlocking the instance for backup
2021-03-01 09:55:00,106 INFO  [oncommand] [taskScheduler-4] [Backup|ScheduleBackup] [c.n.d.i.backup.MysqlDumpOperation] Instance is unlocked
2021-03-01 09:55:00,110 INFO  [oncommand] [taskScheduler-4] [Backup|ScheduleBackup] [c.n.d.i.b.MySqlDumpBackupManager] Deleted BackupFileInfo entity in DB
2021-03-01 09:55:00,128 ERROR [oncommand] [taskScheduler-4] [Backup|ScheduleBackup] [c.n.d.impl.backup.BackupScheduleJob] Error occurred in Regular Backup Job:
com.netapp.dfm.impl.backup.BackupCreationException: Failed to create database backup using mysql utility.
        at deployment.dfm-app.war//com.netapp.dfm.impl.backup.MysqlDumpOperation.takeMysqlbackup(MysqlDumpOperation.java:93)
        at deployment.dfm-app.war//com.netapp.dfm.impl.backup.MySqlDumpBackupManager.collectMysqlDump(MySqlDumpBackupManage ....

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.
28ff2ca7-29f3-407a-9cf6-28011b7fefc4