<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<br>
FYI, here is 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>
Now, though, I'm getting an error regarding Solr:<br>
<br>
<blockquote>RuntimeError: Solr checksum verification failed
(schema): expected
[4d4849771a91d677f255b638cbefa8b8d67a236c56c645bb13c2842480614d78]
got
[f066f17556bbe49b0526ff70ae885bdc9655666b503227667ef0c4315e4e5b0b]<br>
</blockquote>
<br>
And this, despite the fact that I've placed the following in my
config.rb:<br>
<br>
<blockquote>AppConfig[:solr_verify_checksums] = "false"<br>
</blockquote>
<br>
Researching this...<br>
<br>
Mark<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 2:08 PM, Mark Cyzyk wrote:<br>
</div>
<blockquote type="cite"
cite="mid:c311134f-a629-2e51-95fc-da4b0530f9be@gmail.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
Thanks, Blake!<br>
<br>
But did not work:<br>
<br>
<blockquote type="cite">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><br>
</blockquote>
<br>
Researching...<br>
<br>
Mark<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 moz-txt-link-freetext" href="mailto:mcyzyk@jhu.edu" moz-do-not-send="true">mcyzyk@jhu.edu</a>
</pre>
<div class="moz-cite-prefix">On 7/7/23 12:23 PM, Blake Carver
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:DM6PR22MB23091E114290D7778E9446FA9F2DA@DM6PR22MB2309.namprd22.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Haven't seen that one before but it looks like a common error,
adding "<span style="font-family: -apple-system,
"system-ui", "Segoe UI Adjusted",
"Segoe UI", "Liberation Sans",
sans-serif; font-size: 15px; text-align: left; display:
inline !important; color: rgb(35, 38, 41); background-color:
rgb(255, 255, 255);" class="ContentPasted0">AllowPublicKeyRetrieval=True<span
class="ContentPasted0"> " to the connection string looks
like the answer</span></span></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt"
face="Calibri, sans-serif" color="#000000"><b>From:</b> <a
class="moz-txt-link-abbreviated moz-txt-link-freetext"
href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"
moz-do-not-send="true">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
<a class="moz-txt-link-rfc2396E"
href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"
moz-do-not-send="true"><archivesspace_users_group-bounces@lyralists.lyrasis.org></a>
on behalf of Mark Cyzyk <a class="moz-txt-link-rfc2396E"
href="mailto:mcyzyk@gmail.com" moz-do-not-send="true"><mcyzyk@gmail.com></a><br>
<b>Sent:</b> Friday, July 7, 2023 12:06 PM<br>
<b>To:</b> Archivesspace Users Group <a
class="moz-txt-link-rfc2396E"
href="mailto:archivesspace_users_group@lyralists.lyrasis.org"
moz-do-not-send="true"><archivesspace_users_group@lyralists.lyrasis.org></a><br>
<b>Subject:</b> [Archivesspace_Users_Group] Staging upgrade
using Vagrant/Virtualbox, issue with DB connect string</font>
<div> </div>
</div>
<div>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><br>
<br>
<ul>
<li>Ubuntu 20.04 Jammy on Vagrant/Oracle Virtualbox with
Guest Additions installed</li>
<li>Archivesspace 3.2.0 (preparing to upgrade to 3.4.0)</li>
<li>/usr/share/archivesspace/lib/mysql-connector-java-5.1.49.jar
(owned by “archivesspace" user)</li>
<li>MySQL 8.0.33-0ubuntu0.20.04.2 (Ubuntu)</li>
</ul>
<blockquote>
<blockquote>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)<br>
</blockquote>
</blockquote>
<br>
<ul>
<li>Solr 8.10.0</li>
</ul>
<blockquote>
<blockquote>Core<br>
startTime:<br>
6 minutes ago <br>
instanceDir:<br>
/var/solr/data/archivesspace<br>
dataDir:<br>
/var/solr/data/archivesspace/data/<br>
</blockquote>
</blockquote>
<br>
<br>
<br>
<b>The Problem:</b><br>
<br>
<blockquote>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>&</b><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<br>
</blockquote>
<br>
<br>
<b>Notes:</b><br>
<br>
Regarding my DB connect string:<br>
<br>
<blockquote>jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&useSSL=false<br>
</blockquote>
<br>
I appended “useSSL=false” thinking the following error would
go away:<br>
<br>
<blockquote> E, [2023-07-07T15:32:08.914823 #52254] ERROR -- :
Thread-2002: DB connection failed:
Java::ComMysqlJdbcExceptionsJdbc4::MySQLNonTransientConnectionException:
Public Key Retrieval is not allowed<br>
</blockquote>
<br>
No joy!<br>
<br>
Not sure how to remedy. Advice GREATLY appreciated,<br>
<br>
Mark<br>
<pre class="x_moz-signature" cols="72">--
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
<a class="x_moz-txt-link-abbreviated moz-txt-link-freetext" href="mailto:mcyzyk@jhu.edu" moz-do-not-send="true">mcyzyk@jhu.edu</a>
Verba volant, scripta manent.
</pre>
</div>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>