[Archivesspace_Users_Group] Troubleshooting archivesspace 2.6 on Windows Server 2012R2

[Blake Carver]

"Database connection failed..."
For some reason ArchivesSpace can't talk to your DB. The answer is probably in your archivesspace.out file, though it can be hard to spot sometimes.
Could be a user/password issue, or a port or URL issue, or a migration issue. Take another look at that log file, and within the first 50 or so lines, there's probably something that screams "ERROR" with an explanation of some kind.

________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Rodman, Gary <rodmang at ripon.edu>
Sent: Tuesday, June 11, 2019 3:25 PM
To: archivesspace_users_group at lyralists.lyrasis.org
Subject: [Archivesspace_Users_Group] Troubleshooting archivesspace 2.6 on Windows Server 2012R2

Hello, I've installed archivesspace 2.6 on a windows 2012 server. I believe I have installed all necessary prerequisites including:
 MySQL community server,
MySQL Connector J platform independent,
commons-daemon (prunmgr.exe and prunsrv.exe),
edited config.rb to point to the archivesspace database within MySQL,
created the JAVA_HOME environment variable,
added the Java executable to the path statement.

However, I cannot get the archivesspace service to launch
(neither the windows event viewer error nor the archivesspace.out error logs are helpful)

When I execute archivesspace.bat from an elevated command prompt, that seems to run, but browsing to http://localhost:8089/ gives an internal server error
Internal Server Error (500)
Request Method: GET
Request URL:    http://localhost:8089/

Database connection failed from D:/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:101:in `block in ArchivesSpaceService' from D:/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1411:in `configure' from D:/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:78:in `<class:ArchivesSpaceService>' from D:/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:38:in `<main>' from org/jruby/RubyKernel.java:956:in `require' from uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems/core_ext/kernel_require.rb:1:in `(root)' from uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems/core_ext/kernel_require.rb:55:in `block in require' from org/jruby/RubyBasicObject.java:1691:in `instance_eval' from D:\archivesspace\data\tmp\jetty-0.0.0.0-8089-backend.war-_-any-\webapp\WEB-INF\config.ru:4:in `(root)' from uri:classloader:/vendor/rack-1.6.8/rack/builder.rb:55:in `<main>' from launcher/launcher.rb:92:in `start_server' from launcher/launcher.rb:157:in `main' from launcher/launcher.rb:261:in `<main>'

You're seeing this error because you use JRuby::Rack::ErrorApp::ShowStatus.

The other URLs (:8080, :8081, :8082 give connection refused errors.

Looking for any advice on troubleshooting.

Thank you.

Gary Rodman

Director of Enterprise Applications
Ripon College
300 W. Seward St.
Ripon, WI 54971
(direct) 920-748-83<tel:920-748-8365>43
RodmanG at ripon.edu<mailto:RodmanG at ripon.edu>


[image.png]

Visit us at ripon.edu<http://ripon.edu/>




This e­mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information.  Any review, dissemination, copying, printing, or other use of this email by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from your computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20190611/726d65ba/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 17747 bytes
Desc: image.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20190611/726d65ba/attachment.png>