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-boun...@lyralists.lyrasis.org <archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of Busch, Ed <busch...@msu.edu> Sent: Tuesday, March 21, 2023 10:31 AM To: Archivesspace Users Group <archivesspace_users_group@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-boun...@lyralists.lyrasis.org <archivesspace_users_group-boun...@lyralists.lyrasis.org> On Behalf Of Matthews, Lopez (EOM) Sent: Tuesday, March 21, 2023 10:28 AM To: Archivesspace Users Group <archivesspace_users_group@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-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org> <archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>> On Behalf Of Busch, Ed Sent: Tuesday, March 21, 2023 9:50 AM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@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 phish...@dc.gov<mailto:phish...@dc.gov> for additional analysis by OCTO Security Operations Center (SOC). You don't often get email from busch...@msu.edu<mailto:busch...@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-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org> <archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>> On Behalf Of Matthews, Lopez (EOM) Sent: Tuesday, March 21, 2023 9:45 AM To: archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@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@01D95BE0.417B1E90]
_______________________________________________ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
