SUMMARY Cannot update database if I use the digikam mysql executables. If I use the brew mysql executables, I cannot create new tags because of an "unexpected error". STEPS TO REPRODUCE 1. open digikam after upgrade 2. digikam mysql executables not working. OBSERVED RESULT this is the error shown (in Catalan): No s'ha pogut actualitzar la base de dades.<p>Executable: /Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysql_upgrade</p><p>Arguments: --socket=/Users/robert/Library/Application Support/digikam/digikam/db_misc/mysql.socket</p><p>Error del procés: Error desconegut</p EXPECTED RESULT SOFTWARE/OS VERSIONS macOS: 14.1 ADDITIONAL INFORMATION I updated digikam to the latest versions. I had set the internal mysql server in my previous version. Now, it keeps saying that the internal server cannot be started. I'm using mysql installed by brew, not the one that comes with the macosx system. If I set the mysql executables to the ones that come with brew (except mysql_install_db, which is missing in brew), digikam opens with my previous database, __but cannot add any tag__. If I use the executables that come with digikam, it complains that it cannot start the internal server. Besides, any time I open the internal mysql server configuration window, even if I had already selected the brew executables before, I have to look for them again, as digikam doesn't remember my previous setting.
If mysql_install_db is missing, you are probably using Oracle MySQL. You cannot mix MariaDB (shipped with digiKam) with Oracle MySQL. The database is probably defective now. We only support MariaDB for the internal server. Oracle MySQL can also be used for an external server. You have to start with a new database. Maik
Understood. However, trying to config an external mysql server gives me this error: L'error és: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/opt/digikam.org.x86_64/lib/mariadb/plugin/caching_sha2_password.so, 0x0002): tried: '/opt/digikam.org.x86_64/lib/mariadb/plugin/caching_sha2_password.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/opt/digikam.org.x86_64/lib/mariadb/plugin/caching_sha2_password.so' (no such file), '/opt/digikam.org.x86_64/lib/mariadb/plugin/caching_sha2_password.so' (no such file) QMYSQL: No s'ha pogut connectar
This is related to this Bug 474472. We have to deactivate the SHA2 password for the internal server. Maik
Git commit 263e4c2bcd2a7da41c8a7ae31d2b02d5fd0be025 by Maik Qualmann. Committed on 11/12/2023 at 20:57. Pushed by mqualmann into branch 'master'. for internal MySQL only MariaDB supported M +4 -37 core/libs/database/engine/dbengineparameters.cpp https://invent.kde.org/graphics/digikam/-/commit/263e4c2bcd2a7da41c8a7ae31d2b02d5fd0be025
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 474472 M +1 -1 NEWS M +6 -1 core/data/database/mysql-global.conf https://invent.kde.org/graphics/digikam/-/commit/15a9beb0da4d6dd57862101cf1126bc7a058350a