Self contained JWT's may get quite large and if we set it as the default size in the script, for users who are not using self contained JWT also it is going to consume large space in the database.
Did we think about storing a hash of the access token? On Fri, Nov 17, 2017 at 3:06 PM, Isura Karunaratne <is...@wso2.com> wrote: > > > On Fri, Nov 17, 2017 at 1:35 PM, Isura Karunaratne <is...@wso2.com> wrote: > >> Hi all, >> >> Currently, ACCESS_TOKEN column length is defined as 512 [1] which is not >> enough to store self-contained access token [2]. >> >> Shall we increase the column size by default? >> >> Thanks >> Isura. >> >> >> [1] >> CREATE TABLE IF NOT EXISTS IDN_OAUTH2_ACCESS_TOKEN ( >> TOKEN_ID VARCHAR (255), >> ACCESS_TOKEN VARCHAR(512), >> REFRESH_TOKEN VARCHAR(512), >> CONSUMER_KEY_ID INTEGER, >> AUTHZ_USER VARCHAR (100), >> TENANT_ID INTEGER, >> USER_DOMAIN VARCHAR(50), >> USER_TYPE VARCHAR (25), >> GRANT_TYPE VARCHAR (50), >> TIME_CREATED TIMESTAMP DEFAULT 0, >> REFRESH_TOKEN_TIME_CREATED TIMESTAMP DEFAULT 0, >> VALIDITY_PERIOD BIGINT, >> REFRESH_TOKEN_VALIDITY_PERIOD BIGINT, >> TOKEN_SCOPE_HASH VARCHAR(32), >> TOKEN_STATE VARCHAR(25) DEFAULT 'ACTIVE', >> TOKEN_STATE_ID VARCHAR (128) DEFAULT 'NONE', >> SUBJECT_IDENTIFIER VARCHAR(255), >> PRIMARY KEY (TOKEN_ID), >> FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES >> IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE, >> CONSTRAINT CON_APP_KEY UNIQUE (CONSUMER_KEY_ID,AUTHZ_USER,TE >> NANT_ID,USER_DOMAIN,USER_TYPE,TOKEN_SCOPE_HASH, >> TOKEN_STATE,TOKEN_STATE_ID) >> >> >> [2] https://wso2.org/jira/browse/IDENTITY-6917 >> >> >> -- >> >> *Isura Dilhara Karunaratne* >> Associate Technical Lead | WSO2 >> Email: is...@wso2.com >> Mob : +94 772 254 810 <+94%2077%20225%204810> >> Blog : http://isurad.blogspot.com/ >> >> >> >> > > > -- > > *Isura Dilhara Karunaratne* > Associate Technical Lead | WSO2 > Email: is...@wso2.com > Mob : +94 772 254 810 <+94%2077%20225%204810> > Blog : http://isurad.blogspot.com/ > > > > -- Thanks & Regards, *Johann Dilantha Nallathamby* Senior Lead Solutions Engineer WSO2, Inc. lean.enterprise.middleware Mobile - *+94777776950* Blog - *http://nallaa.wordpress.com <http://nallaa.wordpress.com>*
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
