Skip to content
This repository has been archived by the owner on Jan 20, 2024. It is now read-only.

Update mysql db support to latest #91

Open
vinhnhtn opened this issue May 14, 2018 · 1 comment
Open

Update mysql db support to latest #91

vinhnhtn opened this issue May 14, 2018 · 1 comment
Assignees

Comments

@vinhnhtn
Copy link

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

@GavinChenYan
Copy link
Contributor

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants