[digiKam-users] internal SQL Server error after Update to 7.10.0

[Gilles Caulier]

Hi Benjamin,
The problem is due to a packaging bug from Macports used to compile
whole digiKam.

Typically, digiKam use the Qt Sql driver to handle a database (as
sqlite, mysql internal , and mysql server).

Since 2 digiKam release, the mysql server do not work anymore.
initially, the mariabd version 10.15 from Macports was used since a
version to deal with an internal or a remote mysql database. But this
have been broken somewhere, and i don't found exactly the problem, but
i suspect a qt bug.

I used an old mariadb 5.x version, and all work fine. The side effect
is that internal mariadb database created with 10.15 cannot be read
with the 5.x version. I don't found a script to go back from more
recent mariadb contents to an older one.

So the solution is :

1/ Go back to digiKam 7.9 and migrate your mariadb database to sqlite.
2/ Set the sqlite as your current database.
3/ Rename the ".mysql.digikam" folder with ".bak" in your collection.
This directory host the mariadb database file.
4/ Go back to digiKam 7.10 and do the inverse to convert to the new
mariadb format from sqlite.

See the long story from the bugzilla entry relevant of this problem :
https://bugs.kde.org/show_bug.cgi?id=46See t2736

Best

Gilles Caulier


Le lun. 13 mars 2023 à 15:28, Benjcmin v. Bohr <benjcmin at gmail.com> a écrit :
>
> Hi,
>
> after updating to 7.10.0 from 7.9.x via the internal update function on macOS.
> I get an error message
>
> Following error message:
> ---------------------------
> An error occurred during the internal server start.
>
> Details: Database process exited unexpectedly during initial connection.
>
> Executable:
> /Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld
>
> Arguments: --defaults-file=/Users/Username/Library/Application
> Support/digikam/digikam/mysql.conf,
> --datadir=/Users/Username/Pictures/.mysql.digikam/db_data,
> --basedir=/Applications/digiKam.org/digikam.app/Contents//lib/mariadb/,
> --socket=/Users/Username/Library/Application
> Support/digikam/digikam/db_misc/mysql.socket
>
> Process error: Unknown error
> -------------------------
>
> I found an old [Bug 436624] Error during internal server start with the exact same issue.
> As far as I understood that was a bug in the pkg, any advice?
>
> MfG Benjamin