[digiKam-users] What are correct permissions for /var/lib/mysql?

[Steven Gaffagan]

Greetings,

Installed digikam in Arch Linux. Set up mariadb and got it running. I am
trying to use the internal server option for mariadb. However, when I
launched digikam I received:

An error occurred during the internal server start.
Details: Cannot create directory /var/lib/mysql/.mysql.digikam/db_data

I went back and created that: sudo /usr/bin/mysqld_safe
--datadir='/var/lib/mysql/.mysql.digikam/db_data'

Still received same error message.

The owner and group of the file were mysql. Changing permissions: sudo
chmod 777 -R mysql/ allowed digikam to launch without error.

I searched the last 4 months of the mailing list and didn't see a post
on permissions. Also, do I need to set up a user in mariadb that matches
the user name accessing digikam? Apologies if this has been asked a
bunch of times already.

Please advise & thank you.

[Gerhard Hoogterp]

On dinsdag 29 januari 2019 20:00:47 CET Steven Gaffagan wrote:

> Greetings,
>
> Installed digikam in Arch Linux. Set up mariadb and got it running. I am
> trying to use the internal server option for mariadb. However, when I
> launched digikam I received:
>
> An error occurred during the internal server start.
> Details: Cannot create directory /var/lib/mysql/.mysql.digikam/db_data
>
> I went back and created that: sudo /usr/bin/mysqld_safe
> --datadir='/var/lib/mysql/.mysql.digikam/db_data'
>
> Still received same error message.
>
> The owner and group of the file were mysql. Changing permissions: sudo
> chmod 777 -R mysql/ allowed digikam to launch without error.

would chown -R mysql:mysql /path/to/directory help?

https://askubuntu.com/questions/295457/mysql-datadir-on-different-hard-drive


--
https://gerhardhoogterp.nl/latest

[Gerhard Hoogterp]

> > The owner and group of the file were mysql. Changing permissions: sudo
> > chmod 777 -R mysql/ allowed digikam to launch without error.
>
> would chown -R mysql:mysql /path/to/directory help?

In which case a 755 should do..

>
> https://askubuntu.com/questions/295457/mysql-datadir-on-different-hard-drive


--
https://gerhardhoogterp.nl/latest

[Steven Gaffagan]

I tried your suggestions (chown -R mysql:mysql with a 755 permission
setting) but the error messaged returns.


On 1/29/19 11:17 AM, Gerhard Hoogterp wrote:

> On dinsdag 29 januari 2019 20:00:47 CET Steven Gaffagan wrote:
>> Greetings,
>>
>> Installed digikam in Arch Linux. Set up mariadb and got it running. I am
>> trying to use the internal server option for mariadb. However, when I
>> launched digikam I received:
>>
>> An error occurred during the internal server start.
>> Details: Cannot create directory /var/lib/mysql/.mysql.digikam/db_data
>>
>> I went back and created that: sudo /usr/bin/mysqld_safe
>> --datadir='/var/lib/mysql/.mysql.digikam/db_data'
>>
>> Still received same error message.
>>
>> The owner and group of the file were mysql. Changing permissions: sudo
>> chmod 777 -R mysql/ allowed digikam to launch without error.
> would chown -R mysql:mysql /path/to/directory help?
>
> https://askubuntu.com/questions/295457/mysql-datadir-on-different-hard-drive
>
>

[digikam-2]

On Tue, 29 Jan 2019 11:38:21 -0800
Steven Gaffagan <[hidden email]> wrote:

> I tried your suggestions (chown -R mysql:mysql with a 755
> permission setting) but the error messaged returns.

I had similar problems. I never got it working as internal.

It turns out that you are better off use the mysql external. So first
you need to set mysql/mariadb on your system. then you can use mysql.

Dmitri Popov has a good write-up, except his setup is for a nas.
It's the same but with your local wks.

https://scribblesandsnaps.com/2018/10/19/use-digikam-with-a-nas-and-mariadb/

>
>
> On 1/29/19 11:17 AM, Gerhard Hoogterp wrote:
> > On dinsdag 29 januari 2019 20:00:47 CET Steven Gaffagan wrote:  
> >> Greetings,
> >>
> >> Installed digikam in Arch Linux. Set up mariadb and got it
> >> running. I am trying to use the internal server option for
> >> mariadb. However, when I launched digikam I received:
> >>
> >> An error occurred during the internal server start.
> >> Details: Cannot create
> >> directory /var/lib/mysql/.mysql.digikam/db_data
> >>
> >> I went back and created that: sudo /usr/bin/mysqld_safe
> >> --datadir='/var/lib/mysql/.mysql.digikam/db_data'
> >>
> >> Still received same error message.
> >>
> >> The owner and group of the file were mysql. Changing
> >> permissions: sudo chmod 777 -R mysql/ allowed digikam to launch
> >> without error.  
> > would chown -R mysql:mysql /path/to/directory help?
> >
> > https://askubuntu.com/questions/295457/mysql-datadir-on-different-hard-drive
> >
> >  

--
sknahT

vyS

[Maik Qualmann]

What's wrong, digiKam does not create anything in "/var/lib/mysql/". The
database folder is either the image collection folder or a folder in which the
user has all rights (home folder). Everything else digikam created
$HOME/.local/share/digikam.

Maik

Am Dienstag, 29. Januar 2019, 20:00:47 CET schrieb Steven Gaffagan:

> Greetings,
>
> Installed digikam in Arch Linux. Set up mariadb and got it running. I am
> trying to use the internal server option for mariadb. However, when I
> launched digikam I received:
>
> An error occurred during the internal server start.
> Details: Cannot create directory /var/lib/mysql/.mysql.digikam/db_data
>
> I went back and created that: sudo /usr/bin/mysqld_safe
> --datadir='/var/lib/mysql/.mysql.digikam/db_data'
>
> Still received same error message.
>
> The owner and group of the file were mysql. Changing permissions: sudo
> chmod 777 -R mysql/ allowed digikam to launch without error.
>
> I searched the last 4 months of the mailing list and didn't see a post
> on permissions. Also, do I need to set up a user in mariadb that matches
> the user name accessing digikam? Apologies if this has been asked a
> bunch of times already.
>
> Please advise & thank you.