Problem to change the ERE/ESMC administrator password

[Qmarsm 0]

Hi everyone,

I have to change the Native Administrator password of ESMC installation. When I logging into Webmin (root) and I go through the appropriate menu to change the pass or add my new CA, I see this error:

Output from command ..

stty: standard input: Inappropriate ioctl for device

ESET Security Management Center Server Installer (version: 7.1.503.0), Copyright © 1992-2019 ESET, spol. s r.o. - All rights reserved.

Extracting archive, please wait...
Archive extracted to /tmp/tmp.3ha91q9Z8w.
Checking OpenSSL ... done [OpenSSL 1.0.2k-fips 26 Jan 2017]
Reading previous installation settings ... done
Checking installed version... done
Status of current installation is: REPAIR
Checking database connection ... failure

Error: An error occurred while trying to connect to the database. Error code: (2002). Unable to continue.

 

I attached all the info of my installation.

Please help me.

thanx

[Marcos 5,070]

Please check the version of the MySQL ODBC driver:

https://help.eset.com/esmc_install/72/en-US/database_requirements.html

MySQL ODBC driver versions 5.3.11 and later, 8.0.0 – 8.0.15 and 8.0.18 and later are not supported.

[Qmars 0]

Hi, I check it and MySQL ODBC driver versions 5.3.10

[MartinK 378]

Seems that problem is that ESMC is configured to connect to database with hostnane "localhost" which causes problem as in this case, ODBC driver is actually trying to use local file sockets instead of TCP connection. Could you please provide more details of environment used? Is it ESMC Appliance? And if so, what was the initial version that was deployed?

To confirm, I would recommend to manually modify file:

/etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini

so that it contains: Server=127.0.0.1 instead of Server=localhost.

In case system has enabled SELinux protection, it might be required to run also command:

/sbin/restorecon -F -R -v /etc/opt/eset/RemoteAdministrator/Server

to correct configuration after manuall changes.