<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!--.jfk-bubble {
filter: invert(100%) hue-rotate(180deg) contrast(90%) !important;
}[data-darkreader-inline-bgcolor] {
background-color: var(--darkreader-inline-bgcolor) !important;
}
[data-darkreader-inline-bgimage] {
background-image: var(--darkreader-inline-bgimage) !important;
}
[data-darkreader-inline-border] {
border-color: var(--darkreader-inline-border) !important;
}
[data-darkreader-inline-border-bottom] {
border-bottom-color: var(--darkreader-inline-border-bottom) !important;
}
[data-darkreader-inline-border-left] {
border-left-color: var(--darkreader-inline-border-left) !important;
}
[data-darkreader-inline-border-right] {
border-right-color: var(--darkreader-inline-border-right) !important;
}
[data-darkreader-inline-border-top] {
border-top-color: var(--darkreader-inline-border-top) !important;
}
[data-darkreader-inline-boxshadow] {
box-shadow: var(--darkreader-inline-boxshadow) !important;
}
[data-darkreader-inline-color] {
color: var(--darkreader-inline-color) !important;
}
[data-darkreader-inline-fill] {
fill: var(--darkreader-inline-fill) !important;
}
[data-darkreader-inline-stroke] {
stroke: var(--darkreader-inline-stroke) !important;
}
[data-darkreader-inline-outline] {
outline-color: var(--darkreader-inline-outline) !important;
}input, textarea, select, button {
background-color: #181a1b;
}
html, body, input, textarea, select, button {
border-color: #575757;
color: #e8e6e3;
}
a {
color: #3391ff;
}
table {
border-color: #4c4c4c;
}
::placeholder {
color: #bab5ab;
}
::selection {
background-color: #005ccc;
color: #ffffff;
}
::-moz-selection {
background-color: #005ccc;
color: #ffffff;
}
input:-webkit-autofill,
textarea:-webkit-autofill,
select:-webkit-autofill {
background-color: #545b00 !important;
color: #e8e6e3 !important;
}
::-webkit-scrollbar {
background-color: #1c1e1f;
color: #c5c1b9;
}
::-webkit-scrollbar-thumb {
background-color: #2a2c2e;
}
::-webkit-scrollbar-thumb:hover {
background-color: #323537;
}
::-webkit-scrollbar-thumb:active {
background-color: #3d4043;
}
::-webkit-scrollbar-corner {
background-color: #181a1b;
}
* {
scrollbar-color: #2a2c2e #1c1e1f;
}P{margin-top:0;margin-bottom:0;} .vimvixen-hint {
background-color: #7b5300 !important;
border-color: #d8b013 !important;
color: #f3e8c8 !important;
}
::placeholder {
opacity: 0.5 !important;
}p
{margin-top:0;
margin-bottom:0}p
{margin-top:0;
margin-bottom:0}--></style>
</head>
<body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Might there be some way of preventing indexing Sunday mornings or switching the time ran from 2am to 1 or 3am? It looks like solr indexing is behind this issue and this is the second DST switch that I've had to go into the db and switch a time entry manually.</p>
<p><br>
</p>
<p>I don't know much about solr or how it gets scheduled with an ASpace internal solr instance. I was looking at some of the solr docs and it looks like there is an xml file for some solr settings but I wasn't able to locate one within ASpace's file structure.</p>
<p><br>
</p>
<p>-Alan Huebschen</p>
<p>University of Illinois at Springfield<br>
</p>
<p>Brookens Library Information Systems</p>
<p><br>
</p>
<div dir="ltr" style="color: rgb(220, 218, 212); --darkreader-inline-color:#dcd9d4;" data-darkreader-inline-color="">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size: 11pt; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
on behalf of Blake Carver <blake.carver@lyrasis.org><br>
<b>Sent:</b> Monday, March 9, 2020 1:48 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> [EXTERNAL] Re: [Archivesspace_Users_Group] update of previous post archivesspace 'manage user access' pages give error</font>
<div> </div>
</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="">
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); --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="">
<p dir="auto" style="margin: 0px 0px 16px; font-size: 14px; line-height: 20px; outline: currentcolor none 0px; background: rgb(255, 255, 255) none repeat scroll 0% 0%; color: rgb(47, 57, 65); --darkreader-inline-outline:currentcolor; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none; --darkreader-inline-color:#d2cfc8;" data-darkreader-inline-outlinedata-darkreader-inline-bgcolordata-darkreader-inline-bgimagedata-darkreader-inline-color="">
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); display: block; margin: 15px 0px; line-height: 19px; word-break: break-all; background: rgb(248, 249, 249) none repeat scroll 0% 0%; border: 1px solid rgb(194, 200, 204); outline: currentcolor none 0px; --darkreader-inline-color:#bdb8ae; --darkreader-inline-bgcolor:#1a1c1d; --darkreader-inline-bgimage:none; --darkreader-inline-border-top:#3b4246; --darkreader-inline-border-right:#3b4246; --darkreader-inline-border-bottom:#3b4246; --darkreader-inline-border-left:#3b4246; --darkreader-inline-outline:currentcolor;" data-darkreader-inline-colordata-darkreader-inline-bgcolordata-darkreader-inline-bgimagedata-darkreader-inline-border-topdata-darkreader-inline-border-rightdata-darkreader-inline-border-bottomdata-darkreader-inline-border-leftdata-darkreader-inline-outline=""><code style="font-size: 12px; background: rgba(0, 0, 0, 0) none repeat scroll 0% 0%; margin: 0px; outline: currentcolor none 0px; word-break: break-word; --darkreader-inline-bgcolor:rgba(0, 0, 0, 0); --darkreader-inline-bgimage:none; --darkreader-inline-outline:currentcolor;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimagedata-darkreader-inline-outline="">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: currentcolor none 0px; background: rgb(255, 255, 255) none repeat scroll 0% 0%; color: rgb(47, 57, 65); --darkreader-inline-outline:currentcolor; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none; --darkreader-inline-color:#d2cfc8;" data-darkreader-inline-outlinedata-darkreader-inline-bgcolordata-darkreader-inline-bgimagedata-darkreader-inline-color="">
Take a look at<code style="padding: 0px 5px; font-family: Consolas, "Liberation Mono", Menlo, "Bitstream Vera Sans Mono", Courier, monospace; font-size: 12px; background: rgb(248, 249, 249) none repeat scroll 0% 0%; border: 1px solid rgb(233, 235, 237); margin: 0px 2px; outline: currentcolor none 0px; --darkreader-inline-bgcolor:#1a1c1d; --darkreader-inline-bgimage:none; --darkreader-inline-border-top:#343a3f; --darkreader-inline-border-right:#343a3f; --darkreader-inline-border-bottom:#343a3f; --darkreader-inline-border-left:#343a3f; --darkreader-inline-outline:currentcolor;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimagedata-darkreader-inline-border-topdata-darkreader-inline-border-rightdata-darkreader-inline-border-bottomdata-darkreader-inline-border-leftdata-darkreader-inline-outline="">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; background: rgb(248, 249, 249) none repeat scroll 0% 0%; border: 1px solid rgb(233, 235, 237); margin: 0px 2px; outline: currentcolor none 0px; --darkreader-inline-bgcolor:#1a1c1d; --darkreader-inline-bgimage:none; --darkreader-inline-border-top:#343a3f; --darkreader-inline-border-right:#343a3f; --darkreader-inline-border-bottom:#343a3f; --darkreader-inline-border-left:#343a3f; --darkreader-inline-outline:currentcolor;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimagedata-darkreader-inline-border-topdata-darkreader-inline-border-rightdata-darkreader-inline-border-bottomdata-darkreader-inline-border-leftdata-darkreader-inline-outline="">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: currentcolor none 0px; background: rgb(255, 255, 255) none repeat scroll 0% 0%; color: rgb(47, 57, 65); --darkreader-inline-outline:currentcolor; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none; --darkreader-inline-color:#d2cfc8;" data-darkreader-inline-outlinedata-darkreader-inline-bgcolordata-darkreader-inline-bgimagedata-darkreader-inline-color="">
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); --darkreader-inline-color:#e8e6e3; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-colordata-darkreader-inline-bgcolor="">
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size: 11pt; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="" face="Calibri, sans-serif" 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="">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style><style class="darkreader darkreader--sync" media="screen"></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); --darkreader-inline-color:#e8e6e3; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-colordata-darkreader-inline-bgcolor="">
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); --darkreader-inline-color:#e8e6e3; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-colordata-darkreader-inline-bgcolor="">
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); --darkreader-inline-color:#e8e6e3; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-colordata-darkreader-inline-bgcolor="">
<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); --darkreader-inline-color:#e8e6e3; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-colordata-darkreader-inline-bgcolor="">
<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); --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="">
<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); --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="">
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0"></p>
<div><img class="x_EmojiInsert" src="cid:f31f7ef0-8e07-4602-9acc-c50afd47b573"><br>
</div>
<br>
<p style="margin-top:0px; margin-bottom:0px"></p>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>