Jump to content
Martin25B93

Problem install ESMC on Ubuntu 18.04

Recommended Posts

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.

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
Posted (edited)

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 by arusconi

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
Posted (edited)

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!

Screenshot 2020-04-07 at 23.13.21.png

Edited by Martin25B93

Share this post


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

Screenshot 2020-04-07 at 23.13.21.png

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

Share this post


Link to post
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...