<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
"Database connection failed..." <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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. </div>
<div id="Signature">
<div></div>
<div id="divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); background-color:rgb(255,255,255)">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<br>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Rodman, Gary
<rodmang@ripon.edu><br>
<b>Sent:</b> Tuesday, June 11, 2019 3:25 PM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Subject:</b> [Archivesspace_Users_Group] Troubleshooting archivesspace 2.6 on Windows Server 2012R2</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div class="x_gmail_default" style="font-size:small"><font color="#0b5394" face="times new roman, serif" style="">Hello, I've installed archivesspace 2.6 on a windows 2012 server. I believe I have installed all necessary prerequisites including:</font></div>
<div class="x_gmail_default" style="font-size:small"><font color="#0b5394" face="times new roman, serif" style=""> MySQL community server, </font></div>
<div class="x_gmail_default" style="font-size:small"><font color="#0b5394" face="times new roman, serif" style=""><span style="background-color:transparent; font-size:9pt; white-space:pre-wrap">MySQL Connector J platform independent</span>, </font></div>
<div class="x_gmail_default" style="font-size:small"><font color="#0b5394" face="times new roman, serif" style=""><span style="background-color:transparent; font-size:9pt; white-space:pre-wrap">commons-daemon (</span><span style="background-color:transparent; font-size:9pt; white-space:pre-wrap">prunmgr.exe
and prunsrv.exe),</span></font></div>
<div class="x_gmail_default" style="font-size:small"><font color="#0b5394" face="times new roman, serif" style=""><span style="background-color:transparent; font-size:9pt; white-space:pre-wrap">edited config.rb to point to the archivesspace database within
MySQL, </span></font></div>
<div class="x_gmail_default" style="font-size:small"><font color="#0b5394" face="times new roman, serif" style=""><span style="background-color:transparent; font-size:9pt; white-space:pre-wrap">created the JAVA_HOME environment variable,
</span></font></div>
<div class="x_gmail_default" style="font-size:small"><font color="#0b5394" face="times new roman, serif" style=""><span style="background-color:transparent; font-size:9pt; white-space:pre-wrap">added the Java executable to the path statement.</span></font></div>
<div class="x_gmail_default" style="font-size:small"><span style="background-color:transparent; font-size:9pt; white-space:pre-wrap"><font color="#0b5394" face="times new roman, serif"><br>
</font></span></div>
<div class="x_gmail_default" style="font-size:small"><span style="background-color:transparent; font-size:9pt; white-space:pre-wrap"><font color="#0b5394" face="times new roman, serif">However, I cannot get the archivesspace service to launch
</font></span></div>
<div class="x_gmail_default" style="font-size:small"><span style="background-color:transparent; font-size:9pt; white-space:pre-wrap"><font color="#0b5394" face="times new roman, serif">(neither the windows event viewer error nor the archivesspace.out error
logs are helpful)</font></span></div>
<div class="x_gmail_default" style="font-size:small"><span style="background-color:transparent; font-size:9pt; white-space:pre-wrap"><font color="#0b5394" face="times new roman, serif"><br>
</font></span></div>
<div class="x_gmail_default" style=""><font color="#0b5394" face="times new roman, serif"><span style="font-size:12px; white-space:pre-wrap">When I execute archivesspace.bat from an elevated command prompt, that seems to run, but browsing to
</span><a href="http://localhost:8089/">http://localhost:8089/</a> gives an internal server error</font></div>
<div class="x_gmail_default" style="">
<div id="x_gmail-summary" style="padding:10px 20px; margin:0px; border-bottom:1px solid rgb(221,221,221); background:rgb(255,255,204); color:rgb(0,0,0); font-family:sans-serif">
<h1 style="padding:0px; margin:0px 0px 0.4em; font-weight:normal">Internal Server Error <span style="padding:0px; margin:0px; font-size:15.6px; color:rgb(102,102,102)">(500)</span></h1>
<table class="x_gmail-meta" style="padding:0px; margin:0px; border:none; border-collapse:collapse; width:1224px">
<tbody style="padding:0px; margin:0px">
<tr style="padding:0px; margin:0px">
<th style="padding:2px 0.5em 2px 3px; margin:0px; vertical-align:top; width:12em; text-align:right; color:rgb(102,102,102)">
Request Method:</th>
<td style="padding:2px 3px; vertical-align:top">GET</td>
</tr>
<tr style="padding:0px; margin:0px">
<th style="padding:2px 0.5em 2px 3px; margin:0px; vertical-align:top; width:12em; text-align:right; color:rgb(102,102,102)">
Request URL:</th>
<td style="padding:2px 3px; vertical-align:top"><a href="http://localhost:8089/">http://localhost:8089/</a></td>
</tr>
</tbody>
</table>
</div>
<div id="x_gmail-info" style="padding:10px 20px; margin:0px; border-bottom:1px solid rgb(221,221,221); background:rgb(246,246,246); color:rgb(0,0,0); font-family:sans-serif">
<p style="padding:0px; margin:0px">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>'</p>
</div>
<div id="x_explanation" style="padding:10px 20px; margin:0px; border-bottom:0px none; background:rgb(238,238,238); color:rgb(0,0,0); font-family:sans-serif">
<p style="padding:0px; margin:0px">You're seeing this error because you use <code style="padding:0px; margin:0px">JRuby::Rack::ErrorApp::ShowStatus</code>.</p>
</div>
<font face="times new roman, serif" color="#134f5c">The other URLs (:8080, :8081, :8082 give connection refused errors.</font></div>
<div class="x_gmail_default" style=""><font face="times new roman, serif" color="#134f5c"><br>
</font></div>
<div class="x_gmail_default" style=""><font face="times new roman, serif" color="#134f5c">Looking for any advice on troubleshooting. </font></div>
<div class="x_gmail_default" style=""><font face="times new roman, serif" color="#134f5c"><br>
</font></div>
<div class="x_gmail_default" style=""><font face="times new roman, serif" color="#134f5c">Thank you.</font></div>
<div class="x_gmail_default" style=""><br>
</div>
<div class="x_gmail_default" style="">
<div dir="ltr">
<div class="x_gmail_default" style="font-family:"times new roman",serif; color:rgb(11,83,148)">
<span style="color:black; font-family:'Century Gothic',sans-serif; font-size:10pt"><b>Gary Rodman</b></span><br>
</div>
<div class="x_gmail_default" style="font-family:"times new roman",serif; color:rgb(11,83,148)">
<h3 style="color:rgb(34,34,34); font-family:arial,sans-serif; margin:0in 0in 0.0001pt">
<span style="font-family:'Century Gothic',sans-serif; color:black; background-image:initial; background-repeat:initial"></span></h3>
<p style="color:rgb(34,34,34); font-family:arial,sans-serif; font-size:12.8000001907349px; margin:0in 0in 3.75pt">
<span style="font-family:'Century Gothic',sans-serif; color:black; background-image:initial; background-repeat:initial">Director of Enterprise Applications<br>
Ripon College<br>
300 W. Seward St.<br>
Ripon, WI 54971<br>
(direct) <span style="color:rgb(17,85,204)"><a href="tel:920-748-8365" target="_blank">920-748-83</a>43</span><br>
<a href="mailto:RodmanG@ripon.edu" target="_blank">RodmanG@ripon.edu</a></span></p>
<p style="color:rgb(34,34,34); font-family:arial,sans-serif; font-size:12.8000001907349px; margin:0in 0in 3.75pt">
<br>
</p>
</div>
<div class="x_gmail_default" style="font-family:"times new roman",serif; color:rgb(11,83,148)">
<img alt="image.png" width="120" height="42" data-outlook-trace="F:1|T:1" src="cid:ii_16b47ff570acb971f161"><br>
</div>
<div class="x_gmail_default" style="font-family:"times new roman",serif; color:rgb(11,83,148)">
<p class="x_MsoNormal" style="background-image:initial; background-repeat:initial">
<span style="font-size:9.5pt; line-height:115%; font-family:"Century Gothic","sans-serif"; color:black">Visit us at <b><a href="http://ripon.edu/" target="_blank">ripon.edu</a></b></span><span style="font-size:12.0pt; line-height:115%; font-family:"Arial","sans-serif"; color:#888888"></span></p>
</div>
</div>
</div>
<div class="x_gmail_default" style=""><br>
</div>
<div class="x_gmail_default" style=""><br>
</div>
<div class="x_gmail_default" style=""><br>
</div>
</div>
<br>
<i style="font-family:arial; font-size:x-small; white-space:pre-wrap">This email 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.</i></div>
</body>
</html>