[digiKam-users] Remote MySQL Database connectivity

[Maik Qualmann]

Check out this comment for a link to a recent GIT version of digiKam-6.2.0 on 
my GDrive:

https://bugs.kde.org/show_bug.cgi?id=408471#c7

Maik

Am Sonntag, 16. Juni 2019, 08:44:19 CEST schrieb digiKam at styles.me.uk:
> 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") ]
> 
> [14816] digikam.dbengine: Error while opening the database. Error details [
> QSqlError("", "Driver not loaded", "Driver not loaded") ]
> 
> [14816] digikam.dbengine: Error while opening the database. Error details [
> QSqlError("", "Driver not loaded", "Driver not loaded") ]
> 
> [14816] digikam.dbengine: Error while opening the database. Error details [
> QSqlError("", "Driver not loaded", "Driver not loaded") ]
> 
> [14816] digikam.dbengine: Error while opening the database. Error details [
> QSqlError("", "Driver not loaded", "Driver not loaded") ]
> 
> [14816] digikam.dbengine: Error while opening the database. Error details [
> QSqlError("", "Driver not loaded", "Driver not loaded") ]
> 
> [14816] digikam.dbengine: Error while opening the database. Error details [
> QSqlError("", "Driver not loaded", "Driver not loaded") ]
> 
> [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