<div dir="ltr">All,<div><br></div><div>Problem Solved!!!</div><div><br></div><div>The issue was thus, near the top of the log output, a warning that turns out to be **FATAL**:</div><div><br></div><div>
<p class="gmail-p1"><span class="gmail-s1"><b>W, [2017-11-28T10:22:03.136709 #9290]<span class="gmail-Apple-converted-space"> </span>WARN -- : Thread-2000:</b></span></p>
<p class="gmail-p1"><span class="gmail-s1"><b>The following MySQL database tables are not set to use UTF-8 for their character</b></span></p>
<p class="gmail-p1"><span class="gmail-s1"><b>encoding:</b></span></p>
<p class="gmail-p2"><span class="gmail-s1"><b></b></span><br></p>
<p class="gmail-p1"><span class="gmail-s1"><b><span class="gmail-Apple-converted-space"> </span>* rights_statement_pre_088</b></span></p><p class="gmail-p1"><br></p><p class="gmail-p1">The fix is to convert that database table (not the database) to UTF-8 in either Sql Workbench or via:</p><p class="gmail-p1">ALTER TABLE rights_statement_pre_088 CONVERT TO CHARACTER SET utf8;<br></p><p class="gmail-p1"><br></p><p class="gmail-p1">BTW, I ended up at <span style="font-size:12.8px">mysql-connector-java-5.1.40 by chance after I got it restarted. Per the advice here, I am going to leave it at that version for the time being.</span></p><p class="gmail-p1"><span style="font-size:12.8px">Thanks to all who responded.</span></p></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature">-----------------------------------<br>Jeff A. Earickson, Ph.D<br>Senior Server System Administrator<br>Colby College,<br>4214 Mayflower Hill,<br>Waterville ME, 04901-8842<br>207-859-4214 (fax 207-859-4186)<br>Eastern Time Zone, USA<br>-----------------------------------</div></div>
<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/<wbr>app/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/<wbr>app/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/<wbr>app/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:<wbr>55</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_-8601826514982851102HOEnZb"><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="HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div class="m_-8601826514982851102gmail_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">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></div>