<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<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);">
"<span style="color: rgb(50, 49, 48); font-family: Calibri, sans-serif; font-size: 14.6667px; background-color: rgb(255, 255, 255); display: inline !important">Connection to backend failed<span> " can mean a bunch of things.</span></span></div>
<div style=""><font face="Calibri, sans-serif"><span style="font-size: 14.6667px;">What's around that error, are there any other details? Those usually show up before that line. There's should be something more specific in the logs about that error.</span></font></div>
<div style=""><font face="Calibri, sans-serif"><span style="font-size: 14.6667px;">Could be as simple as user/pass isn't correct. Can you connect to mysql from the command line successfully?</span></font></div>
<div style=""><font face="Calibri, sans-serif"><span style="font-size: 14.6667px;"><br>
</span></font></div>
<div>
<div id="Signature">
<div>
<div id="divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); background-color:rgb(255,255,255)">
</div>
</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 Mark Cyzyk
<mcyzyk@jhu.edu><br>
<b>Sent:</b> Tuesday, July 28, 2020 11:18 AM<br>
<b>To:</b> Lora Woodford <Lora.Woodford@lyrasis.org>; Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] ASpace upgrade: "Connection to backend failed"</font>
<div> </div>
</div>
<div><br>
Update on this:<br>
<br>
Upgraded to latest MySQL Connector (8.0.21). Still no joy,<br>
<br>
Mark<br>
<br>
<pre class="x_moz-signature" cols="72"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
<a class="x_moz-txt-link-abbreviated" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>
Verba volant, scripta manent.
</pre>
<div class="x_moz-cite-prefix">On 7/27/20 11:35 AM, Mark Cyzyk wrote:<br>
</div>
<blockquote type="cite"><br>
Hi Lora!<br>
<br>
Sorry, I should have mentioned this, I'm running against MariaDB:<br>
<br>
MariaDB from Ubuntu 20.04 repository, version <span class="x_highlight">10.3<br>
<br>
(We're running against MariaDB here in Prod and Dev on CentOS 7.)<br>
<br>
Thanks!<br>
<br>
Mark<br>
<br>
</span>
<pre class="x_moz-signature" cols="72"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
<a class="x_moz-txt-link-abbreviated" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>
Verba volant, scripta manent.
</pre>
<div class="x_moz-cite-prefix">On 7/27/20 11:22 AM, Lora Woodford wrote:<br>
</div>
<blockquote type="cite">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Consolas}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:blue;
text-decoration:underline}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New"}
span.x_HTMLPreformattedChar
{font-family:"Consolas",serif}
span.x_EmailStyle20
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
-->
</style>
<div class="x_WordSection1">
<p class="x_MsoNormal">Hiya Mark!<br>
<br>
So, if the issue were a db schema mismatch, you’d likely get an error message explaining that. Something like “Schema Info Mismatch. Expected #{expected schema version}, received #{your schema version} for ASPACE version #{version you’re trying to run}.”</p>
<p class="x_MsoNormal"><br>
What version of mysql (if mysql?) are you using? I’ve seen similar issues with folks attempting to run against MySql 8. Can you try 5.7?</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Lora</p>
<p class="x_MsoNormal"> </p>
<div style="border:none; border-top:solid #B5C4DF
1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal"><b><span style="font-size:12.0pt; color:black">From: </span>
</b><span style="font-size:12.0pt; color:black"><a class="x_moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"><archivesspace_users_group-bounces@lyralists.lyrasis.org></a> on behalf of Mark Cyzyk
<a class="x_moz-txt-link-rfc2396E" href="mailto:mcyzyk@jhu.edu"><mcyzyk@jhu.edu></a><br>
<b>Reply-To: </b><a class="x_moz-txt-link-rfc2396E" href="mailto:mcyzyk@jhu.edu">"mcyzyk@jhu.edu"</a>
<a class="x_moz-txt-link-rfc2396E" href="mailto:mcyzyk@jhu.edu"><mcyzyk@jhu.edu></a>, Archivesspace Users Group
<a class="x_moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group@lyralists.lyrasis.org">
<archivesspace_users_group@lyralists.lyrasis.org></a><br>
<b>Date: </b>Monday, July 27, 2020 at 10:55 AM<br>
<b>To: </b><a class="x_moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group@lyralists.lyrasis.org">"archivesspace_users_group@lyralists.lyrasis.org"</a>
<a class="x_moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group@lyralists.lyrasis.org">
<archivesspace_users_group@lyralists.lyrasis.org></a><br>
<b>Subject: </b>[Archivesspace_Users_Group] ASpace upgrade: "Connection to backend failed"</span></p>
</div>
<div>
<p class="x_MsoNormal"> </p>
</div>
<p class="x_MsoNormal" style="margin-bottom:12.0pt"><br>
All,<br>
<br>
I'm trying to practice upgrading ASpace (2.5.1 --> 2.8.0) in a Vagrant box before upgrading for real.<br>
<br>
I was having problems running the /scripts/database-setup.sh migration script via my Vagrant file, and, as with Vagrant, Ansible, etc. found myself spending lots of time troubleshooting the script I've written to install the software, when I could have just
installed the software!<br>
<br>
So now I have my Vagrant box up and running, I SSH in and run /scripts/database-setup.sh without any problem.<br>
<br>
BUT now that I've kicked this can down the road, the next issue is:<br>
<br>
When I go to boot up ASpace, I end up with the following error:</p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal">INFO: DEBUG: resetting rack response due exception<br>
E, [2020-07-25T15:57:06.898049 #38438] ERROR -- : Thread-2004: Connection to backend failed (<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
<a href="http://www.w3.org/TR/html4/loose.dtd">"http://www.w3.org/TR/html4/loose.dtd"</a>></p>
</blockquote>
<p class="x_MsoNormal"><br>
I read that if the schema in the DB does not match the schema in the ASpace codebase, the backend will not start.<br>
<br>
And yet, the setup-database.sh migration script ran without error, so at this point the schemas should be in sync.<br>
<br>
Any advice on how to get the backend up and running greatly appreciated,<br>
<br>
Mark<br>
<br>
</p>
<pre>-- </pre>
<pre><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> </pre>
<pre>Mark Cyzyk, M.A., M.L.S.</pre>
<pre>Library Applications Group</pre>
<pre>The Sheridan Libraries</pre>
<pre>The Johns Hopkins University</pre>
<pre><a href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a></pre>
<pre> </pre>
<pre>Verba volant, scripta manent. </pre>
</div>
</blockquote>
<br>
</blockquote>
<br>
</div>
</body>
</html>