Jump to content

Recommended Posts

Posted

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

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

  • ESET Staff
Posted

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.

Posted (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 by Emiel Wieldraaijer
Complete Error
Posted

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?

Posted

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?

 

  • ESET Staff
Posted

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

Posted

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.

 

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

  • 2 weeks later...
Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

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