bruno67

I restored my server and now I have this error after upgrading the server and the console Error: Service [Thread 7efccd647b80]: Service run-time failed with: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.33]PROCEDURE eset_db.usp_stored_installers_load_all_valid does not exist (1305)

I tried this : set global log_bin_trust_function_creators = 1; but still have the problem

I have this error in /var/log/eset/RemoteAdministrator/EraServerInstaller.log: Error: Statement execution failed. Code: 1419. Error: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.31]You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable). File: /tmp/tmp.ao5dsey00t/setup/Database/MySQL/UpgradeScripts/ 10113_10114.sql. Statement: CREATE FUNCTION `ufn_uuid_str_to_binary`(`_uuid` CHAR(36)) RETURNS binary(16) NO SQL DETERMINISTIC SQL SECURITY INVOKER BEGIN RETURN UNHEX(REPLACE(_uuid, '-', '')); END; 2024-03-18 13:27:46 Error: DbUpgrade: Statement execution failed. Code: 1419. Error: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.31]You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable). File: /tmp/tmp.ao5dsey00t/setup/Database/MySQL/Upgr adeScripts/10113_10114.sql. Statement: CREATE FUNCTION `ufn_uuid_str_to_binary`(`_uuid` CHAR(36)) RETURNS binary(16) NO SQL DETERMINISTIC SQL SECURITY INVOKER BEGIN RETURN UNHEX(REPLACE(_uuid, '-', '')); END; 2024-03-18 13:27:46 Information: Installer: Failed upgrading database. 2024-03-18 13:27:46 Information: Installer: Error: : Error occurred while upgrading database

Hello , I have an ESET PROTECT SERVER with this configuration: ESET PROTECT (Server), Version 10.0 (10.0.2133.0) ESET PROTECT (Console Web), Version 10.0 (10.0.132.0) Ubuntu (64-bit), version 18.04 Version de la base de données : MySQL 8.0.31 Taille de la base de données : 221Mo Server version: Apache Tomcat/9.0.62 Server built: Mar 31 2022 14:34:15 UTC Server number: 9.0.62.0 OS Name: Linux OS Version: 4.15.0-213-generic Architecture: amd64 JVM Version: 17.0.7+7-Ubuntu-0ubuntu118.04 JVM Vendor: Private Build I have a message inviting me to update my server. After the update when I want to log on I have this message: loginConnectionStateNotConnected Here are the status of the different services: service eraserver status ● eraserver.service - ESET PROTECT Server Loaded: loaded (/etc/systemd/system/eraserver.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Mon 2024-03-18 13:45:02 CET; 10s ago Process: 31900 ExecStart=/opt/eset/RemoteAdministrator/Server/ERAServer --daemon --pidfile /var/run/eraserver.pid (code=exited, status=0/SUCCESS) Main PID: 31911 (code=exited, status=70) service mysql status ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: active (running) since Thu 2024-03-14 14:26:53 CET; 3 days ago Docs: man:mysqld(8) hxxp://dev.mysql.com/doc/refman/en/using-systemd.html Main PID: 1791 (mysqld) Status: "Server is operational" Tasks: 47 (limit: 4653) CGroup: /system.slice/mysql.service └─1791 /usr/sbin/mysqld service tomcat9 status ● tomcat9.service - Apache Tomcat 9 Web Application Server Loaded: loaded (/lib/systemd/system/tomcat9.service; enabled; vendor preset: enabled) Active: active (running) since Thu 2024-03-14 14:26:40 CET; 3 days ago Docs: https://tomcat.apache.org/tomcat-9.0-doc/index.html Main PID: 1720 (java) Tasks: 45 (limit: 4653) CGroup: /system.slice/tomcat9.service └─1720 /usr/lib/jvm/java-17-openjdk-amd64/bin/java -Djava.util.logging.config.file=/var/lib/tomcat9/conf/logging.properties -Djava.util.logging.manager= It seems that Eraserver doesn't want to work Do you have an idea ? thanks Bruno

here is the solution SET GLOBAL log_bin_trust_function_creators = 1;

Hello, as usual each time there is an update the webconcsole doesn't work. I have : server:9.1.2301.0 console web 9.1.292.0 on ubunu x64 1804 Mysql 8.0.31 Java version open jdk 17.0.5 Tomcat 9.0.62 I launched the update this mornig and now when I want to log on the console I have this message: Échec de la connexion : la connexion a échoué avec l'état « loginConnectionStateNotConnected » service mysql -->active running service tomcat9 -->active running service eraserver status -->failed Here is the EraServerInstaller.log: 2023-01-02 10:52:10 Information: UpgradeDatabase: Processing file /tmp/tmp.XqWxl3XWKd/setup/Database/MySQL/CreateScripts/2_create_schema_utils.p.sql 2023-01-02 10:52:10 Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseWrapper::UpgradeDatabase(const string&, const string&, const string&, const string &) 2023-01-02 10:52:10 Error: Statement execution failed. Code: 1419. Error: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.31]You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable). File: /tmp/tmp.XqWxl3XWKd/setup/Database/MySQL/CreateScripts/2_create_schema_utils.p.sql. Statement: -- Dumping structure for function ufn_uuid_str_to_binary CREATE FUNCTION `ufn_uuid_str_to_binary`(`_uuid` CHAR(36)) RETURNS binary(16) NO SQL DETERMINISTIC SQL SECURITY INVOKER BEGIN RETURN UNHEX(REPLACE(_uuid, '-', '')); END; 2023-01-02 10:52:10 Error: DbUpgrade: Statement execution failed. Code: 1419. Error: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.31]You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable). File: /tmp/tmp.XqWxl3XWKd/setup/Database/MySQL/CreateScripts/2_create_schema_utils.p.sql. Statement: -- Dumping structure for function ufn_uuid_str_to_binary CREATE FUNCTION `ufn_uuid_str_to_binary`(`_uuid` CHAR(36)) RETURNS binary(16) NO SQL DETERMINISTIC SQL SECURITY INVOKER BEGIN RETURN UNHEX(REPLACE(_uuid, '-', '')); END; 2023-01-02 10:52:10 Information: Installer: Failed upgrading database. 2023-01-02 10:52:10 Information: Installer: Error: : Error occurred while upgrading database Someone can help me ? Thanks

