public inbox for [email protected]  

help / color / mirror / Atom feed

From: Josh Berkus <[email protected]>
To: Devrim Gündüz <[email protected]>
To: Dave Page <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Subject: Re: Install of pgadmin4 from package fails ...
Date: Mon, 8 May 2017 10:20:45 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<CA+OCxow7LrDGFbW-zpSy6uD=ddZTdg-yJcsR=B96TszkaxTtPw@mail.gmail.com>
	<[email protected]>
	<[email protected]>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgadmin-hackers>

On 05/08/2017 03:57 AM, Devrim Gündüz wrote:
> 
> Hi Josh,
> 
> Sorry for the late response, I have 10K unread emails as of now:
> 
> On Tue, 2017-04-25 at 08:24 -0700, Josh Berkus wrote:
> 
>> 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
> 
> Why? I thought we need them to run pgadmin4?

Not for pgadmin-web, see upthread.  Just for the desktop version.

And pulling in QT on RH/Fedora means pulling in all of Xorg, some 200MB
of additional packages.

>> 2. Have the RPM create /usr/share/httpd/.pgadmin, owned by apache user.
>>    (is this the best location?  If not, what is?)
> 
> Good question. I think that location is good.

Going to go back on this, because I looked at Freedesktop standards.  It
should go in /var/lib/pgadmin or /var/run/pgadmin. This will mean
creating a config_local.py file to support this.

>> 3. Fix the systemd unit file so that the pgadmin4 unit is owned by apache.
> 
> Why? I did not read all the emails in this thread (yet), but all of the unit
> files are owned by root, and I see no exception on my system.

Not the file itself, the *process*.  Right how you have the process
starting as root, which means that the permissions on the pgadmin
database are set wrong.

>> 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).
> 
> Red Hat does not care about that that much, does it? Especially for /etc part.

True about the /etc/ part.  However, I can tell you that RH is pushing
security standards where nothing can write to /usr/ or /opt/ at runtime,
so I don't want to put the db in either of those master directories.

> 
>> Devrim, where is the source for this rpm build?
> 
> https://yum.postgresql.org/srpms/testing/10/redhat/rhel-7-x86_64/repoview/pgadmin4-v1.html

No, I mean the rpm template files, not the source of the software.


-- 
Josh Berkus
Containers & Databases Oh My!


-- 
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

view thread (18+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Install of pgadmin4 from package fails ...
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox