It is Microsoft SQL Server 12.0.4213 which I thought matched up with
cas.authn.mfa.trusted.jpa.dialect=org.hibernate.dialect.SQLServer2012Dialect
I've also found that if I modify cas.authn.mfa.trusted.timeUnit to anything
other than "DAYS" (such as MINUTES, SECONDS, or HOURS), I get an error like
below. I'm not sure if some date/time issue is going on here?
cas.authn.mfa.trusted.timeUnit=DAYS
Caused by: java.time.temporal.UnsupportedTemporalTypeException: Unsupported
unit: Seconds
Caused by: java.time.temporal.UnsupportedTemporalTypeException: Unsupported
unit: Minutes
On Tuesday, February 20, 2018 at 12:34:03 PM UTC-5, rbon wrote:
>
> Justin,
>
> Looks like there is a disconnect between the hibernate generated query and
> the db. What database is this?
> Perhaps the hibernate dialect is mismatched.
>
> Ray
>
> On Tue, 2018-02-20 at 06:56 -0800, Justin Andrews wrote:
>
> Some progress, the SQL DBA noticed the query coming in included the date
> as '2018-02-20 00:00:00'
>
> So he modified the column for recordDate from timestamp to datetime and
> the insert then works, but then nothing else works, the selects and deletes
> and maintenance of that table is now broken. I have no idea why it's trying
> to do datetime vs timestamp, is that in the config anywhere?
>
> On Thursday, February 15, 2018 at 7:50:35 PM UTC-5, rbon wrote:
>
> Justin,
>
> It may be possible to see the values that will replace the '?'. Perhaps
> the next few log lines will display the values. The '?' are just there as
> placeholders.
>
> Ray
>
> On Thu, 2018-02-15 at 14:13 -0800, Justin Andrews wrote:
>
> Here is another portion of the log showing that it knows who I am, but the
> SQL select query doesn't know who I am.
>
> 2018-02-15 16:01:35,843 WARN
> [org.apereo.cas.trusted.web.flow.MultifactorAuthenticationVerifyTrustAction]
> - <Retrieving trusted authentication records for [jandrews] that are
> on/after [2018-01-16]>
> 2018-02-15 16:01:35,844 DEBUG
> [org.springframework.orm.jpa.JpaTransactionManager] - <Creating new
> transaction with name
> [org.apereo.cas.trusted.authentication.storage.JpaMultifactorAuthenticationTrustStorage.get]:
>
> PROPAGATION_REQUIRED,ISOLATION_DEFAULT; 'transactionManagerMfaAuthnTrust'>
> 2018-02-15 16:01:35,844 DEBUG
> [org.springframework.orm.jpa.JpaTransactionManager] - <Opened new
> EntityManager
> [SessionImpl(PersistenceContext[entityKeys=[],collectionKeys=[]];ActionQueue[insertions=ExecutableList{size=0}
>
> updates=ExecutableList{size=0} deletions=ExecutableList{size=0}
> orphanRemovals=ExecutableList{size=0}
> collectionCreations=ExecutableList{size=0}
> collectionRemovals=ExecutableList{size=0}
> collectionUpdates=ExecutableList{size=0}
> collectionQueuedOps=ExecutableList{size=0}
> unresolvedInsertDependencies=null])] for JPA transaction>
> 2018-02-15 16:01:35,844 DEBUG
> [org.hibernate.engine.transaction.internal.TransactionImpl] - <begin>
> 2018-02-15 16:01:35,848 DEBUG
> [org.springframework.orm.jpa.JpaTransactionManager] - <Exposing JPA
> transaction as JDBC transaction
> [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@6214c800]>
> 2018-02-15 16:01:35,848 DEBUG
> [org.springframework.orm.jpa.JpaTransactionManager] - <Found thread-bound
> EntityManager
> [SessionImpl(PersistenceContext[entityKeys=[],collectionKeys=[]];ActionQueue[insertions=ExecutableList{size=0}
>
> updates=ExecutableList{size=0} deletions=ExecutableList{size=0}
> orphanRemovals=ExecutableList{size=0}
> collectionCreations=ExecutableList{size=0}
> collectionRemovals=ExecutableList{size=0}
> collectionUpdates=ExecutableList{size=0}
> collectionQueuedOps=ExecutableList{size=0}
> unresolvedInsertDependencies=null])] for JPA transaction>
> 2018-02-15 16:01:35,849 DEBUG
> [org.springframework.orm.jpa.JpaTransactionManager] - <Participating in
> existing transaction>
> 2018-02-15 16:01:35,849 DEBUG [org.hibernate.SQL] - <
> select
> multifacto0_.id as id1_0_,
> multifacto0_.geography as geograph2_0_,
> multifacto0_.name as name3_0_,
> multifacto0_.principal as principa4_0_,
> multifacto0_.recordDate as recordDa5_0_,
> multifacto0_.recordKey as recordKe6_0_
> from
> databasename.dbo.MultifactorAuthenticationTrustRecord multifacto0_
> where
> multifacto0_.principal=?>
>
>
>
> On Thursday, February 15, 2018 at 4:53:35 PM UTC-5, Justin Andrews wrote:
>
> 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
>
> --
> Ray Bon
> Programmer analyst
> Development Services, University Systems
> 2507218831 | CLE 019 | [email protected]
>
>
> --
> Ray Bon
> Programmer analyst
> Development Services, University Systems
> 2507218831 | CLE 019 | [email protected] <javascript:>
>
>
--
- 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/803e34ae-cbed-4ef7-8cd3-28a94fc4d779%40apereo.org.
