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

Brian Hoffman brian.hoffman at lyrasis.org
Fri Jul 7 15:48:32 EDT 2023 

Hi Mark,

Try removing the quotes around “false”:

AppConfig[:solr_verify_checksums] = false

However, for production use you probably want to set this to true and work out the issue – otherwise you will have runtime errors when the application tries to index a record with fields that don’t line up with Solr’s expectations.


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>
Date: Friday, July 7, 2023 at 3:27 PM
To: Blake Carver <blake.carver at lyrasis.org>, mcyzyk at jhu.edu <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/f9dd78ba/attachment.html>

More information about the Archivesspace_Users_Group mailing list