ActiveIQ Unified Manager 9.8 Database Dump from Appliance to Windows Server

[POLICARD]

Hi All,

I'm curently using the appliance version of ActiveIQ Unified Manager 9.8

In my previous company I was using a Powershell script for managing ocum alerts and adapt them to my infrastructure. I want to reuse it.

As it's not possible to use powershell scripts with Active IQ Appliance, I need to install ActiveIQ Unified Manager on a windows server.

So I made a mysqldump of the appliance database using ocum menu and I put the dump on windows server.

There is a script named "restore.bat" in bin folder of Windows OCUM. I used it with the dump from my appliance ... but an error message is indicating that the backup is from unix environment and it's not possible to restore it on windows ... (parameter "supportedOSType" in "restore.bat" prevents from going any further).

As it's a mysql database ... I dont get the point why there coulb be any difference between unix and windows ... 

Is there any way to get my 13 months old data on my fresh installation on Windows ... ?

[POLICARD]

I've tried to the restore.bat by replacing

SET supportedOSType=windows

by

SET supportedOSType=unix

I had to run the following MySQL comamnd prior to launch the batch :

SET GLOBAL log_bin_trust_function_creators = 1;

The I launched the script who ran successfully :

E:\NetApp\ocum\bin>restore.bat c:\Scripts\AIQ_UM_9.8_backup_unix_03-07-2021-11-00.7z
2021-3-8 9:42:52,000 INFO  [Active IQ] [restore] [restore.bat] Backup file exists.
2021-3-8 9:42:53,000 INFO  [Active IQ] [restore] [restore.bat] Backup directory path is not available in ocum.conf.
2021-3-8 9:42:53,000 INFO  [Active IQ] [restore] [restore.bat] The default database dump repository c:\Scripts\database_dumps_repo exists.
2021-3-8 9:42:53,000 INFO  [Active IQ] [restore] [restore.bat] Backup file selected is c:\Scripts\AIQ_UM_9.8_backup_unix_03-07-2021-11-00.7z
2021-3-8 9:42:53,000 INFO  [Active IQ] [restore] [restore.bat] The status of restore will be logged into  "E:\ProgramData\NetApp\OnCommandAppData\ocum\log\UM_NotPromoted_restore_3-8-2021-9-42-52.log"
2021-3-8 9:42:54,000 INFO  [Active IQ] [restore] [restore.bat] Temp extract directory used is E:\ProgramData\NetApp\OnCommandAppData\ocum\backup\UMrestore-3-8-2021-9-42-52
2021-3-8 9:42:54,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the backup file c:\Scripts\AIQ_UM_9.8_backup_unix_03-07-2021-11-00.7z to a temporary location E:\ProgramData\NetApp\OnCommandAppData\ocum\backup\UMrestore-3-8-2021-9-42-52
2021-3-8 9:42:54,000 INFO  [Active IQ] [restore] [restore.bat] Extracted the backup files successfully
2021-3-8 9:42:55,000 INFO  [Active IQ] [restore] [restore.bat] OSType from metadata file = unix
2021-3-8 9:42:55,000 INFO  [Active IQ] [restore] [restore.bat] Supported OSType = unix
2021-3-8 9:42:55,000 INFO  [Active IQ] [restore] [restore.bat] Active IQ Unified Manager Version from metadata file = 9.8
2021-3-8 9:42:55,000 INFO  [Active IQ] [restore] [restore.bat] Supported Active IQ Unified Manager Version = 9.8
2021-3-8 9:42:56,000 INFO  [Active IQ] [restore] [restore.bat] The selected backup file is compatible with existing Active IQ Unified Manager
2021-3-8 9:42:56,000 INFO  [Active IQ] [restore] [restore.bat] Going to stop Active IQ Unified Manager
2021-3-8 9:42:56,000 INFO  [Active IQ] [restore] [restore.bat] Service ocie-au is not running
2021-3-8 9:42:57,000 INFO  [Active IQ] [restore] [restore.bat] Service ONCOMMANDSVC is not running
2021-3-8 9:42:57,000 INFO  [Active IQ] [restore] [restore.bat] Service MySQL8 is already running
2021-3-8 9:42:58,000 INFO  [Active IQ] [restore] [restore.bat] considering all certificates from the location E:\NetApp\ocum\etc\security
2021-3-8 9:42:58,000 INFO  [Active IQ] [restore] [restore.bat] Number of certificates and keystore to restore are 3
2021-3-8 9:42:58,000 INFO  [Active IQ] [restore] [restore.bat] Clearing off security directory E:\NetApp\ocum\etc\security
Deleted file - E:\NetApp\ocum\etc\security\autosupport.truststore
Deleted file - E:\NetApp\ocum\etc\security\saml_sp_metadata.xml
2021-3-8 9:42:58,000 INFO  [Active IQ] [restore] [restore.bat] Removed all the existing truststore and keystores successfully
2021-3-8 9:42:58,000 INFO  [Active IQ] [restore] [restore.bat] Restoring new certificates
2021-3-8 9:42:59,000 INFO  [Active IQ] [restore] [restore.bat] Restored certificates successfully
2021-3-8 9:42:59,000 INFO  [Active IQ] [restore] [restore.bat] considering all reports from the location E:\NetApp\ocum\excel_report
File Not Found
2021-3-8 9:42:59,000 INFO  [Active IQ] [restore] [restore.bat] Number of excel reports to restore are 0
2021-3-8 9:42:59,000 INFO  [Active IQ] [restore] [restore.bat] Clearing off security directory E:\NetApp\ocum\excel_report
2021-3-8 9:43:0,000 INFO  [Active IQ] [restore] [restore.bat] Removed all the existing excel reports successfully
2021-3-8 9:43:0,000 INFO  [Active IQ] [restore] [restore.bat] No Reports to restore
2021-3-8 9:43:0,000 INFO  [Active IQ] [restore] [restore.bat] Clearing off content of Jboss Server Onaro cert directory
Deleted file - E:\NetApp\essentials\jboss\server\onaro\cert\client.keystore
Deleted file - E:\NetApp\essentials\jboss\server\onaro\cert\server.keystore
Deleted file - E:\NetApp\essentials\jboss\server\onaro\cert\server.keystore.default
Deleted file - E:\NetApp\essentials\jboss\server\onaro\cert\server.truststore
Deleted file - E:\NetApp\essentials\jboss\server\onaro\cert\um.client.public.cert.e30636075e2842ca9196d410db83e5c4.pem
Deleted file - E:\NetApp\essentials\jboss\server\onaro\cert\um.client.public.private.pk12
2021-3-8 9:43:0,000 INFO  [Active IQ] [restore] [restore.bat] Removed all files in E:\NetApp\essentials\jboss\server\onaro\cert\ successfully
2021-3-8 9:43:1,000 INFO  [Active IQ] [restore] [restore.bat] Copying 'Jboss Onaro Cert Certificates' contents from 'E:\ProgramData\NetApp\OnCommandAppData\ocum\backup\UMrestore-3-8-2021-9-42-52\jboss_onaro_cert\*' to 'E:\NetApp\essentials\jboss\server\onaro\cert\'
2021-3-8 9:43:1,000 INFO  [Active IQ] [restore] [restore.bat] Restored Jboss Onaro Cert Certificates successfully
2021-3-8 9:43:1,000 INFO  [Active IQ] [restore] [restore.bat] Clearing off content of Au conf cert directory
Deleted file - E:\NetApp\essentials\au\conf\cert\client.keystore
2021-3-8 9:43:1,000 INFO  [Active IQ] [restore] [restore.bat] Removed all files in E:\NetApp\essentials\au\conf\cert\ successfully
2021-3-8 9:43:1,000 INFO  [Active IQ] [restore] [restore.bat] Copying 'Au Conf Certificates' contents from 'E:\ProgramData\NetApp\OnCommandAppData\ocum\backup\UMrestore-3-8-2021-9-42-52\au_conf_cert\*' to 'E:\NetApp\essentials\au\conf\cert\'
2021-3-8 9:43:2,000 INFO  [Active IQ] [restore] [restore.bat] Restored Au Conf Certificates successfully
2021-3-8 9:43:2,000 INFO  [Active IQ] [restore] [restore.bat] Clearing off content of Au conf preferences directory
Deleted file - E:\NetApp\essentials\au\conf\preferences\disable-zapis-default.txt
Deleted file - E:\NetApp\essentials\au\conf\preferences\disable-zapis-override.txt
Deleted file - E:\NetApp\essentials\au\conf\preferences\general.properties
Deleted file - E:\NetApp\essentials\au\conf\preferences\localEjbJndiNames.properties
Deleted file - E:\NetApp\essentials\au\conf\preferences\partial_poll_config.xml
Deleted file - E:\NetApp\essentials\au\conf\preferences\partial_poll_config.xsd
2021-3-8 9:43:2,000 INFO  [Active IQ] [restore] [restore.bat] Removed all files in E:\NetApp\essentials\au\conf\preferences\ successfully
2021-3-8 9:43:2,000 INFO  [Active IQ] [restore] [restore.bat] Copying 'Au Conf Preferences' contents from 'E:\ProgramData\NetApp\OnCommandAppData\ocum\backup\UMrestore-3-8-2021-9-42-52\au_conf_preferences\*' to 'E:\NetApp\essentials\au\conf\preferences\'
2021-3-8 9:43:3,000 INFO  [Active IQ] [restore] [restore.bat] Restored Au Conf Preferences successfully
processed file: E:\ProgramData\NetApp\OnCommandAppData\ocie\server.keystore
Successfully processed 1 files; Failed processing 0 files
2021-3-8 9:43:3,000 INFO  [Active IQ] [restore] [restore.bat] Successfully generated permission for file E:\ProgramData\NetApp\OnCommandAppData\ocie\server.keystore
2021-3-8 9:43:3,000 INFO  [Active IQ] [restore] [restore.bat] Copying 'Ocie keystore' contents from 'E:\ProgramData\NetApp\OnCommandAppData\ocum\backup\UMrestore-3-8-2021-9-42-52\data_dir_ocie\server.keystore' to 'E:\ProgramData\NetApp\OnCommandAppData\ocie\'
2021-3-8 9:43:4,000 INFO  [Active IQ] [restore] [restore.bat] Restored Ocie keystore successfully
processed file: E:\ProgramData\NetApp\OnCommandAppData\ocie\server.keystore
Successfully processed 1 files; Failed processing 0 files
2021-3-8 9:43:4,000 INFO  [Active IQ] [restore] [restore.bat] Successfully restored permissions of file E:\ProgramData\NetApp\OnCommandAppData\ocie\server.keystore
2021-3-8 9:43:4,000 INFO  [Active IQ] [restore] [restore.bat] Successfully deleted the file E:\NetApp\ocum\etc\ocum.conf
Deleted file - E:\NetApp\ocum\etc\ocum.conf
2021-3-8 9:43:4,000 INFO  [Active IQ] [restore] [restore.bat] Successfully deleted the file E:\ProgramData\NetApp\OnCommandAppData\ocum\backup\UMrestore-3-8-2021-9-42-52\custom_hostname
Deleted file - E:\ProgramData\NetApp\OnCommandAppData\ocum\backup\UMrestore-3-8-2021-9-42-52\custom_hostname
2021-3-8 9:43:5,000 INFO  [Active IQ] [restore] [restore.bat] Copying Application config properties to apply performance retention settings
2021-3-8 9:43:5,000 INFO  [Active IQ] [restore] [restore.bat] Successfully deleted the file E:\NetApp\ocum\etc\applicationConfig.properties
Deleted file - E:\NetApp\ocum\etc\applicationConfig.properties
2021-3-8 9:43:5,000 INFO  [Active IQ] [restore] [restore.bat] Copying 'Application config properties' contents from 'E:\ProgramData\NetApp\OnCommandAppData\ocum\backup\UMrestore-3-8-2021-9-42-52\applicationConfig.properties' to 'E:\NetApp\ocum\etc\'
2021-3-8 9:43:5,000 INFO  [Active IQ] [restore] [restore.bat] Restored Application config properties successfully
2021-3-8 9:43:5,000 INFO  [Active IQ] [restore] [restore.bat] Copied Application config properties successfully
2021-3-8 9:43:6,000 INFO  [Active IQ] [restore] [restore.bat] Copying server properties file
2021-3-8 9:43:6,000 INFO  [Active IQ] [restore] [restore.bat] Successfully deleted the file E:\NetApp\essentials\conf\server.properties
Deleted file - E:\NetApp\essentials\conf\server.properties
2021-3-8 9:43:6,000 INFO  [Active IQ] [restore] [restore.bat] Copying 'Server properties' contents from 'E:\ProgramData\NetApp\OnCommandAppData\ocum\backup\UMrestore-3-8-2021-9-42-52\essentials_conf\server.properties' to 'E:\NetApp\essentials\conf\'
2021-3-8 9:43:6,000 INFO  [Active IQ] [restore] [restore.bat] Restored Server properties successfully
2021-3-8 9:43:7,000 INFO  [Active IQ] [restore] [restore.bat] Copied server properties successfully
2021-3-8 9:43:7,000 INFO  [Active IQ] [restore] [restore.bat] Number of alert scripts to restore are 0
2021-3-8 9:43:7,000 INFO  [Active IQ] [restore] [restore.bat] Clearing off old plugin scripts
2021-3-8 9:43:7,000 INFO  [Active IQ] [restore] [restore.bat] Removed all the existing plugin scripts successfully
2021-3-8 9:43:8,000 INFO  [Active IQ] [restore] [restore.bat] No alert script plugins to restore
2021-3-8 9:43:8,000 INFO  [Active IQ] [restore] [restore.bat] Dropping netapp_performance
2021-3-8 9:43:8,000 INFO  [Active IQ] [restore] [restore.bat] Dropping opm
2021-3-8 9:43:9,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_full_backup_1613815200569.sql.7z to a temporary location
2021-3-8 9:44:19,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_full_backup_1613815200569.sql.7z successfully
2021-3-8 9:44:19,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1613901600047.sql.7z to a temporary location
2021-3-8 9:44:31,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1613901600047.sql.7z successfully
2021-3-8 9:44:31,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1613988000051.sql.7z to a temporary location
2021-3-8 9:44:44,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1613988000051.sql.7z successfully
2021-3-8 9:44:45,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614074400040.sql.7z to a temporary location
2021-3-8 9:44:57,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614074400040.sql.7z successfully
2021-3-8 9:44:58,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614160800055.sql.7z to a temporary location
2021-3-8 9:45:10,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614160800055.sql.7z successfully
2021-3-8 9:45:11,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614247200037.sql.7z to a temporary location
2021-3-8 9:45:21,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614247200037.sql.7z successfully
2021-3-8 9:45:23,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614333600032.sql.7z to a temporary location
2021-3-8 9:45:32,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614333600032.sql.7z successfully
2021-3-8 9:45:32,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614420000035.sql.7z to a temporary location
2021-3-8 9:45:43,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614420000035.sql.7z successfully
2021-3-8 9:45:43,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614506400030.sql.7z to a temporary location
2021-3-8 9:45:54,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614506400030.sql.7z successfully
2021-3-8 9:45:54,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614592800043.sql.7z to a temporary location
2021-3-8 9:46:7,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614592800043.sql.7z successfully
2021-3-8 9:46:7,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614679200047.sql.7z to a temporary location
2021-3-8 9:46:20,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614679200047.sql.7z successfully
2021-3-8 9:46:20,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614765600038.sql.7z to a temporary location
2021-3-8 9:46:32,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614765600038.sql.7z successfully
2021-3-8 9:46:32,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614852000050.sql.7z to a temporary location
2021-3-8 9:46:45,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614852000050.sql.7z successfully
2021-3-8 9:46:45,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614938400047.sql.7z to a temporary location
2021-3-8 9:46:56,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1614938400047.sql.7z successfully
2021-3-8 9:46:56,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1615024800034.sql.7z to a temporary location
2021-3-8 9:47:8,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1615024800034.sql.7z successfully
2021-3-8 9:47:8,000 INFO  [Active IQ] [restore] [restore.bat] Extracting the database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1615111200037.sql.7z to a temporary location
2021-3-8 9:47:19,000 INFO  [Active IQ] [restore] [restore.bat] Extracted database dump repository file c:\Scripts\database_dumps_repo\ocum_mysql_incremental_backup_1615111200037.sql.7z successfully
2021-3-8 9:47:20,000 INFO  [Active IQ] [restore] [restore.bat] Combining all backup files into one file:
2021-3-8 9:53:25,000 INFO  [Active IQ] [restore] [restore.bat] Running mysql dump command
2021-3-8 15:41:27,000 INFO  [Active IQ] [restore] [restore.bat] Restored mysql dumps successfully
2021-3-8 15:41:28,000 INFO  [Active IQ] [restore] [restore.bat] Running mysql flushPrivileges command
2021-3-8 15:41:28,000 INFO  [Active IQ] [restore] [restore.bat] Successfully flushed Privileges
2021-3-8 15:41:28,000 INFO  [Active IQ] [restore] [restore.bat] Going to start Active IQ Unified Manager
2021-3-8 15:41:29,000 INFO  [Active IQ] [restore] [restore.bat] Starting service ocie-au
2021-3-8 15:41:54,000 INFO  [Active IQ] [restore] [restore.bat] Service ONCOMMANDSVC is already running
2021-3-8 15:41:55,000 INFO  [Active IQ] [restore] [restore.bat] Resetting binary logs after restore
ERROR 1045 (28000): Access denied for user 'jboss'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'jboss'@'localhost' (using password: YES)
2021-3-8 15:41:55,000 INFO  [Active IQ] [restore] [restore.bat] Restore process took 05:59:01 (hours:minutes:seconds)
2021-3-8 15:41:55,000 INFO  [Active IQ] [restore] [restore.bat] Clearing the directory E:\ProgramData\NetApp\OnCommandAppData\ocum\backup\UMrestore-3-8-2021-9-42-52
2021-3-8 15:41:57,000 INFO  [Active IQ] [restore] [restore.bat] Deleting the directory E:\ProgramData\NetApp\OnCommandAppData\ocum\backup\UMrestore-3-8-2021-9-42-52
2021-3-8 15:41:57,000 INFO  [Active IQ] [restore] [restore.bat] Sucessfully deleted the backup extract folder
2021-3-8 15:41:58,000 INFO  [Active IQ] [restore] [restore.bat] Clearing the log files by retaining only 5 latest log files
2021-3-8 15:41:58,000 INFO  [Active IQ] [restore] [restore.bat] Successfully cleared the Active IQ Unified Manager log files
2021-3-8 15:41:58,000 INFO  [Active IQ] [restore] [restore.bat] Restore operation succeeded

E:\NetApp\ocum\bin>

OCUM seems to work fine ... But I'm still worried about this warning indicating UNIX backup would be different from Windows Backup ...

[POLICARD]

ActiveIQ is working but I cannot connect anymore using root account or jboss login-path ...

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql.exe -uroot -p
Enter password: ******************
ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql.exe --login-path=jboss
ERROR 1045 (28000): Access denied for user 'jboss'@'localhost' (using password: YES)

[jacoba · Accepted solution]

Hi,

We do not support cross-platform migration. As per the documentation, the restore feature is platform-specific and version-specific. You can restore a Unified Manager backup only on the same version of Unified Manager. You can restore a Linux backup file or a virtual appliance backup file to a Red Hat Enterprise Linux or CentOS system.

Please refer to the documentation here

Thanks and Regards,

Jacob