Bug 447793

Summary:	Database socket specification when trying to connect to mariadb server
Product:	[Applications] digikam	Reporter:	jrobens <jrobens>
Component:	Database-Engine	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	RESOLVED FIXED
Severity:	normal	CC:	caulier.gilles, metzpinguin
Priority:	NOR
Version:	7.5.0
Target Milestone:	---
Platform:	Homebrew (macOS)
OS:	macOS
Latest Commit:		Version Fixed In:	7.5.0
Sentry Crash Report:
Attachments:	Connection result

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.