<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:"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:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.xmsonormal0, li.xmsonormal0, div.xmsonormal0
{mso-style-name:x_msonormal0;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.xxmsonormal, li.xxmsonormal, div.xxmsonormal
{mso-style-name:x_xmsonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.xxmsonormal0, li.xxmsonormal0, div.xxmsonormal0
{mso-style-name:x_xmsonormal0;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.xxmsochpdefault, li.xxmsochpdefault, div.xxmsochpdefault
{mso-style-name:x_xmsochpdefault;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:10.0pt;
font-family:"Calibri",sans-serif;}
p.xmsochpdefault, li.xmsochpdefault, div.xmsochpdefault
{mso-style-name:x_msochpdefault;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:10.0pt;
font-family:"Calibri",sans-serif;}
span.xmsohyperlink
{mso-style-name:x_msohyperlink;
color:blue;
text-decoration:underline;}
span.xmsohyperlinkfollowed
{mso-style-name:x_msohyperlinkfollowed;
color:purple;
text-decoration:underline;}
span.xxmsohyperlink
{mso-style-name:x_xmsohyperlink;
color:blue;
text-decoration:underline;}
span.xxmsohyperlinkfollowed
{mso-style-name:x_xmsohyperlinkfollowed;
color:purple;
text-decoration:underline;}
span.xxemailstyle20
{mso-style-name:x_xemailstyle20;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.xemailstyle26
{mso-style-name:x_emailstyle26;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle32
{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="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Good morning Blake,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am working my way through what might be a proxy related and so I went to a console on the affected server and used firefox to locally query the port that Preservica uses. I am seeing the image below with something about packets out of
order.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I begin thinking about the config.rb file that came with the AS version we are using which is 2.5.2. I upgraded from version 2.5. One thing to note is that I did not use the new config.rb file. I tried the old file and it seemingly works
fine with everything except the Preservica connection to ArchiveSpace. The line for connecting to Preservica was already in the old file (no problems connecting before the upgrade) so I didn’t have to change anything there either:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">AppConfig[:db_url] = "jdbc:mysql://localhost:3306/archivesspace?asuser=as&password=somepassword&useUnicode=true&characterEncoding=UTF-8"<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">So I logged into the server on a console that lets me use the local firefox browser to get to port 3306 locally and this is what I see in the browser. Does this offer a clue as to what the issue is?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Rick<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><img width="745" height="170" style="width:7.7604in;height:1.7708in" id="Picture_x0020_1" src="cid:image002.jpg@01D6A6B9.77D337E0"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></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> Friday, October 16, 2020 11:46 AM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Still troubleshooting ArchivesSpace Preservica issue<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p style="background:white"><span style="color:#201F1E">> I am thinking the database and as user is configured correctly at this point and have to ask what else could it be causing the communication issue between Preservica and ArchivesSpace.<o:p></o:p></span></p>
<p style="background:white"><span style="color:#201F1E"> <o:p></o:p></span></p>
<p style="background:white"><span style="color:#201F1E">I don't think it's DB related. I think the ArchivesSpace user for Preservica to connect needs admin powers, but I assume that's not the problem. <o:p></o:p></span></p>
<p style="background:white"><span style="color:#201F1E">Preservice uses the API and the API uses your proxy, and that error looks like a proxy error, though I could be wrong on that. <o:p></o:p></span></p>
<p style="background:white"><span style="color:#201F1E">I did a quick Google search on that error and it looks pretty common. <o:p></o:p></span></p>
<p style="background:white"><span style="color:#201F1E"><o:p> </o:p></span></p>
<p style="background:white"><span style="color:#201F1E">> I want to troubleshoot to see if this might be a mysql connector issue to verify that I have that configured properly. How could I test it?<o:p></o:p></span></p>
<p style="background:white"><span style="color:#201F1E"><o:p> </o:p></span></p>
<p style="background:white"><span style="color:#201F1E">I doubt that's the problem, that connects ArchivesSpace to MySQL so if that had troubles ArchivesSpace would be complaining. <o:p></o:p></span></p>
<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 Neal, Rick <<a href="mailto:rneal@richmond.edu">rneal@richmond.edu</a>><br>
<b>Sent:</b> Friday, October 16, 2020 11:33 AM<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> Re: [Archivesspace_Users_Group] Still troubleshooting ArchivesSpace Preservica issue</span>
<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal">Blake,<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">I have passed this back to Preservica.<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">I am also trying to make sure my database is right. <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">I have an aspace user and an archivesspace database. I can log in to mysql as that user and change to the archivesspace database and I can list the users.<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">I get a list of users that ArchivesSpace created in the admin console.<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">I then check to make sure that the as user has ALL PRIVILEGES (see below) and the as user does have ALL PRIVILEGES.<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">mysql> show grants;<o:p></o:p></p>
<p class="xmsonormal">+--------------------------------------------------------------------------------------------------------------------+<o:p></o:p></p>
<p class="xmsonormal">| Grants for as@localhost |<o:p></o:p></p>
<p class="xmsonormal">+--------------------------------------------------------------------------------------------------------------------+<o:p></o:p></p>
<p class="xmsonormal">| GRANT ALL PRIVILEGES ON *.* TO 'as'@'localhost' IDENTIFIED BY PASSWORD '*389A648EDB48DB63AKE39CC2C21AE774DAD685F9' |<o:p></o:p></p>
<p class="xmsonormal">| GRANT ALL PRIVILEGES ON `archivesspace`.* TO 'as'@'localhost' |<o:p></o:p></p>
<p class="xmsonormal">+--------------------------------------------------------------------------------------------------------------------+<o:p></o:p></p>
<p class="xmsonormal">2 rows in set (0.01 sec)<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">I am thinking the database and as user is configured correctly at this point and have to ask what else could it be causing the communication issue between Preservica and ArchivesSpace.<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">I want to troubleshoot to see if this might be a mysql connector issue to verify that I have that configured properly. How could I test it?<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">Thanks,<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">Rick<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="xmsonormal"><b>From:</b> <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>>
<b>On Behalf Of </b>Blake Carver<br>
<b>Sent:</b> Friday, October 16, 2020 10:26 AM<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> Re: [Archivesspace_Users_Group] Still troubleshooting ArchivesSpace / Preservica issue<o:p></o:p></p>
</div>
</div>
<p class="xmsonormal"> <o:p></o:p></p>
<div>
<p class="xmsonormal"><span style="font-size:12.0pt;color:black">Are you behind Apache/nginx/whatever? That error happens on everything they try to grab?</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-size:12.0pt;color:black">I think I'd start looking there, though I'm not sure what the problem is.</span><o:p></o:p></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="x_divRplyFwdMsg">
<p class="xmsonormal"><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 Neal, Rick <<a href="mailto:rneal@richmond.edu">rneal@richmond.edu</a>><br>
<b>Sent:</b> Friday, October 16, 2020 8:57 AM<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>Cc:</b> LaPrade, Crista <<a href="mailto:claprade@richmond.edu">claprade@richmond.edu</a>><br>
<b>Subject:</b> [Archivesspace_Users_Group] Still troubleshooting ArchivesSpace / Preservica issue</span>
<o:p></o:p></p>
<div>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white">Good morning,</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white">I am still troubleshooting an issue with Preservica not being able to connect to our ArchivesSpace upgrade, which is on a new server.
</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white">Preservica tech support saw this in the log:</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white"> </span><o:p></o:p></p>
<div>
<div>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white">Caused by: org.springframework.web.client.RestClientException: Could not extract response: no suitable HttpMessageConverter found for response type [interface
java.util.Map] and content type [text/html;charset=iso-8859-1] </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white">I checked my config.rb file and have this in it:</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white">AppConfig[:db_url] = "jdbc:mysql://localhost:3306/archivesspace?user=asuser&password=somepassword&useUnicode=true&characterEncoding=UTF-8"</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white">Is there some other place I have to change the Encoding perhaps?</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white">Thanks,</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white">Rick</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white"> </span><o:p></o:p></p>
<p class="xxmsonormal"> <o:p></o:p></p>
<p class="xxmsonormal">Rick Neal<o:p></o:p></p>
<p class="xxmsonormal">Library Systems and Applications Administrator<o:p></o:p></p>
<p class="xxmsonormal">University of Richmond<o:p></o:p></p>
</div>
<p class="xxmsonormal"> <o:p></o:p></p>
<p class="xxmsonormal"><span style="font-family:"Segoe UI",sans-serif;color:#201F1E;background:white"> </span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>