Jump to content

[Linux] Upgrade from version 6.4


Recommended Posts

Hi,

I need to upgrade from version 6.4 (sic) of ERA to PROTECT 9.whateveristhelatest.
Yes, i know, 6.4 is *very* old.
The most important target in my list are:
1) don't touch the client (don't reinstall etc)
2) stay on Debian

I was following this procedure:
1) upgrade the OS from Debian Jessie to Debian Buster (i would have liked Bullseye, but is not supported)
2) upgrade the DB from mysql 5.5 to 5.7, from 5.7 to 8.0 (mysql repo)
3) install MySQL ODBC 8.0.17 (as it is the latest supported)

I have an error during the DB upgrade, from version 7.1.1.7 to 7.1.1.8 of the DB (all before that is OK), see at the bottom of the post.

Despite the error, i've seen that the upgrade to 6.5 is "preferable" (even if, seems to me not really necessary).
Or at least, it can help me out with the support.

Very important note:
I can rollback to the previous VM state (as i have made a copy of it).

Questions:
1) Are the binaries for 6.5 available somewhere? especially server-linux-x86_64.sh
2) is the upgrade supported, as i can see from https://help.eset.com/protect_install/91/en-US/upgrade_procedures.html?upgrade_from_era6.html ?
3) how can i fix the error below?
4) is there any suggestion that i can follow to have the upgrade performed as by my above list?

Thank you very much,

Daniel (he/him)

 

2022-08-09 16:01:28 Information: UpgradeDatabase: Processing file /tmp/tmp.HlC2LiKIXJ/setup/Database/MySQL/UpgradeScripts/7117_7118.sql
2022-08-09 16:01:28 Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseWrapper::UpgradeDatabase(const string&, const string&, const string&, const string&)
2022-08-09 16:01:28 Error: Statement execution failed. Code: 1146. Error: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.30]Table 'era_db.tblf_task_server_status' doesn't exist. File: /tmp/tmp.HlC2LiKIXJ/setup/Database/MySQL/UpgradeScripts/7117_7118.sql. Statement: DELETE
FROM `tblf_task_server_status`
WHERE `TaskId` IN
       (SELECT `task_uuid`
        FROM `tbl_automation_server_tasks`
        WHERE `task_type`      = 7             /* notifications */
               OR `task_type`  = 8             /* internal licence sync task */
               OR `removed`    = 1)            /* already removed server tasks */
OR `TaskId` NOT IN
       (SELECT `task_uuid`
        FROM `tbl_automation_server_tasks`);
2022-08-09 16:01:28 Error: DbUpgrade: Statement execution failed. Code: 1146. Error: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.30]Table 'era_db.tblf_task_server_status' doesn't exist. File: /tmp/tmp.HlC2LiKIXJ/setup/Database/MySQL/UpgradeScripts/7117_7118.sql. Statement: DELETE
FROM `tblf_task_server_status`
WHERE `TaskId` IN
       (SELECT `task_uuid`
        FROM `tbl_automation_server_tasks`
        WHERE `task_type`      = 7             /* notifications */
               OR `task_type`  = 8             /* internal licence sync task */
               OR `removed`    = 1)            /* already removed server tasks */
OR `TaskId` NOT IN
       (SELECT `task_uuid`
        FROM `tbl_automation_server_tasks`);
2022-08-09 16:01:28 Information: Installer: Failed upgrading database.
2022-08-09 16:01:28 Information: Installer: Error: : Error occurred while upgrading database

 

Link to comment
Share on other sites

Thanks Marcos,

So a clean installation is not the right way, as i would lose the clients

The migration of the DB instead have written:

When migrating a database, you must migrate between instances of the same ESET PROTECT version. See our Knowledgebase article for instructions to determine the versions of your ESET PROTECT components. After completing database migration, you can perform an upgrade, if necessary, to get the latest version of ESET PROTECT.

 

Do you confirm that i shall proceed with the old 6.4 DB on 9.1 protect?

 

Thanks,

Daniele

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...