Ray, YES! That fixed that aspect by using create for the value. Except now we are finding that the data entries are now removed on startup though the tables remain. Are we also missing something for startup that cleans. Or should we use update instead of create?
Tim *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Ray Bon *Sent:* Thursday, February 15, 2018 3:15 PM *To:* [email protected] *Subject:* Re: [cas-user] CAS google-authenticator removes tables??? Tim, Check your database settings, something along the lines of 'ddlAuto'. It can be set to 'create-drop' which would result in the behaviour you are seeing. Search for JPA options to see what other settings are available. Ray On Thu, 2018-02-15 at 14:51 -0600, Tim Tyler wrote: CAS experts, We are running CAS 5.2 on Redhat 7. We installed and configured Google Authenticator and got it sort of working with Mariadb. We see the tables and record entries get created and entered into the database when logging in. But when we cntrl-C to restart the CAS service, CAS removes the tables from the database: MariaDB [mfa]> select * from GoogleAuthenticatorRegistrationRecord; ERROR 1146 (42S02): Table 'mfa.GoogleAuthenticatorRegistrationRecord' doesn't exist Why does control-C shutting down CAS result in removing all of the tables and entries? FYI: We startup with ./build.sh run and we shutdown with Ctrl-C. Tim Tyler Network Engineer Beloit College -- Ray Bon Programmer analyst Development Services, University Systems 2507218831 | CLE 019 | [email protected] -- - 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 [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/1518729293.1763.19.camel%40uvic.ca <https://groups.google.com/a/apereo.org/d/msgid/cas-user/1518729293.1763.19.camel%40uvic.ca?utm_medium=email&utm_source=footer> . -- - 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 [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/f8c9636292e1e76a7c660b9be0c76797%40mail.gmail.com.
