bruno67
-
Posts
18 -
Joined
-
Last visited
Posts posted by bruno67
-
-
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 : 221MoServer 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: amd64JVM Version: 17.0.7+7-Ubuntu-0ubuntu118.04
JVM Vendor: Private BuildI 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/mysqldservice 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 databaseSomeone 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 -
-
-
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)
-
-
-
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: bionicI 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=2When 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.XXI 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 ... failureWhen 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 connectionSomeone can help me, please
Thanks
loginConnectionStateNotConnected
in ESET Products for Linux Servers
Posted
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)