New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Nextcloud fpm fails to initialize database on clean install #2190
Comments
I see a mix of Windows volumes and Linux volumes in the same compose file. On WSL2 the path to EDIT: i just ran your setup without the volumes and it gave me no errors.
Edit2: You are also probably missing some configs on WSL2. Add this to /etc/wsl.conf
Then open cmd as admin and type wsl --shutdown (or reboot your PC). Then reopen wsl, restart docker and it should be fine. You can google around how to make docker service autostart on wsl startup. |
Hi,
I tried my best to find the issue, but no success. I also analyzed the Dockerfile in the Nextcloud image as well the php base image. The apache image works flawlessly. I tried nginx and caddy as web server for npm but both with same error. I tried MariaDB and Postgres with the same error. I run the docker compose on docker for windows on wsl2
Issue:
I get this error after the login mask for initial installation after I enter the initial admin credentials:
There is no table with name "oc_nas.oc_comments" in the schema.
If I try again I get this:
Insufficient privilege: 7 ERROR: permission denied for table oc_migrations
Postgres log says this:
ERROR: permission denied for table oc_migrations
2024-03-25 10:21:59.138 CET [91] STATEMENT: SELECT "version" FROM "oc_migrations" WHERE "app" = $1 ORDER BY "version" ASC
I also logged the Postgres queries executed by Nextcloud and it hits to this error.
I also found this:
https://help.nextcloud.com/t/permission-denied-for-table-oc-migrations-on-startup/185597 --> did not help
and this:
nextcloud/helm#436 --> they have the same error but with the helm chart
What I also tried:
php occ maintenance:install
--database='pgsql' --database-host='postgres' --database-name='nextcloud'
--database-user='nextcloud' --database-pass='nextcloud'
--admin-user='nextcloud' --admin-pass='nextcloud'
And I hit the same error
I also tried to set the permissions manually with PSQL, but still no success.
I also tried to set the ADMIN ENV variables that it creates the initial user on first start but fails on the same error
Here is the docker compose file I created:
config files, but also if not set, problem still there.
fpm-config:
nginx config:
The text was updated successfully, but these errors were encountered: