Jump to content

Upgrade ERA 6.5 to EMCS 7.0


Emiel Wieldraaijer
 Share

Recommended Posts

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

  • Administrators
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

  • ESET Staff

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

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 by Emiel Wieldraaijer
Complete Error
Link to comment
Share on other sites

  • ESET Staff

There seems to be some problem when running DB upgrade and new installation in one step.

I would recommend to:

  1. create backup of original ERA 6.5 appliance
  2. 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.
  3. 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

  • ESET Staff
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

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

  • ESET Staff
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

  • 2 weeks later...
Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

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