RE: [cas-user] JPATicketRegistry and ServiceTicket Table

2013-08-01 Thread Whittaker, Geoffrey
to:scott.battag...@gmail.com] Sent: Wednesday, July 31, 2013 3:43 PM To: cas-user@lists.jasig.org Subject: Re: [cas-user] JPATicketRegistry and ServiceTicket Table The tickets will be deleted immediately after being consumed. Is it possible that they're being deleted before you can see them? Are you

Re: [cas-user] JPATicketRegistry and ServiceTicket Table

2013-07-31 Thread Richard Chai
Greetings, I am a new users to CAS. I setup my local copy, but am having difficulties with the CAS -> mysql setup. The manual is a bit confusing. Does anyone have any sample setup (or more detail reference for a Centos 5.x,, Cas 3.5.2, Mysql, JRE 1.7.x, Tomcat 6.x setup? Much appreciated. Richa

Re: [cas-user] JPATicketRegistry and ServiceTicket Table

2013-07-31 Thread Scott Battaglia
The tickets will be deleted immediately after being consumed. Is it possible that they're being deleted before you can see them? Are you able to successfully authenticate to a service? On Wed, Jul 31, 2013 at 3:07 PM, Whittaker, Geoffrey < geoff.whitta...@unf.edu> wrote: > Good afternoon,

[cas-user] JPATicketRegistry and ServiceTicket Table

2013-07-31 Thread Whittaker, Geoffrey
Good afternoon, I was just doing some testing on my shiny new JPATicketRegistry and I noticed that there are no service tickets getting written into my database. The TGTs are written there and updated, but the STs never show up. Is this normal behavior and if not where should I start looking

[cas-user] JPAticketregistry Deadlock

2012-08-20 Thread Juan Quintanilla
Hi, I've began seeing some errors in our CAS logs regarding a Deadlock, after checking the Oracle trace logs we see the following error: Information for THIS session: - Current SQL Statement for this session (sql_id=77uxha5hm28qu) - delete from TICKETGRANTINGTICKET where ID=:1 Running

Re: [cas-user] JpaTicketRegistry

2011-09-29 Thread Marvin Addison
> I have pushed out a bunch of changes to the JpaTicketRegistry documentation. > For any one who is interested please take a look and review. I just got a chance to carefully review this. Your additions and changes look good in general. I reoganized some of the MySQL content into a new section

RE: [cas-user] JpaTicketRegistry

2011-09-16 Thread Jonathan Windle
, September 14, 2011 13:18 To: cas-user@lists.jasig.org Subject: Re: [cas-user] JpaTicketRegistry > Obviously CAS didn't have access to the MySQL JDBC Driver. I fixed this by > adding the following to my pom. Don't do this. Add the driver to the container classpath, e.g. put it in $TOM

Re: [cas-user] JpaTicketRegistry

2011-09-14 Thread Marvin Addison
> Obviously CAS didn't have access to the MySQL JDBC Driver. I fixed this by > adding the following to my pom. Don't do this. Add the driver to the container classpath, e.g. put it in $TOMCAT_HOME/lib for Tomcat. I see this is not documented, so https://wiki.jasig.org/display/CASUM/JpaTicketReg

RE: [cas-user] JpaTicketRegistry

2011-09-14 Thread Jonathan Windle
nted to have some discussion around these changes first before digging into wiki article. Thanks, Jonathan ________ From: Jonathan Windle [jonathan.win...@bellevuecollege.edu] Sent: Tuesday, September 13, 2011 12:56 To: cas-user@lists.jasig.org Subject: RE: [cas-user] Jp

RE: [cas-user] JpaTicketRegistry

2011-09-13 Thread Jonathan Windle
bject: Re: [cas-user] JpaTicketRegistry > I could use a second set of eyes again. > I'm not seeing anything obvious but I'm also not completely sure what I'm > looking for. I don't see any mixed versions, so a version mismatch is likely not the problem. Are you rebuild

Re: [cas-user] JpaTicketRegistry

2011-09-13 Thread Marvin Addison
> I could use a second set of eyes again. > I'm not seeing anything obvious but I'm also not completely sure what I'm > looking for. I don't see any mixed versions, so a version mismatch is likely not the problem. Are you rebuilding and redeploying your custom CAS war file every time? Are you r

RE: [cas-user] JpaTicketRegistry

2011-09-13 Thread Jonathan Windle
api.jar servlet-api.jar tomcat-coyote.jar tomcat-i18n-es.jar tomcat-i18n-fr.jar tomcat-i18n-ja.jar From: Marvin Addison [marvin.addi...@gmail.com] Sent: Tuesday, September 13, 2011 8:58 To: cas-user@lists.jasig.org Subject: Re: [cas-user] JpaTicketRegist

Re: [cas-user] JpaTicketRegistry

2011-09-13 Thread Marvin Addison
> Caused by: java.lang.IncompatibleClassChangeError: Implementing class >     at java.lang.ClassLoader.defineClass1(Native Method) >     at java.lang.ClassLoader.defineClass(ClassLoader.java:634) Looks like a classpath issue to me. A common cause would be duplicate classes in either the s

RE: [cas-user] JpaTicketRegistry

2011-09-13 Thread Jonathan Windle
anFactory.java:1417) ... 43 more Thanks, Jonathan From: Scott Battaglia [scott.battag...@gmail.com] Sent: Monday, September 12, 2011 18:09 To: cas-user@lists.jasig.org Subject: Re: [cas-user] JpaTicketRegistry Marvin may be able to answer it better, but you

