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.
-
Stop the ESET PROTECT Server service. In Terminal, run the command:
systemctl stop eraserver
-
Check if the service has been stopped:
systemctl status eraserver
-
Install the MariaDB ODBC driver:
yum install mariadb-connector-odbc
-
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
-
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
-
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;
-
Start the ESET PROTECT Server service again:
systemctl start eraserver