<div dir="ltr">Hi Jeff,<div><br></div><div>Could you try switching back to <span style="font-size:12.8px">mysql-connector-java-5.1.</span><wbr style="font-size:12.8px"><span style="font-size:12.8px">40 or </span><span style="font-size:12.8px">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.</span></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">Adam</span></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Nov 28, 2017 at 11:52 AM, Jeff Earickson <span dir="ltr"><<a href="mailto:jaearick@colby.edu" target="_blank">jaearick@colby.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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/" target="_blank">http://archivesspace.github.<wbr>io/archivesspace/user/<wbr>upgrading-to-a-new-release-of-<wbr>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" target="_blank">vrpmysql2.colby.<wbr>edu:3306/archivesspace?user=[<wbr>REDACTED]&password=[REDACTED]&<wbr>useSSL=false&useUnicode=true&<wbr>characterEncoding=UTF-8</a>).</div><div><br></div><div>Please check your configuration and try again.</div><div>==============================<wbr>==============================<wbr>============</div><div>A trace file has been written to the following location: /opt/archivesspace-v2.2.1/<wbr>data/tmp/aspace_diagnostic_<wbr>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>==============================<wbr>==============================<wbr>============</div><div>Nov 28, 2017 10:22:03 AM org.eclipse.jetty.server.<wbr>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/<wbr>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/<wbr>data/tmp/jetty-0.0.0.0-8089-<wbr>backend.war-_-any-/webapp/WEB-<wbr>INF/app/main.rb:101</div><div> configure at /opt/archivesspace/gems/gems/<wbr>sinatra-1.4.7/lib/sinatra/<wbr>base.rb:1411</div><div> <class:ArchivesSpaceService> at /opt/archivesspace-v2.2.1/<wbr>data/tmp/jetty-0.0.0.0-8089-<wbr>backend.war-_-any-/webapp/WEB-<wbr>INF/app/main.rb:78</div><div> <main> at /opt/archivesspace-v2.2.1/<wbr>data/tmp/jetty-0.0.0.0-8089-<wbr>backend.war-_-any-/webapp/WEB-<wbr>INF/app/main.rb:38</div><div> require at org/jruby/RubyKernel.java:961</div><div> require at uri:classloader:/META-INF/<wbr>jruby.home/lib/ruby/stdlib/<wbr>rubygems/core_ext/kernel_<wbr>require.rb:55</div><div> block in (root) at /opt/archivesspace-v2.2.1/<wbr>data/tmp/jetty-0.0.0.0-8089-<wbr>backend.war-_-any-/webapp/WEB-<wbr>INF/<a href="http://config.ru:1" target="_blank">config.ru:1</a></div><div> instance_eval at org/jruby/RubyBasicObject.<wbr>java:1687</div><div> (root) at /opt/archivesspace-v2.2.1/<wbr>data/tmp/jetty-0.0.0.0-8089-<wbr>backend.war-_-any-/webapp/WEB-<wbr>INF/<a href="http://config.ru:4" target="_blank">config.ru:4</a></div><div> <main> at uri:classloader:/vendor/rack-<wbr>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.<wbr>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.<wbr>151-1 installed via rpm.</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>Jeff Earickson</div><div>Colby College</div></font></span></div>
<br>______________________________<wbr>_________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@<wbr>lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/<wbr>mailman/listinfo/<wbr>archivesspace_users_group</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><span style="font-size:12.8px">Adam Jazairi</span><br></div><div dir="ltr"><div>Digital Library Applications Developer</div><div>Boston College</div><div><div style="font-size:12.8px">(617) 552-1404</div><div style="font-size:12.8px"><a href="mailto:adam.jazairi@bc.edu" target="_blank">adam.jazairi@bc.edu</a></div></div></div></div></div></div></div></div></div></div></div></div>
</div>