Re: [cas-user] JpaTicketRegistry

2011-09-12 Thread Scott Battaglia
/ticketRegistry.xml]: Invocation of > init method failed; nested exception is > java.lang.IncompatibleClassChangeError: Implementing class > > I'm not sure what's going on here with this one. > > Thanks, > Jonathan > > ___

RE: [cas-user] JpaTicketRegistry

2011-09-12 Thread Jonathan Windle
s java.lang.IncompatibleClassChangeError: Implementing class I'm not sure what's going on here with this one. Thanks, Jonathan From: Marvin Addison [marvin.addi...@gmail.com] Sent: Monday, September 12, 2011 13:48 To: cas-user@lists.jasi

Re: [cas-user] JpaTicketRegistry

2011-09-12 Thread Marvin Addison
> A second set of eyes would be much appreciated. Apparently I needed to take a careful look as well. Turns out the documentation indeed appears wrong -- the location of the tx namespace is missing. But here's the strange part -- the wiki source is correct. It took several attempts to get it to

RE: [cas-user] JpaTicketRegistry

2011-09-12 Thread Jonathan Windle
...@gmail.com] Sent: Monday, September 12, 2011 11:55 To: cas-user@lists.jasig.org Subject: Re: [cas-user] JpaTicketRegistry >> As long as I set the appropriate versions for hibernate-commons-annotations >> and hibernate-annotations the project does build successful. > > Remo

Re: [cas-user] JpaTicketRegistry

2011-09-12 Thread Marvin Addison
>> As long as I set the appropriate versions for hibernate-commons-annotations >> and hibernate-annotations the project does build successful. > > Remove them altogether -- I don't believe they're needed.  In any case > a dependency problem of this sort would likely happen at runtime after > a suc

Re: [cas-user] JpaTicketRegistry

2011-09-12 Thread Marvin Addison
> As long as I set the appropriate versions for hibernate-commons-annotations > and hibernate-annotations the project does build successful. Remove them altogether -- I don't believe they're needed. In any case a dependency problem of this sort would likely happen at runtime after a successful b

RE: [cas-user] JpaTicketRegistry

2011-09-12 Thread Jonathan Windle
or Jpa is also in need of an update. Thanks, Jonathan From: Marvin Addison [marvin.addi...@gmail.com] Sent: Monday, September 12, 2011 10:06 To: cas-user@lists.jasig.org Subject: Re: [cas-user] JpaTicketRegistry > It seemed to me that there should b

Re: [cas-user] JpaTicketRegistry

2011-09-12 Thread Marvin Addison
> It seemed to me that there should be a "3.6.0.Final" version of > hibernate-annotations > so I did some searching and came across this > http://lists.jboss.org/pipermail/hibernate-dev/2010-November/005742.html > To me this means that hibernate-core should replace hibernate-annotations and > poss

[cas-user] JpaTicketRegistry

2011-09-12 Thread Jonathan Windle
Hello, I'm trying to implement the Jpa Ticket Registry using the info found in the CAS User Manual (https://wiki.jasig.org/display/CASUM/JpaTicketRegistry) and I am running into some problems. First I'm a little confused about the dependencies in the pom.xml. In CAS 3.4.10 "${hibernate.core.ve

Re: [cas-user] JpaTicketRegistry - Simple Query

