SUMMARY Modern versions of MySQL starting with 8.0 default to using the `caching_sha2_password` plugin. On my Ubuntu install using the AppImage build, this is working fine. On Windows, digikam fails to start with an error that it can't find the `caching_sha2_password` plugin. Likely needs an updated QMySQL driver STEPS TO REPRODUCE 1. Install Digikam on Windows 2. Test settup up a connection to a MySQL 8 server using caching_sha2_password OBSERVED RESULT Error message received stating the caching_sha2_password module cannot be found EXPECTED RESULT It successfully connects SOFTWARE/OS VERSIONS Windows: 11 Qt Version: Unknown ADDITIONAL INFORMATION
This will require to recompile whole MXE environnement to build Windows installer. Note : the MSVC Windows bundle cannot used instead here, as MySQL support is not implemented in Qt With the Craft build system from KDE. Gilles Caulier
First attend to rebuild MXe from scratch with a more recent Qt5. There is a failure to DejaVuLibre : https://github.com/mxe/mxe/issues/3012 Gilles Caulier
@Lucas Jandrew, This problem still reproducible with the new digiKam 8.2.0 pre-release Windows installer available at usual place: https://files.kde.org/digikam/ This new bundle is based on last Qt framework 5.15.11 and KDE framework 5.110. Thanks in advance Dilles Caulier
@Lucas Jandrew, The digiKam 8.2.0 pre-release compiled under Windows 10 with VCPKG tool-chain is available here : https://files.kde.org/digikam/unstable/ The next build planed tonight will include the mysql support. Please test with this version. Thanks in advance Gilles Caulier
@Lucas Jandrew, The new digiKam 8.2.0 pre-release Windows installer is online. This one is built with VCPKG + MSVC toolchain and Qt6. It's a native version compiled under Windows 10. File is here: https://files.kde.org/digikam/ Please test and report to see if problem remain. Best regards Gilles Caulier
Git commit 15a9beb0da4d6dd57862101cf1126bc7a058350a by Maik Qualmann. Committed on 11/12/2023 at 21:15. Pushed by mqualmann into branch 'master'. disable SHA2 password for the internat MySQL server Related: bug 478375 M +1 -1 NEWS M +6 -1 core/data/database/mysql-global.conf https://invent.kde.org/graphics/digikam/-/commit/15a9beb0da4d6dd57862101cf1126bc7a058350a