<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: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)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:wf_segoe-ui_normal;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.contentpasted1
{mso-style-name:contentpasted1;}
span.markwuv8aitsw
{mso-style-name:markwuv8aitsw;}
span.contentpasted0
{mso-style-name:contentpasted0;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.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><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Thanks Ed! Would you happen to know where I would place this line? I am scared of breaking something.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Busch, Ed<br>
<b>Sent:</b> Tuesday, March 21, 2023 9:50 AM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Lost Access to ArchivesSpace<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:solid #9C6500 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt">
<p class="MsoNormal" style="line-height:12.0pt;background:#FFEB9C"><b><span style="font-size:10.0pt;color:#9C6500">CAUTION:</span></b><span style="font-size:10.0pt;color:black"> This email originated from outside of the DC Government. Do not click on links
or open attachments unless you recognize the sender and know that the content is safe. If you believe that this email is suspicious, please forward to
<a href="mailto:phishing@dc.gov">phishing@dc.gov</a> for additional analysis by OCTO Security Operations Center (SOC).<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%;cellpadding:0;cellspacing:0;display:table;border-collapse:seperate;float:none">
<tbody>
<tr>
<td style="background:#A6A6A6;padding:5.25pt 1.5pt 5.25pt 1.5pt;valign:middle"></td>
<td width="100%" style="width:100.0%;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 11.25pt">
<div>
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;font-family:wf_segoe-ui_normal;color:#212121">You don't often get email from
<a href="mailto:buschedw@msu.edu">buschedw@msu.edu</a>. <a href="https://aka.ms/LearnAboutSenderIdentification">
Learn why this is important</a><o:p></o:p></span></p>
</div>
</td>
<td width="75" style="width:56.25pt;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 3.75pt;align:left">
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal">I bet it’s related to time change on 3/12. Here’s what’s Blake Carver posted to fix that:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">It's that time of year again! If ArchivesSpace isn't working for you today, check the logs... If you see<o:p></o:p></span></p>
<p class="MsoNormal"><span class="contentpasted1"><span style="font-size:12.0pt;color:black;background:white">DatabaseError: Java::JavaSql::SQLException: </span></span><span class="markwuv8aitsw"><span style="font-size:12.0pt;color:black">HOUR_OF_DAY</span></span><span class="contentpasted1"><span style="font-size:12.0pt;color:black;background:white">:
1 -> 2</span></span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Try this and restart, that'll probably do the trick. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span class="contentpasted0"><span style="font-family:"Courier New";color:black;background:white">UPDATE user set user_mtime = NOW(), system_mtime=NOW();</span></span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="color:black;background:white"> </span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Matthews, Lopez (EOM)<br>
<b>Sent:</b> Tuesday, March 21, 2023 9:45 AM<br>
<b>To:</b> <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> [Archivesspace_Users_Group] Lost Access to ArchivesSpace<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi: <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We have been running our instance of ArchivesSpace for a few months with no issue. For the past week, we have not been able to access ArchivesSpace and get an error saying:
<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt;mso-line-height-alt:15.0pt;background:white">
<span style="font-size:17.5pt;font-family:"Segoe UI",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt;mso-line-height-alt:15.0pt;background:white">
<span style="font-size:17.5pt;font-family:"Segoe UI",sans-serif;color:black">This site can’t be reached</span><span style="font-size:17.5pt;font-family:"Segoe UI",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white">
<b><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#5F6368">localhost</span></b><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#5F6368"> refused to connect.<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Has anyone had this issue and know how to fix it? I have tried looking online but have not found something specific to this issue.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Sincerely, <o:p></o:p></p>
<p class="MsoNormal">Lopez <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Lopez D. Matthews, Jr., PhD<o:p></o:p></p>
<p class="MsoNormal">State Archivist and Public Records Administrator <o:p></o:p></p>
<p class="MsoNormal">Office of the Secretary <o:p></o:p></p>
<p class="MsoNormal">District of Columbia Office of Public Records <o:p></o:p></p>
<p class="MsoNormal">1300 Naylor Court, NW <o:p></o:p></p>
<p class="MsoNormal">Washington, DC 20001<o:p></o:p></p>
<p class="MsoNormal">Office Line – 202-671-1105<o:p></o:p></p>
<p class="MsoNormal">Direct Line – 202-671-1108<o:p></o:p></p>
<p class="MsoNormal"><a href="https://urldefense.com/v3/__https:/opr.dc.gov/__;!!HXCxUKc!07qSygy2qtQn3ibLzC_N9P4qnC9joRVUW11HbGsVLCD0FQxZ3PcWMZi3g3JeIpbH_VIJihgutGOkjrZVfoatk_Ewpw$">https://opr.dc.gov</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><img border="0" width="96" height="127" style="width:1.0in;height:1.3229in" id="Picture_x0020_1" src="cid:image001.png@01D95BDF.D8732640"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</body>
</html>