2011-02-10 Thread Ren standist
Is sure all data in database. In my case ,there is nothing query from ticketgrantingticket . On Wed, Feb 9, 2011 at 12:36 AM, Marvin Addison wrote: > > Anyone knows whats the query to see how many sessions are active? > > No such query is possible in general. The process for determining an > ex

Re: [cas-user] JpaTicketRegistry - Simple Query

2011-02-08 Thread Marvin Addison
> Anyone knows whats the query to see how many sessions are active? No such query is possible in general. The process for determining an expired session requires iterating over every session and applying the expiration policy from the Spring application context, which obviously is not available t

[cas-user] JpaTicketRegistry - Simple Query

2011-02-08 Thread Francisco Estanqueiro
Hi everybody, Anyone knows whats the query to see how many sessions are active? Francisco Estanqueiro -- You are currently subscribed to cas-user@lists.jasig.org as: arch...@mail-archive.com To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-us

Re: [cas-user] JpaTicketRegistry - out of memory error during ticket cleanup

2011-02-07 Thread [ G ]
Thank you Marvin, CAS works fine after disabled ticketregistrycleaner. I will wait for CAS 4.x to resolve this issue. Wilson On Mon, Feb 7, 2011 at 10:40 PM, Marvin Addison wrote: > On Sat, Feb 5, 2011 at 1:14 AM, Wilson Lam wrote: > > Dear all, > > > > I am using CAS + Oracle as JpaTicketRegi

Re: [cas-user] JpaTicketRegistry - out of memory error during ticket cleanup

2011-02-07 Thread Marvin Addison
On Sat, Feb 5, 2011 at 1:14 AM, Wilson Lam wrote: > Dear all, > > I am using CAS + Oracle as JpaTicketRegistry, rememberMeExpirationPolicy > timeout = 30 days (we would like to remember user password for 30 days). > > However, the data size stored in each SERVICES_GRANTED_ACCESS_TO record > inc

RE: [cas-user] JpaTicketRegistry

2011-02-04 Thread Francisco Estanqueiro
ailto:marvin.addi...@gmail.com] Enviada: quinta-feira, 3 de Fevereiro de 2011 12:25 Para: cas-user@lists.jasig.org Assunto: Re: [cas-user] JpaTicketRegistry Using http://dev.mysql.com/doc/refman/5.5/en/create-index.html as a guide, should be easy to translate the Oracle DDL you cited to MySQL. I

Re: [cas-user] JpaTicketRegistry

2011-02-03 Thread Marvin Addison
Using http://dev.mysql.com/doc/refman/5.5/en/create-index.html as a guide, should be easy to translate the Oracle DDL you cited to MySQL. If someone is already using MySQL and has done this, please speak up. M -- You are currently subscribed to cas-user@lists.jasig.org as: arch...@mail-archive.

[cas-user] JpaTicketRegistry

2011-02-03 Thread Francisco Estanqueiro
Hi everyone, Anyone using MySQL as their Jpa Ticket Registry DB? How can I create the indexes to avoid deadlocks in Mysql? CREATE INDEX "ST_TGT_FK_I" ON SERVICETICKET ("TICKETGRANTINGTICKET_ID") COMPUTE STATISTICS; /** Create index on TGT self-referential foreign-key constraint */ CREATE IN

[cas-user] JpaTicketRegistry

2011-02-01 Thread Francisco Estanqueiro
https://wiki.jasig.org/display/CASUM/JpaTicketRegistry Hi everyone, Anyone using MySQL as their Jpa Ticket Registry DB? How can I create the indexes to avoid deadlocks in Mysql? CREATE INDEX "ST_TGT_FK_I" ON SERVICETICKET ("TICKETGRANTINGTICKET_ID") COMPUTE STATISTICS; /** Create index on

Re: [cas-user] JpaTicketRegistry have a bug?

2010-10-29 Thread 陈国柱
I use Oracle 10g instead of MySql5.0 for JpaTicketRegistry. It is Effectiveness. It may be done! thanks referrence https://wiki.jasig.org/display/CASUM/JpaTicketRegistry regards 2010/10/29 Marvin Addison > > Question: > > Does cluster high school use cas? > > I have no idea. We are a large p

Re: [cas-user] JpaTicketRegistry have a bug?

2010-10-29 Thread Marvin Addison
> Question: > Does cluster high school use cas? I have no idea. We are a large public university (~3 students). In any case the most important metric is tickets/sec. As I said we're on the order of 5/day or 10/s. I would call that a moderate installation. > What is the solution that th

