loginConnectionStateNotConnected

[bruno67 0]

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

 

[Marcos 5,274]

Please check trace.log for more information about errors on the server. For further troubleshooting, raise a support ticket.

[bruno67 0]

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

 

[Marcos 5,274]

Please raise a support ticket for help with further troubleshooting.

Edited 1 hour ago by Marcos

[bruno67 0]

I tried this :

set global log_bin_trust_function_creators = 1;

but still have the problem

[bruno67 0]

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)

[Marcos 5,274]

Please raise a support ticket for help with finding the root cause of the issue.