[Archivesspace_Users_Group] Staging upgrade using Vagrant/Virtualbox, issue with DB connect string

[Blake Carver]

Haven't seen that one before but it looks like a common error, adding "AllowPublicKeyRetrieval=True " to the connection string looks like the answer
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Mark Cyzyk <mcyzyk at gmail.com>
Sent: Friday, July 7, 2023 12:06 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Staging upgrade using Vagrant/Virtualbox, issue with DB connect string

All,

I'm hoping to get some advice/another set of eyes on this:

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.


Preliminaries:


  *   Ubuntu 20.04 Jammy on Vagrant/Oracle Virtualbox with Guest Additions installed
  *   Archivesspace 3.2.0 (preparing to upgrade to 3.4.0)
  *   /usr/share/archivesspace/lib/mysql-connector-java-5.1.49.jar (owned by “archivesspace" user)
  *   MySQL 8.0.33-0ubuntu0.20.04.2 (Ubuntu)

mysql> show databases;
--------------
show databases
--------------

+--------------------+
| Database           |
+--------------------+
| archivesspace      |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.02 sec)


  *   Solr 8.10.0

Core
    startTime:
        6 minutes ago
    instanceDir:
        /var/solr/data/archivesspace
    dataDir:
        /var/solr/data/archivesspace/data/



The Problem:

Loading ArchivesSpace configuration file from path: /usr/share/archivesspace/config/config.rb

ArchivesSpaceThreadDump: Touch the file '/usr/share/archivesspace/thread_dump_backend.txt' to trigger a thread dump
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&useSSL=false. Max connections: 24
E, [2023-07-07T15:32:08.914823 #52254] ERROR -- : Thread-2002: DB connection failed: Java::ComMysqlJdbcExceptionsJdbc4::MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
      ========================================================================
      A trace file has been written to the following location: /usr/share/archivesspace/data/tmp/aspace_diagnostic_1688743928.txt

      This file contains information that will assist developers in diagnosing
      problems with your ArchivesSpace installation.  Please review the file's
      contents for sensitive information (such as passwords) that you might not
      want to share.
      ========================================================================
Jul 07, 2023 3:32:08 PM org.eclipse.jetty.server.handler.ContextHandler$Context log
INFO: An exception happened during JRuby-Rack startup
Java::ComMysqlJdbcExceptionsJdbc4::MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
--- System
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]
Time: 2023-07-07 15:32:08 +0000
Server: jetty/9.4.44.v20210927
jruby.home: uri:classloader://META-INF/jruby.home


Notes:

Regarding my DB connect string:

jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&useSSL=false

I appended “useSSL=false” thinking the following error would go away:

 E, [2023-07-07T15:32:08.914823 #52254] ERROR -- : Thread-2002: DB connection failed: Java::ComMysqlJdbcExceptionsJdbc4::MySQLNonTransientConnectionException: Public Key Retrieval is not allowed

No joy!

Not sure how to remedy.  Advice GREATLY appreciated,

Mark

--
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
mcyzyk at jhu.edu<mailto:mcyzyk at jhu.edu>

Verba volant, scripta manent.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230707/96d75deb/attachment.html>