ESMC 7 Server-Install "Error while creating database"

[SteveR 0]

Hello Forum,

i´ve problems running the server-install script for ESMC-version 7.0.471.0 on a Centos 7 system with not much more installed than the esmc-installation requirements. After trying severel script options according to the installation guide and struggeling with different ODBC-Connector-versions, the best progress I could achive is until "Error: 2583: Error occured while creating database". At this time the database has 293 tables. I was looking for MySQl-error-codes, the log files, mysql-/innodb-configs etc. but cant get it to finish successfully. Hopefully someone can give me some more ideas or hints to check. So here are some of the config-files and logs. Thanks

 

mysql 8.0.13, secure_installation

[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
max_allowed_packet = 35M
innodb_log_file_size = 105M
innodb_log_files_in_group = 2

 

mysql-connector-odbc-5.3.10 (lower or higher version didnt even start to create the database)

find / -iname "*libmyodbc*"
/usr/lib64/libmyodbc5a.so
/usr/lib64/libmyodbc5w.so

find / -iname "*libodbcmy*"
/usr/lib64/libodbcmyS.so
/usr/lib64/libodbcmyS.so.2
/usr/lib64/libodbcmyS.so.2.0.0

odbcinst.ini

[MySQL]
Description=ODBC for MySQL
Driver64=/usr/lib64/libmyodbc5w.so
Setup64=/usr/lib64/libodbcmyS.so
FileUsage=1

[MySQL ODBC 5.3 Unicode Driver]
Driver=/usr/lib64/libmyodbc5w.so
UsageCount=2

[MySQL ODBC 5.3 ANSI Driver]
Driver=/usr/lib64/libmyodbc5a.so
UsageCount=2

Script and output

sh server-linux-x86_64.sh --skip-license --locale=de-DE --db-driver=MySQL --db-hostname=127.0.0.1 --db-port=3306 --server-root-password=*** --db-user-username=*** --db-user-password=*** --cert-hostname="***"            
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.PVxT5jzlPe.
Checking OpenSSL ... done [OpenSSL 1.0.2k-fips 26 Jan 2017]
Reading previous installation settings ... failure
Checking installed version... done
Status of current installation is: NEW
Checking database connection ... done
Loading GUID ... done [GUID = 9d45998c-151d-4a98-883a-8f4456f28c7c]
Inserting root password ... done
Generating certificates ... done
Skipping static groups synchronization scheduling.
Stopping service... Creating database ... failure

Error: 2586: Error occurred while creating database

and log files

Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseWrapper::ExecuteScriptsInDirectory(const string&, const string&)
2018-12-21 00:35:43 Error: Statement execution failed. Code: 0. Error: CCodeTokenExecutorStaticObjectsBase: CreateClientTrigger: Trigger can not be created, because the referenced trigger group does not exist.. File: /tmp/tmp.PVxT5jzlPe/setup/Database/MySQL/SetupScripts/Install/2_do_install.sql. Statement: ERA_EXECUTE StoreStaticObjectPresets 0x64652d4445, 0x30, 0x, 0x, 0x536572766572, 0x2f746d702f746d702e50567854356a7a6c50652f73657475702f4d6f64756c65732f, 0x2f746d702f746d702e50567854356a7a6c50652f7365747570, 0x4472697665723d4d7953514c3b5365727665723d3132372e302e302e313b506f72743d333330363b557365723d726f6f743b50617373776f72643d7b6a766d6d4151663333332e347d3b436861725365743d757466383b4e4f5f4c4f43414c453d313b44617461626173653d6572615f64623b, 0x372e302e3437312e30, 0x4d7953514c20536572766572;
2018-12-21 00:35:43 Error: DbCreate: Statement execution failed. Code: 0. Error: CCodeTokenExecutorStaticObjectsBase: CreateClientTrigger: Trigger can not be created, because the referenced trigger group does not exist.. File: /tmp/tmp.PVxT5jzlPe/setup/Database/MySQL/SetupScripts/Install/2_do_install.sql. Statement: ERA_EXECUTE StoreStaticObjectPresets 0x64652d4445, 0x30, 0x, 0x, 0x536572766572, 0x2f746d702f746d702e50567854356a7a6c50652f73657475702f4d6f64756c65732f, 0x2f746d702f746d702e50567854356a7a6c50652f7365747570, 0x4472697665723d4d7953514c3b5365727665723d3132372e302e302e313b506f72743d333330363b557365723d726f6f743b50617373776f72643d7b6a766d6d4151663333332e347d3b436861725365743d757466383b4e4f5f4c4f43414c453d313b44617461626173653d6572615f64623b, 0x372e302e3437312e30, 0x4d7953514c20536572766572;
2018-12-21 00:35:43 Information: Installer: Failed creating database.

2018-12-21 00:35:43 Information: Installer: Error: 2586: Error occurred while creating database

Information: Installer: Initializing logging to file /var/log/eset/RemoteAdministrator/EraServerInstaller.log
Information: Installer: Parsing arguments.
Information: Installer: Verifing arguments.
Information: Installer: Server peer certificate ('/root/') is not a regular file. New certificates will be created.
Information: Installer: Starting install sequence.
Information: Installer: Extracting archive to /tmp/tmp.dmvQ9Ly3sk
Information: Installer: Archive extracted to /tmp/tmp.dmvQ9Ly3sk.
Information: Installer: Checking OpenSSL ...
Information: DepCheckOpenSSL: Action invoked with:
Information: DepCheckOpenSSL: Set output property: P_OPENSSL_VERSION = OpenSSL 1.0.2k-fips  26 Jan 2017
Information: DepCheckOpenSSL: Return code: 0
Information: Installer: Found: OpenSSL 1.0.2k-fips 26 Jan 2017
Information: Installer: Reading previous installation settings ...
Information: LoadInstalledData: Action invoked with:  --current-version 7.0.471.0 --db-connectors-dir /tmp/tmp.dmvQ9Ly3sk/setup --db-driver MySQL --db-hostname 127.0.0.1 --db-name era_db --db-port 3306 --db-type MySQL Server --db-user-password ********** --db-user-username ********** --modules-dir /var/opt/eset/RemoteAdministrator/Server/Modules/ --product-guid "" --product-name Server --startup-config-path /etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini
Error: LoadInstalledData: Startup configuration file '/etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini' does not exist, is empty or is not regular file
Information: Installer: Failed reading previous installation settings.
Information: Installer: Checking installed version...
Information: CheckVersion: Action invoked with:  --current-version 7.0.471.0 --installed-version ""
Information: Product is not installed
Information: CheckVersion: Set output property: P_VERSION_STATUS = NEW
Information: CheckVersion: Return code: 0
Information: Installer: Checking of installed version was successful
Information: Installer: Status of current installation is: NEW
Information: Installer: Checking database connection ...
Information: DbCheckConnection: Action invoked with:  --current-version 7.0.471.0 --db-admin-password ********** --db-admin-username ********** --db-connectors-dir /tmp/tmp.dmvQ9Ly3sk/setup --db-driver MySQL --db-hostname 127.0.0.1 --db-name era_db --db-port 3306 --db-scripts-dir /tmp/tmp.dmvQ9Ly3sk/setup/Database/ --db-type MySQL Server --db-user-password ********** --db-user-username ********** --installed "" --modules-dir /var/opt/eset/RemoteAdministrator/Server/Modules/ --product-name Server --silent-reinstall "" --upgrade ""
Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS =
Information: DbCheckConnection: Set output property: P_DB_STATUS =
Information: DbCheckConnection: Set output property: P_DB_UPGRADE =
Information: DbCheckConnection: Set output property: P_DB_USE_FIRST_USER =
Information: DbCheckConnection: Set output property: P_DB_PORT = 3306
Information: GetDatabaseServerConnectionStringWithoutEscape: Created connection string: 'Driver=MySQL;Server=127.0.0.1;Port=3306;User=******;Password={******};CharSet=utf8;NO_LOCALE=1;'
Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOptions)
Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOptions)
Information: Entering function: std::__cxx11::string Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionCommentOfDbServer(const string&)
Information: DatabaseReader: Recycling current DB connection.
Information: Leaving function: std::__cxx11::string Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionCommentOfDbServer(const string&)
Information: Entering function: std::__cxx11::string Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const string&)
Information: DatabaseReader: Recycling current DB connection.
Information: Leaving function: std::__cxx11::string Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const string&)
Information: SQL Database server version is '8.0.13', which is considered as SUPPORTED.
Information: DatabaseReader: Recycling current DB connection.
Information: DatabaseReader: Recycling current DB connection.
Information: Entering function: std::__cxx11::string Era::Setup::Common::CustomActions::CDatabaseReader::GetDatabaseStatusForDBServer(const string&, const string&, const string&, const string&)
Information: DatabaseReader: Recycling current DB connection.
Information: Leaving function: std::__cxx11::string Era::Setup::Common::CustomActions::CDatabaseReader::GetDatabaseStatusForDBServer(const string&, const string&, const string&, const string&)
Information: DbCheckConnection: Set output property: P_DB_STATUS = DB_EMPTY
Information: DbCheckConnection: Set output property: P_DB_UPGRADE = 0
Information: DbCheckConnection: Set output property: P_DB_USE_FIRST_USER =
Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS = OK
Information: DbCheckConnection: Return code: 0
Information: Installer: Connections working.
Information: Installer: Checking database user ...
Information: DbCheckUser: Action invoked with:  --current-version 7.0.471.0 --db-admin-password ********** --db-admin-username ********** --db-connectors-dir /tmp/tmp.dmvQ9Ly3sk/setup --db-driver MySQL --db-hostname 127.0.0.1 --db-name era_db --db-port 3306 --db-type MySQL Server --db-user-password ********** --db-user-username ********** --silent-reinstall ""
Information: DbCheckUser: Set output property: P_DB_USER_STATUS =
Information: DbCheckUser: Set output property: P_DB_CONNECTION_STATUS =
Information: GetDatabaseServerConnectionStringWithoutEscape: Created connection string: 'Driver=MySQL;Server=127.0.0.1;Port=3306;User=******;Password={******};CharSet=utf8;NO_LOCALE=1;'
Information: Entering function: bool Era::Setup::Common::CustomActions::CDatabaseReader::CheckUserExistanceForDBServer(const string&, const string&)
Information: Leaving function: bool Era::Setup::Common::CustomActions::CDatabaseReader::CheckUserExistanceForDBServer(const string&, const string&)

 

[MartinK 378]

Unfortunately ERA/ESMC does not support MySQL 8, so I would recommend to use MySQL 5.7/5.6.

[SteveR 0]

Hello MartinK,

thanks for your hint, guess I didnt read that point accurately, with MySQl 5.7.24/ODBC 5.3.10 installation was successful. Thanks