Created attachment 142096 [details] mysql server status - server version etc I attempted to install using digiKam-7.3.0-x86-64.appimage on my ubuntu 20.04 system. While working through the initial setup wizard I encountered the database setup screen and discovered that I needed to setup a user and database in my mysql database server (see attachment mysql-workbench-server-status). I used the Mysql Workbench to create a user and database as shown in attachments mysql-workbench-pictures-connectionTest and mysql-workbench-picturesDB. After much trial and error with the mysql database workbench I eventually managed to successfully connect from the digiKam setup wizard and complete the remaining screens. The final accepted digiKam screen is attached as digikam-03. The wizard succeeded wnen I used it's "Check Connection" button. However, when I finished the setup it started connecting to my database and I received an error "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13 "Permission denied") QMYSQL: Unable to connect". I decided to start over and simply use the SQLite database which I assumed would be included in the appimage file. However when I rerun the appimage file, it continues to attempt a connection to mysql. I would prefer to use my mysql server since I'm very familiar with it. But I am willing to change to using SQLite if that is the simplest option. If you are concerned that the digiKam "Check Connection" button accepted my database settings and then failed when scanning my Pictures folder I am willing to spend time attempting to work with you to determine the problem and resolve it. STEPS TO REPRODUCE 1. 2. 3. OBSERVED RESULT EXPECTED RESULT SOFTWARE/OS VERSIONS Windows: macOS: Linux/KDE Plasma: (available in About System) KDE Plasma Version: KDE Frameworks Version: Qt Version: ADDITIONAL INFORMATION
Created attachment 142097 [details] mysql workbench connected ok
Created attachment 142099 [details] mysql workbench connection to server and database tested ok
Created attachment 142101 [details] digiKam database settings passed by Check Connections button
Sorry for the extraneous boilerplate text "How to reproduce etc". I expected to be able to attach more than one file and I managed to do so but then could not see how to edit the original text..... Gerry
Well - I'm happy to report that my problem has been resolved and digiKam is now connecting to mysql with no problems. My final test was an attempt to instead use SQLite as the database but that failed because it reported that I had not yet installed SQLite. I had assummed it would be included in the appimage but no such luck. After completing this bug report I rebooted my pc and went for a soak in my hot tub. When I came back to the pc I tried running the appimage again and got the same error that SQLite was not installed. But since the database connection screen was right there I changed the database back to MySQL Server and set the rest of the parameters - when I used "Check Connection" it passed ! When it continued it completed some large downloads and started ok. After a restart of the appimage, digiKam then scanned my ~/Pictures folder successfully.
Well slqite is not need to be installed in client area, as the sqlite core is already included in AppImage (Qt framework in fact). Best gilles Caulier
If you mean that SQLite is included in the appimage for the not yet released digiKam-7.4.0-x86-64.appimage I'm glad to hear it. The version 7.3.0 I am using insists that SQLite is not found and needs to be installed. It's possible that I received that error after initially failing to connect to my MySQL Server and then trying to change database to SQLite.