Security Management Center installation issue

[helis 0]

Hi.

I've been trying to install ESET Security Management Center Server Installer (version: 7.0.471.0) on a Debian server and ran into something I can't quite figure out.

The command is (passwords and IPs omitted)

./server-linux-x86_64.sh --skip-license --db-driver="MySQL ODBC 8.0 Driver" --db-hostname=127.0.0.1 --db-port=3306 --db-admin-username=root --db-admin-password=*** --server-root-password=*** --db-user-username=nod32 --db-user-password=*** --cert-hostname=*** --disable-imp-program --locale=ru-RU

The output:
 

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

Extracting archive, please wait...
Archive extracted to /tmp/tmp.aKtR2efg2z.
Checking OpenSSL ... done [OpenSSL 1.0.2s 28 May 2019]
Reading previous installation settings ... failure
Checking installed version... done
Status of current installation is: NEW
Checking database connection ... done
Checking database user ... done
Loading GUID ... done [GUID = 2a68352e-a321-4d1c-aad6-54d55fde35c8]
Inserting root password ... done
Generating certificates ... done
Skipping static groups synchronization scheduling.
Stopping service... Preparing database upgrade ... done
Upgrading database ... failure

 

 

The log of what I presume is the problem:

2019-08-19 11:50:11 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseWrapper::ExecuteScriptsInDirectory(const string&, const string&)
2019-08-19 11:50:11 Information: ExecuteScriptsInDirectory: Processing file /tmp/tmp.aKtR2efg2z/setup/Database/MySQL/SetupScripts/Upgrade/2_do_upgrade.sql
2019-08-19 11:50:11 Information: StoreStaticObjectPresets: Initializing with locale 'en_US'
2019-08-19 11:50:11 Information: Entering function: void Era::Setup::Server::CustomActions::Database::CCodeTokenExecutorStaticObjectsBase::SetDefaultDashboard(const Era::Common::DataDefinition::Dashboard::DashboardsData&)
2019-08-19 11:50:11 Information: Leaving function: void Era::Setup::Server::CustomActions::Database::CCodeTokenExecutorStaticObjectsBase::SetDefaultDashboard(const Era::Common::DataDefinition::Dashboard::DashboardsData&)
2019-08-19 11:50:11 Information: Entering function: void Era::Setup::Server::CustomActions::Database::CCodeTokenExecutorStaticObjectsBase::CreateReportTemplateCategory(const string&, const string&, const string&)
CustomActions: /export/home/pb2/build/sb_0-34672789-1560939153.14/mysql-connector-odbc-8.0.17-src/driver/my_prepared_stmt.cc:135: int ssps_get_out_params(STMT*): Assertion `values' failed.
Aborted
2019-08-19 11:50:11 Information: Installer: Failed upgrading database.
2019-08-19 11:50:11 Information: Installer: Error: : Error occurred while upgrading database

 

Googling hasn't gotten me anywhere. Any advice of what to do here?

[helis 0]

Nevermind, fell back to older MySQL and ODBC and installed fine.

[MartinK 375]

2 hours ago, helis said:

Nevermind, fell back to older MySQL and ODBC and installed fine.

As you probably found out, ESMC 7.0 does not support MySQL 8.0 nor latest ODBC drivers, so only possibility for now is to stick with supported versions as listed in documentation.