Skip to content
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

[Bug]: Postgresql 15 (Debian12) does not allow user to create public tables - hence halting the Nextcloud 27 installation #39654

Closed
5 of 8 tasks
computyx opened this issue Aug 1, 2023 · 3 comments
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 27-feedback bug feature: install and update needs info stale Ticket or PR with no recent activity

Comments

@computyx
Copy link

computyx commented Aug 1, 2023

⚠️ This issue respects the following points: ⚠️

Bug description

After installing the Debian 12, apache (or nginx), php, postgresql - at the first stage during the web install -
I get this message:

"Error
Error while trying to initialise the database: An exception occurred while executing a query: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for schema public LINE 1: CREATE TABLE oc_migrations (app VARCHAR(255) NOT NULL, versi... ^

Create an admin account "

It seem this is an ISSUE with POSTGRESQL 15 (which is the default version in Debian 12) - there are reports that there are differences between Posgresql 14 and 15 ---- therefore the install scripts should be updated to address this issue.

Steps to reproduce

  1. Install Debian 12 AMD64
  2. Install Postgresql (15 as default)
  3. Install dependencies php and webserver ( We tried both with Apache and NGINX)
    4.During the first web install - we get the error above halting the installation

it seem this is the issue which the new nextcloud installation script should consider as POSTGRESQL 15 public schema access is changed. The following link describes the differences between Postgresql 14 and 15.

https://www.cybertec-postgresql.com/en/error-permission-denied-schema-public/

Expected behavior

the web installer phase should go through after entering the login username password, database name, database user

Installation method

Community Manual installation with Archive

Nextcloud Server version

27

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.2

Web server

Apache (supported)

Database engine version

PostgreSQL

Is this bug present after an update or on a fresh install?

Fresh Nextcloud Server install

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

  • Default user-backend (database)
  • LDAP/ Active Directory
  • SSO - SAML
  • Other

Configuration report

No response

List of activated Apps

No response

Nextcloud Signing status

No response

Nextcloud Logs

No response

Additional info

No response

@computyx computyx added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels Aug 1, 2023
@fenvarien
Copy link

https://www.cybertec-postgresql.com/en/error-permission-denied-schema-public/

@joshtrichards
Copy link
Member

joshtrichards commented Jun 18, 2024

Are you entering the db admin credentials and allowing Nextcloud to create its own db account or are you attempting to use an existing less privileged nextcloud specific account you've created?

There are different behaviors, depending.

https://docs.nextcloud.com/server/latest/admin_manual/installation/installation_wizard.html#database-choice
https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/linux_database_configuration.html#postgresql-database

We already adjusted the docs+code back in v25 to accommodate this otherwise - e.g. #34645 and nextcloud/documentation#9227

@nextcloud-command
Copy link
Contributor

This issue has been automatically marked as stale because it has not had recent activity and seems to be missing some essential information. It will be closed if no further activity occurs. Thank you for your contributions.

@nextcloud-command nextcloud-command added the stale Ticket or PR with no recent activity label Jul 19, 2024
@nextcloud-command nextcloud-command closed this as not planned Won't fix, can't repro, duplicate, stale Aug 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 27-feedback bug feature: install and update needs info stale Ticket or PR with no recent activity
Projects
None yet
Development

No branches or pull requests

5 participants