817 1 Posted April 29, 2019 Share Posted April 29, 2019 OS: CentOS Linux 7.6.1810 mySQL:5.7 I tried to install ESMC and run Server-Linux-x86_64.sh, got the database create error. I checked /var/log/mysqld.log and see the "Got an error reading communication packets" so change the parameter in /etc/my.cnf, max_allowed_packet=33M innodb_log_file_size=200M innodb_log_files_in_group=20 character-set-server=utf8 but, nothing change. Do you have any idea? --- ESET Security Management Center Server Installer (version: 7.0.472.0), Copyright © 1992-2018 ESET, spol. s r.o. - All rights reserved. Product improvement program Participating in product improvement program includes sending crash reports and anonymous telemetry data such as OS version and type, ESET product version and other product-specific information to ESET when enabled. Do you want to participate in the Product improvement program? [Y/n]: Extracting archive, please wait... Archive extracted to /tmp/tmp.aNsol9Mi64. 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 Checking database user ... done Loading GUID ... done [GUID = 28c8f460-3550-4b5c-a0bc-09f4e4bc5c37] Inserting root password ... done Generating certificates ... done Skipping static groups synchronization scheduling. Stopping service... Preparing database upgrade ... done Upgrading database ..../x64/Server-Linux-x86_64.sh: 2549 行: 3656 中止 (コアダンプ) "${tmp_install_prefix}/setup/$ca_wrapper_bin" -a DbUpgrade --locale "$arg_locale" --modules-dir "${tmp_install_prefix}/setup/Modules/" --db-type "$arg_db_type" --db-driver "$arg_db_driver" --db-hostname "$arg_db_hostname" --db-port "$arg_db_port" --db-name "$arg_db_name" --db-user-username "$arg_db_user_username" --db-user-password "$arg_db_user_password" --db-scripts-dir "$tmp_db_scripts_dir" --db-connectors-dir "$arg_db_connectors_dir" --product-guid "$GUID" --product-name "$product_name" --silent-reinstall "$arg_silent_reinstall" --current-version "$arg_current_version" 2>> "$installer_log_file" failure Error: 2564: Error occurred while upgrading database Link to comment Share on other sites More sharing options...
ESET Moderators Peter Randziak 1,160 Posted April 29, 2019 ESET Moderators Share Posted April 29, 2019 Dear @817, can you please send me the full log as a file attachment to check? Regards, Peter Link to comment Share on other sites More sharing options...
817 1 Posted April 29, 2019 Author Share Posted April 29, 2019 dear @Peter Randziak, thank you. I attached the mysqld log and my.cnf files. If do you need other files, please reply me. mysqld.log my.cnf.txt Link to comment Share on other sites More sharing options...
ESET Staff MartinK 383 Posted April 29, 2019 ESET Staff Share Posted April 29, 2019 Could you please provide also /var/log/eset/RemoteAdministrator/EraServerInstaller.log -> it contains ESMC installer log. There is only one suspicious entry in provided output, and it is "2549 行: 3656 中止 (コアダンプ) ": could you help us interpret it? Is it possible you have some non-US locale set in terminal used for installation? In case you are performing new installation, please make sure that before each attempt of installation, ESMC database is removed, it is most probably in undefined state after such failure. Link to comment Share on other sites More sharing options...
817 1 Posted April 30, 2019 Author Share Posted April 30, 2019 Thank you @MartinK, Here's EraServerInstaller.log. "2549 行: 3656 中止 (コアダンプ) " is " Row No.2549 : 3656 stopped (core dump) ". but I don't know the mySQL error message on English environment, it may different actually message in English. The parameter of Server-Linux-x86_64.sh is below, passwords are masked, and these parameter is written in Japanese ESMC installation manual. ./x64/Server-Linux-x86_64.sh \ --locale=ja_JP \ --skip-license \ --db-driver=MySQL \ --db-hostname=127.0.0.1 \ --db-port=3306 \ --db-admin-username=root \ --db-admin-password=********** \ --server-root-password=*********** \ --db-user-username=era_server_user \ --db-user-password=********** \ --cert-hostname=* EraServerInstaller.log Link to comment Share on other sites More sharing options...
ESET Staff MartinK 383 Posted April 30, 2019 ESET Staff Share Posted April 30, 2019 Problem seems to be in MySQL ODBC driver used. Unfortunately ESMC 7.0 does not support latest versions as there is some bug in driver itself. It was supposed to be fixed in ODBC driver 8.0.16 released recently but seems there might be some another issue. I would recommend to check documentation where latest supported version of MySQL ODBC driver is mentioned. If I recall correctly, latest working version is 5.3.10. Peter Randziak 1 Link to comment Share on other sites More sharing options...
817 1 Posted May 1, 2019 Author Share Posted May 1, 2019 I checked the version ODBC-driver and re installed 5.3.10, then ESMC installer run correctly. Thank you very much, @MartinK and @Peter Randziak ! Peter Randziak 1 Link to comment Share on other sites More sharing options...
Recommended Posts