<div dir="ltr"><div class="gmail_extra"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div>JRuby is a Java application that reads and runs the Ruby source code. You don't need to install anything. If rolling back results in the same connectivity issue, I suspect it is not an ArchivesSpace-specific problem and is arising from something lower in your stack, likely an issue with your database server. Re-confirm that your config.rb has the correct credentials and that you also have the MYSQL connector installed at in your lib directory.</div></div></div></div></div></div>
<br><div class="gmail_quote">On Tue, Sep 19, 2017 at 2:20 PM, Jones, Jeremy <span dir="ltr"><<a href="mailto:Jeremy.Jones@unt.edu" target="_blank">Jeremy.Jones@unt.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div class="m_1263398020494876921WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Thanks looking into this. I tried going back to version 1.52 and got the same error. What is jruby and do I need to have it installed on the server?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-<wbr>bounces@lyralists.lyrasis.org</a> [mailto:<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_<wbr>group-bounces@lyralists.<wbr>lyrasis.org</a>]
<b>On Behalf Of </b>Jason Loeffler<br>
<b>Sent:</b> Tuesday, September 19, 2017 12:44 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@<wbr>lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] [EXT] Re: Failed to connect to database issue<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">The db connection error is thrown in only one place, in main.rb at
<a href="https://github.com/archivesspace/archivesspace/blob/75347ba2eb48833ceda804a74ef9caba7f97eeae/backend/app/main.rb#L96-L102" target="_blank">
lines 96-102</a>. It's hard to say what may be impeding the connection. I can't think of any reason the application can't connect, aside from a network issue. Feel free to contact me offlist if you're unable to resolve the issue.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<p class="MsoNormal">On Tue, Sep 19, 2017 at 12:45 PM, Jones, Jeremy <<a href="mailto:Jeremy.Jones@unt.edu" target="_blank">Jeremy.Jones@unt.edu</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Sure,</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">The server is centOS 6.9.
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Mysql version 14.14 Distrib 5.1.73</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Yes I can connect to the database directly using the username and password. It’s the same combo that
I’ve used since AS version 1.2.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">This is very strange that this is happening. I’ve never had any problems including the great migration
to get to version 1.5.2.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">
archivesspace_users_group-<wbr>bounces@lyralists.lyrasis.org</a> [mailto:<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_<wbr>group-bounces@lyralists.<wbr>lyrasis.org</a>]
<b>On Behalf Of </b>Jason Loeffler<br>
<b>Sent:</b> Tuesday, September 19, 2017 11:33 AM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@<wbr>lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [EXT] Re: [Archivesspace_Users_Group] Failed to connect to database issue</span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<p class="MsoNormal">Hi Jeremy, <u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Can you include more information about your environment, e.g. server OS and database server version? Can you connect to the database directly using your ArchivesSpace username and
password as stored in config.rb? <u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><br clear="all">
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Garamond",serif;color:#666666;background:white">Jason Loeffler</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Garamond",serif;color:#666666;background:white">Technology Consultant | </span><span style="font-family:"Garamond",serif;color:#666666">The
American Academy in Rome</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Garamond",serif;color:#666666;background:white">Minor Science | Application Development & Metadata Strategy</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Garamond",serif;color:#666666;background:white">Brooklyn, New York</span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Garamond",serif;color:#666666;background:white"><a href="mailto:jason@minorscience.com" target="_blank">jason@minorscience.com</a></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Garamond",serif;color:#666666;background:white"><a href="tel:(347)%20405-0826" target="_blank">(347) 405-0826</a></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Garamond",serif;color:#666666;background:white">minorscience (Skype)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"> <u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<p class="MsoNormal">On Tue, Sep 19, 2017 at 12:20 PM, Jones, Jeremy <<a href="mailto:Jeremy.Jones@unt.edu" target="_blank">Jeremy.Jones@unt.edu</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal">Hello,<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">I’ve been using Archives Space since version 1.2. I’ve recently upgraded to version 2.1.2 using the directions included. Now I am getting a “Database connection failed” error.
I’m using the same mysql connecter that I used in my version 1.5.2 install and connecting to the same database. The setup-database.sh script ran with no errors. Here is the stack trace:<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New"">"msg": "Database connection failed",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "backtrace": [</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "/var/www/html/archivesspace-<wbr>2.1.2/archivesspace/data/tmp/<wbr>jetty-0.0.0.0-8089-backend.<wbr>war-_-any-/webapp/WEB-INF/app/<wbr>main.rb:101:in `block in ArchivesSpaceService'",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "/var/www/html/archivesspace-<wbr>2.1.2/archivesspace/gems/gems/<wbr>sinatra-1.4.7/lib/sinatra/<wbr>base.rb:1411:in `configure'",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "/var/www/html/archivesspace-<wbr>2.1.2/archivesspace/data/tmp/<wbr>jetty-0.0.0.0-8089-backend.<wbr>war-_-any-/webapp/WEB-INF/app/<wbr>main.rb:78:in `<class:ArchivesSpaceService>'<wbr>",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "/var/www/html/archivesspace-<wbr>2.1.2/archivesspace/data/tmp/<wbr>jetty-0.0.0.0-8089-backend.<wbr>war-_-any-/webapp/WEB-INF/app/<wbr>main.rb:38:in `<main>'",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "org/jruby/RubyKernel.java:<wbr>961:in `require'",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "uri:classloader:/META-INF/<wbr>jruby.home/lib/ruby/stdlib/<wbr>rubygems/core_ext/kernel_<wbr>require.rb:55:in `require'",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "/var/www/html/archivesspace-<wbr>2.1.2/archivesspace/data/tmp/<wbr>jetty-0.0.0.0-8089-backend.<wbr>war-_-any-/webapp/WEB-INF/<wbr>config.ru:1:in `block in (root)'",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "org/jruby/RubyBasicObject.<wbr>java:1687:in `instance_eval'",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "/var/www/html/archivesspace-<wbr>2.1.2/archivesspace/data/tmp/<wbr>jetty-0.0.0.0-8089-backend.<wbr>war-_-any-/webapp/WEB-INF/<wbr>config.ru:4:in `(root)'",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "uri:classloader:/vendor/rack-<wbr>1.5.5/rack/builder.rb:55:in `<main>'",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "launcher/launcher.rb:92:in `start_server'",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "launcher/launcher.rb:157:in `main'",</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> "launcher/launcher.rb:261:in `<main>'"</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> </span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""> </span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New"">Any help solving this issue or any insight is appreciated. Thanks in advance.</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New";color:#888888"> </span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New";color:#888888">jeremy</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:#888888"> </span><u></u><u></u></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
______________________________<wbr>_________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@<wbr>lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" target="_blank">http://lyralists.lyrasis.org/<wbr>mailman/listinfo/<wbr>archivesspace_users_group</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
______________________________<wbr>_________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@<wbr>lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" target="_blank">http://lyralists.lyrasis.org/<wbr>mailman/listinfo/<wbr>archivesspace_users_group</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</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></div>