[Archivesspace_Users_Group] Staging upgrade using Vagrant/Virtualbox, issue with DB connect string
Mark Cyzyk
mcyzyk at gmail.com
Fri Jul 7 16:19:24 EDT 2023
Thanks, Blake, Brian, Valerie,
The connect string that worked:
jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true
And the setting in my config.rb that did the trick, overriding Solr
checksum checking:
AppConfig[:solr_verify_checksums] = false
ASpace running in Vagrant on my workstation now.
Spinning in chair!
Appreciatively,
Mark
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
mcyzyk at jhu.edu
On 7/7/23 3:49 PM, Valerie Addonizio wrote:
>
> 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
>
> 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
>
> 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<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
>
> Verba volant, scripta manent.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230707/e63d33cd/attachment.html>
More information about the Archivesspace_Users_Group
mailing list