Jump to content

ESMC Server-Install "Error while creating database" ubuntu


mathis
 Share

Go to solution Solved by mathis,

Recommended Posts

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

 

Link to comment
Share on other sites

  • Administrators

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 ?

Link to comment
Share on other sites

  • Solution

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
 

Link to comment
Share on other sites

  • ESET Staff
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.

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

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...