<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
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="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>
Verba volant, scripta manent.
</pre>
</body>
</html>