Hi Michele,
I have tried that. -
https://apereo.github.io/cas/5.3.x/installation/JPA-Ticket-Registry.html
But I am getting error. Any Idea ?
CAS config.
cas.ticket.registry.jpa.ticketLockType=NONE
cas.ticket.registry.jpa.jpaLockingTimeout=3600
cas.ticket.registry.jpa.dialect=org.hibernate.dialect.MySQLDialect
cas.ticket.registry.jpa.driverClass=com.mysql.jdbc.Driver
cas.ticket.registry.jpa.isolateInternalQueries=false
cas.ticket.registry.jpa.url=jdbc:mysql://localhost:3306/lportal?useSSL=false
cas.ticket.registry.jpa.leakThreshold=10
cas.ticket.registry.jpa.batchSize=10
cas.ticket.registry.jpa.ddlAuto=none
cas.ticket.registry.jpa.user=root
cas.ticket.registry.jpa.password=root
cas.ticket.registry.jpa.autocommit=false
cas.ticket.registry.jpa.idleTimeout=5000
cas.ticket.registry.jpa.dataSourceProxy=false
cas.ticket.registry.jpa.pool.suspension=false
Error log.
2020-03-18 11:28:15,272 ERROR
[org.hibernate.engine.jdbc.batch.internal.BatchingBatch] - <HHH000315:
Exception executing batch [java.sql.BatchUpdateException: Incorrect integer
value:
'TGT-2-********************************************************gT2mfBHV-GwGIT59-NB'
for column 'id' at row 1], SQL: insert into TICKETGRANTINGTICKET
(NUMBER_OF_TIMES_USED, CREATION_TIME, EXPIRATION_POLICY, EXPIRED,
LAST_TIME_USED, PREVIOUS_LAST_TIME_USED, AUTHENTICATION,
DESCENDANT_TICKETS, PROXIED_BY, PROXY_GRANTING_TICKETS,
SERVICES_GRANTED_ACCESS_TO, ticketGrantingTicket_ID, TYPE, ID) values (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'TGT', ?)>
2020-03-18 11:28:15,272 ERROR
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - <Incorrect integer
value:
'TGT-2-********************************************************gT2mfBHV-GwGIT59-NB'
for column 'id' at row 1>
2020-03-18 11:28:15,273 ERROR
[org.hibernate.internal.ExceptionMapperStandardImpl] - <HHH000346: Error
during managed flush [org.hibernate.exception.GenericJDBCException: could
not execute batch]>
2020-03-18 11:28:15,274 DEBUG
[org.apereo.cas.web.FlowExecutionExceptionResolver] - <Ignoring the
received exception due to a type mismatch>
org.springframework.webflow.execution.ActionExecutionException: Exception
thrown executing
org.apereo.cas.web.flow.login.CreateTicketGrantingTicketAction@690b3795 in
state 'createTicketGrantingTicket' of flow 'login' -- action execution
attributes were 'map[[empty]]'
at
org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:62)
~[spring-webflow-2.5.0.RELEASE.jar:2.5.0.RELEASE]
at
org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:77)
~[spring-webflow-2.5.0.RELEASE.jar:2.5.0.RELEASE]
Caused by: java.sql.BatchUpdateException: Incorrect integer value:
'TGT-2-nM7SNGtvm3oZmXABB-1NXUrbJM-p74N5fBA7X8s-CL7Un84jzkWTWwydgT2mfBHV-GwGIT59-NB'
for column 'id' at row 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method) ~[?:1.8.0_171]
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
~[?:1.8.0_171]
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[?:1.8.0_171]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
~[?:1.8.0_171]
at com.mysql.cj.util.Util.handleNewInstance(Util.java:210)
~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.util.Util.getInstance(Util.java:185)
~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.util.Util.getInstance(Util.java:192)
~[mysql-connector-java-8.0.11.jar:8.0.11]
at
com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:218)
~[mysql-connector-java-8.0.11.jar:8.0.11]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:864)
~[mysql-connector-java-8.0.11.jar:8.0.11]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:453)
~[mysql-connector-java-8.0.11.jar:8.0.11]
at
com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:839)
~[mysql-connector-java-8.0.11.jar:8.0.11]
at
com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
~[HikariCP-3.2.0.jar:?]
at
com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
~[HikariCP-3.2.0.jar:?]
at
org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:118)
~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at
org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:104)
~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at
org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147)
~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:212)
~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:629)
~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:474)
~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at
org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1437)
~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at
org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:494)
~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3245)
~[hibernate-core-5
On Tuesday, March 17, 2020 at 6:04:44 PM UTC+8, Michele Melluso wrote:
>
> Hi Sk,
>
> i think I had your same problem and I solved this way:
>
>
> https://groups.google.com/a/apereo.org/forum/?utm_medium=email&utm_source=footer#!topic/cas-user/i_ImAVPB6jE
>
> regards
> Michele
>
> On Tuesday, March 17, 2020 at 11:00:45 AM UTC+1, SK wrote:
>>
>> Using CAS + Google Authenticator + Mysql (JPA)
>>
>> Able to register and verify users successfully. But once restart the cas
>> server, again ask to scan the bar code ?
>> How can I avoid this.
>>
>> CAS properties
>> # Activate MFA globally for all, regardless of other settings
>> cas.authn.mfa.globalProviderId=mfa-gauth
>>
>> cas.authn.mfa.gauth.issuer=CAS
>> cas.authn.mfa.gauth.label=CAS
>> cas.authn.mfa.gauth.windowSize=3
>> cas.authn.mfa.gauth.codeDigits=6
>> cas.authn.mfa.gauth.timeStepSize=30
>> cas.authn.mfa.gauth.rank=0
>> cas.authn.mfa.gauth.trustedDeviceEnabled=false
>> cas.authn.mfa.gauth.name=
>>
>> #cas.authn.mfa.gauth.cleaner.enabled=true
>> #cas.authn.mfa.gauth.cleaner.schedule.startDelay=20000
>> #cas.authn.mfa.gauth.cleaner.schedule.repeatInterval=60000
>>
>> cas.authn.mfa.gauth.bypass.type=DEFAULT
>> cas.authn.mfa.gauth.bypass.principalAttributeName=data_
>> cas.authn.mfa.gauth.bypass.principalAttributeValue=false
>>
>>
>> cas.authn.mfa.gauth.jpa.user=root
>> cas.authn.mfa.gauth.jpa.password=root
>> cas.authn.mfa.gauth.jpa.driverClass=com.mysql.jdbc.Driver
>>
>> cas.authn.mfa.gauth.jpa.url=jdbc:mysql://localhost:3306/lportal?useSSL=false
>> cas.authn.mfa.gauth.jpa.dialect=org.hibernate.dialect.MySQLDialect
>> cas.authn.mfa.gauth.jpa.failFastTimeout=1
>> cas.authn.mfa.gauth.jpa.healthQuery=
>> cas.authn.mfa.gauth.jpa.isolateInternalQueries=false
>> cas.authn.mfa.gauth.jpa.leakThreshold=10
>> cas.authn.mfa.gauth.jpa.batchSize=1
>> cas.authn.mfa.gauth.jpa.ddl-auto=none
>>
>> cas.authn.mfa.gauth.jpa.autocommit=false
>> cas.authn.mfa.gauth.jpa.idleTimeout=5000
>> cas.authn.mfa.gauth.jpa.pool.suspension=false
>> cas.authn.mfa.gauth.jpa.pool.minSize=6
>> cas.authn.mfa.gauth.jpa.pool.maxSize=18
>> cas.authn.mfa.gauth.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 cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/f38fb3fa-c5c5-45b8-9855-d331fd065ed1%40apereo.org.
