We are in the process of preparing a KB with instructions how to address login issues caused by PROTECT server restarts under heavy server load:
1. stop the PROTECT Server service
systemctl stop eraserver
check if the service has been stopped
systemctl status eraserver
2. install the MariaDB ODBC driver
yum install mariadb-connector-odbc
check if the driver has been correctly installed
yum list installed | grep mariadb
mariadb-connector-c.x86_64 3.2.6-1.el9_0 @appstream
mariadb-connector-odbc.x86_64 3.1.12-3.el9 @appstream
3. check the alias of the ODBC driver and search for the following section:
less /etc/odbcinst.ini
[MariaDB]
Description=ODBC for MariaDB
Driver=/usr/lib/libmaodbc.so
Driver64=/usr/lib64/libmaodbc.so
FileUsage=1
verify if such file is present
ls -la /usr/lib64 | grep -I libmaod*
-rwxr-xr-x. 1 root root 326688 May 25 2022 libmaodbc.so
4. modify the "StartupConfiguration.ini" - replace the "MySQL ODBC 8.3 Unicode Driver" with "MariaDB" so the final configuration file will look like follows:
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;
5. start the PROTECT server service
systemctl start eraserver
