Jump to content

Recommended Posts

  • Marcos changed the title to I migrated VA from CentoS to Rocky Linux, however the virtual machine starts but I have an error in the database
  • Administrators
Posted

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
Posted

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"

 

Posted

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. 

Posted
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. 

image.thumb.png.b0c5f4290a84efff68c3815e9842891b.png

Posted
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 :image.thumb.png.ae836e4e27f22056c06c9517a3cdc4d1.png

image.png.4afddff3f1ae262011cb0d069e281826.png

How to i can restore my server ?

 

image.png

Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...