search

wso2 / product-is

Welcome to the WSO2 Identity Server source code! For info on working with the WSO2 Identity Server repository and contributing code, click the link below.
http://wso2.github.io/
Apache License 2.0
748 stars 728 forks source link

Query interrupted when manually execute MYSQL db script with mysql latest #7301

Closed NilukaSripalim closed 4 years ago

NilukaSripalim commented 4 years ago

Mysql version : MySQL Server 8.0.19-1debian9 DB Script: wso2is-5.10.0-alpha3-SNAPSHOT/dbscripts/identity

Tested and Create Database with ;

  1. CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  2. CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  3. CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
  4. CREATE DATABASE mydb;

  5. CREATE DATABASE mydb CHARACTER SET utf8mb4;

    created databases with above queries and got the error while executing wso2is-5.10.0-alpha3-SNAPSHOT/dbscripts/identity/mysql.sql below mentioned Error:

CREATE TABLE IF NOT EXISTS IDN_PASSWORD_HISTORY_DATA ( ID INTEGER NOT NULL AUTO_INCREMENT, USER_NAME VARCHAR(255) NOT NULL, USER_DOMAIN VARCHAR(127) NOT NULL, TENANT_ID INTEGER DEFAULT -1, SALT_VALUE VARCHAR(255), HASH VARCHAR(255) NOT NULL, TIME_CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(ID), UNIQUE (USER_NAME,USER_DOMAIN,TENANT_ID,SALT_VALUE,HASH) )ENGINE INNODB Error Code: 1071. Specified key was too long; max key length is 3072 bytes

NilukaSripalim commented 4 years ago

Working fine with , sql query create database mydb CHARACTER SET latin1 collate latin1_swedish_ci ;