Hi,
I am using CAS 7.1.0 trying to implement MFA with Google Authenticator.
The scratch codes work fine if I do not enable the encryption key.
Once I enable it, it is no longer working.
In Oracle, it stores the value in database, albeit incorrectly:
2024-11-18 12:22:20,145 TRACE [org.hibernate.orm.jdbc.bind] - <binding
parameter (2:NUMERIC) <-
[9384757230060153264896703075347086368652485274217484744991093912707123982772223679665966928147250745785118824086350172520496]>
ID
--------------------------------------------------
SCRATCH_CODES
--------------------------------------------------
52
9.3847572300601532648967030753470863686520000E+123
In MySQL it simply refuses to store the value, because the value is too big.
I notice the database column type is numeric (19,0) in Oracle.
If it is encrypted, the numeric value is simply too big to be handled by
any database.
Should this be treated as varchar instead?
--
- Website: https://apereo.github.io/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
---
You received this message because you are subscribed to the Google Groups "CAS
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/60c7721f-fbce-4338-bcc9-233d2553bdaan%40apereo.org.
