Re: Install pgadmin4 on Fedora 30 - Mailing list pgadmin-support

From Michael Monerau
Subject Re: Install pgadmin4 on Fedora 30
Date
Msg-id CAOpvgNdyxexajyw=oHUh4QJ0tmPHY+mcBJghBt+foM2RepM+BA@mail.gmail.com
Whole thread Raw
In response to Re: Install pgadmin4 on Fedora 30  (Devrim Gündüz <devrim@gunduz.org>)
Responses Re: Install pgadmin4 on Fedora 30  (Michael Monerau <michael.monerau@gmail.com>)
List pgadmin-support
Hi,

Thanks for the quick update!
Unfortunately, it still gives the errors below on my Fedora 30 in the httpd error log.

I tried to understand what's going on, but in vain.
I verified that the python script correctly runs as `apache` user, it does. If I try to chmod through command line myself as the `apache` user, it works ok (as it should!). But somehow, it fails when called from inside the wsgi.

I guess this has to do with some Apache config that I have different from you by default?
Does anybody know where to look to find this config?

Thanks,
Michael

###
[Thu May 23 18:35:18.258836 2019] [core:notice] [pid 7402:tid 139830674198848] SELinux policy enabled; httpd running as context system_u:system_r:httpd_t:s0
[Thu May 23 18:35:18.260143 2019] [suexec:notice] [pid 7402:tid 139830674198848] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu May 23 18:35:18.269186 2019] [so:warn] [pid 7402:tid 139830674198848] AH01574: module wsgi_module is already loaded, skipping
AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using localhost.localdomain. Set the 'ServerName' directive globally to suppress this message
[Thu May 23 18:35:18.270012 2019] [lbmethod_heartbeat:notice] [pid 7402:tid 139830674198848] AH02282: No slotmem from mod_heartmonitor
[Thu May 23 18:35:18.270343 2019] [http2:warn] [pid 7402:tid 139830674198848] AH02951: mod_ssl does not seem to be enabled
[Thu May 23 18:35:18.272382 2019] [mpm_event:notice] [pid 7402:tid 139830674198848] AH00489: Apache/2.4.39 (Fedora) mod_wsgi/4.6.4 Python/3.7 configured -- resuming normal operations
[Thu May 23 18:35:18.272394 2019] [core:notice] [pid 7402:tid 139830674198848] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu May 23 18:35:18.274994 2019] [:warn] [pid 7404:tid 139830674198848] ./mod_dnssd.c: No services found to register
[Thu May 23 18:35:33.021413 2019] [wsgi:error] [pid 7405:tid 139830615561984] [remote 127.0.0.1:45386] mod_wsgi (pid=7405): Failed to exec Python script file '/usr/lib/python3.7/site-packages/pgadmin4-web/pgAdmin4.wsgi'.
[Thu May 23 18:35:33.021446 2019] [wsgi:error] [pid 7405:tid 139830615561984] [remote 127.0.0.1:45386] mod_wsgi (pid=7405): Exception occurred processing WSGI script '/usr/lib/python3.7/site-packages/pgadmin4-web/pgAdmin4.wsgi'.
[Thu May 23 18:35:33.021736 2019] [wsgi:error] [pid 7405:tid 139830615561984] [remote 127.0.0.1:45386] Traceback (most recent call last):
[Thu May 23 18:35:33.021754 2019] [wsgi:error] [pid 7405:tid 139830615561984] [remote 127.0.0.1:45386]   File "/usr/lib/python3.7/site-packages/pgadmin4-web/pgAdmin4.wsgi", line 36, in <module>
[Thu May 23 18:35:33.021758 2019] [wsgi:error] [pid 7405:tid 139830615561984] [remote 127.0.0.1:45386]     from pgAdmin4 import app as application
[Thu May 23 18:35:33.021761 2019] [wsgi:error] [pid 7405:tid 139830615561984] [remote 127.0.0.1:45386]   File "/usr/lib/python3.7/site-packages/pgadmin4-web/pgAdmin4.py", line 97, in <module>
[Thu May 23 18:35:33.021763 2019] [wsgi:error] [pid 7405:tid 139830615561984] [remote 127.0.0.1:45386]     app = create_app()
[Thu May 23 18:35:33.021765 2019] [wsgi:error] [pid 7405:tid 139830615561984] [remote 127.0.0.1:45386]   File "/usr/lib/python3.7/site-packages/pgadmin4-web/pgadmin/__init__.py", line 241, in create_app
[Thu May 23 18:35:33.021768 2019] [wsgi:error] [pid 7405:tid 139830615561984] [remote 127.0.0.1:45386]     create_app_data_directory(config)
[Thu May 23 18:35:33.021770 2019] [wsgi:error] [pid 7405:tid 139830615561984] [remote 127.0.0.1:45386]   File "/usr/lib/python3.7/site-packages/pgadmin4-web/pgadmin/setup/data_directory.py", line 24, in create_app_data_directory
[Thu May 23 18:35:33.021773 2019] [wsgi:error] [pid 7405:tid 139830615561984] [remote 127.0.0.1:45386]     os.chmod(os.path.dirname(config.SQLITE_PATH), 0o700)
[Thu May 23 18:35:33.021790 2019] [wsgi:error] [pid 7405:tid 139830615561984] [remote 127.0.0.1:45386] PermissionError: [Errno 13] Permission denied: '/var/lib/pgadmin'
###

Le jeu. 23 mai 2019 à 10:33, Devrim Gündüz <devrim@gunduz.org> a écrit :

Hi Michael,

On Wed, 2019-05-22 at 14:29 +0200, Michael Monerau wrote:

> I went through the install process you describe on your website (
> https://people.planetpostgresql.org/devrim/index.php?/archives/96-Installing-pgAdmin4-3.X-on-RHEL-CentOS-7-and-Fedora-27.html)
> but couldn't get it to work.
>
> 1. Small typo in the install script pgadmin4-web-setup.sh: PGADMIN4INSTDIR
> is not known (miss a `$`). I replaced with the full path of the install on
> my system (/usr/lib/python3.7/site-packages/pgadmin4-web/) but I guess
> there is a cleaner way to be more general in the install.
>
> 2. The webserver fails to serve the website, and I get that from httpd log:

<snip>

Just pushed 4.6-2 packages to repos, which should fix this issue (at least it
fixed on my Fedora 30 box).

They will be available in 1 hour from now.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

pgadmin-support by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: Install pgadmin4 on Fedora 30
Next
From: Michael Monerau
Date:
Subject: Re: Install pgadmin4 on Fedora 30