[digikam] [Bug 462736] Connection to external Mysql-Server fails

[Andi]

https://bugs.kde.org/show_bug.cgi?id=462736

Andi <a4bugs.kde at stern.work> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |a4bugs.kde at stern.work

--- Comment #15 from Andi <a4bugs.kde at stern.work> ---
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">

-- 
You are receiving this mail because:
You are watching all bug changes.