<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<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);">
It's probably a problem brought on by the change of time this week.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<p dir="auto" style="margin: 0px 0px 16px; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); font-family: system-ui, -apple-system, system-ui, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; color: rgb(47, 57, 65)">
Try this:</p>
<pre dir="ltr" style="padding: 6px 10px; font-family: Consolas, "Liberation Mono", Menlo, "Bitstream Vera Sans Mono", Courier, monospace; font-size: 12.025px; color: rgb(104, 115, 125); border-radius: 3px; display: block; margin: 15px 0px; line-height: 19px; word-break: break-all; overflow-wrap: break-word; background: rgb(248, 249, 249); border: 1px solid rgb(194, 200, 204); outline: 0px"><code style="font-size: 12px; border-radius: 3px; background: none; margin: 0px; outline: 0px; word-break: break-word">MySQL [archivesspace]> select * from auth_db;
+------+------------------+---------------------+---------------------+--------------------------------------------------------------+
| id | username | create_time | system_mtime | pwhash |
+------+------------------+---------------------+---------------------+--------------------------------------------------------------+
| 1 | admin | 2016-03-09 07:10:13 | 2016-03-09 07:10:13 | $2a$10$Gp0oqAuyVXmG/M1s7XDcTuz8.6aTRooPxbf.AWNUuhxNvzsjTa7om |
| 2 | search_indexer | 2016-03-09 07:10:14 | 2019-10-05 08:33:40 | $2a$10$WEoh7JjTOFZ.m.ih9sbxPOHomfcReIBlnAoRQceAbwWFK0DuyC8Tm |
</code></pre>
<p dir="auto" style="margin: 0px 0px 16px; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); font-family: system-ui, -apple-system, system-ui, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; color: rgb(47, 57, 65)">
Take a look at<code style="padding: 0px 5px; font-family: Consolas, "Liberation Mono", Menlo, "Bitstream Vera Sans Mono", Courier, monospace; font-size: 12px; border-radius: 3px; background: rgb(248, 249, 249); border: 1px solid rgb(233, 235, 237); margin: 0px 2px; outline: 0px">search_indexer</code><span> </span>and
the 2 times. The<span> </span><code style="padding: 0px 5px; font-family: Consolas, "Liberation Mono", Menlo, "Bitstream Vera Sans Mono", Courier, monospace; font-size: 12px; border-radius: 3px; background: rgb(248, 249, 249); border: 1px solid rgb(233, 235, 237); margin: 0px 2px; outline: 0px">system_time</code><span> </span>is
probably the one with the bad hour. You can just update that the current time and that should do it. So something like</p>
<p dir="auto" style="margin: 0px 0px 16px; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); font-family: system-ui, -apple-system, system-ui, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; color: rgb(47, 57, 65)">
update auth_db set system_mtime = NOW()where username = search_indexer.</p>
<br>
</div>
<div>
<div id="Signature">
<div id="divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); background-color:rgb(255,255,255)">
</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 Daniel Sprouse
<dsprouse@tsl.texas.gov><br>
<b>Sent:</b> Monday, March 9, 2020 2:35 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] update of previous post archivesspace 'manage user access' pages give error</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div 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)">
new information added, and new log files attached.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
I am homing in on the issue here, thinking it is a java version issue, or a java version recognition issue. If anyone has seen anything like this, any guidance would be appreciated.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
<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)">
<span>after migrating from 2.7.0 to 2.7.1, and from mysqld Ver 5.7.16 to mysqld Ver 8.0.16, from java 1.7 to 1.8<br>
</span>
<div>[root@tslac4avwebtest archivesspace]# java -version<br>
</div>
<div>openjdk version "1.8.0_232"<br>
</div>
<div>OpenJDK Runtime Environment (build 1.8.0_232-b09)<br>
</div>
<div>OpenJDK 64-Bit Server VM (build 25.232-b09, mixed mode)<br>
</div>
<div>BUT...<br>
</div>
<div>when it was working, the output on the backend webpage showed java 1.7! (I think that not seeing java 1.8 is probably the issue)<br>
</div>
<div>backend_url http://aristest.tsl.texas.gov:8089<br>
</div>
<div>{ "databaseProductName": "MySQL", "databaseProductVersion": "8.0.16", "ruby_version": "2.3.0", "host_os": "linux", "host_cpu": "x86_64", "build": "java1.7", "archivesSpaceVersion": "v2.7.1" }<br>
</div>
<div>-------------------------------------<br>
</div>
<div>Archivesspace started normally several times on Friday, but I got errors when I went to user management pages.<br>
</div>
<div>archivesspace admin account 'System'->'manage users' and 'Repository Settings'->'manage user access' pages give error<br>
</div>
<div>http://arisint.tsl.texas.gov:8080/users<br>
</div>
<div>http://arisint.tsl.texas.gov:8080/users/manage_access<br>
</div>
<div>"We're sorry, but something went wrong."<br>
</div>
<div><br>
</div>
<div>I have not found any other pages that give this error.<br>
</div>
<div>attached is a tail -f of archivesspace.out while attempting to get to 'System'->'manage users'<br>
</div>
<span>and a diagnostic spawned by archivesspace, aspace_diagnostic_1583775751.txt</span><br>
</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div id="x_Signature">
<div id="x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; font-family:Calibri,Helvetica,sans-serif; color:rgb(0,0,0)">
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0"></p>
<div><img class="x_EmojiInsert" data-outlook-trace="F:2|T:2" src="cid:f31f7ef0-8e07-4602-9acc-c50afd47b573"><br>
</div>
<br>
<p style="margin-top:0px; margin-bottom:0px"></p>
</div>
</div>
</div>
</div>
</body>
</html>