Announce: Database Backed Storage Service

[Wessel, Keith]

Duh, I should have figured that one out. Sorry. ;)

The log snippet is interesting, too. As you can see, there are places where it knows what key (kwessel) it should be using, but the line you indicated I should look for does in fact say null.

13:37:09.464 - DEBUG [net.clareitysecurity.shibboleth.storage.DbStorageService:346] [session=] - Using systemName of [shibboleth] for index [30bed2ee0ede4d979992767167afaa134802bb0e9c4d0be39e3eea8da31e064c]
13:37:09.464 - DEBUG [net.clareitysecurity.shibboleth.storage.DbStorageService:392] [session=] - storing to [loginContexts] for key [30bed2ee0ede4d979992767167afaa134802bb0e9c4d0be39e3eea8da31e064c]
13:37:09.464 - DEBUG [net.clareitysecurity.shibboleth.storage.DbStorageService:393] [session=] - value class is [class edu.internet2.middleware.shibboleth.idp.authn.LoginContextEntry]
13:37:17.538 - DEBUG [net.clareitysecurity.shibboleth.storage.DbStorageService:346] [session=] - Using systemName of [shibboleth] for index [e83a97a96ad586796aae9ea704f4bffca6abaf2d39e81bea3c55e1725605d2f4]
13:37:17.539 - DEBUG [net.clareitysecurity.shibboleth.storage.DbStorageService:355] [session=] - Key is a string = [e83a97a96ad586796aae9ea704f4bffca6abaf2d39e81bea3c55e1725605d2f4]
13:37:17.539 - DEBUG [net.clareitysecurity.shibboleth.db.SessionObjectDAOImpl:272] [session=] - Searching for [e83a97a96ad586796aae9ea704f4bffca6abaf2d39e81bea3c55e1725605d2f4] in system [shibboleth]
13:37:17.549 - DEBUG [net.clareitysecurity.shibboleth.db.SessionObjectDAOImpl:64] [session=] - No session object found, performing insert on [e83a97a96ad586796aae9ea704f4bffca6abaf2d39e81bea3c55e1725605d2f4].
13:37:17.592 - DEBUG [net.clareitysecurity.shibboleth.db.SessionObjectDAOImpl:92] [session=] - New persistent session save to db [null]
13:37:17.612 - DEBUG [net.clareitysecurity.shibboleth.storage.DbStorageService:346] [session=e83a97a96ad586796aae9ea704f4bffca6abaf2d39e81bea3c55e1725605d2f4] - Using systemName of [shibboleth] for index [kwessel]
13:37:17.613 - DEBUG [net.clareitysecurity.shibboleth.storage.DbStorageService:355] [session=e83a97a96ad586796aae9ea704f4bffca6abaf2d39e81bea3c55e1725605d2f4] - Key is a string = [kwessel]
13:37:17.613 - DEBUG [net.clareitysecurity.shibboleth.db.SessionObjectDAOImpl:272] [session=e83a97a96ad586796aae9ea704f4bffca6abaf2d39e81bea3c55e1725605d2f4] - Searching for [kwessel] in system [shibboleth]
13:37:17.617 - DEBUG [net.clareitysecurity.shibboleth.db.SessionObjectDAOImpl:64] [session=e83a97a96ad586796aae9ea704f4bffca6abaf2d39e81bea3c55e1725605d2f4] - No session object found, performing insert on [kwessel].
13:37:17.622 - DEBUG [net.clareitysecurity.shibboleth.db.SessionObjectDAOImpl:120] [session=e83a97a96ad586796aae9ea704f4bffca6abaf2d39e81bea3c55e1725605d2f4] - New persistent session save to db [null]

Does this mean the database is somehow rejecting the update and I should talk to my DBA? If so, is there any good way for me to get the exact SQL being sent to add the login_id? I know this is buried under hibernate abstraction, and I think our DBA can turn on trace logging on the Oracle side, but if there's an easier way... such as debug logging for hibernate?

Thanks,
Keith

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

Add something like this to the logging.xml file:

<logger name="net.clareitysecurity.shibboleth">
        <level value="DEBUG" />
        <appender-ref ref="IDP_PROCESS" />
    </logger>

Paul



On 1/8/14 2:11 PM, "Wessel, Keith" <kwessel at illinois.edu> wrote:

>Thanks, Paul. Seems like a reasonable starting point.
>
>I did enable debug logging this morning before I emailed the list for the
>usual edu.internet2.middleware.shibboleth, org.opensaml, and
>edu.vt.middleware.ldap. Yeah, I know those last two were overkill.
>
>But I don't see the debug log entry you're ferring to. What should I be
>logging at debug level that I'm not?
>

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