Bug 382053

Summary:	digikam preferences when using mysql host port resets to default (3306) when accessing preferences
Product:	[Applications] digikam	Reporter:	MM <digikam-mm>
Component:	Setup-Database	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	RESOLVED FIXED
Severity:	normal	CC:	caulier.gilles, metzpinguin
Priority:	NOR
Version:	5.4.0
Target Milestone:	---
Platform:	macOS (DMG)
OS:	macOS
Latest Commit:		Version Fixed In:	6.0.0

Description MM 2017-07-06 13:36:01 UTC

When using digikam with a mysql database, the host port automatically resets itself to 3306 if you access the preferences dialog. I am using a Synology NAS with mariadb and for reasons unbeknownst to me, mariadb 10 listens on port 3307 (see discussion here https://forum.synology.com/enu/viewtopic.php?t=90966&start=30 ). I can set up a mysql database on my NAS fine using 3307 as the host port, but when I reenter the preferences dialog in digikam to add collections or adjust settings, it resets to 3306 with without prompting. This causes the database to refuse the connection and returns an error.

Comment 1 caulier.gilles 2017-10-22 12:12:23 UTC

A new fresh 5.8.0 pre-release PKG installer for MacOS was just rebuild for testing and is available here :

https://drive.google.com/drive/folders/0BzeiVr-byqt5Y0tIRWVWelRJenM

Please confirm if the problem remains with this version. 
Thanks in advance

Gilles Caulier

Comment 2 Maik Qualmann 2017-10-25 10:21:07 UTC

This bug has already been fixed. I close this bug as a duplicate.

Maik

*** This bug has been marked as a duplicate of bug 384366 ***

Comment 3 MM 2017-10-25 14:05:06 UTC

Hello, i have tested the installer and it appears that it has resolved the problem with the port remaining set. 

I have not tested extensively however it may have another issue - I launched it with the database connected but without the external drive mounted and the thumbnails did not appear. In previous versions of digikam I could launch without the external drive that stores my photos mounted and as long as the thumbnail database was accessible, the thumbnails would show up.

Comment 4 MM 2017-10-25 14:06:02 UTC

Also thanks for resolving the port remaining set issue. I appreciate your efforts.

Comment 5 caulier.gilles 2018-08-30 17:51:26 UTC

Not reproducible with 6.0.0