Jump to content

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


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

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
Link to comment
Share on other sites

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"

 

Link to comment
Share on other sites

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. 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

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