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
Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...