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

Jones, Jeremy Jeremy.Jones at unt.edu
Tue Sep 19 14:20:51 EDT 2017 

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 at 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<mailto: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> [mailto: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 at lyralists.lyrasis.org<mailto:archivesspace_users_group at 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<mailto:jason at minorscience.com>
(347) 405-0826<tel:(347)%20405-0826>
minorscience (Skype)


On Tue, Sep 19, 2017 at 12:20 PM, Jones, Jeremy <Jeremy.Jones at unt.edu<mailto: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<mailto: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<mailto: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/13f1f1cb/attachment.html>

More information about the Archivesspace_Users_Group mailing list