kamiyariko opened a new issue, #7702: URL: https://github.com/apache/incubator-devlake/issues/7702
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened I want to configure Jira Cloud connection settings using the REST API. However, when executing the following command, I encounter an error indicating that the token length is too long: curl -X 'POST' \ 'https://devlake.xxxxx/api/plugins/jira/connections' \ -H 'accept: application/json' \ -H 'Content-Type: application/json' \ -d '{ "authMethod": "BasicAuth", "endpoint": "https://xxxxx.atlassian.net/rest/";, "name": "jira-test-connection", "password": "{jira-password}", "proxy": "", "rateLimitPerHour": 0, "token": "{jira-token}", "username": "{jira-username}" }' The error message received is: `{ "code": 0, "success": false, "message": "Error 1406 (22001): Data too long for column 'token' at row 1 (500)\nWraps: (2) Error 1406 (22001): Data too long for column 'token' at row 1\nError types: (1) *hintdetail.withDetail (2) *mysql.MySQLError", "causes": null, "data": null } ` Jira personal access tokens are 192 characters long, but attempting to use a token of 169 characters or more results in this error. Does Devlake support tokens of this length? ### What do you expect to happen I expect to be able to configure the Jira connection successfully by including the token in the request. ### How to reproduce After executing the command provided earlier to set up the Jira Cloud connection, I attempted to test the connection using the following command: curl -X 'POST' \ 'https://devlake.xxxxx/api/plugins/jira/connections/{connectionId}/test' \ -H 'accept: application/json' \ -H 'Content-Type: application/json' ### Anything else https://support.atlassian.com/atlassian-account/docs/manage-api-tokens-for-your-atlassian-account/ Following the documentation, using the token name as the username allows the request to go through, but results in a "Please check your credential (401)" error: curl -X 'POST' \ 'https://devlake.xxxxx/api/plugins/jira/connections' \ -H 'accept: application/json' \ -H 'Content-Type: application/json' \ -d '{ "authMethod": "BasicAuth", "endpoint": "https://xxxxx.atlassian.net/rest/";, "name": "jira-test-connection", "password": "{jira-password}", "proxy": "", "rateLimitPerHour": 0, "token": "{jira-token}", "username": "{jira-username}" }' \ -u '{jira-username}:{token-label}' Jira's official documentation also assumes that applications will support token lengths: https://community.atlassian.com/t5/Jira-Service-Management/How-to-generate-a-token-with-less-than-128-characters/qaq-p/2373530 ### Version v.1.0.0-beta10 ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
