<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Menlo;
panose-1:2 11 6 9 3 8 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:10.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
p.p1, li.p1, div.p1
{mso-style-name:p1;
margin:0in;
font-size:8.5pt;
font-family:Menlo;
color:black;}
p.p2, li.p2, div.p2
{mso-style-name:p2;
margin:0in;
font-size:8.5pt;
font-family:Menlo;
color:black;}
span.s1
{mso-style-name:s1;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt">Hi Scott,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I switched to JDBCStorageService and still the same behavior.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="p1"><span class="s1">2022-10-11 15:07:18,852 - 10.227.147.184 - DEBUG [org.opensaml.storage.impl.client.PopulateClientStorageLoadContext:118] - Profile Action PopulateClientStorageLoadContext: ClientStorageServices requiring load: [shibboleth.ClientSessionStorageService,
shibboleth.ClientPersistentStorageService]</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="p1"><span class="s1">2022-10-11 15:07:37,019 - 10.227.147.184 - DEBUG [org.opensaml.storage.impl.client.LogLocalStorageSaveResults:81] - Profile Action LogLocalStorageSaveResults: Save to local storage for StorageService 'shibboleth.ClientPersistentStorageService'
succeeded</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="p1"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;background:yellow;mso-highlight:yellow">vi
</span><span class="s1"><span style="background:yellow;mso-highlight:yellow">/opt/shibboleth-idp/conf/global.xml</span></span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="p1"><span class="s1"><!-- DB-independent Configuration --></span><o:p></o:p></p>
<p class="p2"><o:p> </o:p></p>
<p class="p1"><span class="s1"><bean id="shibboleth.JPAStorageService"</span><span class="apple-converted-space"> </span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">parent="shibboleth.JDBCStorageService"</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">p:cleanupInterval="%{idp.storage.cleanupInterval:PT10M}"</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">p:dataSource-ref="shibboleth.JPAStorageService.DataSource"/></span><o:p></o:p></p>
<p class="p2"><o:p> </o:p></p>
<p class="p1"><span class="s1"><!-- DB-dependent Configuration --></span><o:p></o:p></p>
<p class="p2"><o:p> </o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1"><bean id="shibboleth.JPAStorageService.DataSource"</span><span class="apple-converted-space"> </span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">class="com.zaxxer.hikari.HikariDataSource" destroy-method="close" lazy-init="true"</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">p:driverClassName="com.mysql.jdbc.Driver"</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">p:jdbcUrl="jdbc:mysql://localhost:3306/storageservice"</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">p:username="root"</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">p:password="tiger" /></span><o:p></o:p></p>
<p class="p2"><o:p> </o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1"><bean id="JDBCStorageService" parent="shibboleth.JDBCStorageService"</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">p:dataSource-ref="shibboleth.JPAStorageService.DataSource"</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">p:transactionIsolation="4"</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">p:retryableErrors="40001"</span><o:p></o:p></p>
<p class="p1"><span class="apple-converted-space"> </span><span class="s1">/></span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="p1"><span class="s1">MariaDB [mysql]> <span style="background:yellow;mso-highlight:yellow">
select * from storageservice.StorageRecords;</span></span><o:p></o:p></p>
<p class="p1"><span class="s1"><b>Empty set (0.000 sec)</b></span><o:p></o:p></p>
<p class="p2"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Sunil<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:12.0pt;color:black">From:
</span></b><span style="font-size:12.0pt;color:black">Cantor, Scott <cantor.2@osu.edu><br>
<b>Date: </b>Tuesday, October 11, 2022 at 1:41 PM<br>
<b>To: </b>Mathew, Sunil <smathew@hbs.edu>, Shib Users <users@shibboleth.net><br>
<b>Subject: </b>Re: Question about shibboleth.ClientPersistentStorageService<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:11.0pt">On 10/11/22, 1:35 PM, "Mathew, Sunil" <smathew@hbs.edu> wrote:<br>
<br>
> To be clear, I want to replace ClientSessionStorageService with a<br>
> database-backed storage service to store session cookies. Let me know if<br>
> you if there is one that can do that. <br>
<br>
I think that's a very, very bad idea, but that's in the wiki.<br>
<br>
<a href="https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fshibboleth.atlassian.net%2Fwiki%2Fspaces%2FIDPPLUGINS%2Fpages%2F2989096970%2FJDBCStorageService&data=05%7C01%7Csmathew%40hbs.edu%7Cc8faa51a06d14f03a39408daabafc24b%7C09fd564ebf4243218f2db8e482f8635c%7C0%7C0%7C638011068627635217%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=UGxDxgPPXIIxSSM07%2FH77RSU4oVpC%2FmMFNUkMXPhREo%3D&reserved=0">https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fshibboleth.atlassian.net%2Fwiki%2Fspaces%2FIDPPLUGINS%2Fpages%2F2989096970%2FJDBCStorageService&data=05%7C01%7Csmathew%40hbs.edu%7Cc8faa51a06d14f03a39408daabafc24b%7C09fd564ebf4243218f2db8e482f8635c%7C0%7C0%7C638011068627635217%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=UGxDxgPPXIIxSSM07%2FH77RSU4oVpC%2FmMFNUkMXPhREo%3D&reserved=0</a><br>
<br>
The original one in the IdP based on Hibernate is deprecated, that's the one to use going forward.<br>
<br>
-- Scott<br>
<br>
<o:p></o:p></span></p>
</div>
</div>
</body>
</html>