Thread: Pgadmin4 Debian

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

Apologies for responding to my own post... but, this is definitely weird
behavior that out of the box pgadmin4 fails to start.



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

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