The mysql docker container ebusa-mysql is not working properly anymore when building a new container with the latest mysql docker image (29.04.2018).
Error: java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'.
Investigate on this error
Check how to fix
First investigation shows, that the db users are using an old password encryption style and new mysql docker images changed to another encryption version.
DB_setup.sql might need adaptation.
NOTE: The running version is 5.7.21. Change the first line in the file /EBUSA-AIM17/Setup/mysql_docker/Dockerfile from FROM mysql:latest to FROM mysql:5.7.21.
This should only be a temporary fix.
It should be fixed in another way if possible to allow users to always use the latest docker mysql version. PLEASE INVESTIGATE
Further references regarding this issue can be found here
The mysql docker container
ebusa-mysqlis not working properly anymore when building a new container with the latest mysql docker image (29.04.2018). Error:java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'.DB_setup.sqlmight need adaptation.5.7.21. Change the first line in the file/EBUSA-AIM17/Setup/mysql_docker/DockerfilefromFROM mysql:latesttoFROM mysql:5.7.21.mysqlversion. PLEASE INVESTIGATEFurther references regarding this issue can be found here