Daniele Palumbo 0 Posted August 9, 2022 Share Posted August 9, 2022 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 More sharing options...
Administrators Marcos 5,281 Posted August 10, 2022 Administrators Share Posted August 10, 2022 I would recommend following the instructions for migrating the database: https://help.eset.com/protect_install/91/en-US/migration_same_version.html?migrated_database_same_ip.html Link to comment Share on other sites More sharing options...
Daniele Palumbo 0 Posted August 10, 2022 Author Share Posted August 10, 2022 Thanks Marcos, https://help.eset.com/protect_install/91/en-US/clean_installation_same_ip.html Or https://help.eset.com/protect_install/91/en-US/migrated_database_same_ip.html ? Thanks, Daniele Link to comment Share on other sites More sharing options...
Daniele Palumbo 0 Posted August 10, 2022 Author Share Posted August 10, 2022 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 More sharing options...
Recommended Posts