search

artefactual / atom-docs

Access to Memory (AtoM) documentation
https://www.accesstomemory.org/docs
Creative Commons Attribution Share Alike 4.0 International
17 stars 26 forks source link

Problem: MySQL authentication method may remain as `mysql_native_password` in upgrades from 2.6 #253

Open jraddaoui opened 7 months ago

jraddaoui commented 7 months ago

AtoM 2.6.x required to use the legacy authentication method in MySQL in order to work with PHP 7.2:

https://accesstomemory.org/en/docs/2.6/admin-manual/installation/linux/ubuntu-bionic/#mysql

This is no longer needed in 2.7 or 2.8 with PHP 7.4 but some users upgrading the system over the same MySQL instance may still have that configuration change. As noted by Jim Adamson in the following user forum thread, this makes the MySQL log grow with warnings about the deprecation of such method:

https://groups.google.com/g/ica-atom-users/c/VGcUg43yWrU/m/vIoWWFh0AgAJ

As Jim suggests in that thread, we could add a note to alter existing AtoM users in the MySQL server in the upgrading docs for 2.7 and 2.8:

https://accesstomemory.org/en/docs/2.7/admin-manual/installation/upgrading/#copy-your-old-data

ALTER USER 'username'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password';