Error occurred while checking database connection - ESMC 7.2.2236.0 installation on Debian Buster

[merentitis 0]

I followed the exact instructions for Debian Linux.

mysql  Ver 8.0.22 for Linux on x86_64 (MySQL Community Server - GPL)

odbcinst.ini created by debian package installer:

[MySQL ODBC 8.0 Unicode Driver]
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so
UsageCount=1

[MySQL ODBC 8.0 ANSI Driver]
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8a.so
UsageCount=1

 

dpkg -l | grep -i connector-odbc
ii  mysql-connector-odbc:amd64        8.0.22-1debian10             amd64        MySQL ODBC driver

added the following lines on my cnf:

[mysqld]
max_allowed_packet=33M
log_bin_trust_function_creators=1

Installer log:

2020-10-21 10:39:10 Information: Installer: Initializing logging to file /var/log/eset/RemoteAdministrator/EraServerInstaller.log
2020-10-21 10:39:10 Information: Installer: Parsing arguments.
2020-10-21 10:39:10 Information: Installer: Verifing arguments.
2020-10-21 10:39:10 Information: Installer: Starting install sequence.
2020-10-21 10:39:10 Information: Installer: Extracting archive to /tmp/tmp.WSEBxYOZvE
2020-10-21 10:39:12 Information: Installer: Archive extracted to /tmp/tmp.WSEBxYOZvE.
2020-10-21 10:39:12 Information: Installer: Checking OpenSSL ...
2020-10-21 10:39:12 Information: DepCheckOpenSSL: Action invoked with: 
2020-10-21 10:39:12 Information: DepCheckOpenSSL: Set output property: P_OPENSSL_VERSION = OpenSSL 1.1.1d  10 Sep 2019
2020-10-21 10:39:12 Information: DepCheckOpenSSL: Return code: 0
2020-10-21 10:39:12 Information: Installer: Found: OpenSSL 1.1.1d 10 Sep 2019
2020-10-21 10:39:12 Information: Installer: Reading previous installation settings ...
2020-10-21 10:39:12 Information: LoadInstalledData: Action invoked with:  --current-version 7.2.2236.0 --db-connectors-dir /tmp/tmp.WSEBxYOZvE/setup --db-driver MySQL ODBC 8.0 Unicode Driver --db-hostname 127.0.0.1 --db-name era_db --db-port 3306 --db-type MySQL Server --db-user-password ********** --db-user-username ********** --modules-dir /var/opt/eset/RemoteAdministrator/Server/Modules/ --product-guid "" --product-name Server --startup-config-path /etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini
2020-10-21 10:39:12 Error: LoadInstalledData: locale::facet::_S_create_c_locale name not valid
2020-10-21 10:39:12 Information: Installer: Failed reading previous installation settings.
2020-10-21 10:39:12 Information: Installer: Checking installed version...
2020-10-21 10:39:12 Information: CheckVersion: Action invoked with:  --current-version 7.2.2236.0 --installed-version ""
2020-10-21 10:39:12 Information: Product is not installed
2020-10-21 10:39:12 Information: CheckVersion: Set output property: P_VERSION_STATUS = NEW
2020-10-21 10:39:12 Information: CheckVersion: Return code: 0
2020-10-21 10:39:12 Information: Installer: Checking of installed version was successful
2020-10-21 10:39:12 Information: Installer: Status of current installation is: NEW
2020-10-21 10:39:12 Information: Installer: Checking database connection ...
2020-10-21 10:39:12 Information: DbCheckConnection: Action invoked with:  --current-version 7.2.2236.0 --db-admin-password ********** --db-admin-username ********** --db-connectors-dir /tmp/tmp.WSEBxYOZvE/setup --db-driver MySQL ODBC 8.0 Unicode Driver --db-hostname 127.0.0.1 --db-name era_db --db-port 3306 --db-scripts-dir /tmp/tmp.WSEBxYOZvE/setup/Database/ --db-type MySQL Server --db-user-password ********** --db-user-username ********** --installed "" --modules-dir /var/opt/eset/RemoteAdministrator/Server/Modules/ --product-name Server --silent-reinstall "" --upgrade ""
2020-10-21 10:39:12 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS = 
2020-10-21 10:39:12 Information: DbCheckConnection: Set output property: P_DB_STATUS = 
2020-10-21 10:39:12 Information: DbCheckConnection: Set output property: P_DB_UPGRADE = 
2020-10-21 10:39:12 Information: DbCheckConnection: Set output property: P_DB_USE_FIRST_USER = 
2020-10-21 10:39:12 Information: DbCheckConnection: Set output property: P_DB_PORT = 3306
2020-10-21 10:39:12 Information: GetDatabaseServerConnectionStringWithoutEscape: Created connection string: 'Driver=MySQL ODBC 8.0 Unicode Driver;Server=127.0.0.1;Port=3306;User=******;Password={******};CharSet=utf8;NO_LOCALE=1;NO_SSPS=1;'
2020-10-21 10:39:12 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOptions)
2020-10-21 10:39:12 Information: Installer: Failed checking database connection.
2020-10-21 10:39:12 Information: Installer: Error: : Error occurred while checking database connection

[Marcos 5,074]

MySQL 8.0.22 is not supported according to https://help.eset.com/esmc_install/72/en-US/database_requirements.html

[merentitis 0]

Right, thank you. Installed 8.0.17 and worked.