[digikam] [Bug 398288] New: digikam no write access to folder

[Steve Franks]

https://bugs.kde.org/show_bug.cgi?id=398288

Bug ID: 398288
Summary: digikam no write access to folder
Product: digikam
Version: 5.9.0
Platform: Other
OS: Linux
Status: UNCONFIRMED
Severity: grave
Priority: NOR
Component: Database
Assignee: digikam-bugs-***@kde.org
Reporter: ***@gmail.com
Target Milestone: ---

I have just bought a windows 10 laptop and am trying to persuade digital to use
a MySQL database.
External database passes the connection test, but fails to actually connect to
a MariaDB 10.3 database. It does try, repeatedly, but eventually gives up.
The database is localhost, so I thought that I would try the internal MYSQL
option, this fails with the error “You do not seem to have write access for the
folder selected to be the root album”...
I have just copied my photos into the directory, so how can I not have access
to it?
There is an old post from 2009 about this bug, was there a workaround? At
present I am unable to use digital at all.
Should I install version 6?

[Steve Franks]

https://bugs.kde.org/show_bug.cgi?id=398288

Steve Franks <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Platform|Other |MS Windows
OS|Linux |MS Windows

[b***@kde.org]

https://bugs.kde.org/show_bug.cgi?id=398288

***@gmail.com changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@gmail.com
Component|Database |Database-Mysql

--- Comment #1 from ***@gmail.com ---
Install DebugView tool from microsoft, and run it. Start digiKam and look the
debug trace capture by DebugView.

Look here for details:

https://www.digikam.org/contribute/

Gilles Caulier

[Maik Qualmann]

https://bugs.kde.org/show_bug.cgi?id=398288

Maik Qualmann <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@gmail.com

--- Comment #2 from Maik Qualmann <***@gmail.com> ---
I suspect that you mean with digital digiKam. Question: The MySQL database
trying to open already exists and has already been used by digiKam? If no, you
first have to create a database user, create the digiKam database (possibly
also for thumbnails etc.) and assign the rights. Look at the other tabs in the
digiKam database setup, there it will be explained. An alternative would be the
internal MySQL server, here digiKam tries to organize everything itself. But
SQLite is not a bad choice and can even be faster than MYSQL on an SSD.

Maik

[Maik Qualmann]

https://bugs.kde.org/show_bug.cgi?id=398288

--- Comment #8 from Maik Qualmann <***@gmail.com> ---
Folders under C:\ are difficult to create since the launch of the UAC for
programs there. Even if the Explorer can do it and other programs, digiKam does
not get this permission. I can reproduce the problem here. Either another drive
or a directory in the user area.

Maik

[Steve Franks]

https://bugs.kde.org/show_bug.cgi?id=398288

--- Comment #3 from Steve Franks <***@gmail.com> ---
Sorry for the delay in responding. I gave up on Digikam, because of this error
and lack of time to solve the problem.
I've just installed Digikam 6.0.0 Beta 2 and have the same issue. I don't want
the database data in Pictures, so I copied the database to C:\Digikam. I
haven't changed from the default internal MySQL database.(In reply to Maik
Qualmann from comment #2)

Post by Maik Qualmann
I suspect that you mean with digital digiKam. Question: The MySQL database
trying to open already exists and has already been used by digiKam? If no,
you first have to create a database user, create the digiKam database
(possibly also for thumbnails etc.) and assign the rights. Look at the other
tabs in the digiKam database setup, there it will be explained. An
alternative would be the internal MySQL server, here digiKam tries to
organize everything itself. But SQLite is not a bad choice and can even be
faster than MYSQL on an SSD.
Maik

I followed the instructions to the letter, but Digikam still wouldn't use the
MariaDB Database.

[Steve Franks]

https://bugs.kde.org/show_bug.cgi?id=398288

Steve Franks <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@gmail.com

--- Comment #5 from Steve Franks <***@gmail.com> ---
Created attachment 116804
--> https://bugs.kde.org/attachment.cgi?id=116804&action=edit
DebugView output

I don't see anything that would help to solve this problem.

[Steve Franks]

https://bugs.kde.org/show_bug.cgi?id=398288

--- Comment #4 from Steve Franks <***@gmail.com> ---
(In reply to caulier.gilles from comment #1)

Post by b***@kde.org
Install DebugView tool from microsoft, and run it. Start digiKam and look
the debug trace capture by DebugView.
https://www.digikam.org/contribute/
Gilles Caulier

OK, I did that, but I'm none the wiser. DebugView output doesn't seem to
mention my attempt to relocate the database.
I'll attach it if I can.
Steve

[Steve Franks]

https://bugs.kde.org/show_bug.cgi?id=398288

--- Comment #7 from Steve Franks <***@gmail.com> ---
Created attachment 116806
--> https://bugs.kde.org/attachment.cgi?id=116806&action=edit
C:\Digikam Folder Properties

These are the permissions I've granted to the Digikam folder that I would like
to use for my database

[Steve Franks]

https://bugs.kde.org/show_bug.cgi?id=398288

--- Comment #6 from Steve Franks <***@gmail.com> ---
Created attachment 116805
--> https://bugs.kde.org/attachment.cgi?id=116805&action=edit
Digikam error dialog - No Write Access

Screen shot of error dialog from my attempt to relocate Digikam's database to
C:\Digikam