[Archivesspace_Users_Group] [EXT] Re: Failed to connect to database issue

[Jason Loeffler]

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.

On Tue, Sep 19, 2017 at 2:20 PM, Jones, Jeremy <Jeremy.Jones at unt.edu> wrote:

> 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?
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] *On Behalf Of *Jason
> Loeffler
> *Sent:* Tuesday, September 19, 2017 12:44 PM
> *To:* Archivesspace Users Group <archivesspace_users_group@
> lyralists.lyrasis.org>
> *Subject:* Re: [Archivesspace_Users_Group] [EXT] Re: Failed to connect to
> database issue
>
>
>
> The db connection error is thrown in only one place, in main.rb at lines
> 96-102
> <https://github.com/archivesspace/archivesspace/blob/75347ba2eb48833ceda804a74ef9caba7f97eeae/backend/app/main.rb#L96-L102>.
> 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.
>
>
>
> On Tue, Sep 19, 2017 at 12:45 PM, Jones, Jeremy <Jeremy.Jones at unt.edu>
> wrote:
>
> Sure,
>
>
>
> The server is centOS 6.9.
>
> Mysql version 14.14 Distrib 5.1.73
>
> 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.
>
>
>
> 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.
>
>
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] *On Behalf Of *Jason
> Loeffler
> *Sent:* Tuesday, September 19, 2017 11:33 AM
> *To:* Archivesspace Users Group <archivesspace_users_group@
> lyralists.lyrasis.org>
> *Subject:* [EXT] Re: [Archivesspace_Users_Group] Failed to connect to
> database issue
>
>
>
> Hi Jeremy,
>
>
>
> 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?
>
>
> Jason Loeffler
>
> Technology Consultant | The American Academy in Rome
>
> Minor Science | Application Development & Metadata Strategy
>
> Brooklyn, New York
>
> jason at minorscience.com
>
> (347) 405-0826
>
> minorscience (Skype)
>
>
>
>
>
> On Tue, Sep 19, 2017 at 12:20 PM, Jones, Jeremy <Jeremy.Jones at unt.edu>
> wrote:
>
> Hello,
>
>
>
> 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:
>
>
>
> "msg": "Database connection failed",
>
>     "backtrace": [
>
>       "/var/www/html/archivesspace-2.1.2/archivesspace/data/tmp/
> jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:101:in
> `block in ArchivesSpaceService'",
>
>       "/var/www/html/archivesspace-2.1.2/archivesspace/gems/gems/
> sinatra-1.4.7/lib/sinatra/base.rb:1411:in `configure'",
>
>       "/var/www/html/archivesspace-2.1.2/archivesspace/data/tmp/
> jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:78:in
> `<class:ArchivesSpaceService>'",
>
>       "/var/www/html/archivesspace-2.1.2/archivesspace/data/tmp/
> jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:38:in
> `<main>'",
>
>       "org/jruby/RubyKernel.java:961:in `require'",
>
>       "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/
> rubygems/core_ext/kernel_require.rb:55:in `require'",
>
>       "/var/www/html/archivesspace-2.1.2/archivesspace/data/tmp/
> jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:1:in
> `block in (root)'",
>
>       "org/jruby/RubyBasicObject.java:1687:in `instance_eval'",
>
>       "/var/www/html/archivesspace-2.1.2/archivesspace/data/tmp/
> jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:4:in
> `(root)'",
>
>       "uri:classloader:/vendor/rack-1.5.5/rack/builder.rb:55:in `<main>'",
>
>       "launcher/launcher.rb:92:in `start_server'",
>
>       "launcher/launcher.rb:157:in `main'",
>
>       "launcher/launcher.rb:261:in `<main>'"
>
>
>
>
>
> Any help solving this issue or any insight is appreciated.  Thanks in
> advance.
>
>
>
> jeremy
>
>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170919/4beff47a/attachment.html>