Could not find gem 'rubyXL (= 3.3.29) java' with aspace-import-excel v2.1.17 on AS 2.6.0

[tomadams]

Upgraded ArchivesSpace from 2.3.2 to 2.6.0 on a RHEL 6.8 machine. Current environment is:
openjdk version "1.8.0_111"
OpenJDK Runtime Environment (build 1.8.0_111-b15)
OpenJDK 64-Bit Server VM (build 25.111-b15, mixed mode)
$ ruby -v; gem -v
ruby 1.8.7 (2013-06-27 patchlevel 374) [x86_64-linux]
1.3.7

The aspace-import-excel plugin seems incompatible, due to a gem issue.

Initially AS would not start accepting connections. In the log file was:

[!] There was an error parsing Gemfile: You cannot specify the same gem twice with different version requirements.
You specified: pry (>= 0) and pry (~> 0.11.3). Bundler cannot continue.

I disabled the plugin, the https://github.com/harvard-library/aspace-import-excel spreadsheet importer, and it ArchivesSpace started.

Yesterday, I then downloaded the most recent version of aspace-import-excel-master, and received a slightly different message:

Jun 18, 2019 6:14:20 PM org.eclipse.jetty.server.handler.ContextHandler$Context log
WARNING: ERROR: initialization failed
org.jruby.rack.RackInitializationException: Could not find gem 'rubyXL (= 3.3.29) java' in any of the gem sources listed in your Gemfile.

$ more aspace-import-excel/Gemfile
ASpaceGems.setup if defined? ASpaceGems

source 'http://rubygems.org'

gem 'rubyXL', "3.3.29", :require => false

archivesspace@archivesspace:/archivesspace-v2.6.0/archivesspace/plugins$ more aspace-import-excel/VERSION
v2.1.17
archivesspace@archivesspace:/archivesspace-v2.6.0/archivesspace/plugins$

Is there anything I can do to get this plugin operational?

Thanks

[bobbi-SMR]

Hi,

We're looking into this, and will get back to you --- hopefully by late this afternoon.

Sorry you're having this problem.

[pobocks]

Hi @tomadams,

Just curious - when you updated the plugin, did you re-run the initialize script:

scripts/initialize-plugin.sh aspace-import-excel

Your second error looks very much like the version of RubyXL in the current plugin just not being installed.

[tomadams]

I did not initially run the initialization script.

Upon running the initization script, I see:

$ scripts/initialize-plugin.sh aspace-import-excel
ERROR: SSL verification error at depth 2: certificate has expired (10)
ERROR: Certificate /C=BE/O=GlobalSign nv-sa/OU=Root CA/CN=GlobalSign Root CA expired at 2014-01-28T12:00:00Z
ERROR: SSL verification error at depth 2: certificate has expired (10)
ERROR: Certificate /C=BE/O=GlobalSign nv-sa/OU=Root CA/CN=GlobalSign Root CA expired at 2014-01-28T12:00:00Z
ERROR: SSL verification error at depth 2: certificate has expired (10)
ERROR: Certificate /C=BE/O=GlobalSign nv-sa/OU=Root CA/CN=GlobalSign Root CA expired at 2014-01-28T12:00:00Z
ERROR: Could not find a valid gem 'bundler' (= 1.16.1), here is why:
Unable to download data from https://rubygems.org/ - certificate verify failed (https://api.rubygems.org/specs.4.8.gz)
ERROR: SSL verification error at depth 2: certificate has expired (10)
ERROR: Certificate /C=BE/O=GlobalSign nv-sa/OU=Root CA/CN=GlobalSign Root CA expired at 2014-01-28T12:00:00Z
Gem::GemNotFoundException: can't find gem bundler (>= 0.a)
find_spec_for_exe at uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems.rb:271
activate_bin_path at uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems.rb:299

at ../../gems/bin/bundle:23

[pobocks]

That sounds, unfortunately, like an issue outside the application - I would retry it tomorrow, I can't imagine that the rubygems SSL cert expiring would pass unnoticed for long.

[pobocks]

https://guides.rubygems.org/ssl-certificate-update/

It's also worth looking at this, actually - it might be a cert included with rubygems, rather than the cert on the server.