July 28, 2020, 1:50 p.m.
IT

ESET SMC 7.1 Not Upgrading

I have a client with ESET Security Management Center 7.1 installed and try to upgrade to 7.2 using the Upgrade task within the web console. That failed with no reason. So I tried downloading the installer and upgrading it that way, but it still failed.

In the log file of the installer I saw that when it was connecting to the database it complained that the ODBC string did not contain the database name (no MySQL database selected). After lots of probing (the console worked, it had a valid connection to the DB) I decided to take the DSN in startupconfiguration.ini and change it from:

DatabaseConnectionString=Driver=MySQL ODBC 5.3 Unicode Driver;Server=SERVER;Port=3306;User=USER; ↩
  Password=PASSWORD;CharSet=utf8;NO_LOCALE=1;Database=era_db 

to

DatabaseConnectionString=Driver=MySQL ODBC 5.3 Unicode Driver;Database=era_db;Server=SERVER;Port=3306; ↩
  User=USER;Password=PASSWORD;CharSet=utf8;NO_LOCALE=1

And restarted the upgrade. It worked. WTF? The MySQL DB did not change, nor did the ODBC driver.