Re: [cas-user] JpaTicketRegistry have a bug?

2010-10-28 Thread 陈国柱
>What's your use case for doing this? I use it for the portal.In my portal index page,it use iframe for including a lot of businiess page. >Under normal circumstances deadlocks happen infrequently enough that they're typically acceptable. On my use case,it is frequently,almost every time ,it hav

Re: [cas-user] JpaTicketRegistry have a bug?

2010-10-28 Thread Marvin Addison
> I try to use JpaTicketRegistry instead of default,but have a deadlock > problem.I don't know how to fix ti. I see from your HTML snippet that you're attempting to obtain a number of service tickets from the same TGT at the same time. This _will_ cause deadlocks in the current JPA implementation

RE: [cas-user] JPATicketRegistry - docs missing persistence.xml - got one?

2010-06-03 Thread Bruno Melloni
ing Security (even though we'd lose true SSO), I am attempting it. I invested too much time and effort into CAS to abandon it without a fight. bruno -Original Message- From: Marvin Addison [mailto:marvin.addi...@gmail.com] Sent: Thursday, June 03, 2010 8:15 AM To: cas-user@lists.ja

Re: [cas-user] JPATicketRegistry - docs missing persistence.xml - got one?

2010-06-03 Thread Marvin Addison
> I am attempting to switch to the JPATicketRegistry with CAS 3.3.1. I would advise slowing down and attempting to fix the problem you're currently having in your environment with JBoss Cache. There's some indication, to me at least, that there is a problem with your HA setup. Switching to JPA o

Re: [cas-user] JPATicketRegistry - docs missing persistence.xml - got one?

2010-06-02 Thread Scott Battaglia
One is actually included with CAS. Though if you're deploying under JBoss (JBoss makes everything fun), it has its own requirements for persistence. There was some discussion of this on the list. We deploy to Tomcat, so I'm unfortunately not sure of all the details. Someone else (maybe the ones

[cas-user] JPATicketRegistry - docs missing persistence.xml - got one?

2010-06-02 Thread Bruno Melloni
I am attempting to switch to the JPATicketRegistry with CAS 3.3.1. I started with the documentation (https://wiki.jasig.org/display/CASUM/JpaTicketRegistry) and fixed a few things that were throwing exceptions. I now am stumped because the docs don't include the necessary persistence.xml. I

Re: [cas-user] JpaTicketRegistry with DB2

2010-05-02 Thread David . Radtke
ork after I restart CAS. Currently after restarting CAS all the user all have to log back in, even if they have selected "Remember Me" Thanks Dave Scott Battaglia wrote on 03/05/2010 12:22:37 PM: > From: Scott Battaglia > To: cas-user@lists.jasig.org > Date: 03/05/2010 12:

Re: [cas-user] JpaTicketRegistry with DB2

2010-05-02 Thread Scott Battaglia
> Thanks > Dave > > Marvin Addison wrote on 02/05/2010 10:49:54 PM: > > > From: Marvin Addison > > To: cas-user@lists.jasig.org > > Date: 02/05/2010 10:50 PM > > Subject: Re: [cas-user] JpaTicketRegistry with DB2 > > > > > I can see in the TicketGrantin

Re: [cas-user] JpaTicketRegistry with DB2

2010-05-02 Thread David . Radtke
> From: Marvin Addison > To: cas-user@lists.jasig.org > Date: 02/05/2010 10:50 PM > Subject: Re: [cas-user] JpaTicketRegistry with DB2 > > > I can see in the TicketGrantingTicket table that the > > SERVICES_GRANTED_ACCESS_TO column grows by around 300 for every

Re: [cas-user] JpaTicketRegistry with DB2

2010-05-02 Thread Marvin Addison
> I can see in the TicketGrantingTicket table that the > SERVICES_GRANTED_ACCESS_TO column grows by around 300 for every application > I access, even if I restart the browser and access the same application > again. I've never measured the growth, but that value sounds reasonable assuming it's in

[cas-user] JpaTicketRegistry with DB2

2010-05-01 Thread David . Radtke
We've been using cas on tomcat for a few months. I just upgraded to 3.4.2 and I'm trying to get the JpaTicketRegistry working with a DB2 (UTF-8) database. We have been using the DefaultTicketRegistry up till now. I could not login because of a SQL error 302 ( variable too large for column). I

Re: [cas-user] JpaTicketRegistry

2010-03-31 Thread Scott Battaglia
In CAS 3.5, the actual user attributes won't be stored in the database. Each person is backed by the PersonDirectory and deployers can configure how they want it to work (i.e. no caching, caching, etc.). This will give deployers a lot more flexibility. If it turns out that it works, of course :-)

Re: [cas-user] JpaTicketRegistry

2010-03-31 Thread Jérôme Rautureau
I had to truncate my TGT table and it's a (little) issue... All my users will have to reauthenticate :). Thanks to the "remember me" feature, they had forgotten how to do so. Here's the data (principal + attributes) witch i'm saving in database (I had to increase the blob length data in order to

Re: [cas-user] JpaTicketRegistry

2010-03-31 Thread Marvin Addison
> The restriction on attributes will have to apply to all storage mechanisms > to ensure a consistent experience (and a consistent API).  I'm actually fine > with that. > I'll probably enforce a Map) API I was thinking it would be possible to keep the Object->String conversion an implementation de

Re: [cas-user] JpaTicketRegistry

2010-03-31 Thread Scott Battaglia
The restriction on attributes will have to apply to all storage mechanisms to ensure a consistent experience (and a consistent API). I'm actually fine with that. I'll probably enforce a Map) API or something similar (depending on how much JPA complains). On Wed, Mar 31, 2010 at 9:20 AM, Marvin

Re: [cas-user] JpaTicketRegistry

2010-03-31 Thread Marvin Addison
> There will still be one LOB to store a set of attribute > (Map) unless we want to restrict the attributes that can > be attached to an Authentication object For JPA we want to enforce storing attributes as string/text. If there is a use case for storing a complex object, there would need to be

Re: [cas-user] JpaTicketRegistry

2010-03-31 Thread Scott Battaglia
On Wed, Mar 31, 2010 at 8:20 AM, Marvin Addison wrote: > > Due to serialization/deserialisation errors. > > I had to truncate my TGT table and the it went correctly > > I've run into this many times recently as I've been testing different > CAS versions on the same database. The root problem is t

Re: [cas-user] JpaTicketRegistry

2010-03-31 Thread Marvin Addison
> Due to serialization/deserialisation errors. > I had to truncate my TGT table and the it went correctly I've run into this many times recently as I've been testing different CAS versions on the same database. The root problem is that we store serialized objects as LOBs in the database and aren'

Re: [cas-user] JpaTicketRegistry

2010-03-31 Thread Jérôme Rautureau
OK...CAS was started but then i submit the form with my credentials i had a javax.persistence.RollbackException: Transaction marked as rollbackOnly org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:73) org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTrans

