Postgres Pro
Downloads
Home   >   mailing lists

Thread: fedora29 repo still serving up pgadmin4.4

fedora29 repo still serving up pgadmin4.4

From
Derrick Rice
Date:
The fedora29 repo is still serving up pgadmin4.4

Which is broken due to psycopg2 dependency issues.

Where can I get pgadmin 4.5 (or later) as an RPM , suitable for Fedora?

I've tried to crawl the yum host itself with no luck.

- Derrick

Re: fedora29 repo still serving up pgadmin4.4

From
Derrick Rice
Date:
Will give it a shot.

The rpm repos are hosted by the postgresql community, though, yeah? Is pushing rpms to these repos not part of the release process ? It’s odd to see announcements of the release of 4.5 and 4.6 but no means of getting it.

On Thu, May 16, 2019 at 16:33 <michael.eschweiler@web.de> wrote:
Did you try:
perhaps you are lucky and can find it there.
 
There are rpm-packages of pgadmin4.5 for opensuse at
but I can't tell if the will work with fedora...
 
Regards,
Michael
 
Gesendet: Donnerstag, 16. Mai 2019 um 11:34 Uhr
Von: "Derrick Rice" <derrick.rice@gmail.com>
An: pgadmin-support@lists.postgresql.org
Betreff: fedora29 repo still serving up pgadmin4.4
The fedora29 repo is still serving up pgadmin4.4
 
Which is broken due to psycopg2 dependency issues.
 
Where can I get pgadmin 4.5 (or later) as an RPM , suitable for Fedora?
 
I've tried to crawl the yum host itself with no luck.
 
- Derrick

Re: fedora29 repo still serving up pgadmin4.4

From
Michael Eschweiler
Date:
... I forgot: You could try alien in order to convert other package
formats like .deb to rpm...

Am 16.05.19 um 14:47 schrieb Derrick Rice:
> Will give it a shot.
>
> The rpm repos are hosted by the postgresql community, though, yeah? Is
> pushing rpms to these repos not part of the release process ? It’s odd
> to see announcements of the release of 4.5 and 4.6 but no means of
> getting it.
>
> On Thu, May 16, 2019 at 16:33 <michael.eschweiler@web.de
> <mailto:michael.eschweiler@web.de>> wrote:
>
>     Did you try:
>     http://rpm.pbone.net/
>     perhaps you are lucky and can find it there.
>      
>     There are rpm-packages of pgadmin4.5 for opensuse at
>     https://software.opensuse.org/package/pgadmin4
>     but I can't tell if the will work with fedora...
>      
>     Regards,
>     Michael
>      
>     *Gesendet:* Donnerstag, 16. Mai 2019 um 11:34 Uhr
>     *Von:* "Derrick Rice" <derrick.rice@gmail.com
>     <mailto:derrick.rice@gmail.com>>
>     *An:* pgadmin-support@lists.postgresql.org
>     <mailto:pgadmin-support@lists.postgresql.org>
>     *Betreff:* fedora29 repo still serving up pgadmin4.4
>     The fedora29 repo is still serving up pgadmin4.4
>      
>     Which is broken due to psycopg2 dependency issues.
>      
>     Where can I get pgadmin 4.5 (or later) as an RPM , suitable for Fedora?
>      
>     I've tried to crawl the yum host itself with no luck.
>      
>     - Derrick
>

Re: fedora29 repo still serving up pgadmin4.4

From
Derrick Rice
Date:
CC'ing devrim@gunduz.org, frequent and recent contributor (owner?) of pgrpms.

