You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "zhangxiaolu (JIRA)" <ji...@apache.org> on 2017/04/23 05:20:04 UTC
[jira] [Updated] (RANGER-1537) when use mysql5.7 ,ranger-admin
setup error
[ 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)