Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d6phw-0007gZ-G6 for pgadmin-hackers@arkaria.postgresql.org; Sat, 06 May 2017 02:44:32 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d6phw-0000gY-2m for pgadmin-hackers@arkaria.postgresql.org; Sat, 06 May 2017 02:44:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d6phh-0000Hu-U0 for pgadmin-hackers@postgresql.org; Sat, 06 May 2017 02:44:18 +0000 Received: from pb-smtp1.pobox.com ([64.147.108.70] helo=sasl.smtp.pobox.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d6phd-0002k2-7c for pgadmin-hackers@postgresql.org; Sat, 06 May 2017 02:44:17 +0000 Received: from sasl.smtp.pobox.com (unknown [127.0.0.1]) by pb-smtp1.pobox.com (Postfix) with ESMTP id D749C6F666; Fri, 5 May 2017 22:44:09 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=pobox.com; h=subject:to :references:cc:from:message-id:date:mime-version:in-reply-to :content-type:content-transfer-encoding; s=sasl; bh=XoMI2yaJxlnh 8JLKYlbAb8Jq0X0=; b=TKmlXnBCC8sIVyJoopsHuaGGY6VrezhNr5mQz1W+BIjo 2R5nbVJelNm48DWShaBA5lq+3sFcw7xDfxvb08xVzpn4d2f4IwctEqApk1bdD2H+ 6GblPWA2QPdDADOb8uxAuKbnNsxcHWu5aexcXSEYC74w7+oj4tgOAlDvrlWB1IA= Received: from pb-smtp1.nyi.icgroup.com (unknown [127.0.0.1]) by pb-smtp1.pobox.com (Postfix) with ESMTP id CED5C6F665; Fri, 5 May 2017 22:44:09 -0400 (EDT) Received: from redhat.com (unknown [12.130.117.176]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by pb-smtp1.pobox.com (Postfix) with ESMTPSA id 1E39E6F663; Fri, 5 May 2017 22:44:06 -0400 (EDT) Subject: Re: Install of pgadmin4 from package fails ... To: Dave Page References: <8ca2ba41-b46f-a89e-6b1b-4b7277348685@berkus.org> <1492765022.3215.2.camel@gunduz.org> <9d48ca84-daaa-dca4-b6c4-ab7e99e9b74a@berkus.org> <31f14480-46d0-03d8-8f13-b1ff6294f326@berkus.org> <5c1f671e-ef59-ff82-5bd1-d6f9cf22abfd@berkus.org> Cc: =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?= , pgadmin-hackers From: Josh Berkus Message-ID: <5f4b5749-e519-2974-dca4-30e5944158b1@berkus.org> Date: Fri, 5 May 2017 19:43:57 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 MIME-Version: 1.0 In-Reply-To: <5c1f671e-ef59-ff82-5bd1-d6f9cf22abfd@berkus.org> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Pobox-Relay-ID: E0D791E0-3205-11E7-965C-E680B56B9B0B-30013111!pb-smtp1.pobox.com DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=berkus.org; h=subject:to:references:cc:from:message-id:date:mime-version:in-reply-to:content-type:content-transfer-encoding; s=mesmtp; bh=XoMI2yaJxlnh8JLKYlbAb8Jq0X0=; b=vaOuVnM5qPxHEPf0cst16qGRALlmOgMBBvxT2ebrSbbRuPRYXVwxYi+VitIrdcjYpZmgZSDbcOkiSgoX3zAnZvNgTS+Qcyjv2WSqMMkTVj61bTtODTxdgR1DkgfT/1YGiEcErgqFB+3VIoVFB5z5/WZ3549azGFg+MbcpQYhCsU= X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org On 04/25/2017 08:24 AM, Josh Berkus wrote: > On 04/24/2017 01:23 AM, Dave Page wrote: >> There isn't an easy fix for this; on a default Fedora or CentOS system, >> the only directory the apache user has read/write to is /tmp, as far as >> I know. >> >> Ideas? >> >> >> This is covered in the docs: >> https://www.pgadmin.org/docs4/1.x/server_deployment.html >> >> Create a directory, setup the config to use it as required, then chown >> the database after running setup (which is probably easier than trying >> to run it as the apache user directly). >> > > I know how to fix my personal install (and container image). But I want > to fix the RPM package so that it's fixed for most users. Right now, > install from RPM is kind of broken. > > Here's the changes that need to happen on the RPM: > > 1. Remove the QT dependencies for pgadmin4-v1-web > > 2. Have the RPM create /usr/share/httpd/.pgadmin, owned by apache user. > (is this the best location? If not, what is?) > > 3. Fix the systemd unit file so that the pgadmin4 unit is owned by apache. > > 4. (optional) set up files according to FDL standards, putting configs > for pgadmin4 in /etc/pgadmin and the db in /var/run/pgadmin (or similar). > > Devrim, where is the source for this rpm build? > Devrim? -- Josh Berkus Containers & Databases Oh My! -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers