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

Jones, Jeremy Jeremy.Jones at unt.edu
Mon Sep 25 11:19:00 EDT 2017 

Hello,

Thanks for the suggestion.  My issue was that I had a database table that had the wrong collation.  I had to update the collection for that table and the app started up as usual.  Now I’m dealing with a whole new set of problems, lol.

Thanks again,
jeremy

From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Christie Peterson
Sent: Monday, September 25, 2017 10:15 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] [EXT] Re: Failed to connect to database issue

Hi Jeremy,

I just did a local install of ASpace with a copy of our production data for the very first time and was getting similar errors:


--- Backtrace

RuntimeError: Database connection failed

  block in ArchivesSpaceService at /Applications/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:101

                      configure at /Applications/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1411

   <class:ArchivesSpaceService> at /Applications/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:78

                         <main> at /Applications/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:38

                        require at org/jruby/RubyKernel.java:961

                        require at uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems/core_ext/kernel_require.rb:55

                block in (root) at /Applications/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:1<http://config.ru:1>

                  instance_eval at org/jruby/RubyBasicObject.java:1687

                         (root) at /Applications/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:4<http://config.ru:4>

                         <main> at uri:classloader:/vendor/rack-1.5.5/rack/builder.rb:55

                   start_server at launcher/launcher.rb:92

                           main at launcher/launcher.rb:157

                         <main> at launcher/launcher.rb:261

 I did two things, and I'm not sure which was the one that fixed the problem (bad methodology, I know), but one of them did:

  *   make sure that the user account you're using to connect has been granted all privileges (see the example for 'finley' at https://dev.mysql.com/doc/refman/5.7/en/adding-users.html)
  *   make sure that when you downloaded the connector, it was the .jar file that ended up in your /lib directory, and not a directory containing the .jar file plus a bunch of other stuff
If you're more patient than I was, you might try to reconnect after each of these and see which (if either) solves the issue.

Good luck!

Christie Peterson

On Tue, Sep 19, 2017 at 4:46 PM Jones, Jeremy <Jeremy.Jones at unt.edu<mailto:Jeremy.Jones at unt.edu>> wrote:
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> [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 3:31 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,

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<tel:(800)%20999-8558>
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<tel:(800)%20999-8558>
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

_______________________________________________
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
--
🍂
Christie S. Peterson

Head of Technical Services for Special Collections
Smith College
Northampton, Mass.
413-585-2996
cpeterson at smith.edu<mailto:cpeterson at smith.edu>

pronouns: she/her/hers
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170925/0300944b/attachment.html>

More information about the Archivesspace_Users_Group mailing list