<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<br>
Thanks, Blake, Brian, Valerie,<br>
<br>
The connect string that worked:<br>
<br>
<blockquote>jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true<br>
</blockquote>
<br>
And the setting in my config.rb that did the trick, overriding Solr
checksum checking:<br>
<br>
<blockquote>AppConfig[:solr_verify_checksums] = false<br>
</blockquote>
<br>
ASpace running in Vagrant on my workstation now.<br>
<br>
Spinning in chair!<br>
<br>
Appreciatively,<br>
<br>
Mark<br>
<br>
<br>
<pre class="moz-signature" cols="72"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
<a class="moz-txt-link-abbreviated" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>
</pre>
<div class="moz-cite-prefix">On 7/7/23 3:49 PM, Valerie Addonizio
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:MN2PR20MB2239015B6D9A98317FE9ECC6892DA@MN2PR20MB2239.namprd20.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<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-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}@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;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}span.contentpasted0
{mso-style-name:contentpasted0;}span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}div.WordSection1
{page:WordSection1;}ol
{margin-bottom:0in;}ul
{margin-bottom:0in;}</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]-->
<div class="WordSection1">
<p class="MsoNormal">Mark,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I just tackled that issue this morning but
am not sure my solution would work for you.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I was trying to update 2.8.1 data in a
3.4.0 docker install.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I was getting that same error with this
order of events: launch db, restore data into db, launch
ASpace<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I did not get that error if I switched the
order of events: launch db, launch ASpace, take ASpace down,
restore data into db, launch Aspace<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>
<a class="moz-txt-link-abbreviated" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
<a class="moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"><archivesspace_users_group-bounces@lyralists.lyrasis.org></a>
<b>On Behalf Of </b>Mark Cyzyk<br>
<b>Sent:</b> Friday, July 7, 2023 3:27 PM<br>
<b>To:</b> Blake Carver <a class="moz-txt-link-rfc2396E" href="mailto:blake.carver@lyrasis.org"><blake.carver@lyrasis.org></a>;
<a class="moz-txt-link-abbreviated" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>; Archivesspace Users Group
<a class="moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group@lyralists.lyrasis.org"><archivesspace_users_group@lyralists.lyrasis.org></a><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Staging
upgrade using Vagrant/Virtualbox, issue with DB connect
string<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
FYI, here is the connect string that worked:<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true<o:p></o:p></p>
</blockquote>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
Now, though, I'm getting an error regarding Solr:<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">RuntimeError: Solr checksum verification
failed (schema): expected
[4d4849771a91d677f255b638cbefa8b8d67a236c56c645bb13c2842480614d78]
got
[f066f17556bbe49b0526ff70ae885bdc9655666b503227667ef0c4315e4e5b0b]<o:p></o:p></p>
</blockquote>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
And this, despite the fact that I've placed the following in
my config.rb:<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">AppConfig[:solr_verify_checksums] =
"false"<o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><br>
Researching this...<br>
<br>
Mark<br>
<br>
<o:p></o:p></p>
<pre><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><o:p> </o:p></pre>
<pre>Mark Cyzyk, M.A., M.L.S.<o:p></o:p></pre>
<pre>Library Applications Group<o:p></o:p></pre>
<pre>The Sheridan Libraries<o:p></o:p></pre>
<pre>The Johns Hopkins University<o:p></o:p></pre>
<pre><a href="mailto:mcyzyk@jhu.edu" moz-do-not-send="true" class="moz-txt-link-freetext">mcyzyk@jhu.edu</a><o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<div>
<p class="MsoNormal">On 7/7/23 2:08 PM, Mark Cyzyk wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Thanks, Blake!<br>
<br>
But did not work:<br>
<br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">I, [2023-07-07T18:05:19.796951 #48893]
INFO -- : Thread-2002: Connecting to database:
jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8<b>&useSSL=false&AllowPublicKeyRetrieval=True</b>.
Max connections: 24<br>
E, [2023-07-07T18:05:20.542986 #48893] ERROR -- :
Thread-2002: DB connection failed:
Java::ComMysqlJdbcExceptionsJdbc4::MySQLNonTransientConnectionException:
<b>Public Key Retrieval is not allowed</b><o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><br>
Researching...<br>
<br>
Mark<br>
<br>
<o:p></o:p></p>
<pre><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><o:p> </o:p></pre>
<pre>Mark Cyzyk, M.A., M.L.S.<o:p></o:p></pre>
<pre>Library Applications Group<o:p></o:p></pre>
<pre>The Sheridan Libraries<o:p></o:p></pre>
<pre>The Johns Hopkins University<o:p></o:p></pre>
<pre><a href="mailto:mcyzyk@jhu.edu" moz-do-not-send="true" class="moz-txt-link-freetext">mcyzyk@jhu.edu</a><o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<div>
<p class="MsoNormal">On 7/7/23 12:23 PM, Blake Carver wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"><span
style="font-size:12.0pt;color:black">Haven't seen that
one before but it looks like a common error, adding "</span><span
class="contentpasted0"><span
style="font-size:11.5pt;font-family:"Segoe
UI",sans-serif;color:#232629;background:white">AllowPublicKeyRetrieval=True "
to the connection string looks like the answer</span></span><span
style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
</div>
<div class="MsoNormal" style="text-align:center"
align="center">
<hr width="98%" size="1" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span
style="color:black">
</span><a
href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"
moz-do-not-send="true" class="moz-txt-link-freetext">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span
style="color:black">
</span><a
href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"
moz-do-not-send="true"><archivesspace_users_group-bounces@lyralists.lyrasis.org></a><span
style="color:black"> on behalf of Mark Cyzyk
</span><a href="mailto:mcyzyk@gmail.com"
moz-do-not-send="true"><mcyzyk@gmail.com></a><span
style="color:black"><br>
<b>Sent:</b> Friday, July 7, 2023 12:06 PM<br>
<b>To:</b> Archivesspace Users Group </span><a
href="mailto:archivesspace_users_group@lyralists.lyrasis.org"
moz-do-not-send="true"><archivesspace_users_group@lyralists.lyrasis.org></a><span
style="color:black"><br>
<b>Subject:</b> [Archivesspace_Users_Group] Staging
upgrade using Vagrant/Virtualbox, issue with DB
connect string</span>
<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">All,<br>
<br>
I'm hoping to get some advice/another set of eyes on
this:<br>
<br>
I am trying to stage an upgrade of Aspace here on my
workstation using Vagrant/Virtualbox and am running into
an issue with the DB connect string I'm using in my
config.rb file.<br>
<br>
<b><br>
Preliminaries:</b><o:p></o:p></p>
<ul type="disc">
<li class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l2
level1 lfo3">
Ubuntu 20.04 Jammy on Vagrant/Oracle Virtualbox with
Guest Additions installed<o:p></o:p></li>
<li class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l2
level1 lfo3">
Archivesspace 3.2.0 (preparing to upgrade to 3.4.0)<o:p></o:p></li>
<li class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l2
level1 lfo3">
/usr/share/archivesspace/lib/mysql-connector-java-5.1.49.jar (owned by
“archivesspace" user)<o:p></o:p></li>
<li class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l2
level1 lfo3">
MySQL 8.0.33-0ubuntu0.20.04.2 (Ubuntu)<o:p></o:p></li>
</ul>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">mysql> show databases;<br>
--------------<br>
show databases<br>
--------------<br>
<br>
+--------------------+<br>
| Database |<br>
+--------------------+<br>
| archivesspace |<br>
| information_schema |<br>
| mysql |<br>
| performance_schema |<br>
| sys |<br>
+--------------------+<br>
5 rows in set (0.02 sec)<o:p></o:p></p>
</blockquote>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
<ul type="disc">
<li class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0
level1 lfo6">
Solr 8.10.0<o:p></o:p></li>
</ul>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Core<br>
startTime:<br>
6 minutes ago <br>
instanceDir:<br>
/var/solr/data/archivesspace<br>
dataDir:<br>
/var/solr/data/archivesspace/data/<o:p></o:p></p>
</blockquote>
</blockquote>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
<br>
<b>The Problem:</b><o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Loading ArchivesSpace configuration
file from path:
/usr/share/archivesspace/config/config.rb<br>
<br>
ArchivesSpaceThreadDump: Touch the file
'/usr/share/archivesspace/thread_dump_backend.txt' to
trigger a thread dump<br>
I, [2023-07-07T15:32:08.607923 #52254] INFO -- :
Thread-2002: Connecting to database:
jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8<b>&useSSL=false</b>.
Max connections: 24<br>
<b>E, [2023-07-07T15:32:08.914823 #52254] ERROR -- :
Thread-2002: DB connection failed:
Java::ComMysqlJdbcExceptionsJdbc4::MySQLNonTransientConnectionException:
Public Key Retrieval is not allowed</b><br>
========================================================================<br>
A trace file has been written to the following
location:
/usr/share/archivesspace/data/tmp/aspace_diagnostic_1688743928.txt<br>
<br>
This file contains information that will assist
developers in diagnosing<br>
problems with your ArchivesSpace installation.
Please review the file's<br>
contents for sensitive information (such as
passwords) that you might not<br>
want to share.<br>
========================================================================<br>
Jul 07, 2023 3:32:08 PM
org.eclipse.jetty.server.handler.ContextHandler$Context
log<br>
INFO: An exception happened during JRuby-Rack startup<br>
Java::ComMysqlJdbcExceptionsJdbc4::MySQLNonTransientConnectionException:
Public Key Retrieval is not allowed<br>
--- System<br>
jruby 9.2.12.0 (2.5.7) 2020-07-01 db01a49ba6 OpenJDK
64-Bit Server VM 25.362-b09 on
1.8.0_362-8u372-ga~us1-0ubuntu1~20.04-b09 +jit
[linux-x86_64]<br>
Time: 2023-07-07 15:32:08 +0000<br>
Server: jetty/9.4.44.v20210927<br>
jruby.home: uri:classloader://META-INF/jruby.home<o:p></o:p></p>
</blockquote>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
<b>Notes:</b><br>
<br>
Regarding my DB connect string:<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&useSSL=false<o:p></o:p></p>
</blockquote>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
I appended “useSSL=false” thinking the following error
would go away:<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"> E, [2023-07-07T15:32:08.914823
#52254] ERROR -- : Thread-2002: DB connection failed:
Java::ComMysqlJdbcExceptionsJdbc4::MySQLNonTransientConnectionException:
Public Key Retrieval is not allowed<o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><br>
No joy!<br>
<br>
Not sure how to remedy. Advice GREATLY appreciated,<br>
<br>
Mark<br>
<br>
<o:p></o:p></p>
<pre>-- <o:p></o:p></pre>
<pre><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><o:p> </o:p></pre>
<pre>Mark Cyzyk, M.A., M.L.S.<o:p></o:p></pre>
<pre>Library Applications Group<o:p></o:p></pre>
<pre>The Sheridan Libraries<o:p></o:p></pre>
<pre>The Johns Hopkins University<o:p></o:p></pre>
<pre><a href="mailto:mcyzyk@jhu.edu" moz-do-not-send="true" class="moz-txt-link-freetext">mcyzyk@jhu.edu</a><o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Verba volant, scripta manent. <o:p></o:p></pre>
</div>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</blockquote>
<br>
</body>
</html>