[digiKam-users] DB migration error: "Error while creating the database schema."

[Maik Qualmann]

First of all, digiKam-7.1.0 is too old for MacOS. Use the current release 
candidate digiKam-7.2.0-RC from here: 

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

Then we need the debug output from the terminal as described here, don't 
forget to set the debug environment variable: 

https://www.digikam.org/contribute/

Maik

Am Montag, 8. Februar 2021, 06:10:20 CET schrieb Tomer Altman:
> To the digikam community:
> 
> I hope that this finds you well. I am a new digikam user and have been
> very happy using it to merge several large sets of photos & videos into
> a single collection. Until now I have used the SQLite DB back-end, but
> my intention has been to move on to using the external MySQL server DB
> back-end to allow me to edit the collection from multiple machines.
> 
> I am using Digikam v.7.1.0
> (commits.kde.org/digikam/d52927ebc98ee24c9fc3a3a34f527d4d21b09fb3) on
> Mac OS X v10.13.6. I have been using the following documentation to
> guide me:
> 
> https://docs.kde.org/trunk5/en/extragear-graphics/digikam/using-setup.html
> 
> I installed MySQL v8.0, and executed the following SQL commands to set
> up the database (see below). Note that I had to go beyond the
> documentation and add the "WITH mysql_native_password" clause in order
> for MySQL to use a password plugin that is supported by Digikam (at
> least the Mac version).
> 
> When using the DB migration tool, I am able to connect to the MySQL
> server, but when I try to initiate the migration, I get a pop up window
> saying "Error while creating the database schema".
> 
> I'm not sure what the error is. I do see on the server side that the
> digikam_core database does get populated with tables. The digikam
> database does not.
> 
> I have some DBA experience, so I'm sure that I could work past any
> mis-configuration issues on the MySQL side, if only I could see a more
> detailed error message. Any suggestions on how to get past this
> uninformative error message would be greatly appreciated. Thanks!
> 
> Cheers,
> 
> ~Tomer
> 
> ---
> 
> CREATE USER 'digikam'@'%' IDENTIFIED WITH mysql_native_password BY
> <password>;
> 
> GRANT ALL ON *.* to 'digikam'@'%';
> 
> CREATE DATABASE digikam;
> 
> GRANT ALL PRIVILEGES ON digikam.* TO 'digikam'@'%';
> 
> CREATE DATABASE digikam_core;
> 
> GRANT ALL PRIVILEGES ON digikam_core.* TO 'digikam'@'%';
> 
> FLUSH PRIVILEGES;