(sorry for the direct message; unsure if you're on this list)


On Thu, May 16, 2019 at 1:34 PM Derrick Rice <derrick.rice@gmail.com> wrote:
The fedora29 repo is still serving up pgadmin4.4

Which is broken due to psycopg2 dependency issues.

Where can I get pgadmin 4.5 (or later) as an RPM , suitable for Fedora?

I've tried to crawl the yum host itself with no luck.

- Derrick

Re: fedora29 repo still serving up pgadmin4.4

From
Devrim Gündüz
Date:
Hi,

On Thu, 2019-05-16 at 13:34 -0400, Derrick Rice wrote:
> The fedora29 repo is still serving up pgadmin4.4
>
> Which is broken due to psycopg2 dependency issues.
>
> Where can I get pgadmin 4.5 (or later) as an RPM , suitable for Fedora?

I pushed 4.6 to repos. Sorry for the delay.

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

Re: fedora29 repo still serving up pgadmin4.4

From
Michael Monerau
Date:
Hi,

Thanks very much!

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:

###
[Wed May 22 11:31:03.317345 2019] [wsgi:error] [pid 26817:tid 139957253187328] [remote 127.0.0.1:46516] mod_wsgi (pid=26817): Failed to exec Python script file '/usr/lib/python3.7/site-packages/pgadmin4-web/pgAdmin4.wsgi'.
[Wed May 22 11:31:03.317376 2019] [wsgi:error] [pid 26817:tid 139957253187328] [remote 127.0.0.1:46516] mod_wsgi (pid=26817): Exception occurred processing WSGI script '/usr/lib/python3.7/site-packages/pgadmin4-web/pgAdmin4.wsgi'.
[Wed May 22 11:31:03.317666 2019] [wsgi:error] [pid 26817:tid 139957253187328] [remote 127.0.0.1:46516] Traceback (most recent call last):
[Wed May 22 11:31:03.317684 2019] [wsgi:error] [pid 26817:tid 139957253187328] [remote 127.0.0.1:46516]   File "/usr/lib/python3.7/site-packages/pgadmin4-web/pgAdmin4.wsgi", line 36, in <module>
[Wed May 22 11:31:03.317688 2019] [wsgi:error] [pid 26817:tid 139957253187328] [remote 127.0.0.1:46516]     from pgAdmin4 import app as application
[Wed May 22 11:31:03.317691 2019] [wsgi:error] [pid 26817:tid 139957253187328] [remote 127.0.0.1:46516]   File "/usr/lib/python3.7/site-packages/pgadmin4-web/pgAdmin4.py", line 97, in <module>
[Wed May 22 11:31:03.317708 2019] [wsgi:error] [pid 26817:tid 139957253187328] [remote 127.0.0.1:46516]     app = create_app()
[Wed May 22 11:31:03.317712 2019] [wsgi:error] [pid 26817:tid 139957253187328] [remote 127.0.0.1:46516]   File "/usr/lib/python3.7/site-packages/pgadmin4-web/pgadmin/__init__.py", line 241, in create_app
[Wed May 22 11:31:03.317714 2019] [wsgi:error] [pid 26817:tid 139957253187328] [remote 127.0.0.1:46516]     create_app_data_directory(config)
[Wed May 22 11:31:03.317717 2019] [wsgi:error] [pid 26817:tid 139957253187328] [remote 127.0.0.1:46516]   File "/usr/lib/python3.7/site-packages/pgadmin4-web/pgadmin/setup/data_directory.py", line 24, in create_app_data_directory
[Wed May 22 11:31:03.317719 2019] [wsgi:error] [pid 26817:tid 139957253187328] [remote 127.0.0.1:46516]     os.chmod(os.path.dirname(config.SQLITE_PATH), 0o700)
[Wed May 22 11:31:03.317727 2019] [wsgi:error] [pid 26817:tid 139957253187328] [remote 127.0.0.1:46516] PermissionError: [Errno 13] Permission denied: '/var/lib/pgadmin'
###

I checked /var/lib/pgadmin permissions and seems right to me (the sh script sets the chown on `apache`):

drwx------.  4 apache   apache   4096 May 22 11:30 pgadmin


Is there something to do with the apache user to solve this permission issue?

Thanks again,
Michael

Le mer. 22 mai 2019 à 07:00, Devrim Gündüz <devrim@gunduz.org> a écrit :

Hi,

On Thu, 2019-05-16 at 13:34 -0400, Derrick Rice wrote:
> The fedora29 repo is still serving up pgadmin4.4
>
> Which is broken due to psycopg2 dependency issues.
>
> Where can I get pgadmin 4.5 (or later) as an RPM , suitable for Fedora?

I pushed 4.6 to repos. Sorry for the delay.

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