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

Fri Jul 7 15:49:57 EDT 2023

Mark,

I just tackled that issue this morning but am not sure my solution would work for you.

I was trying to update 2.8.1 data in a 3.4.0 docker install.

I was getting that same error with this order of events: launch db, restore data into db, launch ASpace

I did not get that error if I switched the order of events: launch db, launch ASpace, take ASpace down, restore data into db, launch Aspace

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Mark Cyzyk
Sent: Friday, July 7, 2023 3:27 PM
To: Blake Carver <blake.carver at lyrasis.org>; mcyzyk at jhu.edu; Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Staging upgrade using Vagrant/Virtualbox, issue with DB connect string

FYI, here is the connect string that worked:
jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true

Now, though, I'm getting an error regarding Solr:
RuntimeError: Solr checksum verification failed (schema): expected [4d4849771a91d677f255b638cbefa8b8d67a236c56c645bb13c2842480614d78] got [f066f17556bbe49b0526ff70ae885bdc9655666b503227667ef0c4315e4e5b0b]

And this, despite the fact that I've placed the following in my config.rb:
AppConfig[:solr_verify_checksums] = "false"

Researching this...

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>

On 7/7/23 2:08 PM, Mark Cyzyk wrote:
Thanks, Blake!

But did not work:

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&useSSL=false&AllowPublicKeyRetrieval=True. Max connections: 24
E, [2023-07-07T18:05:20.542986 #48893] ERROR -- : Thread-2002: DB connection failed: Java::ComMysqlJdbcExceptionsJdbc4::MySQLNonTransientConnectionException: Public Key Retrieval is not allowed

Researching...

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>

On 7/7/23 12:23 PM, Blake Carver wrote:
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<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org><mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Mark Cyzyk <mcyzyk at gmail.com><mailto:mcyzyk at gmail.com>
Sent: Friday, July 7, 2023 12:06 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org><mailto: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/16208f8e/attachment.html>