Update on this:

Upgraded to latest MySQL Connector (8.0.21).    Still no joy,

Mark

<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
mcy...@jhu.edu

Verba volant, scripta manent.

On 7/27/20 11:35 AM, Mark Cyzyk wrote:

Hi Lora!

Sorry, I should have mentioned this, I'm running against MariaDB:

MariaDB from Ubuntu 20.04 repository, version 10.3

(We're running against MariaDB here in Prod and Dev on CentOS 7.)

Thanks!

Mark

<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
mcy...@jhu.edu

Verba volant, scripta manent.
On 7/27/20 11:22 AM, Lora Woodford wrote:

Hiya Mark!

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}.”


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?

Lora

*From: *<archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of Mark Cyzyk <mcy...@jhu.edu> *Reply-To: *"mcy...@jhu.edu" <mcy...@jhu.edu>, Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org>
*Date: *Monday, July 27, 2020 at 10:55 AM
*To: *"archivesspace_users_group@lyralists.lyrasis.org" <archivesspace_users_group@lyralists.lyrasis.org> *Subject: *[Archivesspace_Users_Group] ASpace upgrade: "Connection to backend failed"


All,

I'm trying to practice upgrading ASpace (2.5.1 --> 2.8.0) in a Vagrant box before upgrading for real.

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!

So now I have my Vagrant box up and running, I SSH in and run /scripts/database-setup.sh without any problem.

BUT now that I've kicked this can down the road, the next issue is:

When I go to boot up ASpace, I end up with the following error:

    INFO: DEBUG: resetting rack response due exception
    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"
    "http://www.w3.org/TR/html4/loose.dtd";
    <http://www.w3.org/TR/html4/loose.dtd>>


I read that if the schema in the DB does not match the schema in the ASpace codebase, the backend will not start.

And yet, the setup-database.sh migration script ran without error, so at this point the schemas should be in sync.

Any advice on how to get the backend up and running greatly appreciated,

Mark

--
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
mcy...@jhu.edu  <mailto:mcy...@jhu.edu>
Verba volant, scripta manent.


_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

Reply via email to