Add property spring.integration.jdbc.initialize-schema=always On Saturday, July 8, 2023 at 8:17:47 AM UTC+3 Pablo Vidaurri wrote:
> Same issue with CAS 6.6.8 > > > > On Wednesday, April 6, 2022 at 8:14:36 AM UTC-5 [email protected] wrote: > >> Hello, >> >> I am upgrading our CAS 6.4.6.1 to CAS 6.5.2. >> We are using the JPA ticket registry (PostgreSQL 11). >> >> During startup, CAS creates the "postgres_jpa_ticket_entity" table (name >> changed from "cas_tickets" in 6.4.x) but *does not create the >> "int_locks" table* (name changed from "locks" in 6.4.x). >> >> As a result, during an saml or oidc authentication, I get the following >> error: >> >> 2022-04-06 14:28:25,148 DEBUG >> [org.hibernate.engine.transaction.internal.TransactionImpl] - <On >> TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled >> == false> >> >> 2022-04-06 14:28:25,148 DEBUG >> [org.hibernate.engine.transaction.internal.TransactionImpl] - <begin> >> >> 2022-04-06 14:28:25,160 DEBUG >> [org.hibernate.engine.transaction.internal.TransactionImpl] - <On >> TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled >> == false> >> >> 2022-04-06 14:28:25,160 DEBUG >> [org.hibernate.engine.transaction.internal.TransactionImpl] - <begin> >> >> 2022-04-06 14:28:25,410 DEBUG >> [org.hibernate.engine.transaction.internal.TransactionImpl] - <rolling back> >> >> 2022-04-06 14:28:25,414 INFO >> [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit >> trail record BEGIN >> >> ============================================================= >> >> WHO: <username> >> >> WHAT: >> https://<idp-host>/<idp-context-path>/idp/profile/SAML2/Callback?entityId=<entity-id> >> >> ACTION: SERVICE_TICKET_NOT_CREATED >> >> APPLICATION: CAS >> >> WHEN: Wed Apr 06 14:28:25 CEST 2022 >> >> CLIENT IP ADDRESS: <client-ip> >> >> SERVER IP ADDRESS: <server-ip> >> >> ============================================================= >> >> > >> >> 2022-04-06 14:28:25,414 DEBUG >> [org.hibernate.engine.transaction.internal.TransactionImpl] - <rolling back> >> >> 2022-04-06 14:28:25,415 DEBUG >> [org.springframework.webflow.engine.impl.FlowExecutionImpl] - <Attempting >> to handle [org.springframework.webflow.execution.ActionExecutionException: >> Exception thrown executing >> org.apereo.cas.web.flow.GenerateServiceTicketAction@3d3709d0 in state >> 'generateServiceTicket' of flow 'login' -- action execution attributes were >> 'map[[empty]]'] with root cause *[org.postgresql.util.PSQLException: >> ERROR: relation "int_lock" does not exist* >> >> Position: 8]> >> >> I was able to workaround this by manually creating the int_lock table >> using the spring_integration SQL script here : >> >> >> https://github.com/spring-projects/spring-integration/blob/5.5.x/spring-integration-jdbc/src/main/resources/org/springframework/integration/jdbc/schema-postgresql.sql >> >> >> -Frederic >> >> -- - 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/ac7c9930-ee52-4415-bee1-328d31ae3cc2n%40apereo.org.
