[Archivesspace_Users_Group] [EXT] Re: Failed to connect to database issue
Christie Peterson
cpeterson at smith.edu
Mon Sep 25 11:15:19 EDT 2017
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
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
<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> 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] *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
>
> 800.999.8558 x2927 <(800)%20999-8558>
>
> laneymcglohon Skype
>
>
>
>
>
>
>
> *From: *<archivesspace_users_group-bounces at lyralists.lyrasis.org> on
> behalf of "Jones, Jeremy" <Jeremy.Jones at unt.edu>
> *Reply-To: *Archivesspace Users Group <
> 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>
> *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
> <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>
> *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
>
> 800.999.8558 x2927 <(800)%20999-8558>
>
> 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>
> 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 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>
> 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 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
>
> (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
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> 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
pronouns: she/her/hers
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170925/fc784c81/attachment.html>
More information about the Archivesspace_Users_Group
mailing list