Digikam cannot connect to external server mysql database

English Applications
21

Well sir, normally when I report bugs, as a user, I expect that if more information is required, I will be asked to provide it. I do get to the point in reporting an issue, because I don’t have enough experience with the team or development to know what else to provide. If you can, kindly, re-hydrate the report, I can provide any information that they require.
Thank you
TasP

22

@70tas:

Agreed – The KDE digiKam documentation doesn’t explicitly mention the need to first migrate to a local MySQL/MariaDB database before migrating to a remote MySQL/MariaDB database.
But, reading between the lines, that documentation implicitly points to the method.

What the current documentation does mention is, that SQLite happily handles more than 100 thousand photos provided that –

  1. The SQLite “WAL” option is enabled – more here: <Write-Ahead Logging>
  2. SQLite performs better if SSD or NVMe storage is used for the local digiKam databases.

Another thing that the KDE digiKam documentation points out is –

  • provided that you really need to use a remote MySQL server because, you’re working in a multi-user environment with multiple users accessing the photo collection simultaneously –

the following points need to be addressed:

  1. With a slow network, digiKam hangs a lot of the time, especially when the album contains many items (>1,000). This issue depends on network performances.
  2. Also, if you have an enormous collection, you should start the MySQL server with mysql –max_allowed_packet = 128M. [The remote server’s administrator needs to do this.]
1 Like
23

With local storage enabled digikam readily manages some 116,662 jpeg and mp4 files on Infamous Host Erlangen:

karl@erlangen:~> ll -h /home/Albums/Bilder/*db
-rw-r--r-- 1 karl users  46M  9. Jun 09:28 /home/Albums/Bilder/digikam4.db
-rw-r--r-- 1 karl users  36K  9. Jun 08:52 /home/Albums/Bilder/recognition.db
-rw-r--r-- 1 karl users  24K  9. Jun 08:52 /home/Albums/Bilder/similarity.db
-rw-r--r-- 1 karl users 2,0G  9. Jun 09:28 /home/Albums/Bilder/thumbnails-digikam.db
karl@erlangen:~>

digikam reports 3 seconds startup time.

24

@dcurtisfra Yes, agreed. If you also look at the remote DB table, it lists MySQL, but in the next column talks about MariaDB. that’s why I installed it. But I don’t see anything about encryption. I will play with it more and report success if any. :wink: