Bug 462736 - Connection to external Mysql-Server fails
Summary: Connection to external Mysql-Server fails
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Mysql (show other bugs)
Version: 7.9.0
Platform: macOS (DMG) macOS
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-12-07 08:52 UTC by spitz_hypothesen_0p
Modified: 2023-03-28 13:05 UTC (History)
7 users (show)

See Also:
Latest Commit:
Version Fixed In: 7.10.0
Sentry Crash Report:


Attachments
Screenshot of error message digikam 7.9 on mac - cannot connect to mysql external (110.72 KB, image/png)
2022-12-15 01:37 UTC, MM
Details
macOS digikam 7.8.0 find . -name *maria* & find . -name *mysql* raw output (10.54 KB, text/plain)
2023-01-26 20:59 UTC, Alex
Details

Note You need to log in before you can comment on or make changes to this bug.
Description spitz_hypothesen_0p 2022-12-07 08:52:12 UTC
SUMMARY
***
NOTE: If you are reporting a crash, please try to attach a backtrace with debug symbols.
See https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports
***


STEPS TO REPRODUCE
1. Try to connect to external MYSQL Server.
2. 
3. 

OBSERVED RESULT

No connection is established.

EXPECTED RESULT


SOFTWARE/OS VERSIONS
Windows: 
macOS: 13.0.1
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION
Comment 1 Maik Qualmann 2022-12-07 09:09:05 UTC
Without any information we cannot help. Please post a log from a terminal when trying to connect to the database, described here for macOS:

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

Maik
Comment 2 spitz_hypothesen_0p 2022-12-07 09:29:38 UTC
Here is the log

export QT_LOGGING_RULES="digikam*=true"
    /Applications/digiKam.org/digikam.app/Contents/MacOS/digikam
digikam.widgets: Breeze icons resource file found
digikam.widgets: Breeze-dark icons resource file found
digikam.general: Qt standard translations removed: 0
digikam.general: Qt standard translations path: "/Applications/digiKam.org/digikam.app/Contents/Resources/translations"
digikam.general: Loaded Qt standard translations "de_CH" from catalog "qt"
digikam.general: Loaded Qt standard translations "de_CH" from catalog "qtbase"
digikam.general: Loaded Qt standard translations "de_CH" from catalog "qt_help"
digikam.general: Loaded Qt standard translations "de_CH" from catalog "qtdeclarative"
digikam.general: Loaded Qt standard translations "de_CH" from catalog "qtquickcontrols"
digikam.general: Loaded Qt standard translations "de_CH" from catalog "qtquickcontrols2"
digikam.general: Loaded Qt standard translations "de_CH" from catalog "qtmultimedia"
digikam.general: Loaded Qt standard translations "de_CH" from catalog "qtwebengine"
digikam.general: Loaded Qt standard translations "de_CH" from catalog "qtxmlpatterns"
digikam.general: Loaded Qt ECM translations "en" from catalog "kcoreaddons5_qt"
digikam.general: Loaded Qt ECM translations "en" from catalog "kwidgetsaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kauth5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kbookmarks5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kcodecs5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kcompletion5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kconfig5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kcoreaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kdbusaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kde5_xml_mimetypes"
digikam.general: Loaded Qt ECM translations "de" from catalog "kglobalaccel5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kitemviews5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kwidgetsaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kwindowsystem5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "solid5_qt"
digikam.general: Switch to widget style:  "Fusion"
digikam.general: AlbumWatch is disabled
digikam.general: Database Parameters:
   Type:                      "QMYSQL"
   DB Core Name:              "fussverkehr_digikam"
   DB Thumbs Name:            "fussverkehr_digikam"
   DB Face Name:              "fussverkehr_digikam"
   DB Similarity Name:        "fussverkehr_digikam"
   Connect Options:           ""
   Host Name:                 "domainname.ch"
   Host port:                 3306
   Internal Server:           false
   Internal Server Path:      ""
   Internal Server Admin Cmd: ""
   Internal Server Serv Cmd:  ""
   Internal Server Init Cmd:  ""
   Username:                  "digikam4"
   Password:                  "XXXXXXXX"

digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on 'domainname.ch' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on 'domainname.ch' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on 'domainname.ch' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on 'domainname.ch' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on 'domainname.ch' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on 'domainname.ch' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on 'domainname.ch' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on 'domainname.ch' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on 'domainname.ch' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on 'domainname.ch' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on 'domainname.ch' (60)") ]
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Testing  "mysqladmin" ...
digikam.general: Testing  "mysqld" ...
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Testing  "mysqladmin" ...
digikam.general: Testing  "mysqld" ...
digikam.general: Testing  "/opt/local/bin/mysql_install_db" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/bin/mysqladmin" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/bin/mysqld" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/sbin/mysql_install_db" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/sbin/mysqladmin" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/sbin/mysqld" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/lib/mariadb/bin/mysql_install_db" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/lib/mariadb/bin/mysqladmin" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/lib/mariadb/bin/mysqld" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysql_install_db" ...
digikam.general: Found  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysql_install_db"
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqladmin" ...
digikam.general: Found  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqladmin"
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld" ...
digikam.general: Found  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld"
digikam.general: All Binaries Found :  true
Comment 3 Maik Qualmann 2022-12-07 09:36:02 UTC
The server address "domainname.ch" appears to be invalid/incorrect/not available.
The host address cannot be resolved on your network. Is this a local address? Otherwise try to use the IP address.

digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on 'domainname.ch' (60)") ]

Maik
Comment 4 spitz_hypothesen_0p 2022-12-07 09:47:40 UTC
It's not a local domain, and it works perfect with 7.8.0.
Comment 5 Maik Qualmann 2022-12-07 09:49:28 UTC
I can't ping the address...

Maik
Comment 6 spitz_hypothesen_0p 2022-12-07 09:52:43 UTC
I have tried to connect with the IP-Address and it remains the same issue.
Comment 7 Maik Qualmann 2022-12-07 09:53:59 UTC
The address seems to be dead at the moment, there is no answer...

Maik
Comment 8 Maik Qualmann 2022-12-07 09:59:55 UTC
I knew you changed the domain name. ((:-))

Maik
Comment 9 Maik Qualmann 2022-12-07 10:04:26 UTC
The correct address can of course be reached via ping, that's all I can test at the moment. Gilles, also using macOS, would need to see if it can reproduce an issue with external MySQL.

Maik
Comment 10 Maik Qualmann 2022-12-07 10:12:29 UTC
Just as an idea, you might need to re-assign digiKam the appropriate rights in the macOS security settings?

Maik
Comment 11 spitz_hypothesen_0p 2022-12-07 10:35:27 UTC
I just checked it on my windows machine. There everything works great. I have gone through the securysettings and gave digikam permission to everything. it still don't works.
Comment 12 bnlsg 2022-12-09 12:15:25 UTC
Same here.

7.8.0 is fine, 7.9.0 with the same digikamrc doesn't connect to external MySQL server.

After downgrade to 7.8.0 it works again as expected.

