Problem with database while installing a new ERA server

[makeitsimple 0]

Good afternoon,

I've already installed 4-5 installations of Era on Linux environment, without problems until now.

Today I had to provision a brand new installation and I had difficulties with the database.
I've followed the updated documentation and did installed mysql-server 5.7.23-1 from the mysql repository and also the odbc connector 5.3.11

When I try to execute the server-linux-x86_64, I'm receiving the following message:

Inserting root password ... done
Skipping certificates generation.
Scheduling static groups synchronization task ... done
Stopping service... ./server-linux-x86_64.sh: 1689: ./server-linux-x86_64.sh: initctl: not found
Creating database ... failure

Error: : Error occurred while creating database

Looking further in the installater logs:

cat /var/log/eset/RemoteAdministrator/EraServerInstaller.log

2018-08-05 14:18:05 Information: Entering function: void Era::Setup::Server::CustomActions::Database::CCodeTokenExecutorStaticObjectsBase::CreateClientTrigger(const string&, const string&, const string&)
2018-08-05 14:18:05 Information: Leaving function: void Era::Setup::Server::CustomActions::Database::CCodeTokenExecutorStaticObjectsBase::CreateClientTrigger(const string&, const string&, const string&)
2018-08-05 14:18:05 Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseWrapper::ExecuteScriptsInDirectory(const string&, const string&)
2018-08-05 14:18:05 Error: Statement execution failed. Code: 0. Error: CCodeTokenExecutorStaticObjectsBase: CreateClientTrigger: Trigger can not be created, because the referenced trigger group does not exist.. File: /tmp/tmp.RsERCk3cjD/setup/Database/MySQL/SetupScripts/Install/2_do_install.sql. Statement: ERA_EXECUTE StoreStaticObjectPresets 0x656e5f5553, 0x30;
2018-08-05 14:18:05 Error: DbCreate: Statement execution failed. Code: 0. Error: CCodeTokenExecutorStaticObjectsBase: CreateClientTrigger: Trigger can not be created, because the referenced trigger group does not exist.. File: /tmp/tmp.RsERCk3cjD/setup/Database/MySQL/SetupScripts/Install/2_do_install.sql. Statement: ERA_EXECUTE StoreStaticObjectPresets 0x656e5f5553, 0x30;
2018-08-05 14:18:05 Information: Installer: Failed creating database.
2018-08-05 14:18:05 Information: Installer: Error: : Error occurred while creating database

Any idea why I'm having this?
 

Thanks in advance

 

[MartinK 376]

Could you please verify there are no remnants of ERA database from previous attempts? Just to be sure it is clean installation that results in this kind of errors ...

[makeitsimple 0]

Hi @MartinK, thanks for your reply.

I did all my tests by incrementing the "--db-name=" parameter by one.

e.g.: --db-name="era_db7"

[tomcc 0]

This is not an attempt to hijack this, but I have the same issue when installing ERA on CentOS 7, db is mysql-server 5.7.23 installed on Win10 64bit machine because ERA doesn't support mariadb...

I get: "Error: 2375: Error occurred while creating database"

log states:

"

2018-08-06 14:43:04 Error: Statement execution failed. Code: 0. Error: CCodeTokenExecutorStaticObjectsBase: CreateClientTrigger: Trigger can not be created, because the referenced trigger group does not exist.. File: /tmp/tmp.WMAu0IGIus/setup/Database/MySQL/SetupScripts/Install/2_do_install.sql. Statement: ERA_EXECUTE StoreStaticObjectPresets 0x656e5f5553, 0x30;
2018-08-06 14:43:04 Error: DbCreate: Statement execution failed. Code: 0. Error: CCodeTokenExecutorStaticObjectsBase: CreateClientTrigger: Trigger can not be created, because the referenced trigger group does not exist.. File: /tmp/tmp.WMAu0IGIus/setup/Database/MySQL/SetupScripts/Install/2_do_install.sql. Statement: ERA_EXECUTE StoreStaticObjectPresets 0x656e5f5553, 0x30;
2018-08-06 14:43:04 Information: Installer: Failed creating database.

"

There are no remnants of ERA database from previous attempts...I delete them after each unsuccessful attempt.  

myodbc.ini

[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/lib/psqlodbcw.so
Setup=/usr/lib/libodbcpsqlS.so
Driver64=/usr/lib64/psqlodbcw.so
Setup64=/usr/lib64/libodbcpsqlS.so
FileUsage=1

[MySQL]
Description=ODBC for MySQL
Driver=/usr/lib/libmyodbc5.so
Setup=/usr/lib/libodbcmyS.so
Driver64=/usr/lib64/libmyodbc5w.so
Setup64=/usr/lib64/libodbcmyS.so
FileUsage=1

[MySQL ODBC 5.3 Unicode Driver]
Driver=/usr/lib64/libmyodbc5w.so
UsageCount=1

[MySQL ODBC 5.3 ANSI Driver]
Driver=/usr/lib64/libmyodbc5a.so
UsageCount=1

 

Will follow this thread...

 

[MartinK 376]

could you please provide also remaining command line parameter for ERA installation (without private data and specific paths)? I am interested in configuration of AD synchronization task if present, or maybe activation key is used directly from command line? Also we have recently been notified that ERA does no work correctly with latest version of MySQL ODBC drivers - any chance there was update of those packages in your environment?

[Nataly 1]

Hello! I do have exactly the same error: 

2018-08-06 20:24:17 Error: Statement execution failed. Code: 0. Error: CCodeTokenExecutorStaticObjectsBase: CreateClientTrigger: Trigger can not be created, because the referenced trigger group does not exist.. File: /tmp/tmp.0L9uyjNKma/setup/Database/MySQL/SetupScripts/Install/2_do_install.sql. Statement: ERA_EXECUTE StoreStaticObjectPresets 0x656e5f5553, 0x30;
2018-08-06 20:24:17 Error: DbCreate: Statement execution failed. Code: 0. Error: CCodeTokenExecutorStaticObjectsBase: CreateClientTrigger: Trigger can not be created, because the referenced trigger group does not exist.. File: /tmp/tmp.0L9uyjNKma/setup/Database/MySQL/SetupScripts/Install/2_do_install.sql. Statement: ERA_EXECUTE StoreStaticObjectPresets 0x656e5f5553, 0x30;
2018-08-06 20:24:17 Information: Installer: Failed creating database.
2018-08-06 20:24:17 Information: Installer: Error: : Error occurred while creating database

Fresh install, ODBC 5.3.11, MySQL 5.7, Ubuntu.

 

[MartinK 376]

It seems that all of you have the same problem, and I think problem is with ODBC driver. We have recently discovered that newly released MySQL ODBC 8 driver does not work correctly with ERA. It seems also ODBC 5 driver has been also released (8 days ago), and it causes similar issues.

My recommendation is to revert ODBC 5 driver to previous version, i.e. try to install version 5.3.10 or older and check whether it works. Unfortunately were not able to discover where the problem is yet, as those drivers were release recently.

Also you can check one of previous topic ERA Server broken in VA after updating to mysql-community v5.6.41 mentioning the same issue, but for existing ERA Appliances and caused by incompatible MySQL ODBC 8 driver.

Edited August 7, 2018 by MartinK

[Nataly 1]

With odbc driver 5.1 it worked.

[makeitsimple 0]

On 8/8/2018 at 9:16 PM, Nataly said:

With odbc driver 5.1 it worked.

I confirm. With a previous version of mysql odbc it works.

Thanks @Nataly & @MartinK