CAS Experts, I am trying to setup Google Authenticator for MFA purposes. It works fine in memory mode. So now we want to install persistence for it on MariaDB. So here is what we did.
1. We installed Mariadb and initiated it. 2. We created a database named "mfa" to store the registries. 3. We have no idea what the schema should look like so we didn't create anything else. 4. We configured ca.properties with cas.authn.mfa.trusted.jpa.url=jdbc:mariadb://localhost:1489/mfa cas.authn.mfa.trusted.jpa.dialect=org.hibernate.dialect.MariaDBDialect cas.authn.mfa.trusted.jpa.user=root cas.authn.mfa.trusted.jpa.password=xxxxxxx cas.authn.mfa.trusted.jpa.driverClass=org.mariadb.jdbc.Driver So do we need a schema or does it get created automatically –and how? When I login to CAS, we don't see any evidence of database changes, etc. There are no tables in the mfa database. But we still get the following error on CAS output: <SQL Warning Code: -1100, SQLState: 02000> 2018-01-23 15:19:24,808 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - <no data> What might we be missing or might be wrong? Tim Tyler Network Engineer Beloit College -- - 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/324d6ed73e1fade42c7d91b9b1d82b03%40mail.gmail.com.
