https://bugs.kde.org/show_bug.cgi?id=443238
Bug ID: 443238
Summary: unable to connect to ubuntu 20.04 installed Mysql
server 8.0.26
Product: digikam
Version: 7.3.0
Platform: Appimage
OS: Linux
Status: REPORTED
Severity: critical
Priority: NOR
Component: Database-Mysql
Assignee: digikam-bugs-n...@kde.org
Reporter: ge...@gerrymatte.ca
Target Milestone: ---
Created attachment 142096
--> https://bugs.kde.org/attachment.cgi?id=142096&action=edit
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
--
You are receiving this mail because:
You are watching all bug changes.
