<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
You connect to the database that your ArchivesSpace instance is using and run that SQL command. The connection information should be in your config.yml file.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
- Megan</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
<br>
</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="color:rgb(102,102,102)">_____________________________________</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="color:rgb(102,102,102)"><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="color:rgb(102,102,102)">Megan Schanz</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="color:rgb(102,102,102)">Application Developer & Systems Administrator</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="color:rgb(102,102,102)">Michigan State University Libraries</span></div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Busch, Ed <buschedw@msu.edu><br>
<b>Sent:</b> Tuesday, March 21, 2023 10:31 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</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:"Segoe UI"}
@font-face
{font-family:wf_segoe-ui_normal}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:#0563C1;
text-decoration:underline}
span.x_contentpasted1
{}
span.x_markwuv8aitsw
{}
span.x_contentpasted0
{}
span.x_EmailStyle23
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
-->
</style>
<div lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="x_WordSection1">
<p class="x_MsoNormal">Sorry, I don’t. We get hit with this each time change and our IT fixes it. I’</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Matthews, Lopez (EOM)<br>
<b>Sent:</b> Tuesday, March 21, 2023 10:28 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</p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Thanks Ed! Would you happen to know where I would place this line? I am scared of breaking something.</p>
<p class="x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_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>Busch, Ed<br>
<b>Sent:</b> Tuesday, March 21, 2023 9:50 AM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Lost Access to ArchivesSpace</p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<div style="border:solid #9C6500 1.0pt; padding:2.0pt 2.0pt 2.0pt 2.0pt">
<p class="x_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).</span></p>
</div>
<p class="x_MsoNormal"> </p>
<div>
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%; display:table; border-collapse:seperate; float:none">
<tbody>
<tr>
<td style="background:#A6A6A6; padding:5.25pt 1.5pt 5.25pt 1.5pt"></td>
<td width="100%" style="width:100.0%; background:#EAEAEA; padding:5.25pt 3.75pt 5.25pt 11.25pt">
<div>
<p class="x_MsoNormal" style=""><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://urldefense.com/v3/__https:/aka.ms/LearnAboutSenderIdentification__;!!HXCxUKc!0X9Qu0dyYMuwuMJbI4Q6LeZkKyFeVhRlPdNmukNJD5MjAyoWYSGJfGwzyOgkOjiUQf5sLv2MIT0guar8eEirfYx5gg$">
Learn why this is important</a></span></p>
</div>
</td>
<td width="75" style="width:56.25pt; background:#EAEAEA; padding:5.25pt 3.75pt 5.25pt 3.75pt">
</td>
</tr>
</tbody>
</table>
<div>
<p class="x_MsoNormal">I bet it’s related to time change on 3/12. Here’s what’s Blake Carver posted to fix that:</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal" style="background:white"><span style="font-size:12.0pt; color:black"> </span></p>
<p class="x_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</span></p>
<p class="x_MsoNormal"><span class="x_contentpasted1"><span style="font-size:12.0pt; color:black; background:white">DatabaseError: Java::JavaSql::SQLException: </span></span><span class="x_markwuv8aitsw"><span style="font-size:12.0pt; color:black">HOUR_OF_DAY</span></span><span class="x_contentpasted1"><span style="font-size:12.0pt; color:black; background:white">:
1 -> 2</span></span><span style="font-size:12.0pt; color:black"></span></p>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">Try this and restart, that'll probably do the trick. </span></p>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
<p class="x_MsoNormal"><span class="x_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"></span></p>
<p class="x_MsoNormal" style="background:white"><span style="font-size:12.0pt; color:black"> </span></p>
<p class="x_MsoNormal" style="background:white"><span style="color:black; background:white"> </span><span style="font-size:12.0pt; color:black"></span></p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_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</p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Hi: </p>
<p class="x_MsoNormal"> </p>
<p class="x_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:
</p>
<p class="x_MsoNormal" style="margin-bottom:12.0pt; background:white"><span style="font-size:17.5pt; font-family:"Segoe UI",sans-serif"> </span></p>
<p class="x_MsoNormal" style="margin-bottom:12.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"></span></p>
<p class="x_MsoNormal" style="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.</span></p>
<p class="x_MsoNormal"> </p>
<p class="x_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.
</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Sincerely, </p>
<p class="x_MsoNormal">Lopez </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Lopez D. Matthews, Jr., PhD</p>
<p class="x_MsoNormal">State Archivist and Public Records Administrator </p>
<p class="x_MsoNormal">Office of the Secretary </p>
<p class="x_MsoNormal">District of Columbia Office of Public Records </p>
<p class="x_MsoNormal">1300 Naylor Court, NW </p>
<p class="x_MsoNormal">Washington, DC 20001</p>
<p class="x_MsoNormal">Office Line – 202-671-1105</p>
<p class="x_MsoNormal">Direct Line – 202-671-1108</p>
<p class="x_MsoNormal"><a href="https://urldefense.com/v3/__https:/opr.dc.gov/__;!!HXCxUKc!07qSygy2qtQn3ibLzC_N9P4qnC9joRVUW11HbGsVLCD0FQxZ3PcWMZi3g3JeIpbH_VIJihgutGOkjrZVfoatk_Ewpw$">https://opr.dc.gov</a></p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"><img border="0" width="96" height="127" id="x_Picture_x0020_1" style="width:1.0in; height:1.3229in" data-outlook-trace="F:1|T:1" src="cid:image001.png@01D95BE0.417B1E90"></p>
<p class="x_MsoNormal"> </p>
</div>
</div>
</div>
</div>
</body>
</html>