Bug 432522 - digiKam 7.2.0-b2 on macOS 11 with remote mysql - failed to update DB schema
Summary: digiKam 7.2.0-b2 on macOS 11 with remote mysql - failed to update DB schema
Status: RESOLVED NOT A BUG
Alias: None
Product: digikam
Classification: Applications
Component: Database-Mysql (show other bugs)
Version: 7.2.0
Platform: macOS (DMG) macOS
: NOR crash
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-05 05:05 UTC by Dan Rabinowitz
Modified: 2021-02-05 15:57 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In: 7.2.0


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dan Rabinowitz 2021-02-05 05:05:35 UTC
SUMMARY
Hello, and thank you for such excellent software. I was running 7.1 on macOS 10.15 with mysql on a NAS and photos also stored on a NAS. I updated to macOS 11 last week, and found that digiKam wasn't supported. So I installed 7.2.0-b2.  When I try to run digikam 7.2.0-b2, I first see a window that says "Scanning collections, please wait... 0%" and then almost immediately an error message says "Failed to update the database schema from version 10 to version 11. Please read the error messages printed on the console and report this error as a bug at bugs.kde.org."

I'm not sure where to find the error messages. I found these messages in /var/log/system.log, but they don't seem relevant to a database migration.Feb  4 21:48:02 Dans-MBP-Green-5 com.apple.xpc.launchd[1]: Coalition Cache Hit: app<application.digikam.109283718.109323904(502)> [57556]
Feb  4 21:48:02 Dans-MBP-Green-5 digikam[44756]: getattrlist failed for /System/Library/Extensions/AppleIntelKBLGraphicsGLDriver.bundle/Contents/MacOS/AppleIntelKBLGraphicsGLDriver: #2: No such file or directory
Feb  4 21:48:02 Dans-MBP-Green-5 digikam[44756]: getattrlist failed for /Library/GPUBundles/AMDRadeonX6000GLDriver.bundle/Contents/MacOS/ATIRadeonX6000SCLib.dylib: #2: No such file or directory
Feb  4 21:48:02 Dans-MBP-Green-5 digikam[44756]: getattrlist failed for /System/Library/Extensions/AMDRadeonX6000GLDriver.bundle/Contents/MacOS/ATIRadeonX6000SCLib.dylib: #2: No such file or directory
Feb  4 21:48:02 Dans-MBP-Green-5 digikam[44756]: getattrlist failed for /System/Library/Frameworks/OpenGL.framework/Resources//GLRendererFloat.bundle/GLRendererFloat: #2: No such file or directory

I also downloaded the -debug version of digikam, but I don't know where to find the debug logs.

I tried running /Applications/digiKam.org/digikam.app/Contents/MacOS/applet but didn't see any output.

I did try running /Applications/digiKam.org/digikam.app/Contents/opt/digikam.app/Contents/MacOS/digikam which gave the following output:
$ /Applications/digiKam.org/digikam.app/Contents/opt/digikam.app/Contents/MacOS/digikam
QCommandLineParser: already having an option named "h"
QCommandLineParser: already having an option named "help-all"
QCommandLineParser: already having an option named "v"
digikam.coredb: Core database: cannot process schema initialization
QThreadStorage: Thread 0x7fac25563670 exited after QThreadStorage 8 destroyed

Any guidance would be appreciated.


STEPS TO REPRODUCE
1. Open the digikam binary
2. See the error message

OBSERVED RESULT
Error message

EXPECTED RESULT
No error message.

SOFTWARE/OS VERSIONS
macOS: macOS 11.1

ADDITIONAL INFORMATION
Comment 1 caulier.gilles 2021-02-05 05:56:34 UTC
Hi,

During the 7.2.0 developement macOS support have been well improved and continue . I recomment to switch to current releae condidate availiable here :


https://files.kde.org/digikam/

This is the weekly bundles repository. Macos PKG is compiled under BigSur 11.2 but still compatible with 10.13. It's now fully relocatable.

Gilles Caulier
Comment 2 caulier.gilles 2021-02-05 06:48:43 UTC
/var/log/system.log is not relevant of digiKam run-time. 

By console messages, we want mean the text traces printed on terminal, when you start digiKam from a text console.

Open Terminal from your Mac and run:

export QT_LOGGING_RULES="digikam*=true"
/Applications/digikam.org/digikam.app/Contents/MacOS/digikam

Gilles Caulier
Comment 3 Dan Rabinowitz 2021-02-05 15:46:35 UTC
Thank you. I fixed the problem. With your guidance on how to see the log output, I saw this:

Error messages: "QMYSQL: Unable to execute query" "You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)" "1419" 2

So I ran:
update user set Super_priv='Y' where User='digikam';
and that fixed it.

So, thank you.