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]<javascript:>
--
Ray Bon
Programmer analyst
Development Services, University Systems
2507218831 | 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/1519148034.1765.43.camel%40uvic.ca.
