We're having the same issue with DUO MFA and remember device. Is there a work around? I checked in GitHub, it appears this issue was never entered in GitHub so I did that: https://github.com/apereo/cas/issues/2998
Can anyone provide us with a work around, or at least the list of classes to be updated? On Tue, Aug 22, 2017 at 6:16 AM, Jurica Juren <jurica.ju...@gmail.com> wrote: > 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/M >> ailing-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 cas-user+u...@apereo.org. >> To view this discussion on the web visit https://groups.google.com/a/ap >> ereo.org/d/msgid/cas-user/458110c3-b065-e8a2-052f-1400257812 >> 24%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 cas-user+unsubscr...@apereo.org. > 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 > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/7b52c270-4db1-49bf-adb0-e9b9d4167ddc%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Andrew Tillinghast Sr. Web Developer atill...@conncoll.edu 270 Mohegan Avenue New London, CT 06320-4196 Ph:860 439-5265 Fax: 860 439-2871 P *Think before you print*CONFIDENTIALITY: This email (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this email in error, please notify the sender and delete this email from your system. -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/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 cas-user+unsubscr...@apereo.org. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAGA6n_%3DKo29jFdLN%2By6%3DdfuUHva6Z-ovryY_ybRFeYe%2BPL0yHw%40mail.gmail.com.
