Emiel Wieldraaijer 1 Posted February 19, 2019 Share Posted February 19, 2019 Hi All, I'm trying to upgrade my ERA 6.5 VA to EMC 7.0 VA Pulling the database from remote server works, but i get an error 2564 while upgrading the database. Error: 2564: Error Occured while upgrading database /Root/eset_installers/Server.sh --skip-license --local='en-US' --db-driver='MySQL ODBC 8.0 Unicode Driver' --db-hostname=127.0.0.1 I found something about reverting back the ODBC driver, does this also apply to EMC 7.0 or only to ERA 6.5 Thanks Best regards, Emiel Wieldraaijer Link to comment Share on other sites More sharing options...
Administrators Marcos 5,238 Posted February 19, 2019 Administrators Share Posted February 19, 2019 1 hour ago, Emiel Wieldraaijer said: Error: 2564: Error Occured while upgrading database /Root/eset_installers/Server.sh --skip-license --local='en-US' --db-driver='MySQL ODBC 8.0 Unicode Driver' --db-hostname=127.0.0.1 I found something about reverting back the ODBC driver, does this also apply to EMC 7.0 or only to ERA 6.5 It applies to both. Regarding MySQL ODBC v8 driver, currently only version 8.0.11-e17 is compatible as stated at https://help.eset.com/esmc_install/70/en-US/odbc_configuration.html. Link to comment Share on other sites More sharing options...
Emiel Wieldraaijer 1 Posted February 19, 2019 Author Share Posted February 19, 2019 So you are saying the Hyper-V Virtual Appliance hosted by Eset contains the wrong version Link to comment Share on other sites More sharing options...
ESET Staff MartinK 383 Posted February 19, 2019 ESET Staff Share Posted February 19, 2019 Could you provide more details of what steps you are using to upgrade? Migration steps are described in documentation - did you follow them? In case you downloaded latest appliance, there should be compatible ODBC driver installed. Also I would recommend to check installer log (/var/log/eset/RemoteAdministrator/EraServerInstaller.log) for more precise error: trace message as provided by ODBC driver should be available there. Link to comment Share on other sites More sharing options...
Emiel Wieldraaijer 1 Posted February 19, 2019 Author Share Posted February 19, 2019 (edited) Yes i have used the documentation - Start the VA and don't configure - Pull the Database and the database restores - Connect to IP and configure 2019-02-21 22:34:54 Error: Statement execution failed. Code: 1305. Error: [MySQL][ODBC 8.0(w) Driver][mysqld-5.6.40]PROCEDURE era_db.usp_authentication_update_predefined_log_types does not exist. File: /tmp/tmp.EzbznxAKCk/setup/Database/MySQL/SetupScripts/Upgrade/2_do_upgrade.sql. Statement: ERA_EXECUTE StoreStaticObjectPresets 0x656e2d5553, 0x31, 0x37303232, 0x37303232, 0x536572766572, 0x2f746d702f746d702e457a627a6e78414b436b2f73657475702f4d6f64756c65732f, 0x2f746d702f746d702e457a627a6e78414b436b2f7365747570, 0x4472697665723d4d7953514c204f44424320382e3020556e69636f6465204472697665723b5365727665723d3132372e302e302e313b506f72743d333330363b557365723d6572613b50617373776f72643d7b4c6a705730426355784c664170514e6d78364258527674423147356e456a5a787d3b436861725365743d757466383b4e4f5f4c4f43414c453d313b44617461626173653d6572615f64623b, 0x372e302e3437312e30, 0x4d7953514c20536572766572; 2019-02-21 22:34:54 Error: DbUpgrade: Statement execution failed. Code: 1305. Error: [MySQL][ODBC 8.0(w) Driver][mysqld-5.6.40]PROCEDURE era_db.usp_authentication_update_predefined_log_types does not exist. File: /tmp/tmp.EzbznxAKCk/setup/Database/MySQL/SetupScripts/Upgrade/2_do_upgrade.sql. Statement: ERA_EXECUTE StoreStaticObjectPresets 0x656e2d5553, 0x31, 0x37303232, 0x37303232, 0x536572766572, 0x2f746d702f746d702e457a627a6e78414b436b2f73657475702f4d6f64756c65732f, 0x2f746d702f746d702e457a627a6e78414b436b2f7365747570, 0x4472697665723d4d7953514c204f44424320382e3020556e69636f6465204472697665723b5365727665723d3132372e302e302e313b506f72743d333330363b557365723d6572613b50617373776f72643d7b4c6a705730426355784c664170514e6d78364258527674423147356e456a5a787d3b436861725365743d757466383b4e4f5f4c4f43414c453d313b44617461626173653d6572615f64623b, 0x372e302e3437312e30, 0x4d7953514c20536572766572; 2019-02-21 22:34:54 Information: Installer: Failed upgrading database. 2019-02-21 22:34:54 Information: Installer: Error: 2564: Error occurred while upgrading database Edited February 21, 2019 by Emiel Wieldraaijer Complete Error Link to comment Share on other sites More sharing options...
Emiel Wieldraaijer 1 Posted February 21, 2019 Author Share Posted February 21, 2019 Looks like a table is missing from the Era Database isp_authentication_update_predefined_log_types ! Does anyone have a clue? is there a manual procedure to update the database? Link to comment Share on other sites More sharing options...
Emiel Wieldraaijer 1 Posted February 22, 2019 Author Share Posted February 22, 2019 I downloaded the VA again and tried again still no luck Imported the backup into a standalone MySQL server and no error found. Isn't there anyone who can help? Link to comment Share on other sites More sharing options...
ESET Staff MartinK 383 Posted February 23, 2019 ESET Staff Share Posted February 23, 2019 There seems to be some problem when running DB upgrade and new installation in one step. I would recommend to: create backup of original ERA 6.5 appliance upgrade ERA/ESMC components in original appliance. Components upgrade task can be used for this. Once finished, you will have old appliance with new version of ESMC components. migrate already upgraded ESMC from old appliance to new appliance. As ESMC server will be already on latest version, there won't be any need to do DB upgrade and procedure should be successful. Link to comment Share on other sites More sharing options...
Emiel Wieldraaijer 1 Posted February 24, 2019 Author Share Posted February 24, 2019 Can you tell me which of the following links is the right way? https://support.eset.com/kb3668/ https://support.eset.com/kb6819/ https://support.eset.com/kb6734/?intcmp="KBCJ_3668_Linuxupgrade" Thanks Best regards Emiel Wieldraaijer Link to comment Share on other sites More sharing options...
ESET Staff MartinK 383 Posted February 25, 2019 ESET Staff Share Posted February 25, 2019 11 hours ago, Emiel Wieldraaijer said: Can you tell me which of the following links is the right way? https://support.eset.com/kb3668/ https://support.eset.com/kb6819/ https://support.eset.com/kb6734/?intcmp="KBCJ_3668_Linuxupgrade" Thanks Best regards Emiel Wieldraaijer I would recommend to follow https://support.eset.com/kb6819/ except final check of upgrade check which is platform-specific. You can also check documentation for components upgrade task. Link to comment Share on other sites More sharing options...
Emiel Wieldraaijer 1 Posted February 25, 2019 Author Share Posted February 25, 2019 Also a manual update reports the same database error Could the following be causing the problem, The Agent on the Virtual Appliance is version 7 and the server is version 6.5. Lookes like i made a mistake with updating, I tried removing the Agent and install the 6.5 agent but i cannot downgrade. Link to comment Share on other sites More sharing options...
ESET Staff MartinK 383 Posted February 25, 2019 ESET Staff Share Posted February 25, 2019 24 minutes ago, Emiel Wieldraaijer said: Also a manual update reports the same database error Could the following be causing the problem, The Agent on the Virtual Appliance is version 7 and the server is version 6.5. Lookes like i made a mistake with updating, I tried removing the Agent and install the 6.5 agent but i cannot downgrade. I would recommend to contact ESET support in your country. Seems there is something wrong with database and it will most probably require more advanced analysis. Regarding AGENT versions, that is definitely not reason for ESMC Server upgrade failure, but be aware that 7.0 Agent won't connect to 6.5 Server Link to comment Share on other sites More sharing options...
Emiel Wieldraaijer 1 Posted March 12, 2019 Author Share Posted March 12, 2019 Hi MartinK, I've contacted the Dutch Support and they resolved the problem, database was repaired. Best regards, Emiel Wieldraaijer Peter Randziak 1 Link to comment Share on other sites More sharing options...
ESET Moderators Peter Randziak 1,160 Posted March 13, 2019 ESET Moderators Share Posted March 13, 2019 Hello Emiel, glad to hear that, thank you for keeping us posted. P.R. Link to comment Share on other sites More sharing options...
Recommended Posts