Update ESMC 10.0.14 from 9.1.292.0

[bruno67 0]

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

 

[bruno67 0]

here is the solution

SET GLOBAL log_bin_trust_function_creators = 1;

[rgoldman 2]

Also check ODBC driver version

https://help.eset.com/protect_install/91/en-US/database_requirements.html