light-oauth2 icon indicating copy to clipboard operation
light-oauth2 copied to clipboard

Update mysql db support to latest

Open vinhnhtn opened this issue 7 years ago • 1 comments

I have some problem while try upgrade mysql docker image to version 8. Its about new encrypt password function on mysql 8. Plz support me about that

vinhnhtn avatar May 14 '18 02:05 vinhnhtn

mysql 8 image fail since the row size.

mysqldb-8.0_1 | ERROR 1118 (42000) at line 82: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs light-oauth2_mysqldb-8.0_1 exited with code 1

Please change the db script of the audit_log table as below and try again.

https://github.com/networknt/light-oauth2/blob/develop/db/mysql/create_mysql.sql

create table audit_log ( log_id INT, -- system milliseonds from 1970. service_id VARCHAR(32) NOT NULL, endpoint VARCHAR(256) NOT NULL, request_header VARCHAR(2048), request_body VARCHAR(4096), response_code INT, response_header VARCHAR(2048), response_body VARCHAR(4096) ) ENGINE=INNODB;

We will try to fix this issue for next release

GavinChenYan avatar May 15 '18 17:05 GavinChenYan