Bug 442200

Summary: cannot select homebrew mariadb
Product: [Applications] digikam Reporter: sayo-melu
Component: Database-MysqlAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED INTENTIONAL    
Severity: normal CC: caulier.gilles, metzpinguin
Priority: NOR    
Version: 7.3.0   
Target Milestone: ---   
Platform: macOS (DMG)   
OS: macOS   
Latest Commit: Version Fixed In: 8.1.0
Sentry Crash Report:

Description sayo-melu 2021-09-09 02:23:04 UTC 
SUMMARY


STEPS TO REPRODUCE
1. install digikam
2. brew install mariadb
3. cannot select mariadb

OBSERVED RESULT
cannot select mariadb installed with homebrew

EXPECTED RESULT


SOFTWARE/OS VERSIONS
Windows: 
macOS: 
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION
mariadb with homebrew is installed under /usr/local/bin and linked from /usr/local/Cellar/mariadb, and the mysqld is also a link from mariadbd. but digikam do not accept links/alias.
Comment 1 sayo-melu 2021-09-09 02:26:32 UTC 
there are three way to solve this.

1. auto detect mariadb from $PATH
2. allow choosing alias when choosing mysql bin
3. always attach the latest version of mariadb
Comment 2 caulier.gilles 2021-09-09 09:13:34 UTC 
Hi,

Try this : go to digiKam/Preference dialog, MISC/appareance section, and turn on "use native dialog" option.

Restart digiKam, and go back to the setup mariadb dialog and try again to select the link on FS.

Best regards

Gilles Caulier
Comment 3 Maik Qualmann 2021-09-09 11:32:47 UTC 
I am a little bit surprised. If you want to use an external MySQL server you don't need binary paths to the MySQL files. With an internal MySQL server you should use the MySQL server supplied with the digiKam package. Remember that digiKam must control programs such as mysqld or mysqladmin and must have the appropriate rights. If you want to use another MySQL server for the internal server - for whatever reason - you should check the Terminal Log to see if there are any problems, e.g. the server is shut down properly, etc. Otherwise, data may be lost.

Maik
Comment 4 caulier.gilles 2023-05-01 07:27:54 UTC 
I agree with Maik, digiKam is provided with the relevant and fully tested Mysql/Mariadb version under MacOS. No needs to use an extra one. I close this file.