Jump to content
makeitsimple

Problem with database while installing a new ERA server

Recommended Posts

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

 

Share this post


Link to post
Share on other sites

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 ...

Share this post


Link to post
Share on other sites

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"

Share this post


Link to post
Share on other sites

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...

 

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites
Posted (edited)

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 by MartinK

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×