[Bug 215215] www/nextcloud: PostgreSQL: setup failure, pg_hba.conf: nextcloud db user wants access to "postgres"

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=215215

            Bug ID: 215215
           Summary: www/nextcloud: PostgreSQL: setup failure, pg_hba.conf:
                    nextcloud db user wants access to "postgres"
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Many People
          Priority: ---
         Component: Individual Port(s)
          Assignee: freebsd-ports-bugs at FreeBSD.org
          Reporter: ohartmann at walstatt.org
                CC: loic.blot at unix-experience.fr
             Flags: maintainer-feedback?(loic.blot at unix-experience.fr)
                CC: loic.blot at unix-experience.fr

Problem: www/nextcloud can not be setup using the webinterface by connecting
and setting up the proper tables via its webinterface. Even if installed
properly according to the installation howto (manually setting up the databse
on a PostgreSQL server), www/nextcloud tries to access PostgrSQL's 'postgres'
database - which is wrong!

Scenario:
Using databases/postgresql9[5|6]-server and client accordingly with the most
recent ports tree (r428351) and the proper www/nextcloud from this revision.

According to nextcloud's howto, a database named 'nextcloud' has been created.
The owner is a user 'nextcloudadm' with the priviledge of creating databases,
and login.

This specific user also has the priviledge to access locally and remotely
reflected by proper entries in pg_hba.conf.

The access with that specific user to the specific database on the host
containing the postgresql database is checked and verified by accessing via
"psql" client.

When it comes to the setup of the tables, one might want to access the
nextcloud instance via web. We already placed as recommended in the HowTo a
config/config.php in the correct path to proceed for the proper setup of the
tables. This fails!

The error shown is that nextcloud's setup script tries to access database
'postgres' - which is wrong!

The installation of www/nextcloud never worked for PostgreSQL and should be
fixed.

-- 
You are receiving this mail because:
You are the assignee for the bug.