Re: [Archivesspace_Users_Group] ASpace database issues
Thanks Peter. I was wondering if the age of our installation might have been the issue. I was even trying to poke through the code to see what it was looking for in the check to see if there was that sort of mis-match between what ASpac was looking for and what MySQL was returning. Fortunately, this is not our production server. It is a sandbox / testing server. It sounds like the upgrade to our university managed MySQL server (in conjunction with the old version of ASpace) is the root of the issue. If I were to hazard a guess, we haven't had to reboot the sandbox server since the MySQL upgrade and recent system reboot just brought the issue to light. Matt *Matt Adair* Archivist for Digital Imaging and Infrastructure Bentley Historical Library 1150 Beal Avenue Ann Arbor, Michigan 48109-2113 734-647-3537 http://bentley.umich.edu @UmichBentley *The Bentley Historical Library acknowledges that coerced cessions of land by the Anishnaabeg and Wyandot made the University of Michigan possible, and we seek to reaffirm the ancestral and contemporary ties of these peoples to the lands where the University now stands.* On Wed, Jan 18, 2023 at 4:15 PM Peter Heiner wrote: > Matthew Adair wrote on 2023-01-18 14:23:14: > > Version 2.5.2 of ASpace. Version 8.0.30 of MySQL > > A couple of versions prior to yours MySQL started explicitly reporting > 'utf8mb3' where in the past it would say 'utf8'. That's because 'utf8' is > currently an alias for 'utf8mb3' and they want to deprecate 'utf8mb3' and > make > 'utf8' an alias of 'utf8mb4' instead. > ASpace 2.5.2 only recognises 'utf8' as an UTF-8 character set, this was > fixed > in ASpace 2.7.1. I would consider upgrading to a more recent version if > possible. > > > We get the following error in the log file: > > "The following MySQL database tables are not set to use UTF-8 for their > > character encoding:" > > and then it lists all of the database tables, and fails with an unable to > > connect to database error > > > > Encoding on the database and all of the tables are utf8mb3_general_ci > > Short of the ASpace upgrade (or a database downgrade that might be even > more > painful) the correct solution is to convert table data to 'utf8mb4', see > https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html > for details on how to do that. > > Hope that helps, > p > ___ > Archivesspace_Users_Group mailing list > Archivesspace_Users_Group@lyralists.lyrasis.org > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group > ___ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
Re: [Archivesspace_Users_Group] ASpace database issues
Indeed, university IT updated our MySQL server from 5.x to 8.x. But this was back in early November. Everything had been working fine since then. *Matt Adair* Archivist for Digital Imaging and Infrastructure Bentley Historical Library 1150 Beal Avenue Ann Arbor, Michigan 48109-2113 734-647-3537 http://bentley.umich.edu @UmichBentley *The Bentley Historical Library acknowledges that coerced cessions of land by the Anishnaabeg and Wyandot made the University of Michigan possible, and we seek to reaffirm the ancestral and contemporary ties of these peoples to the lands where the University now stands.* On Wed, Jan 18, 2023 at 3:18 PM Tom Hanstra wrote: > Is there any way that your version of MySQL got upgraded? I see this in > the MySQL documentation: > > https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8.html > > which indicates that utf8mb3 is deprecated after Mysql 8.0.28. > > I don't have any experience to say that this is where the problem is. I > was just looking around because I don't want to end up in a similar > situation. > > Tom > > On Wed, Jan 18, 2023 at 2:23 PM Matthew Adair wrote: > >> Version 2.5.2 of ASpace. Version 8.0.30 of MySQL >> >> We get the following error in the log file: >> "The following MySQL database tables are not set to use UTF-8 for their >> character encoding:" >> and then it lists all of the database tables, and fails with an unable to >> connect to database error >> >> Encoding on the database and all of the tables are utf8mb3_general_ci >> >> This problem seems to have just cropped up and there have been no >> changes that I am aware of. >> >> Thoughts? >> -Matt >> >> >> *Matt Adair* >> Archivist for Digital Imaging and Infrastructure >> >> >> Bentley Historical Library >> 1150 Beal Avenue >> Ann Arbor, Michigan 48109-2113 >> 734-647-3537 >> http://bentley.umich.edu >> @UmichBentley >> >> *The Bentley Historical Library acknowledges that coerced cessions of >> land by the Anishnaabeg and Wyandot made the University of Michigan >> possible, and we seek to reaffirm the ancestral and contemporary ties of >> these peoples to the lands where the University now stands.* >> ___ >> Archivesspace_Users_Group mailing list >> Archivesspace_Users_Group@lyralists.lyrasis.org >> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group >> > > > -- > *Tom Hanstra* > *Sr. Systems Administrator* > hans...@nd.edu > > > ___ > Archivesspace_Users_Group mailing list > Archivesspace_Users_Group@lyralists.lyrasis.org > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group > ___ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
Re: [Archivesspace_Users_Group] ASpace database issues
Matthew Adair wrote on 2023-01-18 14:23:14: > Version 2.5.2 of ASpace. Version 8.0.30 of MySQL A couple of versions prior to yours MySQL started explicitly reporting 'utf8mb3' where in the past it would say 'utf8'. That's because 'utf8' is currently an alias for 'utf8mb3' and they want to deprecate 'utf8mb3' and make 'utf8' an alias of 'utf8mb4' instead. ASpace 2.5.2 only recognises 'utf8' as an UTF-8 character set, this was fixed in ASpace 2.7.1. I would consider upgrading to a more recent version if possible. > We get the following error in the log file: > "The following MySQL database tables are not set to use UTF-8 for their > character encoding:" > and then it lists all of the database tables, and fails with an unable to > connect to database error > > Encoding on the database and all of the tables are utf8mb3_general_ci Short of the ASpace upgrade (or a database downgrade that might be even more painful) the correct solution is to convert table data to 'utf8mb4', see https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html for details on how to do that. Hope that helps, p ___ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
Re: [Archivesspace_Users_Group] ASpace database issues
Is there any way that your version of MySQL got upgraded? I see this in the MySQL documentation: https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8.html which indicates that utf8mb3 is deprecated after Mysql 8.0.28. I don't have any experience to say that this is where the problem is. I was just looking around because I don't want to end up in a similar situation. Tom On Wed, Jan 18, 2023 at 2:23 PM Matthew Adair wrote: > Version 2.5.2 of ASpace. Version 8.0.30 of MySQL > > We get the following error in the log file: > "The following MySQL database tables are not set to use UTF-8 for their > character encoding:" > and then it lists all of the database tables, and fails with an unable to > connect to database error > > Encoding on the database and all of the tables are utf8mb3_general_ci > > This problem seems to have just cropped up and there have been no > changes that I am aware of. > > Thoughts? > -Matt > > > *Matt Adair* > Archivist for Digital Imaging and Infrastructure > > > Bentley Historical Library > 1150 Beal Avenue > Ann Arbor, Michigan 48109-2113 > 734-647-3537 > http://bentley.umich.edu > @UmichBentley > > *The Bentley Historical Library acknowledges that coerced cessions of land > by the Anishnaabeg and Wyandot made the University of Michigan possible, > and we seek to reaffirm the ancestral and contemporary ties of these > peoples to the lands where the University now stands.* > ___ > Archivesspace_Users_Group mailing list > Archivesspace_Users_Group@lyralists.lyrasis.org > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group > -- *Tom Hanstra* *Sr. Systems Administrator* hans...@nd.edu ___ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group