[Archivesspace_Users_Group] Lost Access to ArchivesSpace

Tue Mar 21 10:34:50 EDT 2023

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.

- Megan

_____________________________________

Megan Schanz
Application Developer & Systems Administrator
Michigan State University Libraries
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Busch, Ed <buschedw at msu.edu>
Sent: Tuesday, March 21, 2023 10:31 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Lost Access to ArchivesSpace

Sorry, I don’t. We get hit with this each time change and our IT fixes it. I’

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Matthews, Lopez (EOM)
Sent: Tuesday, March 21, 2023 10:28 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Lost Access to ArchivesSpace

Thanks Ed! Would you happen to know where I would place this line? I am scared of breaking something.

From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> On Behalf Of Busch, Ed
Sent: Tuesday, March 21, 2023 9:50 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] Lost Access to ArchivesSpace

CAUTION: 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 phishing at dc.gov<mailto:phishing at dc.gov> for additional analysis by OCTO Security Operations Center (SOC).

You don't often get email from buschedw at msu.edu<mailto:buschedw at msu.edu>. Learn why this is important<https://urldefense.com/v3/__https:/aka.ms/LearnAboutSenderIdentification__;!!HXCxUKc!0X9Qu0dyYMuwuMJbI4Q6LeZkKyFeVhRlPdNmukNJD5MjAyoWYSGJfGwzyOgkOjiUQf5sLv2MIT0guar8eEirfYx5gg$>

I bet it’s related to time change on 3/12. Here’s what’s Blake Carver  posted to fix that:

It's that time of year again! If ArchivesSpace isn't working for you today, check the logs... If you see

DatabaseError: Java::JavaSql::SQLException: HOUR_OF_DAY: 1 -> 2

Try this and restart, that'll probably do the trick.

UPDATE user set user_mtime = NOW(), system_mtime=NOW();

From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> On Behalf Of Matthews, Lopez (EOM)
Sent: Tuesday, March 21, 2023 9:45 AM
To: archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Lost Access to ArchivesSpace

Hi:

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:

This site can’t be reached

localhost refused to connect.

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.

Sincerely,

Lopez

Lopez D. Matthews, Jr., PhD

State Archivist and Public Records Administrator

Office of the Secretary

District of Columbia Office of Public Records

1300 Naylor Court, NW

Washington, DC 20001

Office Line – 202-671-1105

Direct Line – 202-671-1108

https://opr.dc.gov<https://urldefense.com/v3/__https:/opr.dc.gov/__;!!HXCxUKc!07qSygy2qtQn3ibLzC_N9P4qnC9joRVUW11HbGsVLCD0FQxZ3PcWMZi3g3JeIpbH_VIJihgutGOkjrZVfoatk_Ewpw$>

[cid:image001.png at 01D95BE0.417B1E90]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230321/529b4f0e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 24585 bytes
Desc: image001.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230321/529b4f0e/attachment.png>