Installing Nextclound APP on Trunas Scale - Problem on initial startup SQLSTATE[42501]

[AlexJa]

Hi all,

I have a problem - after installing Nextcloud (APP) on Trunas I can access the initial Dialog - but on the very next page, I get an Error:

Error while trying to initialise the database: An exception occurred while executing a query: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for table oc_migrations

It seems to me like a problem with the permissions on the PostgreSQL database - but how can I fix this?

Has anyone recently come to the same error?

Trunas: 25.10.2 - Goldeye
Nextcloud: App Version: 32.0.6
Version: 2.2.2

[LarsR]

postgres needs permissions for uid 999 set. In truenas that id correlates to the buildin netdata user. give that user permissions and it should work.

[AlexJa]

Mights sounds stupid - but how to set this - out in a shell? for what file/dir?

[LarsR]

Through the truenas gui and on the Dataset you used for the postgres db

Edit:
Or edit the nextcloud app and under the storage tab is an option to enable acls.

[AlexJa]

in the App configuration - auto permission is set on the postgresql dataset.

In the host dataset I did set User/Group/Other to R/W/X (999)

so far no luck

[AlexJa]

Anyone - any idea - it looks to me like a problem with the database - but how to fix?