uograde IMC 7.3 on new server RedHAT / MySQL 8.0

[nonozi]

Hello

Actually i have in production a iMC 7.3 E0504 on MysqL 5.6 and RH 5.5. We plan to update all components on this server :

RH 7.9

MySQL 8.0

IMC 7.3 E0604

Have you got some recommendations concerning update procedure ?

Now i was able to install a new server (RH7.9 MySQL 8.0 IMC 7.3 E0604), a mysqldump on the old database to the newest is ok ?

Thanks

Arnaud

[jguse]

Hello,

Please do not use the database tools like mysqldump for migrations. iMC consists of both a filesystem and a database - and if you restore only the database on the new system, your iMC will not work, as config files and more are not present. Additionally it is not possible to restore from one iMC version to another - the source and destination system versions must match exactly. If you theoretically did this anyway (with mysqldump), then iMC will either not work, or you will encounter some strange 'bugs' due to the version mismatch.

The things I mentioned above are what the built-in DBMAN tool in iMC takes care of. It ensures you do not restore onto a different version and also backs up and restores the filesystem for you. Make sure you use it for migrations!

For the procedure I would recommend checking the official Linux migration guide:

https://support.hpe.com/hpesc/public/docDisplay?docLocale=en_US&docId=a00075554en_us

Note that you can restore from older MySQL onto a newer one, but not vice versa. The upgrade of database version should take place automatically upon restore.

[nonozi]

Hello

I try the procedure, by installing my old IMC version E0504 on my new redhat 7.9 in MySQL 8.0 before restore and upgrade IMC but, with my old version of IMC 7.3, I have an error message when connecting the database at the installation.

A beginning, when i have installed the E0705 I also had this error which had been resolved by putting the default-time-zone in Mysql.

It's not work here with E0504.

Do you have any ideas ?

Thanks

Regards

Arnaud

[jguse · Accepted solution]

Hello,

That is most likely due to E0504 not supporting MySQL 8.0 yet - 7.3 E0705 is the first version to support it, but it no longer supports older RHEL before 7.x. Considering this, and that you are going from an old RHEL and MySQL system to a much newer one, it looks like you will need to migrate twice. It would look like this:

1. Upgrade your old iMC installation to E0605 version, as that still supports RHEL 5.5.

2. Set up a temporary system with RHEL 7.x and MySQL 5.6 running iMC 7.3 E0605, and migrate to this system.

3. Upgrade the temporary system from 7.3 E0605 to E0705. Now MySQL 8.0 is supported.

4. Make sure your final system has iMC 7.3 E0705 running with MySQL 8.0, and migrate from the temporary system. MySQL should upgrade the DBs as needed during the restore.

Hope that makes sense. Let me know if you have any questions.

[nonozi]

Thanks for your help but to many problem with this operations. unable to upgrade IMC version  on the old server (incompatible components for an update for E0504 PLAT and E0502 NTA)  and unable to install the old version on my new RedHat 7.9 (jvm.so ELF OS ABI invalid).

I abandon my updating projet for IMC and RedHat.

I have open another post because i need to do a technical operation on disk but i still have another problem with licencing...

Thanks for your help.