Announce: Database Backed Storage Service

[Wessel, Keith]

Thanks, Paul. The database row is now being created and, I think, updated. Both IDP nodes can see it. Terracotta's still in the mix, though. Should be just a quick modification to my start-up process to undo that, and we'll see if it's actually doing everything correctly. I'll have news for you tomorrow morning at the latest if there's a problem, but it looks like we have success.

Shall I just share my sql files with the list since they're small, and you can add them to the contributed examples from there?

Keith


-----Original Message-----
From: users-bounces at shibboleth.net [mailto:users-bounces at shibboleth.net] On Behalf Of Paul Hethmon
Sent: Wednesday, October 16, 2013 3:47 PM
To: Shib Users
Subject: Re: Announce: Database Backed Storage Service

Ok, version 1.1.3 is uploaded. Verified it is Java 1.6.

On 10/16/13 4:40 PM, "Paul Hethmon" <paul.hethmon at clareitysecurity.com>
wrote:

>Crud. That's my machine being completely flakey lately on compiling stuff.
>Somehow even though I'm using Java 1.6 as the javac compiler, it ends up
>setting the version as 1.7. I'll go fix it.
>
>Paul
>
>
>On 10/16/13 4:37 PM, "Wessel, Keith" <kwessel at illinois.edu> wrote:
>
>>Great, I can send those along shortly.
>>
>>As for V1.1.2, I put it in, and now we're getting IDP start-up problems.
>>Perhaps I'm forgetting something. All I did was put the jar  in my IDP,
>>removing the 1.1.0 jar, and redeployed. Now, I get this in catalina.out:
>>
>>Oct 16, 2013 3:34:38 PM org.apache.tomcat.util.modeler.Registry
>>registerComponent
>>SEVERE: Null component
>>Catalina:type=JspMonitor,name=jsp,WebModule=//localhost/idp,J2EEApplicati
>>o
>>n=none,J2EEServer=none
>>Oct 16, 2013 3:34:38 PM org.apache.tomcat.util.modeler.Registry
>>registerComponent
>>SEVERE: Null component
>>Catalina:type=JspMonitor,name=shibboleth_jsp,WebModule=//localhost/idp,J2
>>E
>>EApplication=none,J2EEServer=none
>>Oct 16, 2013 3:34:38 PM org.apache.catalina.startup.HostConfig
>>deployDescriptor
>>SEVERE: Error deploying configuration descriptor idp.xml
>>java.lang.UnsupportedClassVersionError:
>>net/clareitysecurity/shibboleth/storage/ClusterFilter : Unsupported
>>major.minor version 51.0 (unable to load class
>>net.clareitysecurity.shibboleth.storage.ClusterFilter)
>>
>>Am I doing something wrong?
>>
>>Keith
>>
>>-----Original Message-----
>>From: users-bounces at shibboleth.net [mailto:users-bounces at shibboleth.net]
>>On Behalf Of Paul Hethmon
>>Sent: Wednesday, October 16, 2013 3:25 PM
>>To: Shib Users
>>Subject: Re: Announce: Database Backed Storage Service
>>
>>Sure. We could add them to them code repository as examples.
>>
>>Paul
>>
>>On 10/16/13 4:11 PM, "Wessel, Keith" <kwessel at illinois.edu> wrote:
>>
>>>I guess we'll see what happens. Would you like to see the SQL files to
>>>define the schema, triggers and indexes that our DBA modified for me
>>>from the ones that came with the binary distribution just to see what
>>>we're using on our side? Don't know if this would be useful for you to
>>>compare to the generated ones.
>>>
>>>Keith
>>>
>>>
>>>-----Original Message-----
>>>From: users-bounces at shibboleth.net
>>>[mailto:users-bounces at shibboleth.net]
>>>On Behalf Of Paul Hethmon
>>>Sent: Wednesday, October 16, 2013 3:04 PM
>>>To: Shib Users
>>>Subject: Re: Announce: Database Backed Storage Service
>>>
>>>Keith,
>>>
>>>That's correct, just drop the new jar in place and rebuild Shib.
>>>
>>>I did just upload yet another version: 1.1.2
>>>
>>>Looking a bit more, it seems that I needed to declare the Oracle
>>>sequence in the Hibernate files. I tested the SQL generation using the
>>>Oracle dialect and it creates a statement to create the actual
>>>sequence. What I'm not sure about is how Hibernate makes use of that
>>>sequence to populate the actual DB column. I am hoping that Hibernate
>>>takes care of all of that for me behind the curtain. If it doesn't we
>>>might have to look at using a trigger or some other mechanism to
>>>actually push the sequence value into the identity column.
>>>
>>>Paul
>>>
>>>
>>>On 10/16/13 3:42 PM, "Wessel, Keith" <kwessel at illinois.edu> wrote:
>>>
>>>>Fabulous, Paul, thanks so much! I'll give this a try today or tomorrow
>>>>and post back if I have problems. In terms of upgrading from 1.1.0, I
>>>>only need to replace the precompiled jar with the new version in my
>>>>IDP, correct? No other changes needed?
>>>>
>>>>Keith
>>>>
>>>>
>>>>-----Original Message-----
>>>>From: users-bounces at shibboleth.net
>>>>[mailto:users-bounces at shibboleth.net]
>>>>On Behalf Of Paul Hethmon
>>>>Sent: Wednesday, October 16, 2013 2:35 PM
>>>>To: Shib Users
>>>>Subject: Re: Announce: Database Backed Storage Service
>>>>
>>>>Keith,
>>>>
>>>>I believe I've found the solution for this. New code has been
>>>>committed and a 1.1.1 build uploaded.
>>>>
>>>>Let me know.
>>>>
>>>>cheers,
>>>>
>>>>Paul
>>>>
>>>>On 10/4/13 10:57 AM, "Wessel, Keith" <kwessel at illinois.edu> wrote:
>>>>
>>>>>Thanks, Paul, for being willing to stick with our Oracle craziness. I
>>>>>know you want to make this code as universal as you can, and it
>>>>>certainly benefits us that you do!
>>>>>
>>>>>Hoping for an easy fix for you. From my googling for that error
>>>>>yesterday before posting to the list, it looks like there's some
>>>>>decent built-in code to Hibernate, assuming I understood what I was
>>>>>reading.
>>>>>
>>>>>Keith
>>>>>
>>>>>
>>>>>-----Original Message-----
>>>>>From: users-bounces at shibboleth.net
>>>>>[mailto:users-bounces at shibboleth.net]
>>>>>On Behalf Of Paul Hethmon
>>>>>Sent: Friday, October 04, 2013 9:54 AM
>>>>>To: Shib Users
>>>>>Subject: Re: Announce: Database Backed Storage Service
>>>>>
>>>>>Yep, pretty obvious what the problem is. I'll have to do some
>>>>>research on how to tell Hibernate to tell Oracle to create/use an
>>>>>identity/key column.
>>>>>
>>>>>Paul
>>>>>
>>>>>On 10/3/13 3:02 PM, "Wessel, Keith" <kwessel at illinois.edu> wrote:
>>>>>
>>>>>>Looks like I found another minor glitch with using your storage
>>>>>>service and Oracle. It's with an item you're using that doesn't seem
>>>>>>to be supported by the Oracle10gDialect.
>>>>>>
>>>>>>Stack trace follows; doubt you need more than the first line to see
>>>>>>the issue.
>>>>>
>>>>>--
>>>>>To unsubscribe from this list send an email to
>>>>>users-unsubscribe at shibboleth.net
>>>>>--
>>>>>To unsubscribe from this list send an email to
>>>>>users-unsubscribe at shibboleth.net
>>>>
>>>>--
>>>>To unsubscribe from this list send an email to
>>>>users-unsubscribe at shibboleth.net
>>>>--
>>>>To unsubscribe from this list send an email to
>>>>users-unsubscribe at shibboleth.net
>>>
>>>--
>>>To unsubscribe from this list send an email to
>>>users-unsubscribe at shibboleth.net
>>>--
>>>To unsubscribe from this list send an email to
>>>users-unsubscribe at shibboleth.net
>>
>>--
>>To unsubscribe from this list send an email to
>>users-unsubscribe at shibboleth.net
>>--
>>To unsubscribe from this list send an email to
>>users-unsubscribe at shibboleth.net
>
>--
>To unsubscribe from this list send an email to
>users-unsubscribe at shibboleth.net

--
To unsubscribe from this list send an email to users-unsubscribe at shibboleth.net