macOS 13.0.1
Comment 13 Maik Qualmann 2022-12-09 12:24:23 UTC
There were no changes in MySQL support between digiKam-7.8.0 and 7.9.0. Everything works on Linux and Windows. The problem will be due to external components when creating the macOS package.

Maik
Comment 14 caulier.gilles 2022-12-09 12:25:44 UTC
Hum nothing has changed in macports install between 7.8.0 to 7.9.0. Same computer, same compiler, same MacOS hosts.

Gilles
Comment 15 Andi 2022-12-09 23:22:32 UTC
can confirm - using MacOS 11.6 : 7.9.0 fails, 7.8.0 works.
% export QT_LOGGING_RULES="digikam*=true"

 % /Applications/digiKam.org/digikam.app/Contents/MacOS/digikam
digikam.widgets: Breeze icons resource file found
digikam.widgets: Breeze-dark icons resource file found
digikam.general: Qt standard translations removed: 0
digikam.general: Qt standard translations path: "/Applications/digiKam.org/digikam.app/Contents/Resources/translations"
digikam.general: Loaded Qt standard translations "de_AT" from catalog "qt"
digikam.general: Loaded Qt standard translations "de_AT" from catalog "qtbase"
digikam.general: Loaded Qt standard translations "de_AT" from catalog "qt_help"
digikam.general: Loaded Qt standard translations "de_AT" from catalog "qtdeclarative"
digikam.general: Loaded Qt standard translations "de_AT" from catalog "qtquickcontrols"
digikam.general: Loaded Qt standard translations "de_AT" from catalog "qtquickcontrols2"
digikam.general: Loaded Qt standard translations "de_AT" from catalog "qtmultimedia"
digikam.general: Loaded Qt standard translations "de_AT" from catalog "qtwebengine"
digikam.general: Loaded Qt standard translations "de_AT" from catalog "qtxmlpatterns"
digikam.general: Loaded Qt ECM translations "en" from catalog "kcoreaddons5_qt"
digikam.general: Loaded Qt ECM translations "en" from catalog "kwidgetsaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kauth5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kbookmarks5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kcodecs5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kcompletion5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kconfig5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kcoreaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kdbusaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kde5_xml_mimetypes"
digikam.general: Loaded Qt ECM translations "de" from catalog "kglobalaccel5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kitemviews5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kwidgetsaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kwindowsystem5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "solid5_qt"
digikam.general: Switch to widget style:  "Fusion"
digikam.general: Switch to application font:  QFont(.AppleSystemUIFont,10,-1,5,50,0,0,0,0,0)
digikam.general: AlbumWatch is disabled
digikam.general: Database Parameters:
   Type:                      "QMYSQL"
   DB Core Name:              "digikam"
   DB Thumbs Name:            "digikam"
   DB Face Name:              "digikam"
   DB Similarity Name:        "digikam"
   Connect Options:           ""
   Host Name:                 "127.0.0.1"
   Host port:                 3306
   Internal Server:           false
   Internal Server Path:      ""
   Internal Server Admin Cmd: ""
   Internal Server Serv Cmd:  ""
   Internal Server Init Cmd:  ""
   Username:                  "digikam"
   Password:                  "XXXXXXXXX"

"Can't connect to MySQL server on '127.0.0.1' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '127.0.0.1' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '127.0.0.1' (60)") ]
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqladmin" ...
digikam.general: Found  "mysqladmin"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.database: Testing DB connection ( "ConnectionTest" ) with these settings:
digikam.database: Database Parameters:
   Type:                      "QMYSQL"
   DB Core Name:              "digikam"
   DB Thumbs Name:            "digikam"
   DB Face Name:              "digikam"
   DB Similarity Name:        "digikam"
   Connect Options:           ""
   Host Name:                 "127.0.0.1"
   Host port:                 3306
   Internal Server:           false
   Internal Server Path:      ""
   Internal Server Admin Cmd: ""
   Internal Server Serv Cmd:  ""
   Internal Server Init Cmd:  ""
   Username:                  "digikam"
   Password:                  "XXXXXXXXX"

maliciously ;-)) did a
diff -ur *
Binary files 7.8.0/.DS_Store and 7.9.0/.DS_Store differ
diff -ur 7.8.0/database/dbconfig.xml 7.9.0/database/dbconfig.xml
--- 7.8.0/database/dbconfig.xml	2022-08-29 17:23:33.000000000 +0200
+++ 7.9.0/database/dbconfig.xml	2022-12-03 14:30:27.000000000 +0100
@@ -1884,7 +1884,7 @@
 
             <!-- Note Albums with an icon set are setup after population of the Images table. -->
             <dbaction name="Migrate_Read_Albums"><statement mode="query">
-                SELECT id, albumRoot, relativePath, date, caption, collection, modificationDate FROM Albums
+                SELECT id, albumRoot, relativePath COLLATE utf8_general_ci, date, caption, collection, modificationDate FROM Albums
                 WHERE  albumRoot IN (SELECT id FROM AlbumRoots);
             </statement></dbaction>
             <dbaction name="Migrate_Write_Albums" mode="transaction"><statement mode="query">
@@ -1900,7 +1900,7 @@
             </statement></dbaction>
 
             <dbaction name="Migrate_Read_Images"><statement mode="query">
-                SELECT id, album, name, status, category, modificationDate, fileSize, uniqueHash, manualOrder FROM Images
+                SELECT id, album, name COLLATE utf8_general_ci, status, category, modificationDate, fileSize, uniqueHash, manualOrder FROM Images
                 WHERE  album IN (SELECT id FROM Albums);
             </statement></dbaction>
             <dbaction name="Migrate_Write_Images" mode="transaction"><statement mode="query">
Comment 16 Maik Qualmann 2022-12-10 07:40:37 UTC
The changes in the dbconfig.xml are not relevant to this problem.
These SQL commands are only executed during database migration.

