Re: Install pgadmin4 on Fedora 30

Also FYI, for the performance issue, I ran into it again this morning.
A simple "service postgresql restart" solved the issue.

If you want some diag info next time it occurs, let me know.

Best,
Michael

Le ven. 24 mai 2019 à 10:52, Michael Monerau <michael(dot)monerau(at)gmail(dot)com> a
écrit :

> Nope, didn't help (I also tried to disable addons).
>
> When trying to login, the sent requests are:
>
> [image: image.png]
>
> and the two repeating requests are:
>
> [image: image.png]
>
> [image: image.png]
>
> Hope it helps to debug,
> Michael
>
> Le ven. 24 mai 2019 à 01:11, Murtuza Zabuawala <
> murtuza(dot)zabuawala(at)enterprisedb(dot)com> a écrit :
>
>> Have you tried after removing browser cache?
>>
>>
>> https://www.getfilecloud.com/blog/2015/03/tech-tip-how-to-do-hard-refresh-in-browsers/#.XOcoEfdX5-E
>>
>>
>> On Fri, 24 May 2019, 00:39 Michael Monerau, <michael(dot)monerau(at)gmail(dot)com>
>> wrote:
>>
>>> Well, the performance issue seems to be gone.
>>>
>>> The only thing I can think of that would have solved the issue is I
>>> added the following to pg_hba.conf:
>>> local all postgres md5
>>> host all postgres md5
>>>
>>> and restart the postgresql service.
>>>
>>> Hope it really fixed the issue and it can help somebody going through
>>> that also.
>>> (but Chrome still broken FYI).
>>>
>>> Best,
>>> Michael
>>>
>>>
>>> Le jeu. 23 mai 2019 à 20:35, Michael Monerau <michael(dot)monerau(at)gmail(dot)com>
>>> a écrit :
>>>
>>>> Ok, found the issue (but now am stuck with a big performance issue, see
>>>> below).
>>>>
>>>> It had to do with SELinux, which was blocking the access to the files
>>>> because they are not decorated with the proper types. Based on the results
>>>> from `/var/log/audit/audit.log` and the actual types of /var/lib/httpd and
>>>> /var/log/httpd, I did the following, which could be useful to incorporate
>>>> in the install script (or put in a README somewhere?):
>>>>
>>>> ```
>>>> sudo setsebool -P httpd_can_network_connect 1
>>>> sudo setsebool -P httpd_can_network_connect_db 1
>>>> sudo semanage fcontext -a -t httpd_var_lib_t '/var/lib/pgadmin(/.*)?'
>>>> sudo restorecon -R -v /var/lib/pgadmin
>>>> sudo semanage fcontext -a -t httpd_log_t '/var/log/pgadmin(/.*)?'
>>>> sudo restorecon -R -v /var/log/pgadmin
>>>> ```
>>>>
>>>> And now localhost/pgadmin4 properly loads.
>>>>
>>>> Unfortunately, I run into 2 new issues:
>>>> - The module doesn't work on Chrome (stays on the login page, 302
>>>> redirections seem to stay stuck on the login page). But works ok in Firefox.
>>>> - In Firefox, when connecting to the database, it takes forever to
>>>> open the tree elements, and times out after a few minutes. But the
>>>> databases are correctly recognized. I'm not sure how to investigate this
>>>> issue. Any idea? I see this thread, but can't find a solution in it (
>>>> https://www.postgresql-archive.org/quot-pgadmin4-quot-slow-td5966570.html)
>>>> I'm interested to help debunk the issue. Note if it helps: pgadmin3 works
>>>> well.
>>>>
>>>> Best,
>>>> Michael
>>>>
>>>> Le jeu. 23 mai 2019 à 19:20, Michael Monerau <michael(dot)monerau(at)gmail(dot)com>
>>>> a écrit :
>>>>
>>>>> 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(at)gunduz(dot)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
>>>>>>
>>>>>