Arch Linux

carbon64

Member

Registered: 2012-03-23

Posts: 13

Permissions for /var/lib/mysql in digikam

Greetings,

Installed digikam 5.9.0-4 in Arch Linux. Set up mariadb 10.3.12-5 and got it running. I am trying to use the internal server option in digikam. 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. (My user account includes mysql group). Changing permissions of /var/lib/mysql:

sudo chmod 777 -R mysql/

allowed digikam to launch without error.

I searched the last 4 months of the digikam mailing list and didn't see a post on permissions. Questions:
1. Do I need to set up a user in mariadb that matches the user name accessing digikam? (I did that and it still returns original error when permissions are set at 700).
2. What are the correct permissions for the /var/lib/mysql? (Should they have been set by the program - or manually?)

Please advise & thank you.