Re: Pgadmin4 Debian

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!

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

On 2020-04-30 15:07, Dave Page wrote:
> Hi
>
> On Thu, Apr 30, 2020 at 5:52 PM Mark Murawski
> <markm-lists(at)intellasoft(dot)net <mailto:markm-lists(at)intellasoft(dot)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