<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);">
</div>
<p style="color: rgb(32, 31, 30); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px">
> 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.</p>
<p style="color: rgb(32, 31, 30); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px">
</p>
<p style="color: rgb(32, 31, 30); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px">
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. </p>
<p style="color: rgb(32, 31, 30); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px">
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. </p>
<p style="color: rgb(32, 31, 30); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px">
I did a quick Google search on that error and it looks pretty common. </p>
<p style="color: rgb(32, 31, 30); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px">
<br>
</p>
<p style="color: rgb(32, 31, 30); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px">
> 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?</p>
<p style="color: rgb(32, 31, 30); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px">
<br>
</p>
<p style="color: rgb(32, 31, 30); background-color: rgb(255, 255, 255); font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px">
I doubt that's the problem, that connects ArchivesSpace to MySQL so if that had troubles ArchivesSpace would be complaining. </p>
<div>
<div id="Signature">
<div>
<div id="divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); background-color:rgb(255,255,255)">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span dir="ltr" style="font-size:12pt; background-color:white"><font size="2"><span style="font-size:11pt"></span></font></span></font></div>
</div>
</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 Neal, Rick
<rneal@richmond.edu><br>
<b>Sent:</b> Friday, October 16, 2020 11:33 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</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:"Segoe UI"}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.x_MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p.x_msonormal0, li.x_msonormal0, div.x_msonormal0
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
p.x_xmsonormal, li.x_xmsonormal, div.x_xmsonormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
p.x_xmsonormal0, li.x_xmsonormal0, div.x_xmsonormal0
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
p.x_xmsochpdefault, li.x_xmsochpdefault, div.x_xmsochpdefault
{margin-right:0in;
margin-left:0in;
font-size:10.0pt;
font-family:"Calibri",sans-serif}
span.x_xmsohyperlink
{color:blue;
text-decoration:underline}
span.x_xmsohyperlinkfollowed
{color:purple;
text-decoration:underline}
span.x_xemailstyle20
{font-family:"Calibri",sans-serif;
color:windowtext}
span.x_EmailStyle26
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
-->
</style>
<div lang="EN-US" link="blue" vlink="purple">
<div class="x_WordSection1">
<p class="x_MsoNormal">Blake,</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">I have passed this back to Preservica.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">I am also trying to make sure my database is right. </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">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.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">I get a list of users that ArchivesSpace created in the admin console.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">I then check to make sure that the as user has ALL PRIVILEGES (see below) and the as user does have ALL PRIVILEGES.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">mysql> show grants;</p>
<p class="x_MsoNormal">+--------------------------------------------------------------------------------------------------------------------+</p>
<p class="x_MsoNormal">| Grants for as@localhost |</p>
<p class="x_MsoNormal">+--------------------------------------------------------------------------------------------------------------------+</p>
<p class="x_MsoNormal">| GRANT ALL PRIVILEGES ON *.* TO 'as'@'localhost' IDENTIFIED BY PASSWORD '*389A648EDB48DB63AKE39CC2C21AE774DAD685F9' |</p>
<p class="x_MsoNormal">| GRANT ALL PRIVILEGES ON `archivesspace`.* TO 'as'@'localhost' |</p>
<p class="x_MsoNormal">+--------------------------------------------------------------------------------------------------------------------+</p>
<p class="x_MsoNormal">2 rows in set (0.01 sec)</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">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.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">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?</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Thanks,</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Rick</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_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 10:26 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</p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">Are you behind Apache/nginx/whatever? That error happens on everything they try to grab?</span></p>
</div>
<div>
<p class="x_MsoNormal"><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></p>
</div>
<div class="x_MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="x_divRplyFwdMsg">
<p class="x_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 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>
</p>
<div>
<p class="x_MsoNormal"> </p>
</div>
</div>
<div>
<div>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white">Good morning,</span></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white"> </span></p>
<p class="x_xmsonormal"><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></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white"> </span></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white">Preservica tech support saw this in the log:</span></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white"> </span></p>
<div>
<div>
<p class="x_xmsonormal"><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></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white"> </span></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white">I checked my config.rb file and have this in it:</span></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white"> </span></p>
<p class="x_xmsonormal"><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></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white"> </span></p>
<p class="x_xmsonormal"><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></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white"> </span></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white">Thanks,</span></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white"> </span></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white">Rick</span></p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white"> </span></p>
<p class="x_xmsonormal"> </p>
<p class="x_xmsonormal">Rick Neal</p>
<p class="x_xmsonormal">Library Systems and Applications Administrator</p>
<p class="x_xmsonormal">University of Richmond</p>
</div>
<p class="x_xmsonormal"> </p>
<p class="x_xmsonormal"><span style="font-family:"Segoe UI",sans-serif; color:#201F1E; background:white"> </span></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>