Have configured MFA - works great with JSON storage file, but when
configuring JDBC, the values are always question marks.... any ideas?
Caused by: java.sql.SQLException: Cannot insert an explicit value into a
timestamp column. Use INSERT with a column list to exclude the timestamp
column, or insert a DEFAULT into the timestamp column.
2018-02-15 15:45:08,024 DEBUG [org.hibernate.SQL] - <
insert
into
databasename.dbo.MultifactorAuthenticationTrustRecord
(geography, name, principal, recordDate, recordKey)
values
(?, ?, ?, ?, ?)>
cas.authn.mfa.trusted.jpa.healthQuery=select 1
cas.authn.mfa.trusted.jpa.isolateInternalQueries=false
cas.authn.mfa.trusted.jpa.url=jdbc:jtds:sqlserver://databaseserverFQDN/databasename
cas.authn.mfa.trusted.jpa.failFastTimeout=1
cas.authn.mfa.trusted.jpa.dialect=org.hibernate.dialect.SQLServer2012Dialect
cas.authn.mfa.trusted.jpa.leakThreshold=10
cas.authn.mfa.trusted.jpa.batchSize=1
cas.authn.mfa.trusted.jpa.defaultCatalog=databasename
cas.authn.mfa.trusted.jpa.defaultSchema=dbo
cas.authn.mfa.trusted.jpa.user=svcCAS
#cas.authn.mfa.trusted.jpa.ddlAuto=create-drop
cas.authn.mfa.trusted.jpa.ddlAuto=validate
cas.authn.mfa.trusted.jpa.password=redacted
cas.authn.mfa.trusted.jpa.autocommit=false
cas.authn.mfa.trusted.jpa.driverClass=net.sourceforge.jtds.jdbc.Driver
cas.authn.mfa.trusted.jpa.idleTimeout=5000
#cas.authn.mfa.trusted.jpa.dataSourceName=
#cas.authn.mfa.trusted.jpa.dataSourceProxy=false
# Hibernate-specific properties (i.e.
`hibernate.globally_quoted_identifiers`)
#cas.authn.mfa.trusted.jpa.properties.propertyName=propertyValue
cas.authn.mfa.trusted.jpa.pool.suspension=false
cas.authn.mfa.trusted.jpa.pool.minSize=6
cas.authn.mfa.trusted.jpa.pool.maxSize=18
cas.authn.mfa.trusted.jpa.pool.maxWait=2000
--
- 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/3bdab86f-591a-44c9-9283-eeb6b25d8f7c%40apereo.org.
