Problem install ESMC on Ubuntu 18.04

[Martin25B93 1]

Hello. I have this problem I can't install ESMC server on ubuntu 18.04. I have MYSQL 5.7.29 and ODBC 5.3.10 both are supported (I tried also 5.2.7 still same story). Maybe because I have on server MYSQL -> password policy and ESMC installer can't take a difficult password (In that password are this symbols ",%")?

Or what do you suggests?  Thank you for help!

 

Extracting archive, please wait...
Archive extracted to /tmp/tmp.lgJUYYy9xA.
Checking OpenSSL ... done [OpenSSL 1.0.2n 7 Dec 2017]
Reading previous installation settings ... failure
Checking installed version... done
Status of current installation is: NEW
Checking database connection ... failure

Error: The database server is not configured correctly. Please check the documentation and reconfigure the database server as needed.

Log:

2020-04-07 17:40:07 Information: Installer: Initializing logging to file /var/log/eset/RemoteAdministrator/EraServerInstaller.log
2020-04-07 17:40:07 Information: Installer: Parsing arguments.
2020-04-07 17:40:07 Information: Installer: Verifing arguments.
2020-04-07 17:40:07 Information: Installer: Starting install sequence.
2020-04-07 17:40:07 Information: Installer: Extracting archive to /tmp/tmp.lgJUYYy9xA
2020-04-07 17:40:11 Information: Installer: Archive extracted to /tmp/tmp.lgJUYYy9xA.
2020-04-07 17:40:11 Information: Installer: Checking OpenSSL ...
2020-04-07 17:40:11 Information: DepCheckOpenSSL: Action invoked with:
2020-04-07 17:40:11 Information: DepCheckOpenSSL: Set output property: P_OPENSSL_VERSION = OpenSSL 1.0.2n  7 Dec 2017
2020-04-07 17:40:11 Information: DepCheckOpenSSL: Return code: 0
2020-04-07 17:40:11 Information: Installer: Found: OpenSSL 1.0.2n 7 Dec 2017
2020-04-07 17:40:11 Information: Installer: Reading previous installation settings ...
2020-04-07 17:40:11 Information: LoadInstalledData: Action invoked with:  --current-version 7.1.503.0 --db-connectors-dir /tmp/tmp.lgJUYYy9xA/setup --db-driver MySQL --db-hostna$
2020-04-07 17:40:11 Error: LoadInstalledData: Startup configuration file '/etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini' does not exist, is empty or is not r$
2020-04-07 17:40:11 Information: Installer: Failed reading previous installation settings.
2020-04-07 17:40:11 Information: Installer: Checking installed version...
2020-04-07 17:40:11 Information: CheckVersion: Action invoked with:  --current-version 7.1.503.0 --installed-version ""
2020-04-07 17:40:11 Information: Product is not installed
2020-04-07 17:40:11 Information: CheckVersion: Set output property: P_VERSION_STATUS = NEW
2020-04-07 17:40:11 Information: CheckVersion: Return code: 0
2020-04-07 17:40:11 Information: Installer: Checking of installed version was successful
2020-04-07 17:40:11 Information: Installer: Status of current installation is: NEW
2020-04-07 17:40:11 Information: Installer: Checking database connection ...
2020-04-07 17:40:11 Information: DbCheckConnection: Action invoked with:  --current-version 7.1.503.0 --db-admin-password ********** --db-admin-username ********** --db-connecto$
2020-04-07 17:40:11 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS =
2020-04-07 17:40:11 Information: DbCheckConnection: Set output property: P_DB_STATUS =
2020-04-07 17:40:11 Information: DbCheckConnection: Set output property: P_DB_UPGRADE =
2020-04-07 17:40:11 Information: DbCheckConnection: Set output property: P_DB_USE_FIRST_USER = 
2020-04-07 17:40:11 Information: DbCheckConnection: Set output property: P_DB_PORT = 3306
2020-04-07 17:40:11 Information: GetDatabaseServerConnectionStringWithoutEscape: Created connection string: 'Driver=MySQL;Server=127.0.0.1;Port=3306;User=******;Password={******$
2020-04-07 17:40:11 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framewor$
2020-04-07 17:40:11 Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework$
2020-04-07 17:40:11 Information: Entering function: std::__cxx11::string Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionCommentOfDbServer(const string&)
2020-04-07 17:40:11 Information: DatabaseReader: Recycling current DB connection.
2020-04-07 17:40:11 Information: Leaving function: std::__cxx11::string Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionCommentOfDbServer(const string&)
2020-04-07 17:40:11 Information: Entering function: std::__cxx11::string Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const string&)
2020-04-07 17:40:11 Information: DatabaseReader: Recycling current DB connection.
2020-04-07 17:40:11 Information: Leaving function: std::__cxx11::string Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const string&)
2020-04-07 17:40:11 Information: SQL Database server version is '5.7.29', which is considered as SUPPORTED.
2020-04-07 17:40:11 Information: DatabaseReader: Recycling current DB connection.
2020-04-07 17:40:12 Information: Execution test of long statement failed with DATABASE exception.. Error code: 65535, DB specific error code: 1153, error message: [MySQL][ODBC 5$
2020-04-07 17:40:12 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS = 77702
2020-04-07 17:40:12 Information: DbCheckConnection: Return code: 0
2020-04-07 17:40:12 Information: Installer: The database server is not configured correctly. Please check the documentation and reconfigure the database server as needed.
2020-04-07 17:40:12 Information: Installer: Error: The database server is not configured correctly. Please check the documentation and reconfigure the database server as needed.

 

[MartinK 375]

Unfortunately crucial part of log is missing (lines are not whole), but I think that most relevant error would be:

Execution test of long statement failed with DATABASE exception

which indicated that MySQL is not configured properly. There are certain configuration requirements as described in documentation. Error indicates that parameter max_allowed_packet is not configured properly, but there are also two other settings that has to be changed and are checked during installation. I would also recommend to check original log for missing part, as DB error that caused failure of this check might be different, not related to value itself, but I do not think it will be communication nor authentication issue as prior to configuration check there was successful connection check performed.

[arusconi 4]

In particular, I found that implementing ESMC on Linux is some tricky, especially when it comes to the odbc connection. I recommend you install an instance of the appliance via Virtualbox.
Best regards.

Edited April 7, 2020 by arusconi

[Martin25B93 1]

I installed it. I had two errors first were in DSN (I fixed it by unixodbc package) and second were in:

/etc/mysql/mysql.conf.d/mysqld.cnf

I had there multiple max_allowed_packet entries. Thank you for your help!!! Stay safe and healthy.

[Martin25B93 1]

Have you ever anybody seen this? Duplicate Peer Certificates? Which can be deleted from webconsole? Or If I delete everything and run installation again?

Thank you!

Edited April 7, 2020 by Martin25B93

[MartinK 375]

19 hours ago, Martin25B93 said:

Have you ever anybody seen this? Duplicate Peer Certificates? Which can be deleted from webconsole? Or If I delete everything and run installation again?

Thank you!

Seems that each attempt of installation created new set -> I would recommend to perform complete reinstall in case you have not performed any actions or deployment yet. Those certificates can be "revoked" which would probably results in removal from console, but might be cleaner to just reinstall (uninstall with database removal + install).

[Martin25B93 1]

Solved! Thank you very much