Gauth Scratch Codes - Issue with encrypted values?

[Agus Santosa]

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?