<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:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
code
{mso-style-priority:99;
font-family:"Courier New";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
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">
<div class="WordSection1">
<p class="MsoNormal">Thanks for the help…<o:p></o:p></p>
<p class="MsoNormal">This makes sense for the Daniel’s case – where his error was:<o:p></o:p></p>
<p class="MsoNormal">Thread-10706: Error communicating with authentication source DBAuth: Java::JavaSql::SQLException: HOUR_OF_DAY: 2 -> 3<o:p></o:p></p>
<p class="MsoNormal">So the date glitch is probably in the auth_db table.<o:p></o:p></p>
<p class="MsoNormal">I checked my auth_db table and didn’t see any problematic dates.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">My error in more context is:<o:p></o:p></p>
<p class="MsoNormal">Mar 10, 2020 1:01:52 PM org.eclipse.jetty.server.handler.ContextHandler$Context log<o:p></o:p></p>
<p class="MsoNormal">INFO: An exception happened during JRuby-Rack startup<o:p></o:p></p>
<p class="MsoNormal">Java::JavaSql::SQLException: HOUR_OF_DAY: 2 -> 3<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Any thoughts on how I figure out where my glitchy dates might be stored?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks for any ideas…<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Mike<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New""><o:p> </o:p></span></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>Blake Carver<br>
<b>Sent:</b> Monday, March 9, 2020 2:49 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] update of previous post archivesspace 'manage user access' pages give error<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">It's probably a problem brought on by the change of time this week.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p style="margin-bottom:12.0pt;line-height:15.0pt;background:white;outline: 0px">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;color:#2F3941">Try this:<o:p></o:p></span></p>
<div style="mso-element:para-border-div;border:solid #C2C8CC 1.0pt;padding:5.0pt 8.0pt 5.0pt 8.0pt;background:#F8F9F9">
<pre style="line-height:14.25pt;background:#F8F9F9;word-break:break-all;border:none;padding:0in;border-radius: 3px;overflow-wrap: break-word;outline: 0px"><code><span style="font-size:9.0pt;color:#68737D">MySQL [archivesspace]> select * from auth_db;<o:p></o:p></span></code></pre>
<pre style="line-height:14.25pt;background:#F8F9F9;word-break:break-all;border:none;padding:0in"><code><span style="font-size:9.0pt;color:#68737D">+------+------------------+---------------------+---------------------+--------------------------------------------------------------+<o:p></o:p></span></code></pre>
<pre style="line-height:14.25pt;background:#F8F9F9;word-break:break-all;border:none;padding:0in"><code><span style="font-size:9.0pt;color:#68737D">| id | username | create_time | system_mtime | pwhash |<o:p></o:p></span></code></pre>
<pre style="line-height:14.25pt;background:#F8F9F9;word-break:break-all;border:none;padding:0in"><code><span style="font-size:9.0pt;color:#68737D">+------+------------------+---------------------+---------------------+--------------------------------------------------------------+<o:p></o:p></span></code></pre>
<pre style="line-height:14.25pt;background:#F8F9F9;word-break:break-all;border:none;padding:0in"><code><span style="font-size:9.0pt;color:#68737D">| 1 | admin | 2016-03-09 07:10:13 | 2016-03-09 07:10:13 | $2a$10$Gp0oqAuyVXmG/M1s7XDcTuz8.6aTRooPxbf.AWNUuhxNvzsjTa7om |<o:p></o:p></span></code></pre>
<pre style="line-height:14.25pt;background:#F8F9F9;word-break:break-all;border:none;padding:0in"><code><span style="font-size:9.0pt;color:#68737D">| 2 | search_indexer | 2016-03-09 07:10:14 | 2019-10-05 08:33:40 | $2a$10$WEoh7JjTOFZ.m.ih9sbxPOHomfcReIBlnAoRQceAbwWFK0DuyC8Tm |<o:p></o:p></span></code></pre>
</div>
<p style="line-height:15.0pt;background:white;outline: 0px"><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;color:#2F3941">Take a look at</span><code><span style="font-size:9.0pt;font-family:Consolas;color:#2F3941;border:solid #E9EBED 1.0pt;padding:0in;background:#F8F9F9">search_indexer</span></code><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;color:#2F3941"> and
the 2 times. The </span><code><span style="font-size:9.0pt;font-family:Consolas;color:#2F3941;border:solid #E9EBED 1.0pt;padding:0in;background:#F8F9F9">system_time</span></code><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;color:#2F3941"> is
probably the one with the bad hour. You can just update that the current time and that should do it. So something like<o:p></o:p></span></p>
<p style="margin-bottom:12.0pt;line-height:15.0pt;background:white;outline: 0px">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;color:#2F3941">update auth_db set system_mtime = NOW()where username = search_indexer.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black">
<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>>
on behalf of Daniel Sprouse <<a href="mailto:dsprouse@tsl.texas.gov">dsprouse@tsl.texas.gov</a>><br>
<b>Sent:</b> Monday, March 9, 2020 2:35 PM<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> [Archivesspace_Users_Group] update of previous post archivesspace 'manage user access' pages give error</span>
<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">new information added, and new log files attached.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">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.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">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<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">[root@tslac4avwebtest archivesspace]# java -version<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">openjdk version "1.8.0_232"<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">OpenJDK Runtime Environment (build 1.8.0_232-b09)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">OpenJDK 64-Bit Server VM (build 25.232-b09, mixed mode)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">BUT...<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">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)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">backend_url
<a href="http://aristest.tsl.texas.gov:8089">http://aristest.tsl.texas.gov:8089</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">{ "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" }<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">-------------------------------------<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">Archivesspace started normally several times on Friday, but I got errors when I went to user management pages.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">archivesspace admin account 'System'->'manage users' and 'Repository Settings'->'manage user access' pages give error<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><a href="http://arisint.tsl.texas.gov:8080/users">http://arisint.tsl.texas.gov:8080/users</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><a href="http://arisint.tsl.texas.gov:8080/users/manage_access">http://arisint.tsl.texas.gov:8080/users/manage_access</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">"We're sorry, but something went wrong."<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">I have not found any other pages that give this error.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">attached is a tail -f of archivesspace.out while attempting to get to 'System'->'manage users'<o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">and a diagnostic spawned by archivesspace, aspace_diagnostic_1583775751.txt<o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div id="x_Signature">
<div id="x_divtagdefaultwrapper">
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><img border="0" width="528" height="216" style="width:5.5in;height:2.25in" id="_x0000_i1026" src="cid:image001.jpg@01D5F6DA.C9958360"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>