<div dir="ltr">Adam,<div><br></div><div>Once my DB guy said that mysql was fine, that was the next thing we did. Still no go.</div><div><br></div><div>Regarding the other person's comment about going from 1.5.3 -> 2.1.2 -> 2.2.1 that is an idea (but I would have to get back to a working 1.5.3 first). But... I did not see</div><div>anyplace that the leap from 1.5x to 2.2.x was not allowed in the update instructions. :(</div><div><br></div><div>My attempt to retreat back to 1.5.3 via changing my symlink back to arcspace-v1.5.3 and a database restore of 1.5.3 also failed. Very surprising and painful.</div><div><br></div><div>Jeff Earickson</div><div>Colby College</div><div class="gmail_extra">
<br><div class="gmail_quote">On Tue, Nov 28, 2017 at 12:13 PM, Adam Jazairi <span dir="ltr"><<a href="mailto:jazairi@bc.edu" target="_blank">jazairi@bc.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">Hi Jeff,<div><br></div><div>Could you try switching back to <span style="font-size:12.8px">mysql-connector-java-5.1.</span><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.io<wbr>/archivesspace/user/upgrading-<wbr>to-a-new-release-of-archivessp<wbr>ace/</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=[R<wbr>EDACTED]&password=[REDACTED]&u<wbr>seSSL=false&useUnicode=true&ch<wbr>aracterEncoding=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/data<wbr>/tmp/aspace_diagnostic_1511882<wbr>523.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.handl<wbr>er.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/jru<wbr>by.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<wbr>/tmp/jetty-0.0.0.0-8089-backen<wbr>d.war-_-any-/webapp/WEB-INF/ap<wbr>p/main.rb:101</div><div> configure at /opt/archivesspace/gems/gems/s<wbr>inatra-1.4.7/lib/sinatra/base.<wbr>rb:1411</div><div> <class:ArchivesSpaceService> at /opt/archivesspace-v2.2.1/data<wbr>/tmp/jetty-0.0.0.0-8089-backen<wbr>d.war-_-any-/webapp/WEB-INF/ap<wbr>p/main.rb:78</div><div> <main> at /opt/archivesspace-v2.2.1/data<wbr>/tmp/jetty-0.0.0.0-8089-backen<wbr>d.war-_-any-/webapp/WEB-INF/ap<wbr>p/main.rb:38</div><div> require at org/jruby/RubyKernel.java:961</div><div> require at uri:classloader:/META-INF/jrub<wbr>y.home/lib/ruby/stdlib/rubygem<wbr>s/core_ext/kernel_require.rb:5<wbr>5</div><div> block in (root) at /opt/archivesspace-v2.2.1/data<wbr>/tmp/jetty-0.0.0.0-8089-backen<wbr>d.war-_-any-/webapp/WEB-INF/<a href="http://config.ru:1" target="_blank">co<wbr>nfig.ru:1</a></div><div> instance_eval at org/jruby/RubyBasicObject.java<wbr>:1687</div><div> (root) at /opt/archivesspace-v2.2.1/data<wbr>/tmp/jetty-0.0.0.0-8089-backen<wbr>d.war-_-any-/webapp/WEB-INF/<a href="http://config.ru:4" target="_blank">co<wbr>nfig.ru:4</a></div><div> <main> at uri:classloader:/vendor/rack-1<wbr>.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="m_6035096528154719681m_4731298730152151227HOEnZb"><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" target="_blank">Archivesspace_Users_Group@lyra<wbr>lists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/m<wbr>ailman/listinfo/archivesspace_<wbr>users_group</a><br>
<br></blockquote></div><span class="m_6035096528154719681HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div class="m_6035096528154719681m_4731298730152151227gmail_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"><a href="tel:(617)%20552-1404" value="+16175521404" target="_blank">(617) 552-1404</a></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>
</font></span></div>
<br>______________________________<wbr>_________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyra<wbr>lists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/m<wbr>ailman/listinfo/archivesspace_<wbr>users_group</a><br>
<br></blockquote></div><br></div></div>