Maik
Comment 17 Andi 2022-12-10 18:43:07 UTC
(In reply to Maik Qualmann from comment #16)
> The changes in the dbconfig.xml are not relevant to this problem.
> These SQL commands are only executed during database migration.
> 
> Maik

I thought so - what else could be done to help?
... any version changes of qt  ( before digging deeper ) ?
... before perhaps testing with el capitan or catalina ( both meanwhile out of support ) ...
Comment 18 MM 2022-12-15 01:37:59 UTC
Created attachment 154595 [details]
Screenshot of error message digikam 7.9 on mac - cannot connect to mysql external
Comment 19 MM 2022-12-15 01:42:46 UTC
Hi all, I can confirm this bug. 
I am running digikam 7.9 on Mac M1 under MacOS 13.0.1. Mysql database is on a Synology NAS on the local network Screenshot of error message from failed connection attached.
Digikam 7.8 on the same machine can connect to the database. Digikam 7.9 on Fedora in a VM on Parallels on the same machine can also connect to the database. I can also connect using earlier versions of digikam under Ubuntu on a separate machine.
I attached a screenshot to the bug report.
Comment 20 Maik Qualmann 2022-12-16 12:51:16 UTC
Gilles, do I understand correctly that we use a different Qt version in digiKam-7.9.0 than in digiKam-7.8.0 due to problems compiling QtWebEngine on macOS?  And Monterey is now the minimum version?

https://invent.kde.org/graphics/digikam/-/commit/358e1739bce36630b7f5c82d1ace76a8d29efecc

Maik
Comment 21 caulier.gilles 2022-12-16 13:16:25 UTC
Hi Maik,

Not at all. Look the minimal MacOS version supported, It's 10.13 as High Sierra:

https://invent.kde.org/graphics/digikam/-/blob/master/project/bundles/macports/config.sh#L48

For Qt6, yes, it will be different and Monterrey will be the minimal version, but not with Qt5.

Don't forget that digiKam is compiled on Intel Macbook pro and Rosetta 2 emulator is used at run time by MacOS with M1 CPU to translate in live x86_64 binary instructions to Arm. Perhaps the problem is here... and the ultimate solution is to compile an Universal PKG including x86_64 and Arm binary version. This cannot be done with an Intel CPU as XCode do not support cross compiling to Arm. An Silicon CPU computer must be used in this case. I plan to do it after the Documentation port from DocBook to Sphinx/reST format, so later january 2023.

Gilles
Comment 22 Maik Qualmann 2023-01-06 21:00:10 UTC
*** Bug 463941 has been marked as a duplicate of this bug. ***
Comment 23 Alex 2023-01-25 10:19:30 UTC
Same issue.
Intel mac with Ventura 13.1.
Went from 7.3.0 (with working MySQL-connection) to 7.9.0.
Result: 7.9.0 won't connect to MariaDB10 on server.

Message:
Database connection test was not successful. 
Error was: Can't connect to MySQL server on '192.168.178.66' (60) QMYSQL: Es kann keine Verbindung aufgebaut werden

Tried out 8.0.0 beta1 – same issue.

Went back to 7.8.0 – Connection to database works.
Comment 24 Maik Qualmann 2023-01-25 10:27:14 UTC
Please set the debug environment variable and start the AppImage in the terminal and post the output from the start.

export QT_LOGGING_RULES="digikam*=true"

Maik
Comment 25 caulier.gilles 2023-01-25 10:28:28 UTC
What's about the 7.10.0 PKG that i rebuild from scratch few days ago ?

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

Gilles Caulier
Comment 26 Maik Qualmann 2023-01-25 10:29:11 UTC
Sorry wrong comment 24 post to bug number.

Maik
Comment 27 Alex 2023-01-25 10:34:40 UTC
Hi all,
sorry for being rude.

The logs from 7.9.0:

digikam.widgets: Breeze icons resource file found
digikam.widgets: Breeze-dark icons resource file found
digikam.general: Qt standard translations removed: 0
digikam.general: Qt standard translations path: "/Applications/digiKam.org/digikam.app/Contents/Resources/translations"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qt"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qtbase"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qt_help"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qtdeclarative"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qtquickcontrols"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qtmultimedia"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qtwebengine"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qtxmlpatterns"
digikam.general: Loaded Qt ECM translations "en" from catalog "kcoreaddons5_qt"
digikam.general: Loaded Qt ECM translations "en" from catalog "kwidgetsaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kauth5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kbookmarks5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kcodecs5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kcompletion5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kconfig5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kcoreaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kdbusaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kde5_xml_mimetypes"
digikam.general: Loaded Qt ECM translations "de" from catalog "kglobalaccel5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kitemviews5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kwidgetsaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kwindowsystem5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "solid5_qt"
digikam.general: Switch to widget style:  "Fusion"
digikam.general: AlbumWatch is disabled
digikam.general: Database Parameters:
   Type:                      "QMYSQL"
   DB Core Name:              "digikam"
   DB Thumbs Name:            "digikam"
   DB Face Name:              "digikam"
   DB Similarity Name:        "digikam"
   Connect Options:           ""
   Host Name:                 "192.168.178.66"
   Host port:                 3306
   Internal Server:           false
   Internal Server Path:      ""
   Internal Server Admin Cmd: ""
   Internal Server Serv Cmd:  ""
   Internal Server Init Cmd:  ""
   Username:                  "digikam"
   Password:                  "XXXXXXXXXXXX"

digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Testing  "mysqladmin" ...
digikam.general: Testing  "mysqld" ...
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Testing  "mysqladmin" ...
digikam.general: Testing  "mysqld" ...
digikam.general: Testing  "/opt/local/bin/mysql_install_db" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/bin/mysqladmin" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/bin/mysqld" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/sbin/mysql_install_db" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/sbin/mysqladmin" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/sbin/mysqld" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/lib/mariadb/bin/mysql_install_db" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/lib/mariadb/bin/mysqladmin" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/lib/mariadb/bin/mysqld" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysql_install_db" ...
digikam.general: Found  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysql_install_db"
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqladmin" ...
digikam.general: Found  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqladmin"
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld" ...
digikam.general: Found  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld"
digikam.general: All Binaries Found :  true
digikam.database: Testing DB connection ( "ConnectionTest" ) with these settings:
digikam.database: Database Parameters:
   Type:                      "QMYSQL"
   DB Core Name:              "digikam"
   DB Thumbs Name:            "digikam"
   DB Face Name:              "digikam"
   DB Similarity Name:        "digikam"
   Connect Options:           ""
   Host Name:                 "192.168.178.66"
   Host port:                 3306
   Internal Server:           false
   Internal Server Path:      ""
   Internal Server Admin Cmd: ""
   Internal Server Serv Cmd:  ""
   Internal Server Init Cmd:  ""
   Username:                  "digikam"
   Password:                  "XXXXXXXXXXXX"




Alex
Comment 28 Alex 2023-01-25 10:39:11 UTC
Issue persists in 7.10.0

log

digikam.widgets: Breeze icons resource file found
digikam.widgets: Breeze-dark icons resource file found
digikam.general: Qt standard translations removed: 0
digikam.general: Qt standard translations path: "/Applications/digiKam.org/digikam.app/Contents/Resources/translations"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qt"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qtbase"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qt_help"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qtdeclarative"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qtquickcontrols"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qtmultimedia"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qtwebengine"
digikam.general: Loaded Qt standard translations "de_DE" from catalog "qtxmlpatterns"
digikam.general: Loaded Qt ECM translations "en" from catalog "kwidgetsaddons5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kbookmarks5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kcompletion5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kglobalaccel5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kitemviews5_qt"
digikam.general: Loaded Qt ECM translations "de" from catalog "kwidgetsaddons5_qt"
digikam.general: Switch to widget style:  "Fusion"
digikam.general: AlbumWatch is disabled
digikam.general: Database Parameters:
   Type:                      "QMYSQL"
   DB Core Name:              "digikam"
   DB Thumbs Name:            "digikam"
   DB Face Name:              "digikam"
   DB Similarity Name:        "digikam"
   Connect Options:           ""
   Host Name:                 "192.168.178.66"
   Host port:                 3306
   Internal Server:           false
   Internal Server Path:      ""
   Internal Server Admin Cmd: ""
   Internal Server Serv Cmd:  ""
   Internal Server Init Cmd:  ""
   Username:                  "digikam"
   Password:                  "XXXXXXXXXXXX"

digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.dbengine: Error while opening the database. Error details [ QSqlError("2002", "QMYSQL: Es kann keine Verbindung aufgebaut werden", "Can't connect to MySQL server on '192.168.178.66' (60)") ]
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Testing  "mysqladmin" ...
digikam.general: Testing  "mysqld" ...
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Testing  "mysqladmin" ...
digikam.general: Testing  "mysqld" ...
digikam.general: Testing  "/opt/local/bin/mysql_install_db" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/bin/mysqladmin" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/bin/mysqld" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/sbin/mysql_install_db" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/sbin/mysqladmin" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/sbin/mysqld" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/lib/mariadb/bin/mysql_install_db" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/lib/mariadb/bin/mysqladmin" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/opt/local/lib/mariadb/bin/mysqld" ...
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysql_install_db" ...
digikam.general: Found  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysql_install_db"
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqladmin" ...
digikam.general: Found  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqladmin"
digikam.general: All Binaries Found :  false
digikam.general: Testing  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld" ...
digikam.general: Found  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld"
digikam.general: All Binaries Found :  true
qt.qpa.fonts: Populating font family aliases took 205 ms. Replace uses of missing font family ".AppleSystemUIFont" with one that exists to avoid this cost. 
digikam.database: Testing DB connection ( "ConnectionTest" ) with these settings:
digikam.database: Database Parameters:
   Type:                      "QMYSQL"
   DB Core Name:              "digikam"
   DB Thumbs Name:            "digikam"
   DB Face Name:              "digikam"
   DB Similarity Name:        "digikam"
   Connect Options:           ""
   Host Name:                 "192.168.178.66"
   Host port:                 3306
   Internal Server:           false
   Internal Server Path:      ""
   Internal Server Admin Cmd: ""
   Internal Server Serv Cmd:  ""
   Internal Server Init Cmd:  ""
   Username:                  "digikam"
   Password:                  "XXXXXXXXXXXX"

digikam.general: Database Parameters:
   Type:                      "QMYSQL"
   DB Core Name:              "digikam"
   DB Thumbs Name:            "digikam"
   DB Face Name:              "digikam"
   DB Similarity Name:        "digikam"
   Connect Options:           ""
   Host Name:                 "192.168.178.66"
   Host port:                 3306
   Internal Server:           false
   Internal Server Path:      ""
   Internal Server Admin Cmd: ""
   Internal Server Serv Cmd:  ""
   Internal Server Init Cmd:  ""
   Username:                  "digikam"
   Password:                  "XXXXXXXXXXXX"
Comment 29 caulier.gilles 2023-01-25 10:42:20 UTC
Of course 192.168.178.66 is visible from your client computer ?

What's give nmap with 192.168.178.66 ? Port 3306 is open and listening ?

Just to be sure, as we already discovered some dysfunctions with the digiKam configuration file, can you try this:

1/ create a new test account on your computer.
2/ Start digiKam and configure the database
3/ try to connect

Gilles Caulier
Comment 30 Alex 2023-01-25 11:08:08 UTC
(In reply to caulier.gilles from comment #29)

Hi Gilles,

> Of course 192.168.178.66 is visible from your client computer ?
It's visible. I can ping the address and it also works in 7.8.0

> 
> What's give nmap with 192.168.178.66 ? Port 3306 is open and listening ?
Starting Nmap 7.93 ( https://nmap.org ) at 2023-01-25 12:05 CET
Nmap scan report for … (192.168.178.66)
Host is up (0.0034s latency).
Not shown: 88 closed tcp ports (reset)
PORT     STATE SERVICE
…
3306/tcp open  mysql
–
MAC Address: … (Synology Incorporated)
Nmap done: 1 IP address (1 host up) scanned in 0.28 seconds

> 
> Just to be sure, as we already discovered some dysfunctions with the digiKam
> configuration file, can you try this:
> 
> 1/ create a new test account on your computer.
> 2/ Start digiKam and configure the database
> 3/ try to connect
I will try this in the evening.

> 
> Gilles Caulier
Comment 31 Alex 2023-01-25 11:38:07 UTC
(In reply to Alex from comment #30)

> > Just to be sure, as we already discovered some dysfunctions with the digiKam
> > configuration file, can you try this:
> > 
> > 1/ create a new test account on your computer.
> > 2/ Start digiKam and configure the database
> > 3/ try to connect
> I will try this in the evening.
> 
> > 
> > Gilles Caulier

I got ten more minutes :)

Tried it with a new user.
Starting with 7.9.0 I got exactly the same results.
No connection possible.
Then I went back to 7.8.0 – connection is working perfectly.

Alex
Comment 32 caulier.gilles 2023-01-25 12:36:34 UTC
Hum sound like the macports compilation of Mysqlclient used by Qt5 is not fine.

I don't change something about between 7.9.0 and later releases. But in compilation rules i put :

https://invent.kde.org/graphics/digikam/-/blob/master/project/bundles/macports/01-build-macports.sh#L305

The mariadb10_5 variant is an older rules due to Qt5 incompatibility with recent version of mariadb and mysql. This problem is now reselved with recent Qt version available in macports. I will try to recompile all from scratch (again) without this variant.

Gilles Caulier
Comment 33 Alex 2023-01-25 16:59:54 UTC
(In reply to caulier.gilles from comment #32)
> The mariadb10_5 variant is an older rules due to Qt5 incompatibility with
> recent version of mariadb and mysql. This problem is now reselved with
> recent Qt version available in macports. I will try to recompile all from
> scratch (again) without this variant.
> 
> Gilles Caulier

Thank you Gilles for your answer.
If I can do anything else, please let me know.

Alex
Comment 34 caulier.gilles 2023-01-25 17:40:19 UTC
Well, to build all digiKam from scratch will take around 6/8 hours on my old macbook pro 2015 Intel....

I will do probably tomorrow morning. If all is fine, the PKG will be available online Friday or Saturday. I will ping you when it will be ready to test...

Gilles
Comment 35 caulier.gilles 2023-01-26 09:53:42 UTC
One question : which mysql or mariadb version did you use on your remote computer ?
Comment 36 spitz_hypothesen_0p 2023-01-26 11:19:00 UTC
(In reply to caulier.gilles from comment #25)
> What's about the 7.10.0 PKG that i rebuild from scratch few days ago ?
> 
> https://files.kde.org/digikam/
> 
> Gilles Caulier

Hi Gilles,

7.10 didn't solve the problem on my machines.
Comment 37 Alex 2023-01-26 11:27:29 UTC
(In reply to caulier.gilles from comment #35)
> One question : which mysql or mariadb version did you use on your remote
> computer ?

It is mariadb 10.3.32-1040
Comment 38 caulier.gilles 2023-01-26 13:21:59 UTC
Alex,

Your version sound fine.

I tried to recompile with Macports the qt5-mysql-plugin package with the last mariadb dependency, and of course, mariadb do not compile. It's always the same with Macports and the rolling release policy: there is always something broken...

Currently, with the qt5-mysql-plugin and the mariadb10_5 variant, we force to compile with and older version of Mariadb for retro compatibility due to an old bug in Qt5. Even if this bug is now fixed with Qt5 version from Macports, the goal to use an older Mariadb release must not be the problem here. I suspect a packaging problem due to a change in installed file on the Macports lead directory.

Can you run the following commands on your system from a Terminal :

bash-3.2$ pwd
/Applications/digiKam.org

bash-3.2$ find . -name *maria*
./digikam.app/Contents/etc/mariadb
./digikam.app/Contents/etc/mariadb-10.5
./digikam.app/Contents/lib/mariadb
./digikam.app/Contents/lib/mariadb-10.5
./digikam.app/Contents/lib/mariadb-10.5/pkgconfig/libmariadb.pc
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-check
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-secure-installation
./digikam.app/Contents/lib/mariadb-10.5/bin/wsrep_sst_mariabackup
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-show
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadbd-safe-helper
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-waitpid
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-config
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-install-db
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-access
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-conv
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-client-test-embedded
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-plugin
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-client-test
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-test-embedded
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-embedded
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-dump
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadbd
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-test
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-slap
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-dumpslow
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-admin
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb_config
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-find-rows
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-upgrade
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-setpermission
./digikam.app/Contents/lib/mariadb-10.5/bin/mariabackup
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-binlog
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-fix-extensions
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadbd-multi
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-import
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-tzinfo-to-sql
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-backup
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-hotcopy
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-convert-table-format
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadbd-safe
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadbclient.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/pkgconfig/mariadb.pc
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadbd.19.dylib
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadb.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadbd.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadbd.dylib
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadb.dylib
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadb.3.dylib
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/maria_add_gis_sp.sql
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/policy/selinux/mariadb-server.te
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/policy/selinux/mariadb-server.fc
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/policy/selinux/mariadb.te
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/maria_add_gis_sp_bootstrap.sql
bash-3.2$
 
bash-3.2$ find . -name *mysql*
./digikam.app/Contents/libexec/qt5/plugins/sqldrivers/libqsqlmysql.dylib
./digikam.app/Contents/Resources/digikam/database/mysql-global.conf
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlbinlog
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_plugin
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_tzinfo_to_sql
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_install_db
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqldumpslow
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqld
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqltest_embedded
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_config
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqld_multi
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_waitpid
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlcheck
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_find_rows
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlimport
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_fix_extensions
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqld_safe_helper
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlaccess
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_client_test
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlshow
./digikam.app/Contents/lib/mariadb-10.5/bin/wsrep_sst_mysqldump
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_secure_installation
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_embedded
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_client_test_embedded
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_convert_table_format
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqladmin
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqldump
./digikam.app/Contents/lib/mariadb-10.5/bin/msql2mysql
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlhotcopy
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_setpermission
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_upgrade
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqltest
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqld_safe
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlslap
./digikam.app/Contents/lib/mariadb-10.5/plugin/mysql_clear_password.so
./digikam.app/Contents/lib/mariadb-10.5/plugin/type_mysql_json.so
./digikam.app/Contents/lib/mariadb-10.5/mysql
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqlclient_r.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqld.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqld.so
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqlclient.dylib
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqlservices.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqlclient.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqlclient_r.dylib
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/aclocal/mysql.m4
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/mysql_performance_tables.sql
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/mysqld_multi.server
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/mysql-log-rotate
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/mysql.server
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/policy/apparmor/usr.sbin.mysqld
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/policy/apparmor/usr.sbin.mysqld.local
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/mysql_system_tables.sql
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/mysql_system_tables_data.sql
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/mysql_test_data_timezone.sql
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/mysql_test_db.sql
bash-3.2$ 

This is the result on my macbook pro with digiKam 7.10 installed. I would to compare with an older version to see if files are missing.

Gilles
Comment 39 Alex 2023-01-26 17:34:18 UTC
Hi Gilles

(In reply to caulier.gilles from comment #38)
> Can you run the following commands on your system from a Terminal :
> 
digikam 7.8.0

bash-3.2$ find . -name *maria*
./digikam.app/Contents/etc/mariadb
./digikam.app/Contents/etc/mariadb 1
./digikam.app/Contents/etc/mariadb-10.5
./digikam.app/Contents/lib/mariadb
./digikam.app/Contents/lib/mariadb 1
./digikam.app/Contents/lib/mariadb 1/share/mariadb
./digikam.app/Contents/lib/mariadb 1/share/mariadb/support-files/SELinux/mariadb.te
./digikam.app/Contents/lib/mariadb-10.5
./digikam.app/Contents/lib/mariadb-10.5/pkgconfig/libmariadb.pc
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-check
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-secure-installation
./digikam.app/Contents/lib/mariadb-10.5/bin/wsrep_sst_mariabackup
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-show
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadbd-safe-helper
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-waitpid
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-config
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-install-db
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-access
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-conv
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-client-test-embedded
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-plugin
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-client-test
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-test-embedded
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-embedded
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-dump
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadbd
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-test
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-slap
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-dumpslow
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-admin
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb_config
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-find-rows
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-upgrade
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-setpermission
./digikam.app/Contents/lib/mariadb-10.5/bin/mariabackup
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-binlog
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-fix-extensions
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadbd-multi
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-import
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-tzinfo-to-sql
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-backup
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-hotcopy
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadb-convert-table-format
./digikam.app/Contents/lib/mariadb-10.5/bin/mariadbd-safe
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadbclient.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/pkgconfig/mariadb.pc
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadbd.19.dylib
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadbd.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadbd.dylib
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadb.dylib
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmariadb.3.dylib
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/maria_add_gis_sp.sql
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/policy/selinux/mariadb-server.te
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/policy/selinux/mariadb-server.fc
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/policy/selinux/mariadb.te
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/maria_add_gis_sp_bootstrap.sql

bash-3.2$ find . -name *mysql*
./digikam.app/Contents/libexec/qt5/plugins/sqldrivers/libqsqlmysql.dylib
./digikam.app/Contents/Resources/digikam/database/mysql-global.conf
./digikam.app/Contents/lib/mariadb 1/bin/mysqlbinlog
./digikam.app/Contents/lib/mariadb 1/bin/mysql_plugin
./digikam.app/Contents/lib/mariadb 1/bin/mysql_tzinfo_to_sql
./digikam.app/Contents/lib/mariadb 1/bin/mysql_install_db
./digikam.app/Contents/lib/mariadb 1/bin/mysqldumpslow
./digikam.app/Contents/lib/mariadb 1/bin/mysqld
./digikam.app/Contents/lib/mariadb 1/bin/mysqltest_embedded
./digikam.app/Contents/lib/mariadb 1/bin/mysql_config
./digikam.app/Contents/lib/mariadb 1/bin/mysqld_multi
./digikam.app/Contents/lib/mariadb 1/bin/mysql_waitpid
./digikam.app/Contents/lib/mariadb 1/bin/mysqlcheck
./digikam.app/Contents/lib/mariadb 1/bin/mysql_find_rows
./digikam.app/Contents/lib/mariadb 1/bin/mysqlimport
./digikam.app/Contents/lib/mariadb 1/bin/mysql_fix_extensions
./digikam.app/Contents/lib/mariadb 1/bin/mysql_zap
./digikam.app/Contents/lib/mariadb 1/bin/mysqld_safe_helper
./digikam.app/Contents/lib/mariadb 1/bin/mysqlaccess
./digikam.app/Contents/lib/mariadb 1/bin/mysql_client_test
./digikam.app/Contents/lib/mariadb 1/bin/mysqlshow
./digikam.app/Contents/lib/mariadb 1/bin/mysql_secure_installation
./digikam.app/Contents/lib/mariadb 1/bin/mysql
./digikam.app/Contents/lib/mariadb 1/bin/mysql_embedded
./digikam.app/Contents/lib/mariadb 1/bin/mysql_client_test_embedded
./digikam.app/Contents/lib/mariadb 1/bin/mysql_convert_table_format
./digikam.app/Contents/lib/mariadb 1/bin/mysqladmin
./digikam.app/Contents/lib/mariadb 1/bin/mysqlbug
./digikam.app/Contents/lib/mariadb 1/bin/mysqldump
./digikam.app/Contents/lib/mariadb 1/bin/msql2mysql
./digikam.app/Contents/lib/mariadb 1/bin/mysqlhotcopy
./digikam.app/Contents/lib/mariadb 1/bin/mysql_setpermission
./digikam.app/Contents/lib/mariadb 1/bin/mysql_upgrade
./digikam.app/Contents/lib/mariadb 1/bin/mysqltest
./digikam.app/Contents/lib/mariadb 1/bin/mysqld_safe
./digikam.app/Contents/lib/mariadb 1/bin/mysqlslap
./digikam.app/Contents/lib/mariadb 1/plugin/mysql_clear_password.so
./digikam.app/Contents/lib/mariadb 1/mysql
./digikam.app/Contents/lib/mariadb 1/mysql/libmysqlclient_r.a
./digikam.app/Contents/lib/mariadb 1/mysql/libmysqlclient_r.18.dylib
./digikam.app/Contents/lib/mariadb 1/mysql/libmysqld.a
./digikam.app/Contents/lib/mariadb 1/mysql/libmysqlclient.18.dylib
./digikam.app/Contents/lib/mariadb 1/mysql/libmysqlclient.dylib
./digikam.app/Contents/lib/mariadb 1/mysql/libmysqlservices.a
./digikam.app/Contents/lib/mariadb 1/mysql/libmysqlclient.a
./digikam.app/Contents/lib/mariadb 1/mysql/libmysqld.dylib
./digikam.app/Contents/lib/mariadb 1/mysql/libmysqlclient_r.dylib
./digikam.app/Contents/lib/mariadb 1/mysql/libmysqld.18.dylib
./digikam.app/Contents/lib/mariadb 1/share/mariadb/aclocal/mysql.m4
./digikam.app/Contents/lib/mariadb 1/share/mariadb/mysql_performance_tables.sql
./digikam.app/Contents/lib/mariadb 1/share/mariadb/support-files/mysqld_multi.server
./digikam.app/Contents/lib/mariadb 1/share/mariadb/support-files/mysql-log-rotate
./digikam.app/Contents/lib/mariadb 1/share/mariadb/support-files/SELinux/rhel4-mysql.te
./digikam.app/Contents/lib/mariadb 1/share/mariadb/support-files/SELinux/rhel4-mysql.fc
./digikam.app/Contents/lib/mariadb 1/share/mariadb/support-files/mysql.server
./digikam.app/Contents/lib/mariadb 1/share/mariadb/mysql_system_tables.sql
./digikam.app/Contents/lib/mariadb 1/share/mariadb/mysql_system_tables_data.sql
./digikam.app/Contents/lib/mariadb 1/share/mariadb/mysql_test_data_timezone.sql
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlbinlog
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_plugin
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_tzinfo_to_sql
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_install_db
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqldumpslow
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqld
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqltest_embedded
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_config
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqld_multi
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_waitpid
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlcheck
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_find_rows
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlimport
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_fix_extensions
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqld_safe_helper
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlaccess
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_client_test
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlshow
./digikam.app/Contents/lib/mariadb-10.5/bin/wsrep_sst_mysqldump
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_secure_installation
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_embedded
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_client_test_embedded
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_convert_table_format
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqladmin
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqldump
./digikam.app/Contents/lib/mariadb-10.5/bin/msql2mysql
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlhotcopy
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_setpermission
./digikam.app/Contents/lib/mariadb-10.5/bin/mysql_upgrade
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqltest
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqld_safe
./digikam.app/Contents/lib/mariadb-10.5/bin/mysqlslap
./digikam.app/Contents/lib/mariadb-10.5/plugin/mysql_clear_password.so
./digikam.app/Contents/lib/mariadb-10.5/plugin/type_mysql_json.so
./digikam.app/Contents/lib/mariadb-10.5/mysql
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqlclient_r.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqld.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqld.so
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqlclient.dylib
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqlservices.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqlclient.a
./digikam.app/Contents/lib/mariadb-10.5/mysql/libmysqlclient_r.dylib
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/aclocal/mysql.m4
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/mysql_performance_tables.sql
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/mysqld_multi.server
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/mysql-log-rotate
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/mysql.server
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/policy/apparmor/usr.sbin.mysqld
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/support-files/policy/apparmor/usr.sbin.mysqld.local
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/mysql_system_tables.sql
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/mysql_system_tables_data.sql
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/mysql_test_data_timezone.sql
./digikam.app/Contents/lib/mariadb-10.5/share/mariadb-10.5/mysql_test_db.sql

I hope that's what you wanted.

Alex
Comment 40 Alex 2023-01-26 17:37:04 UTC
(In reply to caulier.gilles from comment #38)
> 
>  I would to compare with an older version to see if files are missing.
> 

Definitely some files missing.
Comment 41 caulier.gilles 2023-01-26 17:48:06 UTC
There is something strange in your find trace. What's the "mariadb 1" stuff. It look like broken directories.

Can you capture the console text in raw and save it to a file. Just attach it to this entry.

Gilles
Comment 42 Alex 2023-01-26 20:26:03 UTC
(In reply to caulier.gilles from comment #41)
> There is something strange in your find trace. What's the "mariadb 1" stuff.
> It look like broken directories.
> 
> Can you capture the console text in raw and save it to a file. Just attach
> it to this entry.
> 
> Gilles

Sorry Gilles, I am not a programmer – just very interested in computer stuff :)
How do I capture console text in raw? You probably don't mean an output with 'script'?
Google didn't help me with this. If you got a helpful link for macOS I will probably be able to figure it out.

Alex
Comment 43 caulier.gilles 2023-01-26 20:35:31 UTC
Form the Terminal, use redirection of you command line with > and >> to conacatenate.

ex : ls -al > foo.txt

foo.txt will be created with the output of ls -al

to append new contents to foo.txt, use >> as for ex:

uname -a >> foo.txt

Et voilà attach foo.txt to this entry.

a tutorial: https://linuxconfig.org/introduction-to-bash-shell-redirections

Gilles Caulier
Comment 44 Alex 2023-01-26 20:59:33 UTC
Created attachment 155679 [details]
macOS digikam 7.8.0 find . -name *maria*  & find . -name *mysql* raw output

Hi Gilles, I hope this is what you wanted.
Thank you for your explanation and link.
Comment 45 caulier.gilles 2023-01-27 03:58:13 UTC
yes this is exactly what i needs. Thanks. I take a look this morning...

Gilles
Comment 46 Alex 2023-02-05 18:25:01 UTC
(In reply to caulier.gilles from comment #45)

Hi Gilles,

did I have some time to look into the issue?

Best wishes;
Alex
Comment 47 caulier.gilles 2023-02-05 20:15:38 UTC
I just finalized another big update of macOS on my computer (Apple is very active currently). I will rebuild all from scratch again tomorrow.

Best

Gilles
Comment 48 caulier.gilles 2023-02-08 21:51:02 UTC
Done 7.10.0 macOS PKG installer are now updated at usual place :

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

Let's me hear if this fix your problem...

Gilles Caulier
Comment 49 Alex 2023-02-09 07:45:44 UTC
(In reply to caulier.gilles from comment #48)
> Done 7.10.0 macOS PKG installer are now updated at usual place :
> 
> https://files.kde.org/digikam/
> 
> Let's me hear if this fix your problem...
> 
> Gilles Caulier

Hi Gilles, unfortunately this doesn't fix the problem.
Still exactly the same issue.
Comment 50 caulier.gilles 2023-02-09 07:54:46 UTC
Ok, i will try to rebuild all with the last mysql (mariadb version) instead to use a specific older version). last time that i tried this, compilation was completely broken.

Gilles
Comment 51 caulier.gilles 2023-02-09 18:34:29 UTC
Et voilà : Mariadb current version do not compile :

--->  Computing dependencies for qt5-mysql-plugin
--->  Dependencies to be installed: mariadb
--->  Building mariadb
Error: Failed to build mariadb: command execution failed
Error: See /opt/digikam.org.x86_64/var/macports/logs/_opt_digikam.org.x86_64_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb/mariadb/main.log for details.
Error: Follow https://guide.macports.org/#project.tickets if you believe there is a bug.
Error: Processing of port qt5-mysql-plugin failed
FAILED COMMAND: port install cctools +xcode cmake ccache libpng jpeg tiff boost eigen3 gettext libusb libgphoto2 jasper lcms2 expat libxml2 libxslt libical lensfun bison py38-lxml x265 aom ffmpeg wget +ssl qt5-qtbase qt5-qtdeclarative qt5-qtmacextras qt5-qtquickcontrols qt5-qtxmlpatterns qt5-qtsvg qt5-qttools qt5-qttranslations qt5-qtimageformats qt5-qtnetworkauth qt5-sqlite-plugin qt5-mysql-plugin

I will report this problem to Macports team...

Gilles
Comment 52 caulier.gilles 2023-02-09 18:44:40 UTC
Problem reported to Macports:

https://trac.macports.org/ticket/66879
Comment 53 Alex 2023-02-10 15:05:08 UTC
(In reply to caulier.gilles from comment #52)
> Problem reported to Macports:
> 
> https://trac.macports.org/ticket/66879

Thank you Gilles.
Comment 54 caulier.gilles 2023-02-16 02:42:45 UTC
Voilà, the Macports UPSTREAM bug about mariadb compilation is now closed.

The Qt::mysql plugin is now compile with current Mariadb version, not the specific older 10.5 version.

I started to compile and upload the new macOS PKG 7.10.0 pre-release bundle, at usual place.

Please try again. Thanks in advance

Gilles
Comment 55 caulier.gilles 2023-02-16 06:40:09 UTC
Maik,

Under macOS i use now the standard mariadb port to compile qt mysql database plugin.

(1) https://ports.macports.org/port/mariadb/

Look well the release number : 5.5.68

Previously, i used this one:

(2) https://ports.macports.org/port/mariadb-10.5/

...with the release number: 10.5.18 

(1) do not work with an internal server database where (2) works as expected. The error messages from a console are :

digikam.databaseserver: Database Parameters:
   Type:                      "QMYSQL"
   DB Core Name:              "digikam"
   DB Thumbs Name:            "digikam"
   DB Face Name:              "digikam"
   DB Similarity Name:        "digikam"
   Connect Options:           "UNIX_SOCKET=/Users/gilles/Library/Application Support/digikam/digikam/db_misc/mysql.socket"
   Host Name:                 ""
   Host port:                 -1
   Internal Server:           true
   Internal Server Path:      "/Users/gilles/Pictures/"
   Internal Server Admin Cmd: "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqladmin"
   Internal Server Serv Cmd:  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld"
   Internal Server Init Cmd:  "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysql_install_db"
   Username:                  "root"
   Password:                  ""

digikam.databaseserver: Internal Server data path: "/Users/gilles/Pictures/.mysql.digikam/db_data"
digikam.databaseserver: The mysql configuration was already up-to-date: "/Users/gilles/Library/Application Support/digikam/digikam/mysql.conf"
digikam.databaseserver: Database server: "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld" ("--defaults-file=/Users/gilles/Library/Application Support/digikam/digikam/mysql.conf", "--datadir=/Users/gilles/Pictures/.mysql.digikam/db_data", "--basedir=/Applications/digiKam.org/digikam.app/Contents//lib/mariadb/", "--socket=/Users/gilles/Library/Application Support/digikam/digikam/db_misc/mysql.socket")
digikam.databaseserver: "Database process exited unexpectedly during initial connection."
digikam.databaseserver: Executable: "/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld"
digikam.databaseserver: Arguments: "--defaults-file=/Users/gilles/Library/Application Support/digikam/digikam/mysql.conf, --datadir=/Users/gilles/Pictures/.mysql.digikam/db_data, --basedir=/Applications/digiKam.org/digikam.app/Contents//lib/mariadb/, --socket=/Users/gilles/Library/Application Support/digikam/digikam/db_misc/mysql.socket"
digikam.databaseserver: Stdout: ""
digikam.databaseserver: Stderr: "230216  7:30:01 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --log_slow_queries is not set\n230216  7:30:01 [Note] /Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld (mysqld 5.5.68-MariaDB) starting as process 25388 ...\n230216  7:30:01 [Warning] Setting lower_case_table_names=2 because file system for /Users/gilles/Pictures/.mysql.digikam/db_data/ is case insensitive\n"
digikam.databaseserver: Exit code: 1
digikam.databaseserver: Process error: "Unknown error"
digikam.databaseserver: Cannot start internal database server

I can conclude that mariadb 5 is not compatible with Qt5.15.8 currently available in macports.

What i found strange is the rules to compile qt mysql plugin: by default macports use mariadb 5, not 10. Why if 5 is not compatible ? (i suspect that nobody has already tested this from macports team).

Note : the Alex problem is different as it use a remote mysql server as database.

Gilles
Comment 56 Alex 2023-02-16 06:45:19 UTC
(In reply to caulier.gilles from comment #54)
> Voilà, the Macports UPSTREAM bug about mariadb compilation is now closed.
> 
> The Qt::mysql plugin is now compile with current Mariadb version, not the
> specific older 10.5 version.
> 
> I started to compile and upload the new macOS PKG 7.10.0 pre-release bundle,
> at usual place.
> 
> Please try again. Thanks in advance
> 
> Gilles

YES, thank you so much Gilles.
Finally remote server connection is working.
Comment 57 caulier.gilles 2023-02-16 06:55:08 UTC
Maik,

From the Qt5 doc, the requirement is : "MySQL or MariaDB (version 5.0 and above)"

https://doc.qt.io/qt-5/sql-driver.html#qmysql

The mariadb versions exist with a 5.x and 10.x major number The differences are explained here:

https://en.wikipedia.org/wiki/MariaDB#Versioning

So we cannot switch back from 10 to 5 safety, because the database will be not compatible. So i need to go back to 10.x

Now the Q is : must i stay to 10.5.x or a later version (there are plenty available under Macports) ? Initially 10.5 was used due to the Qt 5.15.3 bug, now fixed. A database created with mariadb 10.5 can be open with a mariadb 10.6 or later ?  

Gilles
Comment 58 caulier.gilles 2023-02-16 06:57:17 UTC
Hi Alex, 

Really ??? Arg!!! now the remote mysql work, but not the internal one... I will become crazy (:-=)))

Gilles
Comment 59 Maik Qualmann 2023-02-16 07:24:52 UTC
Hi Gilles,

Ok, so MariadDB 5.x still corresponds to Oracle MySQL. I'm not entirely sure, but I think support for triggers first came in MySQL-5.6, so that would be a version issue.

I think you are trying to start an existing internal MariaDB-10.x DB, this will not work with the old MariaDB-5.x. Try creating a new DB.

An internal MariaDB database created under 10.5 can run with 10.6, but needs a mariadb_upgrade execution if digiKam changes something in the tables during an update. However, in the case of an update error, we now try to carry out this database upgrade if we recognize it in the log files.

At the moment I strongly advise against using an external DB created under 10.x with 5.5.x as long as the issue of trigger support has not been clarified.

Maik
Comment 60 Alex 2023-02-16 07:29:24 UTC
(In reply to caulier.gilles from comment #58)
> Hi Alex, 
> 
> Really ??? Arg!!! now the remote mysql work, but not the internal one... I
> will become crazy (:-=)))
> 
> Gilles

Yes, really :)
Everything is working fine with the remote mysql.
Sorry – this is really crazy.
Comment 61 Alex 2023-02-17 14:23:01 UTC
Just to be thorough:
I tested the new 7.10 on another Mac.
This time with an apple silicon Chip (M1 Max).
External db connection works.
Comment 62 caulier.gilles 2023-03-06 14:04:27 UTC
Alex, 

I recompiled all with the Mariadb version 10.5 as we used at start of this thread. As i can see in Macports log, a fix have been applied to mariadb compilation. Perhaps this have fixed the orignal problem. I would to preserve the compatibility with older internal mysql database in production.

Can you check again we the PKG published at usual place today ?

Gilles
Comment 63 caulier.gilles 2023-03-09 16:58:52 UTC
Alex,

Did you seen my previous comment ?

Thanks in advance

Gilles Caulier
Comment 64 caulier.gilles 2023-03-11 10:30:09 UTC
Git commit 88138b312e3236319918ad10fefb8718d811b067 by Gilles Caulier.
Committed on 11/03/2023 at 10:26.
Pushed by cgilles into branch 'qt5-maintenance'.

use current mariadb version from macports instead a specific version as qtsql module fail to use the network to communicate. Sound like a bug in Qt (currently 5.15.8). BUGS: 462736 FIXED-IN: 7.10.0

M  +4    -2    project/bundles/macports/config.sh

https://invent.kde.org/graphics/digikam/commit/88138b312e3236319918ad10fefb8718d811b067

diff --git a/project/bundles/macports/config.sh b/project/bundles/macports/config.sh
index c452400cfff..8b6f312e902 100644
--- a/project/bundles/macports/config.sh
+++ b/project/bundles/macports/config.sh
@@ -97,8 +97,10 @@ DK_KF5_VERSION="5.102"
 # Qt version to use in bundle and provided by Macports.
 DK_QTVERSION="5.15"

-# Mariadb version to install for Qt QSL plugin
-DK_MARIADB_VERSION="10.5"
+# Mariadb version to install for Qt QSL plugin.
+# Left empty to use current 5.x from Macports
+DK_MARIADB_VERSION=""
+#DK_MARIADB_VERSION="10.5"

 if [[ ! -z "$DK_MARIADB_VERSION" ]] ; then
     MP_MARIADB_VARIANT="+mariadb$DK_MARIADB_VERSION"
Comment 65 Alex 2023-03-28 12:52:18 UTC
(In reply to caulier.gilles from comment #63)
> Alex,
> 
> Did you seen my previous comment ?
> 
> Thanks in advance
> 
> Gilles Caulier

Hi Gilles,
sorry I have been away from my computers.
Checking it out now.
Comment 66 caulier.gilles 2023-03-28 13:00:49 UTC
Note : 7.x maintenance branch is closed now. We are focused to next major 8.0.0 release. Only this version is build as pre-release in files.kde.org server.

Take a care, 8.0.0 update the database schema compared to 7.x release. backup your database before to play with 8.0.0, else 7.x will usable at all.

...but 8.0.0 come with... 300 files closed in bugzilla...

https://invent.kde.org/graphics/digikam/-/raw/master/NEWS

Gilles
Comment 67 Alex 2023-03-28 13:03:48 UTC
(In reply to caulier.gilles from comment #66)
> Note : 7.x maintenance branch is closed now. We are focused to next major
> 8.0.0 release. Only this version is build as pre-release in files.kde.org
> server.
> 
> Take a care, 8.0.0 update the database schema compared to 7.x release.
> backup your database before to play with 8.0.0, else 7.x will usable at all.
> 
> ...but 8.0.0 come with... 300 files closed in bugzilla...
> 
> https://invent.kde.org/graphics/digikam/-/raw/master/NEWS
> 
> Gilles

Thank you for your advice.
Tested 8.0.0 and it seems to work fine.
No issues so far.
If something comes up I will report it.
Thanks again!
Alex
Comment 68 caulier.gilles 2023-03-28 13:05:41 UTC
Great. Your welcomes (:=)))