Can you tell me which class need to be changed so that right queries are send to MySQL? I manually created table in database but now when CAS want's to insert I received error because of reserved words in MySQL (key and date).
Jurica On Wednesday, 16 August 2017 12:55:30 UTC+2, Matt Elson wrote: > > On 08/15/2017 04:47 PM, Matt Elson wrote: > > > Both look like the SQL statements are getting incorrectly formed or > > truncated in some format; going to be firing up more debugging on > > mariadb/mysql side of things and will try other DBs later. > > > > Just figured I'd throw it out there in case the underlying cause of this > > new issue of mine is a really obvious one. > > Turns out it's pretty simple. > > The fields "date" and "key" are reserved words in mysql/mariadb and > aren't being quoted/backticked properly so causing the SQL errors. > Changing the names to something like trustedDate and trustedKey in > MultiFactorAuthenticationRecord and altering the explicit SQL queries > in JpaMultifactorAuthenticationTrustStorage accordingly causes the DDL > and subsequent inserts to succeed in my brief testing. > > While playing with that, a length of 255 isn't sufficient for the key > value once encryption takes place; had to bump it up to 1000 or so. > > Not familiar with hibernate so not sure if it's supposed to take care of > this sort of quoting/escaping, so not sure who to report this seeming > bug to. > > Matt > > -- > - CAS gitter chatroom: https://gitter.im/apereo/cas > - CAS mailing list guidelines: > https://apereo.github.io/cas/Mailing-Lists.html > - CAS documentation website: https://apereo.github.io/cas > - CAS project website: https://github.com/apereo/cas > --- > 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] <javascript:>. > To view this discussion on the web visit > https://groups.google.com/a/apereo.org/d/msgid/cas-user/458110c3-b065-e8a2-052f-140025781224%40fastmail.net. > > > -- - CAS gitter chatroom: https://gitter.im/apereo/cas - CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html - CAS documentation website: https://apereo.github.io/cas - CAS project website: https://github.com/apereo/cas --- 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 on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/7b52c270-4db1-49bf-adb0-e9b9d4167ddc%40googlegroups.com.
