Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Review size of jansAuthData column #1105

Open
jgomer2001 opened this issue Mar 24, 2022 · 0 comments
Open

Review size of jansAuthData column #1105

jgomer2001 opened this issue Mar 24, 2022 · 0 comments
Assignees
Labels
comp-jans-fido2 Component affected by issue or PR needs-triage Issue or PR yet to be triaged. Add more labels or details that will help during triage review.
Milestone

Comments

@jgomer2001
Copy link
Contributor

Let's ensure jansAuthData (in jansFido2AuthnEntry table) has a proper size. Formerly I set it 512 chars but now it is complaining again (data too long for this column).

This is a real world example value:
'{"createdDate":1648164383524,"updatedDate":1648164402918,"createdBy":"admin","updatedBy":"admin","id":null,"username":"admin","domain":"jans.kt.co","userId":null,"challenge":"5bojCmdDJspm91yEELyqgXfHio0-xw3AfbqjRImUGcI","assertionRequest":"{\"username\":\"admin\"}","assertionResponse":"{\"type\":\"public-key\",\"id\":\"GVoGcfY6MwWWUb_Jr2Z_M-H37BZGQavlFDBVVYIzOc_jzkBiiLcgKQRqk1fQTIbezTMqicuqORPMZVVNHq6iLQ\",\"rawId\":\"GVoGcfY6MwWWUb_Jr2Z_M-H37BZGQavlFDBVVYIzOc_jzkBiiLcgKQRqk1fQTIbezTMqicuqORPMZVVNHq6iLQ\",\"response\":{\"authenticatorData\":\"Nt89clLioIPkoUWKqdeNCV4PJMiYDHtNnOnde3UYNowFAAAAmw\",\"clientDataJSON\":\"eyJjaGFsbGVuZ2UiOiI1Ym9qQ21kREpzcG05MXlFRUx5cWdYZkhpbzAteHczQWZicWpSSW1VR2NJIiwib3JpZ2luIjoiaHR0cHM6Ly9qYW5zLmt0LmNvIiwidHlwZSI6IndlYmF1dGhuLmdldCJ9\",\"signature\":\"MEQCIF45XOqOZZzLR2rRFYpCL5HbgEhC2LnKdyFPKyi8SJePAiBE3AZwtXuJ-S1fvt4VBiL-WPdYsU5nPqoLxMeLThVcRw\",\"userHandle\":null},\"clientExtensionResults\":{}}","userVerificationOption":"preferred","status":"authenticated"}'

Does the json content grow in time with authentication attempts?

@jgomer2001 jgomer2001 added comp-jans-fido2 Component affected by issue or PR needs-triage Issue or PR yet to be triaged. Add more labels or details that will help during triage review. labels Mar 24, 2022
@moabu moabu added this to the 1.0.1 milestone Jun 15, 2022
@moabu moabu modified the milestones: 1.0.1, 1.0.2 Jul 8, 2022
@moabu moabu modified the milestones: 1.0.2, 1.0.3 Aug 30, 2022
@moabu moabu modified the milestones: 1.0.3, 1.0.4 Nov 3, 2022
@moabu moabu modified the milestones: 1.0.4, 1.0.5 Nov 14, 2022
@moabu moabu modified the milestones: 1.0.5, 1.0.6 Dec 1, 2022
@moabu moabu modified the milestones: 1.0.6, 1.0.7 Jan 9, 2023
@moabu moabu modified the milestones: 1.0.7, 1.0.8, 1.0.9 Mar 1, 2023
@moabu moabu modified the milestones: 1.0.9, 1.0.10 Mar 9, 2023
@moabu moabu modified the milestones: 1.0.10, 1.0.11 Mar 16, 2023
@moabu moabu modified the milestones: 1.0.11, 1.0.12 Apr 5, 2023
@moabu moabu modified the milestones: 1.0.12, 1.0.13 Apr 18, 2023
@moabu moabu removed this from the 1.0.13 milestone May 10, 2023
@moabu moabu added this to the 1.0.14 milestone May 10, 2023
@moabu moabu modified the milestones: 1.0.14, 1.0.15 Jun 20, 2023
@moabu moabu modified the milestones: 1.0.15, 1.0.16 Jul 12, 2023
@moabu moabu modified the milestones: 1.0.16, 1.0.17 Aug 2, 2023
@moabu moabu modified the milestones: 1.0.17, 1.0.18 Sep 18, 2023
@moabu moabu modified the milestones: 1.0.18, 1.0.21 Nov 22, 2023
@moabu moabu modified the milestones: 1.0.21, 1.0.22 Dec 14, 2023
@moabu moabu modified the milestones: 1.0.22, 1.0.23 Feb 1, 2024
@moabu moabu modified the milestones: 1.1.0, 1.1.1 Mar 14, 2024
@moabu moabu modified the milestones: 1.1.1, 1.1.2 May 1, 2024
@moabu moabu modified the milestones: 1.1.2, 1.1.3 May 29, 2024
@moabu moabu modified the milestones: 1.1.3, 1.1.4 Jul 8, 2024
@moabu moabu modified the milestones: 1.1.4, 1.1.5 Sep 3, 2024
@moabu moabu modified the milestones: 1.1.5, 1.1.6 Sep 16, 2024
@moabu moabu modified the milestones: 1.1.6, next-release Nov 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
comp-jans-fido2 Component affected by issue or PR needs-triage Issue or PR yet to be triaged. Add more labels or details that will help during triage review.
Projects
None yet
Development

No branches or pull requests

3 participants