Update mysql db support to latest
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
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