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

Jones, Jeremy Jeremy.Jones at unt.edu
Tue Sep 19 16:46:39 EDT 2017 

Hello,

Thanks for the update and suggestion.  No, my database is on the same machine.  It’s the same user and permissions that it’s always been.  I commented out the bd_url declaration in the config.rb file and actually got the thing to start so I’m thinking it has something to do with the app talking to the database.  I’ve got ssl on this machine with a force rewrite.  I didn’t think that would cause any issues but I’m running out of ideas on this. It’s been a day and a half.  Last update took less than 5 minutes. Lol.

jeremy

From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Laney McGlohon
Sent: Tuesday, September 19, 2017 3:31 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

Hey Jeremy,

I had the same problem on my server. To fix it I had to fix the permissions of my AS user to the database.
I had granted permissions for localhost but the mysql server was on a different machine so I had to grant permissions for that machine.
Could your mysql database be on a different machine?

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<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of "Jones, Jeremy" <Jeremy.Jones at unt.edu<mailto:Jeremy.Jones at unt.edu>>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Date: Tuesday, September 19, 2017 at 3:40 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

I used 5.1.34 until today then I upgraded to 6.0.6.  No luck.

jeremy

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] On Behalf Of Laney McGlohon
Sent: Tuesday, September 19, 2017 2:38 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

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<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Jason Loeffler <j at minorscience.com<mailto:j at minorscience.com>>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto: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<mailto: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/bd08eb25/attachment.html>

More information about the Archivesspace_Users_Group mailing list