> SELECT TOP 10 cast(cast(AUTHENTICATION as varbinary(8000)) as varchar(8000)) > FROM TICKETGRANTINGTICKET > but just got a bunch of "’"
Which is what you'd expect for what's contained in that column, a binary blob of data corresponding to the Java serialized data of an ImmutableAuthentication object instance. I don't know what DB platform Ben is using, but it's unusual for a query that simple to work on any platform for binary data. For example, you can't do anything remotely similar on PostgreSQL afaik. In any case if the cast above works, you may be safe to use a LIKE operator on the converted binary data to search for the text REMEMBER_ME like Ben suggested. In any case that's not the best way to determine whether you've enabled the "Remember Me" feature. It's something that has to be explicitly enabled as described at https://wiki.jasig.org/display/CASUM/Remember+Me. If you've done that configuration, it's enabled. It's hard to imagine you've got > 1M SSO sessions caused by that feature unless you have an enormous SSO domain. I imagine it's more likely that you don't have a RegistryCleaner component set up properly to purge orphaned sessions. M -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-dev
