Error During Silent Upgrade on Windows with MariaDB

Applies to: Ephesoft Transact 2019.2 and above

Issue

When performing a silent upgrade from version 2019.2 or above to a later version, your upgrade may fail with the following error:

Exception occurred while executing script in database.MySql.Data.MySqlClient.MySqlException (0x80004005): Access denied for user <username>

Workaround

To prevent this issue from occurring, perform the following steps for each node of a Transact environment cluster:

  1. Prepare for the upgrade by following the prerequisites in the upgrade guide for your version.
  2. Navigate to [Ephesoft_Directory]\Dependencies\mariadb\MariaDBSetup.
  3. Rename the following files, if they are present:
Old File Name New File Name
local_mariadb_config.bat ephesoft-mariadb-setup.bat
remote_mariadb_config.bat local-ephesoft-mariadb-setup.bat
upgrade_mariadb_config.bat upgrade-ephesoft-mariadb-setup.bat
  1. Perform the silent upgrade as normal.
  2. Refer to the License and Launch section of your upgrade guide to verify the upgrade was successful.