Subject: Re: Install of pgadmin4 from package fails ...
To: =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?= <devrim@gunduz.org>,
 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>
 <5c1f671e-ef59-ff82-5bd1-d6f9cf22abfd@berkus.org>
 <1494241045.2858.27.camel@gunduz.org>
Cc: pgadmin-hackers <pgadmin-hackers@postgresql.org>
From: Josh Berkus <josh@berkus.org>
Message-ID: <317e830d-ca50-4d6a-cf55-e5f9471071f0@berkus.org>
Date: Mon, 8 May 2017 10:20:45 -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: <1494241045.2858.27.camel@gunduz.org>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgadmin-hackers-owner@postgresql.org

On 05/08/2017 03:57 AM, Devrim G=C3=BCnd=C3=BCz wrote:
>=20
> Hi Josh,
>=20
> Sorry for the late response, I have 10K unread emails as of now:
>=20
> On Tue, 2017-04-25 at 08:24 -0700, Josh Berkus wrote:
>=20
>> 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
>=20
> 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?)
>=20
> 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 apach=
e.
>=20
> Why? I did not read all the emails in this thread (yet), but all of the u=
nit
> 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).
>=20
> 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.

>=20
>> Devrim, where is the source for this rpm build?
>=20
> 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.


--=20
Josh Berkus
Containers & Databases Oh My!


--=20
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers