zhangxiaolu created RANGER-1537:
-----------------------------------
Summary: 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
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)
