[Archivesspace_Users_Group] ASpace database issues

[Matthew Adair]

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 <hanstra at nd.edu> 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 <mladair at umich.edu> 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 at lyralists.lyrasis.org
>> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>>
>
>
> --
> *Tom Hanstra*
> *Sr. Systems Administrator*
> hanstra at nd.edu
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230119/b503d222/attachment.html>