Upgrade ERA 6.5 to EMCS 7.0

[Emiel Wieldraaijer 1]

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

[Marcos 5,074]

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.

[Emiel Wieldraaijer 1]

So you are saying the Hyper-V Virtual Appliance hosted by Eset contains the wrong version 

[MartinK 378]

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.

[Emiel Wieldraaijer 1]

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

[Emiel Wieldraaijer 1]

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?

[Emiel Wieldraaijer 1]

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?

 

[MartinK 378]

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.

[Emiel Wieldraaijer 1]

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

 

 

[MartinK 378]

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.

[Emiel Wieldraaijer 1]

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.

 

[MartinK 378]

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

[Emiel Wieldraaijer 1]

Hi MartinK,

I've contacted the Dutch Support and they resolved the problem, database was repaired. 

 

Best regards,

 

Emiel Wieldraaijer

[Peter Randziak 1,130]

Hello Emiel,

glad to hear that, thank you for keeping us posted.

P.R.