AIQUM备份失败、并且jboss用户的mysql错误访问被拒绝
适用场景
- Active IQ Unified Manager （ AIQUM ）
- 安装在 RHEL 上或部署为 OVA
问题描述
- 备份始终失败
- 未创建备份
- 图形界面无错误
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 ....
2023-03-06 21:40:00,061 ERROR [oncommand] [task-scheduler-18] [Backup|ScheduleFullBackup] [c.n.d.i.backup.MysqlDumpOperation] Error occured while taking mysql dump. Error message:
2023-03-06 21:40:00,061 ERROR [oncommand] [task-scheduler-18] [Backup|ScheduleFullBackup] [c.n.d.i.backup.MysqlDumpOperation] mysqldump: [Warning] /opt/netapp/ocum/etc/.mylogin.cnf should be readable/writable only by current user.