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

[Mark Cyzyk]

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

Verba volant, scripta manent.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230707/c6b1fe36/attachment.html>