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
showing again for digikam in macos (digiKam-8.5.0-Qt6-MacOS-arm64) when connecting to a MySQL 8.4.3 server ``` Database connection test was not successful. Error was: Plugin caching_sha2_password could not be loaded: dlopen(/opt/digikam.org.arm64/lib/mariadb-10.11/plugin/caching_sha2_password.so, 0x0002): tried: '/opt/digikam.org.arm64/lib/mariadb-10.11/plugin/caching_sha2_password.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/opt/digikam.org.arm64/lib/mariadb-10.11/plugin/caching_sha2_password.so' (no such file), '/opt/digikam.org.arm64/lib/mariadb-10.11/plugin/caching_sha2_password.so' (no such file) QMYSQL: Unable to connect ```
Sorry for any disturbance when I changed the metadata of this issue. I thought it was a search filter
(In reply to Maik Qualmann from comment #6) > 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 for the remote mqSQL server usage, how shall we force to use mysql_native_password without change the remote server?
*** Bug 501453 has been marked as a duplicate of this bug. ***
Hi, The 8.7.0 pre-release Windows installer from today have been rebuilt from scratch with Qt 6.8.3, KDE 6.12, OpenCV 4.11 + CUDA support, Exiv2 0.28.5, ExifTool 13.27, ffmpeg 7, all image codecs updated to last version (jxl, avif, heif, aom, etc.). Please try with this version to see if your problem still reproducible... https://files.kde.org/digikam/ Thanks in advance Best regards Gilles Caulier