Bug 447793 - Database socket specification when trying to connect to mariadb server
Summary: Database socket specification when trying to connect to mariadb server
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Engine (show other bugs)
Version: 7.5.0
Platform: Homebrew (macOS) macOS
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-01-01 20:37 UTC by jrobens
Modified: 2022-01-01 22:40 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 7.5.0
Sentry Crash Report:


Attachments
Connection result (572.94 KB, image/png)
2022-01-01 20:37 UTC, jrobens
Details

Note You need to log in before you can comment on or make changes to this bug.
Description jrobens 2022-01-01 20:37:42 UTC
Created attachment 145026 [details]
Connection result

SUMMARY

I'd like to connect to a mariadb server that I have on the local machine. The socket is not able to be specified and is wrong. 

My socket is in /tmp/mysql.sock. digikam is trying to use a socket in /opt/digikam.org.x86_64/...


STEPS TO REPRODUCE
1. Install digikam
2. attempt to connect to the database
3. 

OBSERVED RESULT

Wrong socket path as per screen grab. I'm trying to connect via port 3306

EXPECTED RESULT

Connection successful


SOFTWARE/OS VERSIONS
Windows: 
macOS: Darwin Kernel Version 21.2.0: Sun Nov 28 20:28:41 PST 2021; root:xnu-8019.61.5~1/RELEASE_ARM64_T6000 arm64

Qt Version: 
qt: stable 6.2.2 (bottled), HEAD
Cross-platform application and UI framework
https://www.qt.io/
/opt/homebrew/Cellar/qt/6.2.2 (12,257 files, 488.2MB) *
  Poured from bottle on 2021-12-14 at 07:23:24
From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/qt.rb
License: GFDL-1.3-only and GPL-2.0-only and GPL-3.0-only and LGPL-2.1-only and LGPL-3.0-only
==> Dependencies
Build: cmake ✘, ninja ✘, node ✘, pkg-config ✔
Required: assimp ✔, brotli ✔, dbus ✔, double-conversion ✔, freetype ✘, glib ✔, hunspell ✔, icu4c ✔, jasper ✔, jpeg ✔, libb2 ✔, libpng ✔, libtiff ✔, md4c ✔, pcre2 ✔, python@3.9 ✔, sqlite ✔, webp ✔, zstd ✔
==> Requirements
Build: Xcode ✔
==> Options
--HEAD
	Install HEAD version
==> Analytics
install: 59,357 (30 days), 199,484 (90 days), 719,367 (365 days)
install-on-request: 29,463 (30 days), 96,768 (90 days), 266,095 (365 days)
build-error: 79 (30 days)


ADDITIONAL INFORMATION
Comment 1 Maik Qualmann 2022-01-01 20:46:46 UTC
When using an external MySQL database, digiKam does not set any socket options. So this must be a problem with your MariaDB installation.
But you can enter the following in the connections options:

UNIX_SOCKET=/tmp/mysql.sock

Maik
Comment 2 jrobens 2022-01-01 20:57:08 UTC
I could connect by using 127.0.0.1 instead of localhost.