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] <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/da3f4ef4-8fee-4955-b30e-a13c8f294aea%40apereo.org.
