Re: Pgadmin4 Debian

Hi

On Fri, May 1, 2020 at 5:05 PM Mark Murawski <markm-lists(at)intellasoft(dot)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(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
>
>
>

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

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