Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 11 Dec 2016 15:30:03 +0000
From:      bugzilla-noreply@freebsd.org
To:        freebsd-ports-bugs@FreeBSD.org
Subject:   [Bug 215215] www/nextcloud: PostgreSQL: setup failure, pg_hba.conf: nextcloud db user wants access to "postgres"
Message-ID:  <bug-215215-13@https.bugs.freebsd.org/bugzilla/>

next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D215215

            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@FreeBSD.org
          Reporter: ohartmann@walstatt.org
                CC: loic.blot@unix-experience.fr
             Flags: maintainer-feedback?(loic.blot@unix-experience.fr)
                CC: loic.blot@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 datab=
se
on a PostgreSQL server), www/nextcloud tries to access PostgrSQL's 'postgre=
s'
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 creat=
ed.
The owner is a user 'nextcloudadm' with the priviledge of creating database=
s,
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.

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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-215215-13>