[Pkg-kde-extras] Bug#1007220: digikam: Failed to update the database schema from version 10 to version 11 with mysql database

[Vincent Danjean]

Package: digikam
Version: 4:7.5.0-5
Severity: important

When using digikam with an external (mysql/mariadb) database, the upgrade
can fail leading to digikam refusing to start.
This is due to a permission problems.

It can be workarounded/fixed by issuing the following mysql command:
set global log_bin_trust_function_creators=1;
I'm not sure of all the security implication (it does not matter for
me: I'm alone on the machine).

At minimal, a notice in /usr/share/doc/digikam/NEWS.Debian.gz would
be appreciated (and/or a better/more precise error message from digikam).

Details of this can be found in
https://bugs.kde.org/show_bug.cgi?id=451460
and
https://bugs.kde.org/show_bug.cgi?id=435065

  Regards,
    Vincent


-- System Information:
Debian Release: bookworm/sid
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'oldstable-updates'), (500, 'unstable'), (500, 'testing'), (500, 'stable'), (500, 'oldstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386, armel, mipsel

Kernel: Linux 5.16.0-3-amd64 (SMP w/4 CPU threads; PREEMPT)
Kernel taint flags: TAINT_OOT_MODULE
Locale: LANG=fr_FR.utf8, LC_CTYPE=fr_FR.utf8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages digikam depends on:
ii  digikam-data          4:7.5.0-5
ii  digikam-private-libs  4:7.5.0-5
ii  libc6                 2.33-7
ii  libgcc-s1             12-20220222-1
ii  libkf5configcore5     5.90.0-1
ii  libkf5coreaddons5     5.90.0-1
ii  libkf5i18n5           5.90.0-1
ii  libmagick++-6.q16-8   8:6.9.11.60+dfsg-1.3+b2
ii  libqt5core5a          5.15.2+dfsg-15
ii  libqt5gui5            5.15.2+dfsg-15
ii  libqt5sql5            5.15.2+dfsg-15
ii  libqt5sql5-mysql      5.15.2+dfsg-15
ii  libqt5sql5-sqlite     5.15.2+dfsg-15
ii  libqt5widgets5        5.15.2+dfsg-15
ii  libstdc++6            12-20220222-1
ii  perl                  5.34.0-3

Versions of packages digikam recommends:
ii  chromium [www-browser]     98.0.4758.102-1+b1
ii  ffmpegthumbs               4:21.08.0-1
ii  firefox [www-browser]      96.0.3-1
ii  firefox-esr [www-browser]  91.6.0esr-1
ii  konqueror [www-browser]    4:21.08.2-1
ii  lynx [www-browser]         2.9.0dev.10-1
ii  w3m [www-browser]          0.5.3+git20210102-6

Versions of packages digikam suggests:
ii  breeze-icon-theme  4:5.90.0-1
pn  digikam-doc        <none>
ii  systemsettings     4:5.24.2-1

-- no debconf information