Hi Jeff, Could you try switching back to mysql-connector-java-5.1.40 or mysql-connector-java-5.1.39 and see if that fixes it? We've had problems in the past with versions above 5.1.40.
Adam On Tue, Nov 28, 2017 at 11:52 AM, Jeff Earickson <[email protected]> wrote: > All, > > Per the instructions at http://archivesspace.github.io/archivesspace/user/ > upgrading-to-a-new-release-of-archivesspace/ I upgraded from 1.5.3 to > 2.2.1 this morning. The database conversion went fine. > > Now I cannot get AS restarted, the logs say: > > E, [2017-11-28T10:22:03.545378 #9290] ERROR -- : Thread-2000: ***** > DATABASE CONNECTION FAILED ***** > > ArchivesSpace could not connect to your specified database URL > (jdbc:mysql://vrpmysql2.colby.edu:3306/archivesspace?user=[ > REDACTED]&password=[REDACTED]&useSSL=false&useUnicode=true& > characterEncoding=UTF-8). > > Please check your configuration and try again. > ======================================================================== > A trace file has been written to the following location: > /opt/archivesspace-v2.2.1/data/tmp/aspace_diagnostic_1511882523.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. > ======================================================================== > Nov 28, 2017 10:22:03 AM > org.eclipse.jetty.server.handler.ContextHandler$Context > log > INFO: An exception happened during JRuby-Rack startup > Database connection failed > --- System > 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] > Time: 2017-11-28 10:22:03 -0500 > Server: jetty/8.1.5.v20120716 > jruby.home: uri:classloader://META-INF/jruby.home > > --- Context Init Parameters: > jruby.compat.version = 1.9 > jruby.max.runtimes = 1 > jruby.min.runtimes = 1 > public.root = / > rack.env = production > > --- Backtrace > RuntimeError: Database connection failed > 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 > configure at /opt/archivesspace/gems/gems/ > sinatra-1.4.7/lib/sinatra/base.rb:1411 > <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 > <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 > require at org/jruby/RubyKernel.java:961 > require at uri:classloader:/META-INF/ > jruby.home/lib/ruby/stdlib/rubygems/core_ext/kernel_require.rb:55 > block in (root) at /opt/archivesspace-v2.2.1/ > data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:1 > instance_eval at org/jruby/RubyBasicObject.java:1687 > (root) at /opt/archivesspace-v2.2.1/ > data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:4 > <main> at uri:classloader:/vendor/rack- > 1.5.5/rack/builder.rb:55 > start_server at launcher/launcher.rb:92 > main at launcher/launcher.rb:157 > <main> at launcher/launcher.rb:261 > > 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. > > 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. > > What's wrong? How to fix? I have the diagnostic file available. > > My system: Redhat 7.4, java-1.8.0-openjdk-1.8.0.151-1 installed via rpm. > > Jeff Earickson > Colby College > > _______________________________________________ > Archivesspace_Users_Group mailing list > [email protected] > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group > > -- Adam Jazairi Digital Library Applications Developer Boston College (617) 552-1404 [email protected]
_______________________________________________ Archivesspace_Users_Group mailing list [email protected] http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
