Jump to content

loginConnectionStateNotConnected


Recommended Posts

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 statusese-1.png.f2f93ad43135d749e12d6c37eebd5811.png

● 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

 

zz.png

Link to comment
Share on other sites

  • Administrators

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

Link to comment
Share on other sites

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

 

Link to comment
Share on other sites

  • Administrators

Please raise a support ticket for help with further troubleshooting.

Edited by Marcos

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

  • Administrators

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

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.

  • Recently Browsing   0 members

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