Hi, I’m trying to install ranger-admin with MYSQL 8 running setup.sh
Error: CREATE TABLE `x_trx_log_v2` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `added_by_id` bigint(20) DEFAULT NULL, `class_type` int(11) NOT NULL DEFAULT '0', `object_id` bigint(20) DEFAULT NULL, `parent_object_id` bigint(20) DEFAULT NULL, `parent_object_class_type` int(11) NOT NULL DEFAULT '0', `parent_object_name` varchar(1024) DEFAULT NULL, `object_name` varchar(1024) DEFAULT NULL, `change_info` MEDIUMTEXT NULL DEFAULT NULL, `trx_id` varchar(1024) DEFAULT NULL, `action` varchar(255) DEFAULT NULL, `sess_id` varchar(512) DEFAULT NULL, `req_id` varchar(30) DEFAULT NULL, `sess_type` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`), KEY `x_trx_log_v2_FK_added_by_id` (`added_by_id`), KEY `x_trx_log_v2_cr_time` (`create_time`), KEY `x_trx_log_v2_trx_id` (`trx_id`) )ROW_FORMAT=DYNAMIC; java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes SQLException : SQL state: 42000 java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes ErrorCode: 1071 Problem seems to be the trx_id is too long. Regards Steven
