[KB8654] ESET PROTECT Virtual Appliance is crashing on Rocky Linux

Issue

  • ESET PROTECT Virtual Appliance (VA) is crashing on Rocky Linux

Details


Click to expand

ESET PROTECT Server service running on Rocky Linux based Virtual Appliance keeps restarting due to the hang of the service and automatic restart triggered by the system. This is caused by the Open Database Connectivity (ODBC) driver. All supported ODBC drivers are affected (for example, versions 8.1, 8.2 or 8.3).


Solution

You need to change the ODBC driver. In this example, we change the driver to MariaDB ODBC driver.

  1. Stop the ESET PROTECT Server service. In Terminal, run the command:

    systemctl stop eraserver
  2. Check if the service has been stopped:

    systemctl status eraserver
  3. Install the MariaDB ODBC driver:

    yum install mariadb-connector-odbc
  4. Check the alias of the ODBC driver:

    less /etc/odbcinst.ini

    Search for the following section:

    [MariaDB]
    Description=ODBC for MariaDB
    Driver=/usr/lib/libmaodbc.so
    Driver64=/usr/lib64/libmaodbc.so
    FileUsage=1
  5. Verify if such a file is present:

    ls -la /usr/lib64 | grep -I libmaod*

    The result should be:

    -rwxr-xr-x.  1 root root    326688 May 25  2022 libmaodbc.so
  6. Replace the MySQL ODBC 8.3 Unicode Driver with MariaDB in the StartupConfiguration.ini file. The configuration should look like this:

    vi /etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini
    DatabaseType=MySqlOdbc
    DatabaseConnectionString=Driver=MariaDB;Server=127.0.0.1;Port=****;User=***;Password={****};CharSet=utf8;NO_LOCALE=1;NO_SSPS=1;Database=era_db;
  7. Start the ESET PROTECT Server service again:

    systemctl start eraserver