Re: Install pgadmin4 on Fedora 30

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