Maybe you can find something interesting in this docs:
Property: cas.authn.mfa.gauth.jpa.database.autocommit=false
Type: java.lang.Boolean
The default auto-commit behavior of connections in the pool. Determined
whether queries such as update/insert should be immediately executed
without waiting for an underlying transaction.
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.batch-size=5
Type: java.lang.Integer
A non-zero value enables use of JDBC2 batch updates by Hibernate. e.g.
recommended values between 5 and 30.
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.data-source-name=null
Type: java.lang.String
Attempts to do a JNDI data source look up for the data source name
specified. Will attempt to locate the data source object as is, or will try
to return a proxy instance of it, in the event that See #dataSourceProxy is
used.
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.data-source-proxy=false
Type: java.lang.Boolean
Indicates whether JNDI data sources retrieved should be proxied or returned
back verbatim.
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.ddl-auto=create-drop
Type: java.lang.String
Hibernate feature to automatically validate and exports DDL to the schema.
By default, creates and drops the schema automatically when a session is
starts and ends
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.default-catalog=null
Type: java.lang.String
Qualifies unqualified table names with the given catalog in generated SQL.
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.default-schema=null
Type: java.lang.String
Qualify unqualified table names with the given schema/tablespace in
generated SQL.
------------------------------
Property:
cas.authn.mfa.gauth.jpa.database.dialect=org.hibernate.dialect.HSQLDialect
Type: java.lang.String
The database dialect is a configuration setting for platform independent
software (JPA, Hibernate, etc) which allows such software to translate its
generic SQL statements into vendor specific DDL, DML.
------------------------------
Property:
cas.authn.mfa.gauth.jpa.database.driver-class=org.hsqldb.jdbcDriver
This property is required.
Type: java.lang.String
The JDBC driver used to connect to the database.
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.fail-fast-timeout=1
Type: java.lang.Long
Set the pool initialization failure timeout.
- Any value greater than zero will be treated as a timeout for pool
initialization. The calling thread will be blocked from continuing until a
successful connection to the database, or until the timeout is reached. If
the timeout is reached, then a PoolInitializationException; they will be
honored before this timeout is applied. The default value is one
millisecond.
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.health-query=null
Type: java.lang.String
The SQL query to be executed to test the validity of connections.
------------------------------
Property:
cas.authn.mfa.gauth.jpa.database.isolate-internal-queries=false
Type: java.lang.Boolean
This property determines whether data source isolates internal pool
queries, such as the connection alive test, in their own transaction.
Since these are typically read-only queries, it is rarely necessary to
encapsulate them in their own transaction. This property only applies if See
#autocommit is disabled.
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.leak-threshold=3000
Type: java.lang.Integer
Controls the amount of time that a connection can be out of the pool
before a message is logged indicating a possible connection leak.
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.password=null
This property is required.
Type: java.lang.String
The database connection password.
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.pool=null
Type:
org.apereo.cas.configuration.model.support.ConnectionPoolingProperties
Database connection pooling settings.
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.properties=null
Type: java.util.Map
Additional settings provided by Hibernate in form of key-value pairs. See
org.hibernate.cfg.AvailableSettings
------------------------------
Property:
cas.authn.mfa.gauth.jpa.database.url=jdbc:hsqldb:mem:cas-hsql-database
This property is required.
Type: java.lang.String
The database connection URL.
------------------------------
Property: cas.authn.mfa.gauth.jpa.database.user=sa
This property is required.
Type: java.lang.String
The database user. The database user must have sufficient permissions to
be able to handle schema changes and updates, when needed.
2018-02-16 1:47 GMT+01:00 Ray Bon <[email protected]>:
> 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]] *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 <(250)%20721-8831> | 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>
> .
>
> --
> Ray Bon
> Programmer analyst
> Development Services, University Systems2507218831 <(250)%20721-8831> | 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
> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/1518742038.1763.24.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/CABeW3hR%3DiY2CEkT4smG7nbQasWTbVZJjOuQkf2wSxp7%3DQ%2BLf4w%40mail.gmail.com.
