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

[Mark Cyzyk]

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