Re: [cas-user] JpaTicketRegistry

2010-03-31 Thread Jérôme Rautureau
I've resolved the first problem of jpaTicketRegistry maven dependencies : Here the maven dependencies I use for persisiting my tickets in MySQL databases. org.hibernate hibernate-entitymanager 3.5.0-CR-2 runtime

Re: [cas-user] jpaTicketRegistry using openJpa instead of hibernate

2010-03-30 Thread Harikrishnan R.
ya, thats the advantage JPA is offering. Edit the persistence.xml and include the OPnJPa specific details.It will work. Regards Hari 2010/3/30 Pablo Ramírez > Hi, > > It's possible to use openJpaVendor for persisting tickets into a database > using this method? > > http://www.ja-sig.org/wiki/dis

[cas-user] jpaTicketRegistry and Hibernate Session Closed

2010-03-30 Thread Pablo Ramírez
Hi, After enabling jpaTicketRegistry i'm getting a hibernate session closed exception. [30/03/10 11:47:46:203 CLT] 00cf TransactionSy E org.springframework.transaction.support.TransactionSynchronizationUtils triggerBeforeCompletion TransactionSynchronization.beforeCompletion threw excepti

Re: [cas-user] JpaTicketRegistry

2010-03-30 Thread Marvin Addison
I believe only hibernate-entity-manager is required in 3.4.x since the other hibernate dependencies will be included transitively. Additionally, I don't believe concurrent is required any longer. Could you please try the following and report back: org.hibernate hibernate-entityman

[cas-user] JpaTicketRegistry

2010-03-30 Thread Jérôme Rautureau
Hi every body I want to activate the JpaTicketRegistry support in CAS 3.4.2, but the doc ( http://www.ja-sig.org/wiki/display/CASUM/JpaTicketRegistry) seems outdated, specially from the maven dependencies (hibernate version conflits) I wanted to activate remember me feature in cas 3.4.2 but Bill