<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Our running v2.2.1 test instance uses the v5.1.34 one. <br>
</p>
<p><br>
</p>
<p>Mang</p>
<p>Rice U.<br>
</p>
<br>
<div class="moz-cite-prefix">On 11/28/2017 11:13 AM, Adam Jazairi
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAF1DmewwTyqVawrPj4yziZ0iL8U__gO700EPyML+pAi77w0MPQ@mail.gmail.com">
<meta http-equiv="Context-Type" content="text/html; charset=UTF-8">
<div dir="ltr">Hi Jeff,
<div><br>
</div>
<div>Could you try switching back to <span>mysql-connector-java-5.1.</span><wbr><span>40
or </span><span>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><br>
</span></div>
<div><span>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"
moz-do-not-send="true">jaearick@colby.edu</a>></span>
wrote:<br>
<blockquote class="gmail_quote">
<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" moz-do-not-send="true">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" moz-do-not-send="true">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"
moz-do-not-send="true">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"
moz-do-not-send="true">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">
<div><br>
</div>
<div>Jeff Earickson</div>
<div>Colby College</div>
</span></div>
<br>
______________________________<wbr>_________________<br>
Archivesspace_Users_Group mailing list<br>
<a
href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org"
moz-do-not-send="true">Archivesspace_Users_Group@<wbr>lyralists.lyrasis.org</a><br>
<a
href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lyralists.lyrasis.org/<wbr>mailman/listinfo/<wbr>archivesspace_users_group</a><br>
<br>
</blockquote>
</div>
<br>
<br>
<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>Adam Jazairi</span><br>
</div>
<div dir="ltr">
<div>Digital Library Applications Developer</div>
<div>Boston College</div>
<div>
<div>(617) 552-1404</div>
<div><a href="mailto:adam.jazairi@bc.edu"
target="_blank" moz-do-not-send="true">adam.jazairi@bc.edu</a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Archivesspace_Users_Group mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a>
<a class="moz-txt-link-freetext" href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a>
</pre>
</blockquote>
<br>
</body>
</html>