[
https://issues.apache.org/jira/browse/RANGER-1537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
zhangxiaolu updated RANGER-1537:
--------------------------------
Attachment: RANGER-1537.patch
> when use mysql5.7 ,ranger-admin setup error
> -------------------------------------------
>
> Key: RANGER-1537
> URL: https://issues.apache.org/jira/browse/RANGER-1537
> Project: Ranger
> Issue Type: Bug
> Components: admin
> Affects Versions: 0.5.3
> Reporter: zhangxiaolu
> Attachments: RANGER-1537.patch
>
>
> If user use mysql which version is 5.7, and execute ranger-admin's setup.sh,
> the error like this:
> /usr/jdk64/jdk1.7.0_67/bin/java -cp
> /usr/share/java/mysql-connector-java.jar:/usr/lib/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://docker1.cmss.com/ranger -u 'rangerdba' -p '********' -noheader
> -trim -c \; -input
> /usr/lib/ranger/ranger-admin/db/mysql/create_dbversion_catalog.sql
> Error executing: create table if not exists x_db_version_h ( id
> bigint not null auto_increment primary key,
> version varchar(64) not null, inst_at timestamp
> not null default current_timestamp, inst_by varchar(256)
> not null, updated_at timestamp not null, updated_by
> varchar(256) not null, active ENUM('Y', 'N') default 'Y' ) ;
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default
> value for 'updated_at'
> SQLException : SQL state: 42000
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default
> value for 'updated_at' ErrorCode: 1067
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
