ESMC Server-Install "Error while creating database" ubuntu

[mathis 0]

Hello Forum,

i´ve problems running the server-install script for ESMC Server version: 8.0.31-0ubuntu0.20.04.2 (Ubuntu)

 

 

Extracting archive, please wait...
Archive extracted to /tmp/tmp.zbjrzm5uNN.
Checking OpenSSL ... done [OpenSSL 1.1.1f 31 Mar 2020]
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.
 

 

2023-01-18 14:34:51 Information: Installer: Initializing logging to file /var/log/eset/RemoteAdministrator/EraServerInstaller.log
2023-01-18 14:34:52 Information: Installer: Parsing arguments.
2023-01-18 14:34:52 Information: Installer: Verifing arguments.
2023-01-18 14:34:52 Information: Installer: Starting install sequence.
2023-01-18 14:34:52 Information: Installer: Spawning license agreement dialog.
2023-01-18 14:34:54 Information: Installer: License accepted.
2023-01-18 14:34:55 Information: Installer: Extracting archive to /tmp/tmp.zbjrzm5uNN
2023-01-18 14:35:01 Information: Installer: Archive extracted to /tmp/tmp.zbjrzm5uNN.
2023-01-18 14:35:01 Information: Installer: Checking OpenSSL ...
2023-01-18 14:35:01 Information: DepCheckOpenSSL: Action invoked with:
2023-01-18 14:35:01 Information: DepCheckOpenSSL: Set output property: P_OPENSSL_VERSION = OpenSSL 1.1.1f  31 Mar 2020
2023-01-18 14:35:01 Information: DepCheckOpenSSL: Return code: 0
2023-01-18 14:35:01 Information: Installer: Found: OpenSSL 1.1.1f 31 Mar 2020
2023-01-18 14:35:01 Information: Installer: Reading previous installation settings ...
2023-01-18 14:35:01 Information: LoadInstalledData: Action invoked with:  --current-version 10.0.2133.0 --db-connectors-dir /tmp/tmp.zbjrzm5uNN/setup --db-driver MySQL ODBC 8.0 Driver --db-hostname localhost --db-name era_db --db-port 3>
2023-01-18 14:35:01 Error: LoadInstalledData: Startup configuration file '/etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini' does not exist, is empty or is not regular file
2023-01-18 14:35:01 Information: Installer: Failed reading previous installation settings.
2023-01-18 14:35:01 Information: Installer: Checking installed version...
2023-01-18 14:35:01 Information: CheckVersion: Action invoked with:  --current-version 10.0.2133.0 --installed-version ""
2023-01-18 14:35:01 Information: Product is not installed
2023-01-18 14:35:01 Information: CheckVersion: Set output property: P_VERSION_STATUS = NEW
2023-01-18 14:35:01 Information: CheckVersion: Return code: 0
2023-01-18 14:35:01 Information: Installer: Checking of installed version was successful
2023-01-18 14:35:01 Information: Installer: Status of current installation is: NEW
2023-01-18 14:35:01 Information: Installer: Checking database connection ...
2023-01-18 14:35:01 Information: DbCheckConnection: Action invoked with:  --current-version 10.0.2133.0 --db-admin-password ********** --db-admin-username ********** --db-connectors-dir /tmp/tmp.zbjrzm5uNN/setup --db-driver MySQL ODBC 8>
2023-01-18 14:35:01 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS =
2023-01-18 14:35:01 Information: DbCheckConnection: Set output property: P_DB_STATUS =
2023-01-18 14:35:01 Information: DbCheckConnection: Set output property: P_DB_UPGRADE =
2023-01-18 14:35:01 Information: DbCheckConnection: Set output property: P_DB_USE_FIRST_USER =
2023-01-18 14:35:01 Information: DbCheckConnection: Set output property: P_LOCALE = --skip-license
2023-01-18 14:35:01 Information: DbCheckConnection: Set output property: P_DB_PORT = 3306
2023-01-18 14:35:01 Information: GetDatabaseServerConnectionStringWithoutEscape: Created connection string: 'Driver=MySQL ODBC 8.0 Driver;Server=localhost;Port=3306;User=******;Password={******};CharSet=utf8;NO_LOCALE=1;NO_SSPS=1;'
2023-01-18 14:35:01 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOptions)
2023-01-18 14:35:01 Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOptions)
2023-01-18 14:35:01 Information: Entering function: std::string Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionCommentOfDbServer(const string&)
2023-01-18 14:35:01 Information: DatabaseReader: Recycling current DB connection.
2023-01-18 14:35:01 Information: Leaving function: std::string Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionCommentOfDbServer(const string&)
2023-01-18 14:35:01 Information: Entering function: std::string Era::Setup::Common::CustomActions::CDatabaseReader::GetFullVersionOfDbServer(const string&)
2023-01-18 14:35:01 Information: DatabaseReader: Recycling current DB connection.
2023-01-18 14:35:01 Information: Leaving function: std::string Era::Setup::Common::CustomActions::CDatabaseReader::GetFullVersionOfDbServer(const string&)
2023-01-18 14:35:01 Information: Entering function: std::string Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const string&)
2023-01-18 14:35:01 Information: DatabaseReader: Recycling current DB connection.
2023-01-18 14:35:01 Information: Leaving function: std::string Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const string&)
2023-01-18 14:35:01 Information: SQL Database server version is '8.0.31', which is considered as SUPPORTED.
2023-01-18 14:35:01 Information: DatabaseReader: Recycling current DB connection.
2023-01-18 14:35:01 Error: Execution test of long statement failed with exception: CMysqlCodeTokenExecutor: CheckVariableInnodbLogFileSize: Server variables innodb_log_file_size*innodb_log_files_in_group value 100663296 is too low.
2023-01-18 14:35:01 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS = 77702
2023-01-18 14:35:01 Information: DbCheckConnection: Return code: 0
2023-01-18 14:35:01 Information: Installer: The database server is not configured correctly. Please check the documentation and reconfigure the database server as needed.
2023-01-18 14:35:01 Information: Installer: Error: The database server is not configured correctly. Please check the documentation and reconfigure the database server as needed

 

 

 

