Bug 474472

Summary:	MySQL doesn't support modern caching_sha2_password
Product:	[Applications] digikam	Reporter:	Lucas Jandrew <fapiko>
Component:	Bundle-Windows	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	REPORTED ---
Severity:	normal	CC:	caulier.gilles
Priority:	NOR
Version:	8.2.0
Target Milestone:	---
Platform:	Microsoft Windows
OS:	Microsoft Windows
Latest Commit:		Version Fixed In:
Sentry Crash Report:

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