Tim, Once your tables are created you can change the value to anything and the tables will not be touched. (Try 'none' or 'dummy'.) With create, the tables are created every time but not dropped (on close). update will also work and will leave the tables untouched unless something changes, operating only during an upgrade (unless you are actively make changes to domain classes).
Ray On Thu, 2018-02-15 at 15:59 -0600, Tim Tyler wrote: 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]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Ray Bon Sent: Thursday, February 15, 2018 3:15 PM To: [email protected]<mailto:[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]<mailto:[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]<mailto:[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>. -- 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/1518742038.1763.24.camel%40uvic.ca.
