Data too long for column 'access_token' at row 1: UPDATE `oic_sessions` SET `access_token`

[Ronald B]

Hello,

I'm running the last version of redmine + the last version of the redmine openid connect plugin but failed to get it working.

I have appropriate sso redirects but then I get the following error in the logs: Data too long for column 'access_token' at row 1: UPDATE oic_sessions SET access_token

eyJhbGciOiJSUyI1NiIsInR5cCIgOiAiSldUIiwia2lkIiA6ICJsM28wNGs3bGFfZmM2N2k1VzA5OU5LUC12cFlwekpzdm53TnAwWVo1YnBBIn0.eyJqdGkiOiI2ODgwNzlmMS04ZTI4LTQ5MmUtYjNiNy1lMmVmOTY0ZmU0M2EiLCJleHAiOjE0OTMxMDY4NDYsIm5iZiI6MCwiaWF0IjoxNDkzMTA2NTQ2LCJpc3MiOiJodHRwOi8vd2Vic3NvLWVmc2Eub3BlbnFuYWx5dGljcy5ldS9hdXRoL3JlYWxtcy9lZnNhIiwiYXVkIjoicmVkbWluZSIsInN1YiI6ImExZWUxODU0LTdmMzUtNGE4NC04NmVkLTQ3ZjhhYzk0ZTdjMCIsInR5cCI6IkJlYXJlciIsImF6cCI6InJlZG1pbmUiLCJub25jZSI6ImExYjFjOGY3LWU3ZjItNDBiNy1hZjRmLTUzOTAwOTAwM2MwNyIsImF1dGhfdGltZSI6MTQ5MzEwNjM2NCwic2Vzc2lvbl9zdGF0ZSI6IjI3MzQ1NWUyLTdlMTAtNDg0ZS1iOTZhLWU1ZWIwYTUxY2Q5YSIsImFjciI6IjAiLCJjbGllbnRfc2Vzc2lvbiI6IjkxNzVlY2MwLWY1ZWYtNGM1NS04YWM5LTgzYWU3MWNkOGVkOCIsImFsbG93ZWQtb3JpZ2lucyI6WyIiXSwicmVhbG1fYWNjZXNzIjp7InJvbGVzIjpbInVtYV9hdXRob3JpemF0aW9uIl19LCJyZXNvdXJjZV9hY2Nlc3MiOnsiYWNjb3VudCI6eyJyb2xlcyI6WyJtYW5hZ2UtYWNjb3VudCIsIm1hbmFmZS1hY2NvdW50LWxpbmtzIiwidmlldy1wcm9maWxlIl19fSwidXNlcl9uYW1lIjoicmJpc3RlciIsIm5hbWUiOiJSb25hbGQgQmlzdGVyIEJpc3RlciIsImdpdmVuX25hbWUiOiJSb25hbGQgQmlzdGVyIiwibWVtYmVyX29mIjoiW10iLCJmYW1pbHlfbmFtZSI6IkJpc3RlciIsImVtYWlsIjoicm9uYWxkLmJpc3RlckBvcGVuYW5hbHl0aWNzLmV1In0.KFepjhGSikMCWIyPOvmK4QzB_4XD5pXAq9bguOWbXkw7vHIM478CbkKoAJchHtnoxlwrW8e2JPmUKYg-8_-KaG2XvPAyO8AnM-fiq8zBn4y7f4r20sbx6wFIqDMr8IRSeivsqPnxtfS-3y0LYSMFuAMQ_j0-OdRKXVJjQoqzRgdKNMqBRNbIoMhCpnw9df6buxOqPUiADbseifzV1CvRed4NPzvxv-YRkR7qc9N_qvv21IyxsZBwuZmXAjb6VdQ5K0ekHT7yAbgdskTP0qubN9E-F58bPYsCVdd1HXFUZLESCvEnU1GQyq5GyuEnahD4PeRcauQFf2EZMR5-sMjaqg'

any suggestion?

thanks in advance

[Markus M. May]

The field access_token is defined as varchar(255), which is usually enough. What OpenId system are you using?