From owner-freebsd-ports-bugs@freebsd.org Sun Dec 11 15:30:04 2016 Return-Path: Delivered-To: freebsd-ports-bugs@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 4E312C72B1E for ; Sun, 11 Dec 2016 15:30:04 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 233CB98D for ; Sun, 11 Dec 2016 15:30:04 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id uBBFU35H082996 for ; Sun, 11 Dec 2016 15:30:04 GMT (envelope-from bugzilla-noreply@freebsd.org) 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" Date: Sun, 11 Dec 2016 15:30:03 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: ohartmann@walstatt.org X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: freebsd-ports-bugs@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter cc flagtypes.name Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 11 Dec 2016 15:30:04 -0000 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.=