mathis 0 Posted January 18, 2023 Posted January 18, 2023 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
Administrators Marcos 5,735 Posted January 18, 2023 Administrators Posted January 18, 2023 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 ?
Solution mathis 0 Posted January 19, 2023 Author Solution Posted January 19, 2023 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
ESET Staff MartinK 384 Posted January 20, 2023 ESET Staff Posted January 20, 2023 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.
Recommended Posts