<div dir="ltr">All,
<div><br></div><div>Per the instructions at <a href="http://archivesspace.github.io/archivesspace/user/upgrading-to-a-new-release-of-archivesspace/">http://archivesspace.github.io/archivesspace/user/upgrading-to-a-new-release-of-archivesspace/</a> I upgraded from 1.5.3 to 2.2.1 this morning. The database conversion went fine.</div><div><br></div><div>Now I cannot get AS restarted, the logs say:</div><div><br></div><div>E, [2017-11-28T10:22:03.545378 #9290] ERROR -- : Thread-2000: ***** DATABASE CONNECTION FAILED *****</div><div><br></div><div>ArchivesSpace could not connect to your specified database URL (jdbc:mysql://<a href="http://vrpmysql2.colby.edu:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useSSL=false&useUnicode=true&characterEncoding=UTF-8">vrpmysql2.colby.edu:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useSSL=false&useUnicode=true&characterEncoding=UTF-8</a>).</div><div><br></div><div>Please check your configuration and try again.</div><div>========================================================================</div><div>A trace file has been written to the following location: /opt/archivesspace-v2.2.1/data/tmp/aspace_diagnostic_1511882523.txt</div><div><br></div><div>This file contains information that will assist developers in diagnosing</div><div>problems with your ArchivesSpace installation. Please review the file's</div><div>contents for sensitive information (such as passwords) that you might not</div><div>want to share.</div><div>========================================================================</div><div>Nov 28, 2017 10:22:03 AM org.eclipse.jetty.server.handler.ContextHandler$Context log</div><div>INFO: An exception happened during JRuby-Rack startup</div><div>Database connection failed</div><div>--- System</div><div>jruby 9.1.8.0 (2.3.1) 2017-03-06 90fc7ab OpenJDK 64-Bit Server VM 25.151-b12 on 1.8.0_151-b12 +jit [linux-x86_64]</div><div>Time: 2017-11-28 10:22:03 -0500</div><div>Server: jetty/8.1.5.v20120716</div><div>jruby.home: uri:classloader://META-INF/jruby.home</div><div><br></div><div>--- Context Init Parameters:</div><div>jruby.compat.version = 1.9</div><div>jruby.max.runtimes = 1</div><div>jruby.min.runtimes = 1</div><div>public.root = /</div><div>rack.env = production</div><div><br></div><div>--- Backtrace</div><div>RuntimeError: Database connection failed</div><div> block in ArchivesSpaceService at /opt/archivesspace-v2.2.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:101</div><div> configure at /opt/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1411</div><div> <class:ArchivesSpaceService> at /opt/archivesspace-v2.2.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:78</div><div> <main> at /opt/archivesspace-v2.2.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:38</div><div> require at org/jruby/RubyKernel.java:961</div><div> require at uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems/core_ext/kernel_require.rb:55</div><div> block in (root) at /opt/archivesspace-v2.2.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/<a href="http://config.ru:1">config.ru:1</a></div><div> instance_eval at org/jruby/RubyBasicObject.java:1687</div><div> (root) at /opt/archivesspace-v2.2.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/<a href="http://config.ru:4">config.ru:4</a></div><div> <main> at uri:classloader:/vendor/rack-1.5.5/rack/builder.rb:55</div><div> start_server at launcher/launcher.rb:92</div><div> main at launcher/launcher.rb:157</div><div> <main> at launcher/launcher.rb:261 </div><div><br></div><div>I huddled with my DB guy and he says that there is nothing wrong with the database. He could connect to it with the username and password.</div><div><br></div><div>The other thing I did in the upgrade was move mysql-connector-java-5.1.40 to 5.1.44, putting the mysql jar file in the lib subdir in 2.2.1. </div><div><br></div><div>What's wrong? How to fix? I have the diagnostic file available.</div><div><br></div><div>My system: Redhat 7.4, java-1.8.0-openjdk-1.8.0.151-1 installed via rpm.</div><div><br></div><div>Jeff Earickson</div><div>Colby College</div></div>