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

Laney McGlohon laney.mcglohon at lyrasis.org
Tue Sep 19 15:38:02 EDT 2017 

Hey Jeremy,

What version of the mysql connector are you using? I have been using mysql-connector-java-5.1.42-bin.jar.

Laney


Laney McGlohon
ArchivesSpace Tech Lead
laney.mcglohon at lyrasis.org<mailto:laney.mcglohon at lyrasis.org>
800.999.8558 x2927
laneymcglohon Skype



From: <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Jason Loeffler <j at minorscience.com>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Date: Tuesday, September 19, 2017 at 3:22 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

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<mailto: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> [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 12:44 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto: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


_______________________________________________
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/e7826494/attachment.html>

More information about the Archivesspace_Users_Group mailing list