I migrated VA from CentoS to Rocky Linux, however the virtual machine starts but I have an error in the database

[JonathanGA 0]

[Marcos 5,267]

Since this is an English forum, we kindly ask you to post in English.

Please carry on as follows to resolve the issue:

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

[CNNS 0]

Might be Off-Topic but the provided Steps from Marcos also helped to get the Webconsole Login working again after an OS-Update of the Rocky VA.

Error Message upon Login was:

Login failed: Connection has failed with state "loginConnectionStateNotConnected"

 

[VlP 0]

I have same problem with upgrade via database pull from ESET VA 10.0 to 11...

None of above put appliance at work, because eraserver is not installed, so config file /etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini doesn't exist. 

[eornate 4]

On 5/2/2024 at 6:59 PM, CNNS said:

Might be Off-Topic but the provided Steps from Marcos also helped to get the Webconsole Login working again after an OS-Update of the Rocky VA.

Error Message upon Login was:

Login failed: Connection has failed with state "loginConnectionStateNotConnected"

 

I have the same issue after done those steps from Marcos.Now i can not log in the webconsole. 

[eornate 4]

On 5/2/2024 at 12:00 AM, Marcos said:

Since this is an English forum, we kindly ask you to post in English.

Please carry on as follows to resolve the issue:

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

Hi @Marcos, i tried to deploy again with this VM ( i snapshot this VM and backup database before) but it was not successful and appear the error :

How to i can restore my server ?