<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<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);" 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>
<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 Mark Cyzyk
<mcyzyk@gmail.com><br>
<b>Sent:</b> Friday, July 7, 2023 12:06 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><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" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>
Verba volant, scripta manent.
</pre>
</div>
</body>
</html>