Jump to content

Installation ERA6 on Opensuse failed


Recommended Posts

Hello,

 

after installing mysql, unixODBC and MyODBC-unixODBC I*ve got the installer working.

But it seems that a sql-statement of the installer is wrong.

When I do a ./Server-Linux-x86_64-6.1.450.0.sh --skip-license --db-driver=MySQL --db-hostname=fry.xxx.xx --db-port=3306 --db-admin-username=root --db-admin-password=yyyyyyyy --server-root-password="zzzzzzzz." --db-user-username=era_user --db-user-password=aaaaaaaa --cert-hostname="xxxx;xxx.xx.xxx.xxx;xxxxx.xxx.xx"

I get in the log:

 

2015-04-30 09:18:54 Information: DropAndCreateDatabaseForDBServer: Skipping file /tmp/tmp.KVASjCfSUS/setup/Database/MySQL/CreateScripts/version.ini
2015-04-30 09:18:54 Information: DropAndCreateDatabaseForDBServer: Processing file /tmp/tmp.KVASjCfSUS/setup/Database/MySQL/CreateScripts/1_create_schema_without_views.sql
2015-04-30 09:18:54 Information: DropAndCreateDatabaseForDBServer: Processing file /tmp/tmp.KVASjCfSUS/setup/Database/MySQL/CreateScripts/2_create_log_tables.sql
2015-04-30 09:18:55 Information: DropAndCreateDatabaseForDBServer: Processing file /tmp/tmp.KVASjCfSUS/setup/Database/MySQL/CreateScripts/3_create_views.sql
2015-04-30 09:18:55 Information: DropAndCreateDatabaseForDBServer: Processing file /tmp/tmp.KVASjCfSUS/setup/Database/MySQL/CreateScripts/4_init_data.sql
2015-04-30 09:18:55 Information: DropAndCreateDatabaseForDBServer: Processing file /tmp/tmp.KVASjCfSUS/setup/Database/MySQL/CreateScripts/5_reports_interface.sql
2015-04-30 09:18:55 Error: DbCreate: Statement execution failed. Error: [MySQL][ODBC 5.1 Driver][mysqld-5.5.29-MariaDB-log]This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary loggin
g is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable). File: /tmp/tmp.KVASjCfSUS/setup/Database/MySQL/CreateScripts/5_reports_interface.sql. Statement:
CREATE FUNCTION `ufn_create_hour_interval`(`timeParam` DATETIME)
    RETURNS TIMESTAMP
    LANGUAGE SQL
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY INVOKER
BEGIN
    return FROM_UNIXTIME(UNIX_TIMESTAMP(timeParam)- UNIX_TIMESTAMP(timeParam)%(60*60));
END;
2015-04-30 09:18:55 Information: Installer: Failed creating database.
2015-04-30 09:18:56 Information: Installer: Error: 1954: Error occured while creating database

 

 

Any ideas how to solve that?

 

Regards

 

Daniel

 

Link to post
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...