Subject: Re: Install of pgadmin4 from package fails ...
To: Dave Page <dpage@pgadmin.org>
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>
 <CA+OCxow7LrDGFbW-zpSy6uD=ddZTdg-yJcsR=B96TszkaxTtPw@mail.gmail.com>
Cc: =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?= <devrim@gunduz.org>,
 pgadmin-hackers <pgadmin-hackers@postgresql.org>
From: Josh Berkus <josh@berkus.org>
Message-ID: <5c1f671e-ef59-ff82-5bd1-d6f9cf22abfd@berkus.org>
Date: Tue, 25 Apr 2017 08:24:22 -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: 
 <CA+OCxow7LrDGFbW-zpSy6uD=ddZTdg-yJcsR=B96TszkaxTtPw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgadmin-hackers-owner@postgresql.org

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?

-- 
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