JDBC Storage Service on Shibboleth IDP 5.0

[Rod Widdowson]

> Not much adoption of 5 but the plugin has been used by people on 4, plenty of bug reports on it.

The V2 version has one minor bug fix but otherwise is a recompile of the V1.last version.  So everything should "just work".

During initialization the service does a round trip to the database so I think that the best working premise is that the bean isn't
happening for some reason.

If you turn up logging for net.shibboleth.plugin.storage.jdbc.impl to TRACE it gets really quite noisy, so that would be my next
step.  

With apologies to the list, This is the log from an initialization sequence:

TRACE [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:581] - Create [Insert]:: 'INSERT INTO StorageRecords(context, id,
expires, value, version) VALUES (?, ?, ?, ?, 1)'  1: 'net.shibboleth.plugin.storage.jdbc.impl.test' ; 2:
'net.shibboleth.plugin.storage.jdbc.impl.test' ; 3 '1697622346082' ; 4 'net.shibboleth.plugin.storage.jdbc.impl.test'
TRACE [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:669] - Read:: 'SELECT version, expires, value FROM StorageRecords
WHERE context=? AND id=?' 1: 'net.shibboleth.plugin.storage.jdbc.impl.test' ; 2: 'net.shibboleth.plugin.storage.jdbc.impl.test'
TRACE [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:681] - Considering Version '1', Expires
'net.shibboleth.plugin.storage.jdbc.impl.test', Value '1697622346082'
TRACE [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:669] - Read:: 'SELECT version, expires, value FROM StorageRecords
WHERE context=? AND id=?' 1: 'net.shibboleth.plugin.storage.jdbc.impl.test' ; 2: 'NET.SHIBBOLETH.PLUGIN.STORAGE.JDBC.IMPL.TEST'
DEBUG [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:674] - Nothing returned
TRACE [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:669] - Read:: 'SELECT version, expires, value FROM StorageRecords
WHERE context=? AND id=?' 1: 'NET.SHIBBOLETH.PLUGIN.STORAGE.JDBC.IMPL.TEST' ; 2: 'net.shibboleth.plugin.storage.jdbc.impl.test'
DEBUG [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:674] - Nothing returned
TRACE [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:889] - Delete [Query]:: 'SELECT version FROM StorageRecords WHERE
context=? AND id=?':  1: 'net.shibboleth.plugin.storage.jdbc.impl.test' ; 2: 'net.shibboleth.plugin.storage.jdbc.impl.test'
TRACE [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:900] - Delete [Delete]:: 'DELETE FROM StorageRecords WHERE
context=? AND id=?':  1: 'net.shibboleth.plugin.storage.jdbc.impl.test' ; 2: 'net.shibboleth.plugin.storage.jdbc.impl.test'
DEBUG [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:1200] - Running cleanup task at 1697621749579
TRACE [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:944] - DeleteByExpired:: 'DELETE FROM StorageRecords WHERE expires
<= ? ':  1: '1697621749579' ;
DEBUG [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:1206] - Finished cleanup task for 1697621749579