<html><head><style>pre,code,address {
margin: 0px;
}
h1,h2,h3,h4,h5,h6 {
margin-top: 0.2em;
margin-bottom: 0.2em;
}
ol,ul {
margin-top: 0em;
margin-bottom: 0em;
}
blockquote {
margin-top: 0em;
margin-bottom: 0em;
}
</style></head><body><p></p><div style="font-size: 14.666667px;">Hallo all,</div><div style="font-size: 14.666667px;"><br></div><div style="font-size: 14.666667px;">we still have to migrate from <span style="font-size: 14.666667px;">shibboleth.JPAStorageService to JDBCStorageService. I followed the docs[1], but now the new datasets differ, so that existing entries are not valid anymore. This results in user consent to pop up again - and some nasty json-parsing exceptions.</span></div><div style="font-size: 14.666667px;"><br></div><div style="font-size: 14.666667px;">here are my database entries (test data - redacted)</div><div style="font-size: 14.666667px;"><br></div><div style="font-size: 14.666667px;">table "storagerecords" with shibboleth.JPAStorageService:</div><table style="border: solid rgb(100, 149, 237); border-collapse: collapse; width: 3784px;"><tbody><tr><th colspan="5" style="font-family: monospace; border: thin solid rgb(100, 149, 237); padding: 5px; background-color: rgb(208, 227, 250); text-align: left;"><pre><code>select * from storagerecords</code></pre></th></tr><tr><th style="font-family: monospace; border: thin solid rgb(100, 149, 237); padding: 5px; background-color: rgb(208, 227, 250); text-align: left;">context</th><th style="font-family: monospace; border: thin solid rgb(100, 149, 237); padding: 5px; background-color: rgb(208, 227, 250); text-align: left;">id</th><th style="font-family: monospace; border: thin solid rgb(100, 149, 237); padding: 5px; background-color: rgb(208, 227, 250); text-align: left;">expires</th><th style="font-family: monospace; border: thin solid rgb(100, 149, 237); padding: 5px; background-color: rgb(208, 227, 250); text-align: left;">value</th><th style="font-family: monospace; border: thin solid rgb(100, 149, 237); padding: 5px; background-color: rgb(208, 227, 250); text-align: left;">version</th></tr><tr class="odd" style="background: rgb(232, 237, 255);"><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">582b114eedac80d76b557f2ec12ec85ed6b13096e7ceb85408b886b700a39344</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">authn/MFA</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1.707.235.769.569</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">16401</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1</td></tr><tr><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">intercept/attribute-release</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">johndoe:<a href="https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth" title="Click to open https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth">https://sp.example.com/shibboleth</a></td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;"> </td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">16403</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1</td></tr><tr class="odd" style="background: rgb(232, 237, 255);"><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">intercept/attribute-release</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">johndoe:_key_idx</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;"> </td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">16404</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1</td></tr><tr><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">582b114eedac80d76b557f2ec12ec85ed6b13096e7ceb85408b886b700a39344</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;"><a href="https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth" title="Click to open https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth">https://sp.example.com/shibboleth</a></td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1.707.240.573.812</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">16405</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1</td></tr><tr class="odd" style="background: rgb(232, 237, 255);"><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">582b114eedac80d76b557f2ec12ec85ed6b13096e7ceb85408b886b700a39344</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">_session</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1.707.236.969.578</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">16406</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">3</td></tr><tr><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;"><a href="https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth" title="Click to open https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth">https://sp.example.com/shibboleth</a></td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">sV1uW+rlsx/EqtSSo/xcDlGGj28=</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1.707.240.573.812</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">16407</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1</td></tr></tbody></table><div style="font-size: 14.666667px;"><br></div><div style="font-size: 14.666667px;">table "storagerecords" with <span style="font-size: 14.666667px;">JDBCStorageService:</span></div><table style="border: solid rgb(100, 149, 237); border-collapse: collapse; width: 3784px;"><tbody><tr><th colspan="5" style="font-family: monospace; border: thin solid rgb(100, 149, 237); padding: 5px; background-color: rgb(208, 227, 250); text-align: left;"><pre><code>select * from storagerecords</code></pre></th></tr><tr><th style="font-family: monospace; border: thin solid rgb(100, 149, 237); padding: 5px; background-color: rgb(208, 227, 250); text-align: left;">context</th><th style="font-family: monospace; border: thin solid rgb(100, 149, 237); padding: 5px; background-color: rgb(208, 227, 250); text-align: left;">id</th><th style="font-family: monospace; border: thin solid rgb(100, 149, 237); padding: 5px; background-color: rgb(208, 227, 250); text-align: left;">expires</th><th style="font-family: monospace; border: thin solid rgb(100, 149, 237); padding: 5px; background-color: rgb(208, 227, 250); text-align: left;">value</th><th style="font-family: monospace; border: thin solid rgb(100, 149, 237); padding: 5px; background-color: rgb(208, 227, 250); text-align: left;">version</th></tr><tr class="odd" style="background: rgb(232, 237, 255);"><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1a2a26b6a4701699c8195c0a83cf567dc8dcdee7cf2d4db6e6690008af629103</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">authn/MFA</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1.707.236.290.770</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">{"id":"authn/MFA","ts":1707233890770,"princ":[{"AUTHRES":"{\"id\":\"authn/Password\",\"ts\":1707233879983,\"princ\":[{\"typ\":1,\"nam\":107},{\"typ\":3,\"nam\":200},{\"typ\":1,\"nam\":108},{\"LDAPN\":\"johndoe\",\"LDAPE\":{\"dn\":\"cn=johndoe,ou=Active,ou=User,o=hmt\"}},{\"U\":\"johndoe\"}]}"},{"typ":1,"nam":107},{"typ":3,"nam":200},{"typ":1,"nam":108},{"LDAPN":"johndoe","LDAPE":{"dn":"cn=johndoe,ou=Active,ou=User,o=hmt"}},{"U":"johndoe"},{"AUTHRES":"{\"id\":\"authn/fudiscr\",\"ts\":1707233890761,\"princ\":[{\"typ\":1,\"nam\":\"urn:de:zedat:fudis:SAML:2.0:ac:classes:CR\"},{\"TID\":\"TOTP00006415\"},{\"U\":\"johndoe\"}]}"},{"typ":1,"nam":"urn:de:zedat:fudis:SAML:2.0:ac:classes:CR"},{"TID":"TOTP00006415"}]}</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1</td></tr><tr><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">intercept/attribute-release</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">johndoe:<a href="https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth" title="Click to open https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth">https://sp.example.com/shibboleth</a></td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;"> </td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">[{"id":301,"v":"x7wtAxaDrz4H9nu67g7puu14HK79scDoXKXNppyUJk8="},{"id":307,"v":"zRNaUun+RC3dpzUESFwn/AlGiTO1H9mZdMYD4rie91Y="},{"id":308,"v":"ONCCZMWPTk78Jpml0WHzawPTuyF0bFIVMy3xruXFeOo="},{"id":117,"v":"n1VnUiHwxN+01vGvHJiOf7ii+/ILLBcWm0X92gmgtro="},{"id":"mail","v":"RrBlcv7Mdg0vm/lA9Pw+qkUKJVYqS3kU+K29tVtxmfA="},{"id":"sn","v":"cxV005JLyQhM++fBupmPLfNzzBmJwgyunBsDy0sIGdg="},{"id":"uid","v":"S5Ui2yuQZoQuqVFmpaYVa5vRnjFPRaLqT/h4lwufHnw="}]</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1</td></tr><tr class="odd" style="background: rgb(232, 237, 255);"><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">intercept/attribute-release</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">johndoe:_key_idx</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;"> </td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">["johndoe:<a href="https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth" title="Click to open https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth">https://sp.example.com/shibboleth</a>"]</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1</td></tr><tr><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1a2a26b6a4701699c8195c0a83cf567dc8dcdee7cf2d4db6e6690008af629103</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;"><a href="https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth" title="Click to open https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth">https://sp.example.com/shibboleth</a></td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1.707.241.095.865</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">net.shibboleth.idp.saml.session.SAML2SPSession:{"id":"<a href="https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth%22,%22ts%22:1707233895865,%22nam" title="Click to open https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth%22,%22ts%22:1707233895865,%22nam">https://sp.example.com/shibboleth","ts":1707233895865,"nam</a>":"<saml2:NameID xmlns:saml2=\"urn:oasis:names:tc:SAML:2.0:assertion\" Format=\"urn:oasis:names:tc:SAML:2.0:nameid-format:persistent\" NameQualifier=\"<a href="https://idp.us66zumi.dev.hmt-leipzig.de/shibboleth/" title="Click to open https://idp.us66zumi.dev.hmt-leipzig.de/shibboleth/">https://idp.example.com/shibboleth\</a>" SPNameQualifier=\"<a href="https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth/" title="Click to open https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth/">https://sp.example.com/shibboleth\</a>">sV1uW+rlsx/EqtSSo/xcDlGGj28=</saml2:NameID>","ix":"_adacc4a1bb07f7e448aea9c56be3be66","acs":"<a href="https://redmine.us66zumi.dev.hmt-leipzig.de/Shibboleth.sso/SAML2/POST%22,%22slo%22:true" title="Click to open https://redmine.us66zumi.dev.hmt-leipzig.de/Shibboleth.sso/SAML2/POST%22,%22slo%22:true">https://sp.example.com/Shibboleth.sso/SAML2/POST","slo":true</a>}</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1</td></tr><tr class="odd" style="background: rgb(232, 237, 255);"><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1a2a26b6a4701699c8195c0a83cf567dc8dcdee7cf2d4db6e6690008af629103</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">_session</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1.707.237.490.779</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">{"ts":1707233890779,"nam":"johndoe","v4":"172.17.5.1","flows":["authn/MFA"],"svcs":["<a href="https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth" title="Click to open https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth">https://sp.example.com/shibboleth</a>"]}</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">3</td></tr><tr><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;"><a href="https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth" title="Click to open https://redmine.us66zumi.dev.hmt-leipzig.de/shibboleth">https://sp.example.com/shibboleth</a></td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">sV1uW+rlsx/EqtSSo/xcDlGGj28=</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1.707.241.095.865</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1a2a26b6a4701699c8195c0a83cf567dc8dcdee7cf2d4db6e6690008af629103,</td><td style="font-family: sans-serif; border: thin solid rgb(100, 149, 237); padding: 5px; text-align: center;">1</td></tr></tbody></table><div style="font-size: 14.666667px;"><br></div><div style="font-size: 14.666667px;"><br></div><div style="font-size: 14.666667px;">As you can see the value-field now holds a JSON object and is not compatible to the old values - whatever they represent. </div><div style="font-size: 14.666667px;"><br></div><div style="font-size: 14.666667px;">Does anyone can explain / know how to fix this?</div><div style="font-size: 14.666667px;"><br></div><div style="font-size: 14.666667px;">Thanks in advance</div><div style="font-size: 14.666667px;">cheers</div><div style="font-size: 14.666667px;"><br></div><div style="font-size: 14.666667px;"><span style="font-size: 14.666667px;">[1]: </span><a href="https://shibboleth.atlassian.net/wiki/spaces/IDPPLUGINS/pages/2989096970/JDBCStorageService" style="font-size: 14.666667px;">https://shibboleth.atlassian.net/wiki/spaces/IDPPLUGINS/pages/2989096970/JDBCStorageService</a></div><div style="font-size: 14.666667px;"><pre>-- <br></pre><pre>Ulf Seltmann
System-Administrator
Hochschule für Musik und Theater Leipzig
IT-Dienste
Grassistraße 8 | 04107 Leipzig
Tel.: +49 341 2144 681
<a href="mailto:ulf.seltmann@hmt-leipzig.de">ulf.seltmann@hmt-leipzig.de</a> | <a href="https://www.hmt-leipzig.de">www.hmt-leipzig.de</a></pre></div><pre><code>
</code></pre>
</body></html>