Re: Install of pgadmin4 from package fails ...

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!