Re: Pgadmin4 Debian - Mailing list pgadmin-support

From Dave Page
Subject Re: Pgadmin4 Debian
Date
Msg-id CA+OCxoxT4+n0=4xC=Sg8GZBynbX-udyDvJmqKCZJsqfHbLqx3Q@mail.gmail.com
Whole thread Raw
In response to Re: Pgadmin4 Debian  (Mark Murawski <markm-lists@intellasoft.net>)
List pgadmin-support
Hi

On Fri, May 1, 2020 at 5:05 PM Mark Murawski <markm-lists@intellasoft.net> wrote:
Hi Dave,

Thanks!

Starting up /usr/pgadmin4/bin/pgadmin4 from the snapshot does work.
Installing the packages I hit a dependency that was missing:
libapache2-mod-wsgi-py3

I've installed libapache2-mod-wsgi-py3 and the pgadmin4 packages from
your link.  This works!

Thanks for the feedback. I don't think that would be a problem once the packages are available in a repo rather than just for download, as libapache2-mod-wsgi-py3 is declared as a dependency in the -web package.
 

I wonder if this was what was causing pgadmin4 from apt.postgresql.org/
to not start.

I doubt it. The packages I pointed you to are completely written by scratch, by me. The ones on apt.postgresql.org are very different.
 



On 2020-04-30 15:07, Dave Page wrote:
> Hi
>
> On Thu, Apr 30, 2020 at 5:52 PM Mark Murawski
> <markm-lists@intellasoft.net <mailto:markm-lists@intellasoft.net>> wrote:
>
>     Apologies for responding to my own post... but, this is definitely
>     weird
>     behavior that out of the box pgadmin4 fails to start.
>
>
> The dev team don't maintain those packages, but we do have some
> experimental builds of our own. Can you test them?
>
> https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2020-04-30/
>
>
>
>
>     On 2020-04-22 12:42, Mark Murawski wrote:
>      > Hi!
>      >
>      > pgadmin4 does not start up on debian buster
>      >
>      > Process:
>      > apt-get install pgadmin4
>      >
>      > Get:2 http://apt.postgresql.org/pub/repos/apt buster-pgdg/main amd64
>      > pgadmin4 amd64 4.18-1.pgdg100+1 [272 kB]
>      > Get:3 http://apt.postgresql.org/pub/repos/apt buster-pgdg/main amd64
>      > pgadmin4-common all 4.18-1.pgdg100+1 [3045 kB]
>      >
>      > $ pgadmin4
>      > QStandardPaths: XDG_RUNTIME_DIR not set, defaulting to
>     '/tmp/runtime-kobaz'
>      > Python path:
>      >
>     "/home/kobaz/.virtualenvs/pgadmin4/lib/python3.4/site-packages:/usr/lib/python3/dist-packages"
>
>      >
>      > Python Home:  ""
>      > Webapp path:  "/usr/share/pgadmin4/web/pgAdmin4.py"
>      > NOTE: Configuring authentication for DESKTOP mode.
>      >
>      >
>      > pgAdmin splash pops up, and eventually says 'Taking longer than
>     usual'.
>      >   'Almost there'  and then dumps this:
>      >
>      > The application server could not be contacted
>      >
>      >
>      >
>      > I've tried cleaning out my pgadmin4 python path:
>      > rm -rf /home/kobaz/.virtualenvs/pgadmin4
>      >
>      > I've also tried startingconfig from scratch:
>      > mv ~/.pgadmin ~/.pgadmin-old
>      >
>      >
>      > This has not resolved the issue.
>      >
>      >
>      > strace is showing a loop on:
>      >
>      > poll([{fd=6, events=POLLIN}], 1, 0) = 0 (Timeout)
>      > stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=3545, ...}) = 0
>      >
>      >
>      > Other items of note:
>      >
>      > [pid 10122] connect(18, {sa_family=AF_INET, sin_port=htons(46311),
>      > sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection
>      > refused)
>      >
>      > There's no firewall rules or other network type access
>     restrictions on
>      > this box.
>      >
>      > For example as my non-root user I can:
>      >   nc -l -s 127.0.0.1 -p  46311
>      >
>      > And then successfully connect to it with another nc
>      >
>      >
>
>
>
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-support by date:

Previous
From: Akshay Joshi
Date:
Subject: Re: pgAdmin 4.20 and 4.21 cannot create foreign key
Next
From: Shaheed Haque
Date:
Subject: Re: Dashboard graphs are not drawn with 4.20 or 4.21