I found the solution , 1/verify if you have the good version of mysql odbc connector (for me myodbc-installer -d -l) MySQL ODBC 8.0 then open your odbc.ini and check [MySQL ODBC 8.0] Driver=/usr/local/lib/libmyodbc8a.so Setup=/usr/local/lib:libmyodbc8S.so FileUsage=1 UsageCount=3

Hello, I confirm ,I have the same issue on my ubuntu 1804. I contacted the eset support , but they answered me that they were not competent under linux

All is ok

I succeeded , now I try to backup the database

Hello, When I want to download the server , I have these informations: server-linux-x86_64.sh | File size: 88 MB | Version: 7.2.2233.0 and Filename: era.war | File size: 140 MB | Version: 7.2.221.0 I created a client task (security Management center component upgrade ) on my server with a trigger ASAP , but I still have the same version 7.0.471.0. The task is planned but doesn't start and I can't launch it manually (exection is greyed)

Hello, I have an ESMC server under linux (ESET Security Management Center (Server), version 7.0 (7.0.471.0), and I see that the last server available is 7.2.2233.0 I don't have the button to update . Can you help me? Thanks

thanks a lot

just a question I have this error: CMysqlCodeTokenExecutor: CheckVariableInnodbLogFileSize: Server variables innodb_log_file_size*innodb_log_files_in_group value 100663296 is too low I have: | innodb_log_file_size | 50331648 | | innodb_log_files_in_group | 2 | and my server have 2GB of RAM Can you say me what I have to change to remove the error thanks

I remove '-' in Mysql-Server and the error is not the same , I think you found my error thanks

Sorry , I don't understand , what do I verify ?

thanks for your answer , I have just tested ,but the problem is the same. I 'm going to test with ODBC 5.3.10 but it seems to be no more present on MYSQL website

Hello, I try to install ESET Security Management Center (7.0.471.0) on an ubuntu Distributor ID: Ubuntu Description: Ubuntu 18.04.2 LTS Release: 18.04 Codename: bionic I made all the steps from that page : https://help.eset.com/esmc_install/70/en-US/prerequisites_server_linux.html I installed this mysql server +-------------------------+-------------------------+ | Variable_name | Value | +-------------------------+-------------------------+ | innodb_version | 5.7.25 | | protocol_version | 10 | | slave_type_conversions | | | tls_version | TLSv1,TLSv1.1 | | version | 5.7.25-0ubuntu0.18.04.2 | | version_comment | (Ubuntu) | | version_compile_machine | x86_64 | | version_compile_os | Linux | +-------------------------+-------------------------+ I installed this ODBC Driver 5.3.12 I copied libmyodbc5a.so libmyodbc5S.so libmyodbc5w.so to /usr/local/lib and launched myodbc-installer -a -d -n "MySQL ODBC 5.3.12 Driver" -t "Driver=/usr/local/lib/libmyodbc5w.so" myodbc-installer -a -d -n "MySQL ODBC 5.3.12 Driver" -t "Driver=/usr/local/lib/libmyodbc5a.so" my file odbcinst.ini [MySQL ODBC 5.3.12 Driver] Driver=/usr/local/lib/libmyodbc5a.so UsageCount=2 When I launch the installer ./server-linux-x86_64.sh \--skip-license \--locale fr-FR \--server-root-password xxxx \--db-driver [MySQL ODBC 5.3.12 Driver] \--db-hostname 192.168.xx.xx \--db-port 3306 \--db-user-username era_db_user \--db-user-password XXX \--cert-hostname 192.168.XX.XX I have these errors Extracting archive, please wait... Archive extracted to /tmp/tmp.kcfOTy9538. Checking OpenSSL ... done [OpenSSL 1.0.2n 7 Dec 2017] Reading previous installation settings ... failure Checking installed version... done Status of current installation is: NEW Checking database connection ... failure When I see the log in /var/log/eset/RemoteAdministrator# more EraServerInstaller.log I have : 2019-04-15 11:31:06 Information: Installer: Initializing logging to file /var/log/eset/RemoteAdministrator/EraServerInstaller.log 2019-04-15 11:31:06 Information: Installer: Parsing arguments. 2019-04-15 11:31:06 Information: Installer: Verifing arguments. 2019-04-15 11:31:06 Information: Installer: Starting install sequence. 2019-04-15 11:31:07 Information: Installer: Extracting archive to /tmp/tmp.kcfOTy9538 2019-04-15 11:31:10 Information: Installer: Archive extracted to /tmp/tmp.kcfOTy9538. 2019-04-15 11:31:10 Information: Installer: Checking OpenSSL ... 2019-04-15 11:31:10 Information: DepCheckOpenSSL: Action invoked with: 2019-04-15 11:31:10 Information: DepCheckOpenSSL: Set output property: P_OPENSSL_VERSION = OpenSSL 1.0.2n 7 Dec 2017 2019-04-15 11:31:10 Information: DepCheckOpenSSL: Return code: 0 2019-04-15 11:31:10 Information: Installer: Found: OpenSSL 1.0.2n 7 Dec 2017 2019-04-15 11:31:10 Information: Installer: Reading previous installation settings ... 2019-04-15 11:31:10 Information: LoadInstalledData: Action invoked with: --current-version 7.0.471.0 --db-connectors-dir /tmp/tmp.kcfOTy9538/setup --db-driver MySQL --db-h ostname 192.168.80.180 --db-name era_db --db-port 3306 --db-type MySQL-Server --db-user-password ********** --db-user-username ********** --modules-dir /var/opt/eset/Remote Administrator/Server/Modules/ --product-guid "" --product-name Server --startup-config-path /etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini 2019-04-15 11:31:10 Error: LoadInstalledData: Startup configuration file '/etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini' does not exist, is empty or is not regular file 2019-04-15 11:31:10 Information: Installer: Failed reading previous installation settings. 2019-04-15 11:31:10 Information: Installer: Checking installed version... 2019-04-15 11:31:10 Information: CheckVersion: Action invoked with: --current-version 7.0.471.0 --installed-version "" 2019-04-15 11:31:10 Information: Product is not installed 2019-04-15 11:31:10 Information: CheckVersion: Set output property: P_VERSION_STATUS = NEW 2019-04-15 11:31:10 Information: CheckVersion: Return code: 0 2019-04-15 11:31:10 Information: Installer: Checking of installed version was successful 2019-04-15 11:31:10 Information: Installer: Status of current installation is: NEW 2019-04-15 11:31:10 Information: Installer: Checking database connection ... 2019-04-15 11:31:10 Information: DbCheckConnection: Action invoked with: --current-version 7.0.471.0 --db-admin-password ********** --db-admin-username ********** --db-con nectors-dir /tmp/tmp.kcfOTy9538/setup --db-driver MySQL --db-hostname 192.168.XX.XX --db-name era_db --db-port 3306 --db-scripts-dir /tmp/tmp.kcfOTy9538/setup/Database/ -- db-type MySQL-Server --db-user-password ********** --db-user-username ********** --installed "" --modules-dir /var/opt/eset/RemoteAdministrator/Server/Modules/ --product-na me Server --silent-reinstall "" --upgrade "" 2019-04-15 11:31:10 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS = 2019-04-15 11:31:10 Information: DbCheckConnection: Set output property: P_DB_STATUS = 2019-04-15 11:31:10 Information: DbCheckConnection: Set output property: P_DB_UPGRADE = 2019-04-15 11:31:10 Information: DbCheckConnection: Set output property: P_DB_USE_FIRST_USER = 2019-04-15 11:31:10 Error: DbCheckConnection: No enum format of database type exists for provided user format: "MySQL-Server". 2019-04-15 11:31:10 Information: Installer: Failed checking database connection. 2019-04-15 11:31:10 Information: Installer: Error: : Error occurred while checking database connection Someone can help me, please Thanks