[digiKam-users] Remote MySQL Database connectivity

Sun Jun 16 07:44:19 BST 2019

I've been successfully running digKam on Windows 10 with a remote MySQL
database (mariadb-5.5.60-1.el7_5.x86_64) on Centos 7 for some time now.

Running digiKam-6.2.0-git-20190519T130939-Win64 in a test configuration (the
last version that connects successfully to the database) DebugView provides
the following 

[9748] digikam.general: Loading DrMinGw run-time...

[9748] digikam.general: DrMinGw run-time loaded.

[9748] digikam.general: DrMinGw crash-file will be located at:
"C:\\Users\\phil\\AppData\\Local\\digikam_crash.log"

[9748] digikam.widgets: Breeze icons resource file found

[9748] digikam.general: AlbumWatch use QFileSystemWatcher

[9748] digikam.general: Database Parameters:

[9748]    Type:                     "QMYSQL"

[9748]    DB Core Name:             "digikam6_core"

[9748]    DB Thumbs Name:           "digikam6_thumbs"

[9748]    DB Face Name:             "digikam6_faces"

[9748]    DB Similarity Name:      "digikam6_similarity"

[9748]    Connect Options:          ""

[9748]    Host Name:                "10.0.0.43"

[9748]    Host port:                3306

[9748]    Internal Server:          false

[9748]    Internal Server Path:     ""

[9748]    Internal Server Serv Cmd: ""

[9748]    Internal Server Init Cmd: ""

[9748]    Username:                 "digikam6"

[9748]    Password:                 "XXXXXXXXX"

[9748] 

[9748] digikam.dbengine: Loading SQL code from config file "C:/Program
Files/digiKam/data/digikam/database/dbconfig.xml"

[9748] digikam.dbengine: Checking XML version ID => expected:  3  found:  3

[9748] digikam.coredb: Core database: running schema update

[9748] digikam.coredb: Core database: have a structure version  10

[9748] digikam.coredb: Core database: makeUpdates  10  to  10

[9748] digikam.database: Creating new Location  "/"  uuid
"networkshareid:?mountpath=P:"

[9748] digikam.database: location for  "P:"  is available  true

[9748] KMemoryInfo: Platform identified :  "WINDOWS"

[9748] KMemoryInfo: TotalRam:  17121632256

[9748] digikam.general: Allowing a cache size of 200 MB

[9748] digikam.thumbsdb: ThumbDB SelectThumbnailSetting val ret =  0

[9748] digikam.thumbsdb: ThumbDB SelectThumbnailSetting val ret =  0

[9748] digikam.thumbsdb: Thumbs database: have a structure version  "3"

[9748] digikam.general: Thumbnails database ready for use

[9748] digikam.similaritydb: SimilarityDb SelectSimilaritySetting val ret =
0

[9748] digikam.similaritydb: SimilarityDb SelectSimilaritySetting val ret =
0

[9748] digikam.similaritydb: Similarity database: have a structure version
"1"

[9748] digikam.similaritydb: Similarity database ready for use

[9748] digikam.general: Switch to widget style:  "Fusion"

[9748] digikam.dimg: ()

Unfortunately, more recent versions of digicam 6.2 64-bit for Windows have
failed to connect to the database. After upgrading my test configuration to
digiKam-6.2.0-git-20190615T015548-Win64, running digiKam with DebugView
highlights the following issue.

[14816] digikam.general: Loading DrMinGw run-time...

[14816] digikam.general: DrMinGw run-time loaded.

[14816] digikam.general: DrMinGw crash-file will be located at:
"C:\\Users\\phil\\AppData\\Local\\digikam_crash.log"

[14816] digikam.widgets: Breeze icons resource file found

[14816] digikam.general: Switch to widget style:  "Windows"

[14816] digikam.general: AlbumWatch is disabled

[14816] digikam.general: Database Parameters:

[14816]    Type:                     "QMYSQL"

[14816]    DB Core Name:             "digikam6_core"

[14816]    DB Thumbs Name:           "digikam6_thumbs"

[14816]    DB Face Name:             "digikam6_faces"

[14816]    DB Similarity Name:       "digikam6_similarity"

[14816]    Connect Options:          ""

[14816]    Host Name:                "10.0.0.43"

[14816]    Host port:                3306

[14816]    Internal Server:          false

[14816]    Internal Server Path:     ""

[14816]    Internal Server Serv Cmd: ""

[14816]    Internal Server Init Cmd: ""

[14816]    Username:                 "digikam6"

[14816]    Password:                 "XXXXXXXXX"

[14816] 

[14816] QSqlDatabase: QMYSQL driver not loaded

[14816] QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3
QPSQL QPSQL7 QTDS QTDS7

[14816] QSqlDatabase: QMYSQL driver not loaded

[14816] QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3
QPSQL QPSQL7 QTDS QTDS7

[14816] digikam.dbengine: Error while opening the database. Error details [
QSqlError("", "Driver not loaded", "Driver not loaded") ]

If I re-install digiKam-6.2.0-git-20190519T130939-Win64, digiKam will
connect to the database and function normally.

Any ideas?

Thanks, Phil

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20190616/0795d82b/attachment.html>