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

[Mark Cyzyk]

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> 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/fb4128da/attachment.html>