Bug 474472 - MySQL doesn't support modern caching_sha2_password
Summary: MySQL doesn't support modern caching_sha2_password
Status: REPORTED
Alias: None
Product: digikam
Classification: Applications
Component: Bundle-Windows (show other bugs)
Version: 8.2.0
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-13 05:38 UTC by Lucas Jandrew
Modified: 2023-12-11 20:17 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Lucas Jandrew 2023-09-13 05:38:52 UTC
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
Comment 1 caulier.gilles 2023-09-13 05:54:09 UTC
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
Comment 2 caulier.gilles 2023-09-16 10:39:58 UTC
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
Comment 3 caulier.gilles 2023-10-15 03:04:20 UTC
@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
Comment 4 caulier.gilles 2023-11-12 18:09:31 UTC
@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
Comment 5 caulier.gilles 2023-11-21 15:38:24 UTC
@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
Comment 6 Maik Qualmann 2023-12-11 20:17:33 UTC
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