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
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 –
- The SQLite “WAL” option is enabled – more here: <Write-Ahead Logging>
- 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:
- 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.
- 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
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.
@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. 
Well, some weird stuff is going on with DigiKam; There is a bug report on the DigiKam site that has the following statements (paraphrased of course):
a. We don’t test with MySQL, only MariaDB
b. DigiKam only works with MariaDB on Windows
The above really does not make any sense. But I threw caution to the wind, logged in to my Tumbleweed system, and brought up the migration wizard, from a local DB to a remote MySQL on the Windows test box I created (MariaDB). I’m dumbfounded, that it actually worked. I don’t know why MySQL/MariaDB would work on Windows and not Linux, that just does not compute.
Here are the versions:
TW - DigiKam 8.6
MariaDB on Windows - 11.4
MySQL on Linux - 8.45
MariaDB on Linux - ( I believe 11.4, I got rid of the VM)
Not sure what is going in with DigiKam, but it doesn’t sound good.
TasP
Link to DigiKam bug here:
Ok, here is a summary of all that I have tried:
DB Server
MySQL on LXC 9.3.0
MariaDB on LXC 11.8.2
MariaDB on Windows 11.4
MariaDB on Leap 15.6 (Mariadb 10.11.11)
DigiKam on Windows - connects to all above
DigiKam on Neon - connect to all above
DigiKam on TW - connects to Windows above, no Linux servers
DigiKam on Leap - connect to Windows above, no Linux servers
The error I get is certificate failure. I have tried creating a my.cnf with the no-ssl parameter, and other variations I’ve found in the documentation, but it appears that the mysql client ignores them on the SUSE distros. So if this is not a bug, then it is intentional, but one should be able to turn it off for a Linux server, as documented in the Mariadb client docs.
Why do the SUSE distros allow use of a Windows Mariadb server but not a Linux server?
For now, I guess I’ll have to choose either to use the Windows Mariadb instance, or use non-SUSE distro to run DigiKam. If anyone can shed any light, it would be tremendously appreciated.
Can you post
openssl s_client -showcerts db-server-address:db-server-port < /dev/null
for both Windows and Linux database servers?
To the OP:
If I were you, I wouldn’t dream of using one client application (like Digikam is) alternately on Mysql and Mariadb. These are 90+% compatible, but never 100% and the differences tend to grow since their ways parted. I would choose one and stick to it and forget the other.
@hermviaene I’m not. Just trying to see if it will work with either. There appears to be a bug on the latest release, which requires encryption in-transit, but still does not work, and can’t be turned off. MySQL or MariaDB, doesn’t so much matter if one or the other works. The only one I’ve found that does is MariaDB on Windows. And I’m trying to leave Windows… I do use Win8.
If you wish to move away from MS Windows and, the files associated with photographic images are located on the disks of MS Windows systems then:
- There’s this KDE mail thread recipe for moving from Windows to macOS which, because macOS is BSD UNIX®, will also be OK for Windows to Linux – which is also a UNIX® …
<[digiKam-users] Migrate db/collection to new OS (windows->mac)>
Thank you 
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.