Hi All,
Hopefully I'm just missing something simple...I appreciate any and all insight.
I've worked on 3.5.x extensively and 4.0.x briefly but 4.2.2 is giving me some
trouble.
I am working on a 4.2.2 CAS build using the Maven overlay method and I'd like
to use LDAP and JPA support.
I added LDAP support, JPA Ticket Registry support and MySQL 5.1.39 to my
pom.xml:
<dependencies>
<dependency>
<groupId>org.jasig.cas</groupId>
<artifactId>cas-server-webapp</artifactId>
<version>${cas.version}</version>
<type>war</type>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.jasig.cas</groupId>
<artifactId>cas-server-support-ldap</artifactId>
<version>${cas.version}</version>
</dependency>
<dependency>
<groupId>org.jasig.cas</groupId>
<artifactId>cas-server-support-jpa-ticket-registry</artifactId>
<version>${cas.version}</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.39</version>
</dependency>
</dependencies>
After getting LDAP working with the default ticket registry, I then updated
src/main/webapp/WEB-INF/deployerConfigContext.xml as follows:
<!-- TONeill/JPA Ticket registry -->
<!-- <alias name="defaultTicketRegistry" alias="ticketRegistry" /> -->
<alias name="jpaTicketRegistry" alias="ticketRegistry" />
I also added the ticket registry database properties to my cas.properties file.
I am using a 5.7 MySQL InnoDB so I have the following dialect set:
org.hibernate.dialect.MySQL5InnoDBDialect
After authentication succeeds I see hibernate indicate that it is going to
attempt an insert into the ticketgrantingticket table but the insert never
seems to complete.
2016-06-27 13:34:51,614 DEBUG
[org.hibernate.engine.transaction.internal.TransactionImpl] - <begin>
2016-06-27 13:34:51,623 DEBUG
[org.hibernate.event.internal.AbstractSaveEventListener] - <Generated
identifier: TGT-1-1Pzdcw6T0gSjt4SQwa2q5CgI2x373ayd72CHMcjK2wfet0bAv2-auth1test,
using strategy: org.hibernate.id.Assigned>
2016-06-27 13:34:51,715 INFO
[org.jasig.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit trail
record BEGIN
=============================================================
WHO: audit:unknown
WHAT: TGT-**********************************************2wfet0bAv2-auth1test
ACTION: TICKET_GRANTING_TICKET_CREATED
APPLICATION: CAS
WHEN: Mon Jun 27 13:34:51 CDT 2016
CLIENT IP ADDRESS: 10.213.88.21
SERVER IP ADDRESS: 10.186.86.6
=============================================================
>
2016-06-27 13:34:51,716 DEBUG
[org.hibernate.engine.transaction.internal.TransactionImpl] - <committing>
2016-06-27 13:34:51,716 DEBUG
[org.hibernate.event.internal.AbstractFlushingEventListener] - <Processing
flush-time cascades>
2016-06-27 13:34:51,717 DEBUG
[org.hibernate.event.internal.AbstractFlushingEventListener] - <Dirty checking
collections>
2016-06-27 13:34:51,723 DEBUG
[org.hibernate.event.internal.AbstractFlushingEventListener] - <Flushed: 1
insertions, 0 updates, 0 deletions to 1 objects>
2016-06-27 13:34:51,723 DEBUG
[org.hibernate.event.internal.AbstractFlushingEventListener] - <Flushed: 0
(re)creations, 0 updates, 0 removals to 0 collections>
2016-06-27 13:34:51,723 DEBUG [org.hibernate.internal.util.EntityPrinter] -
<Listing entities:>
2016-06-27 13:34:51,724 DEBUG [org.hibernate.internal.util.EntityPrinter] -
<org.jasig.cas.ticket.TicketGrantingTicketImpl{lastTimeUsed=1467052491621,
previousLastTimeUsed=0, proxiedBy=null, supplementalAuthentications=[],
expired=false, creationTime=1467052491621, countOfUses=0,
id=TGT-1-1Pzdcw6T0gSjt4SQwa2q5CgI2x373ayd72CHMcjK2wfet0bAv2-auth1test,
expirationPolicy=org.jasig.cas.ticket.support.TicketGrantingTicketExpirationPolicy@42f8ab07<mailto:expirationPolicy=org.jasig.cas.ticket.support.TicketGrantingTicketExpirationPolicy@42f8ab07>,
services={}, ticketGrantingTicket=null,
authentication=org.jasig.cas.authentication.ImmutableAuthentication@c0763239<mailto:authentication=org.jasig.cas.authentication.ImmutableAuthentication@c0763239>}>
Hibernate: insert into TICKETGRANTINGTICKET (NUMBER_OF_TIMES_USED,
CREATION_TIME, EXPIRATION_POLICY, LAST_TIME_USED, PREVIOUS_LAST_TIME_USED,
ticketGrantingTicket_ID, AUTHENTICATION, EXPIRED, PROXIED_BY,
SERVICES_GRANTED_ACCESS_TO, SUPPLEMENTAL_AUTHENTICATIONS, TYPE, ID) values (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'TGT', ?)
2016-06-27 13:34:51,730 DEBUG [org.hibernate.SQL] - <insert into
TICKETGRANTINGTICKET (NUMBER_OF_TIMES_USED, CREATION_TIME, EXPIRATION_POLICY,
LAST_TIME_USED, PREVIOUS_LAST_TIME_USED, ticketGrantingTicket_ID,
AUTHENTICATION, EXPIRED, PROXIED_BY, SERVICES_GRANTED_ACCESS_TO,
SUPPLEMENTAL_AUTHENTICATIONS, TYPE, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, 'TGT', ?)>
2016-06-27 13:35:01,612 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool] -
<Refurbishing idle resources - Mon Jun 27 13:35:01 CDT 2016
[com.mchange.v2.resourcepool.BasicResourcePool@156eeecf]>
2016-06-27 13:35:01,612 DEBUG
[com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool] - <Testing PooledConnection
[com.mchange.v2.c3p0.impl.NewPooledConnection@7eb9ca3c] on IDLE CHECK.>
2016-06-27 13:35:01,613 DEBUG
[com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool] - <Testing PooledConnection
[com.mchange.v2.c3p0.impl.NewPooledConnection@b2132c4] on IDLE CHECK.>
2016-06-27 13:35:01,613 DEBUG
[com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool] - <Testing PooledConnection
[com.mchange.v2.c3p0.impl.NewPooledConnection@3ee0eb3d] on IDLE CHECK.>
2016-06-27 13:35:01,616 DEBUG
[com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool] - <Test of PooledConnection
[com.mchange.v2.c3p0.impl.NewPooledConnection@b2132c4] on IDLE CHECK has
SUCCEEDED.>
2016-06-27 13:35:01,616 DEBUG
[com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool] - <Testing PooledConnection
[com.mchange.v2.c3p0.impl.NewPooledConnection@cd8fa76] on IDLE CHECK.>
2016-06-27 13:35:01,616 DEBUG
[com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool] - <Test of PooledConnection
[com.mchange.v2.c3p0.impl.NewPooledConnection@3ee0eb3d] on IDLE CHECK has
SUCCEEDED.>
2016-06-27 13:35:01,616 DEBUG
[com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool] - <Testing PooledConnection
[com.mchange.v2.c3p0.impl.NewPooledConnection@54b032c8] on IDLE CHECK.>
2016-06-27 13:35:01,616 DEBUG
[com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool] - <Test of PooledConnection
[com.mchange.v2.c3p0.impl.NewPooledConnection@7eb9ca3c] on IDLE CHECK has
SUCCEEDED.>
2016-06-27 13:35:01,617 DEBUG
[com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool] - <Test of PooledConnection
[com.mchange.v2.c3p0.impl.NewPooledConnection@cd8fa76] on IDLE CHECK has
SUCCEEDED.>
2016-06-27 13:35:01,617 DEBUG
[com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool] - <Test of PooledConnection
[com.mchange.v2.c3p0.impl.NewPooledConnection@54b032c8] on IDLE CHECK has
SUCCEEDED.>
Thanks,
Tom O'Neill
--
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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/a/apereo.org/group/cas-user/.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/BY1PR0201MB099948E01CE07680743753A6CB210%40BY1PR0201MB0999.namprd02.prod.outlook.com.
For more options, visit https://groups.google.com/a/apereo.org/d/optout.
