Subject: Re: Install of pgadmin4 from package fails ...
To: =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?= <devrim@gunduz.org>
References: <8ca2ba41-b46f-a89e-6b1b-4b7277348685@berkus.org>
 <1492765022.3215.2.camel@gunduz.org>
 <9d48ca84-daaa-dca4-b6c4-ab7e99e9b74a@berkus.org>
Cc: pgadmin-hackers <pgadmin-hackers@postgresql.org>
From: Josh Berkus <josh@berkus.org>
Message-ID: <31f14480-46d0-03d8-8f13-b1ff6294f326@berkus.org>
Date: Fri, 21 Apr 2017 14:40:44 -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: <9d48ca84-daaa-dca4-b6c4-ab7e99e9b74a@berkus.org>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgadmin-hackers-owner@postgresql.org

On 04/21/2017 02:14 PM, Josh Berkus wrote:
> On 04/21/2017 01:57 AM, Devrim G=C3=BCnd=C3=BCz wrote:
>> On RHEL 7 / Fedora 25:
>>
>> * systemctl enable pgadmin4-v1.service; systemctl start pgadmin4-v1.serv=
ice
>> * cp /etc/httpd/conf.d/pgadmin4-v1.conf.sample /etc/httpd/conf.d/pgadmin=
4-
>> v1.conf
>> * systemctl start httpd.service
>>
>> should be enough, at least this is what I just tested on my Fedora 25 bo=
x.
>=20
> So I just tried this, and it doesn't do any of the setup.
>=20
> There's no config_local, and as far as I can tell the database isn't
> created.  It's hard to know for sure, though, because without a
> config_local I'm not sure where it would be located.
>=20
> Error: [Fri Apr 21 21:02:32.080337 2017] [wsgi:error] [pid 26] [remote
> 76.115.138.49:35628] FileNotFoundError: [Errno 2] No such file or
> directory: '/usr/share/httpd/.pgadmin/pgadmin4.log'
>=20
> ... certainly there is no /usr/share/httpd/.pgadmin directory
>=20

Aha, here's the problem.  Setup is getting run as root, not as the user
httpd.  This means it's dropping .pgadmin into /root/, which the web
server can't access; it's "home" directory is /usr/share/httpd.
However, that directory isn't writable by the apache user, either.

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?

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