audited icon indicating copy to clipboard operation
audited copied to clipboard

Type JSON not working for MariaDB

Open chmich opened this issue 1 year ago • 0 comments

Hi

MariaDB 10.11.3, audited 5.3.3

I had the error Psych::DisallowedClass: Tried to load unspecified class: ActiveSupport::BigDecimal.

Regarding to issue 67912150 Psych::DisallowedClass i switched to to json.

But didnt change anything.

Problem:

MariaDB marks column type :json as :longtext, see Stackoverflow

Unlike mySql, MariaDB marks json types as longtext, see mariadb json or Stackoverflow.

Could it be that for this reason audited is not able to recognize json as a data type?

Would it be an idea to have a config to override the detection based on column type and tell audited to handle audits as json?

Thanks, Chris

chmich avatar Jun 02 '23 09:06 chmich