thanks

 

[Marcos 4,935]

Error: Execution test of long statement failed with exception: CMysqlCodeTokenExecutor: CheckVariableInnodbLogFileSize: Server variables innodb_log_file_size*innodb_log_files_in_group value 100663296 is too low.

Did you configure MySQL as per https://help.eset.com/protect_install/90/en-US/mysql_configuration.html ?

[mathis 0]

It's my file /etc/mysql/mysql.conf.d/mysqld.cnf but same problem

 

 

 

#
# The MySQL database server configuration file.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# hxxp://dev.mysql.com/doc/mysql/en/server-system-variables.html

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

[mysqld]
#
# * Basic Settings
#
user            = mysql
# pid-file      = /var/run/mysqld/mysqld.pid
# socket        = /var/run/mysqld/mysqld.sock
# port          = 3306
# datadir       = /var/lib/mysql

# If MySQL is running as a replication slave, this should be
# changed. Ref https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_tmpdir
# tmpdir                = /tmp
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1
mysqlx-bind-address     = 127.0.0.1
#
# * Fine Tuning
#
key_buffer_size         = 16M
 max_allowed_packet     = 33M
# thread_stack          = 256K

# thread_cache_size       = -1

# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options  = BACKUP

# max_connections        = 151

# table_open_cache       = 4000

#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
#
# Log all queries
# Be aware that this log type is a performance killer.
# general_log_file        = /var/log/mysql/query.log
# general_log             = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
# slow_query_log                = 1
# slow_query_log_file   = /var/log/mysql/mysql-slow.log
# long_query_time = 2
# log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
# server-id             = 1
 log_bin                        = 0
# binlog_expire_logs_seconds    = 2592000

log_bin_trust_function_creators =1
# max_binlog_size   = 100M
innodb_log_file_size= 100M
innodb_log_files_in_group=2innodb_log_files_in_group =2

# binlog_do_db          = include_database_name
# binlog_ignore_db      = include_database_name
 

[MartinK 376]

22 hours ago, mathis said:

It's my file /etc/mysql/mysql.conf.d/mysqld.cnf but same problem

This part of the configuration file:

innodb_log_file_size= 100M
innodb_log_files_in_group=2innodb_log_files_in_group =2 

does not look correct and that is probably reason why second setting is probably ignored.

[mathis 0]

perfect thank's