Failure creating log table
Installing firewall with logging enabled fails with:
CREATE TABLE
xxx_civicrm
.log_civicrm_firewall_ipaddress (id
int(10) unsigned COMMENT 'Unique FirewallIpaddress ID',ip_address
varchar(255) COMMENT 'IP address used',access_date
TIMESTAMP NULL COMMENT 'When the IP address accessed',event_type
varchar(64) COMMENT 'The type of event that triggered this log',source
varchar(255) DEFAULT NULL COMMENT 'Origin of this access request' , log_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, log_conn_id VARCHAR(17), log_user_id INTEGER, log_action ENUM('Initialization', 'Insert', 'Update', 'Delete'), INDEX index_log_conn_id(log_conn_id), INDEX index_log_date(log_date), INDEX index_id(id) ) ENGINE=INNODB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC [nativecode=1031 ** Table storage engine for 'log_civicrm_firewall_ipaddress' doesn't have this option]
Server version: 5.7.29-percona-sure1-log MySQL Community Server (GPL)