digiKam › digikam-users

[digiKam-users] Remote MySQL Database connectivity

Classic

List

Threaded

3 messages Options

digikam-3

[digiKam-users] Remote MySQL Database connectivity

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: 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: 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

Maik Qualmann

Re: Remote MySQL Database connectivity

There's a problem somewhere in the build system from Gilles computer. Some
tools were localized, so the output was not parsed correctly anymore. We have
already identified a problem. But some plugins are not working. Gilles is very
busy at the moment. I create a current Windows bundle today and upload it for
testing on my GDrive.

Maik

Am Sonntag, 16. Juni 2019, 08:44:19 CEST schrieb [hidden email]:

> 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

Maik Qualmann

Re: Remote MySQL Database connectivity

In reply to this post by digikam-3

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 [hidden email]: