Pgadmin 4 an error occurred initializing the application server

Arch Linux

You are not logged in.

#1 2018-08-06 20:37:54

Unable to start pgadmin4 after python and pgadmin update

Removing pgadmin cache do not help.
No info in log file.

Python path: «/usr/lib/pgadmin4/venv/lib/python3.7/site-packages:/usr/lib/python3.7/site-packages:/usr/lib/python3.7»
Python Home: «/usr/lib/pgadmin4/venv»
Webapp path: «/usr/lib/pgadmin4/web/pgAdmin4.py»
NOTE: Configuring authentication for DESKTOP mode.

An error occurred initialising the application server:

An error occurred initialising the application server:

#2 2018-08-07 02:11:07

Re: Unable to start pgadmin4 after python and pgadmin update

Me too! I see exactly the same issue as gkrukar.

#3 2018-08-07 03:13:55

Re: Unable to start pgadmin4 after python and pgadmin update

Doesn’t help resolve the issue with the package, but the docker image is a reliable alternative.

#4 2018-08-08 08:16:01

Re: Unable to start pgadmin4 after python and pgadmin update

Me too! Also with the aur/pgadmin4-systray-fix 3.1-2 version

#5 2018-08-08 10:29:20

Re: Unable to start pgadmin4 after python and pgadmin update

I’ve tried the docker image. Works for most part, but gets really complicated when I have to restore database backups. Seems like the image has a few packages missing: postgresql-common, postgresql-client

Any pointers as to what to look for to fix the original pgadmin4 issue? This issue has hit me hard.

#6 2018-08-08 14:40:43

Re: Unable to start pgadmin4 after python and pgadmin update

Same problem after python and pgadmin update in 08/08/2018

Python path: «/usr/lib/pgadmin4/venv/lib/python3.7/site-packages:/usr/lib/python3.7/site-packages:/usr/lib/python3.7»
Python Home: «/usr/lib/pgadmin4/venv»
Webapp path: «/usr/lib/pgadmin4/web/pgAdmin4.py»

An error occurred initialising the application server: %1

#7 2018-08-08 21:57:54

Re: Unable to start pgadmin4 after python and pgadmin update

I also have the following problem when starting pgadmin4:

]$ pacman -Qi pgadmin4
Name : pgadmin4
Version : 3.0-3
Packager : Evangelos Foutras
Build Date : Mon 23 Jul 2018 06:11:20 PM CEST
Install Date : Wed 08 Aug 2018 11:30:46 PM CEST

]$ pgadmin4
Python path: «/usr/lib/pgadmin4/venv/lib/python3.7/site-packages:/usr/lib/python3.7/site-packages:/usr/lib/python3.7»
Python Home: «/usr/lib/pgadmin4/venv»
Webapp path: «/usr/lib/pgadmin4/web/pgAdmin4.py»
«Failed to launch the application server, server thread exiting.

Segmentation fault (core dumped)

If there is any information I could provide to solve the issue please let me know.

Last edited by mach (2018-08-08 22:00:57)

#8 2018-08-09 17:33:41

Re: Unable to start pgadmin4 after python and pgadmin update

Same issue. I was in a bind so I tried modifying the PKGBUILD to install 3.2, which has a release date of today (2018-08-09).

In your build directory, you’ll need to create config_distro.py:

config_local.py

. and pgAdmin4.desktop:

I’m also foolhardy enough to skip the integrity checks.

It appears that some directories aren’t available to my user account. So.

Score! Running the pgAdmin4 startup script still gives me the dialog window asking for paths but maybe this will do until the package maintainer gets around to updating. Until then, I’m running pgadmin4-server and navigating directly to http://127.0.0.1:5050/browser.

Last edited by jmbull (2018-08-20 19:29:12)

#9 2018-08-10 17:30:21

Re: Unable to start pgadmin4 after python and pgadmin update

I’m seeing this in pgadmin4’s icon server log:

Traceback (most recent call last):
File «/usr/lib/pgadmin4/web/pgAdmin4.py», line 70, in
app = create_app()
File «/usr/lib/pgadmin4/web/pgadmin/__init__.py», line 367, in create_app
driver.init_app(app)
File «/usr/lib/pgadmin4/web/pgadmin/utils/driver/__init__.py», line 40, in init_app
DriverRegistry.load_drivers()
File «/usr/lib/pgadmin4/web/pgadmin/utils/driver/registry.py», line 88, in load_drivers
module = import_module(module_name)
File «/usr/lib/python3.7/importlib/__init__.py», line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File » «, line 1006, in _gcd_import
File » «, line 983, in _find_and_load
File » «, line 967, in _find_and_load_unlocked
File » «, line 677, in _load_unlocked
File » «, line 728, in exec_module
File » «, line 219, in _call_with_frames_removed
File «/usr/lib/pgadmin4/web/pgadmin/utils/driver/psycopg2/__init__.py», line 26, in
from .connection import Connection
File «/usr/lib/pgadmin4/web/pgadmin/utils/driver/psycopg2/connection.py», line 141
def __init__(self, manager, conn_id, db, auto_reconnect=True, async=0,
^
SyntaxError: invalid syntax

#10 2018-08-11 10:00:13

Re: Unable to start pgadmin4 after python and pgadmin update

BTW I don’t know about pgadmin4 4.3, but building/installing manually the recently released 3.2
by adapting the current PKGBUILD worked fine (no .sig file though) at least on my machine, which is
running ‘Linux sarchx64 4.17.13-arch1-1-ARCH #1 SMP PREEMPT Mon Aug 6 23:06:31 UTC 2018 x86_64 GNU/Linux’
with latest python and postgresql

So please update pgadmin4 to 3.2

#11 2018-08-20 09:05:32

Re: Unable to start pgadmin4 after python and pgadmin update

Note this is being tracked on the packages bug reports.

#12 2018-08-20 19:31:04

Re: Unable to start pgadmin4 after python and pgadmin update

BTW I don’t know about pgadmin4 4.3,

Ha! pgadmin4 3.2. Thanks, I corrected that above.

#13 2018-08-28 22:38:28

Re: Unable to start pgadmin4 after python and pgadmin update

Resolved in the latest release, pgadmin4 3.2-1

#14 2018-08-30 11:59:26

Re: Unable to start pgadmin4 after python and pgadmin update

Tray icon issue is solved, but I’m having another issue that a user also reported on the package bug report page: https://bugs.archlinux.org/task/59575#comment172627

I’m guessing it has something to do with the setup of the virtualenv.

Pasting the issue here:
«`
$ pgadmin4
Python path: «/usr/lib/pgadmin4/venv/lib/python3.6/site-packages:/usr/lib/python3.6/site-packages:/usr/lib/python3.6»
Python Home: «/usr/lib/pgadmin4/venv»
Fatal Python error: initfsencoding: Unable to get the locale encoding
ModuleNotFoundError: No module named ‘encodings’

Current thread 0x00007f6e5a5ddc80 (most recent call first):
Aborted (core dumped)
«`

#15 2018-09-14 15:22:02

Re: Unable to start pgadmin4 after python and pgadmin update

I had the same issue, check your

/.config/pgadmin/pgadmin4.conf
Under [General] you have a PythonPath= entry

For me this worked, I first tried removing this configuration file altogether, it then writes no new file and defaults on python2.7

Hope this helped.

#16 2021-08-06 07:10:36

Re: Unable to start pgadmin4 after python and pgadmin update

Downgrading not working for me either ,
tried DBeaver too its crashing without any log too
someone help please.

Thanks in Advance.

As someone mentioned above we can create our own web based pgadmin4 server it worked

Last edited by rahulnegi20 (2021-08-06 07:23:42)

#17 2021-08-06 14:32:01

Re: Unable to start pgadmin4 after python and pgadmin update

rahulnegi20:
This is two year old thread, and I cannot tell if you solved your problem after the edit. Regardless, I am going to invite you to open a your own thread (if you need to) and I will close this one. If you think this thread relevant, you can refer back to this thread with a link. Thanks.

Nothing is too wonderful to be true, if it be consistent with the laws of nature — Michael Faraday
Sometimes it is the people no one can imagine anything of who do the things no one can imagine. — Alan Turing
—
How to Ask Questions the Smart Way

Источник

Сейчас при запуске pgAdmin 4 v4 выдается сообщение:

The server could not verify that you are authorized to access the URL requested.
You either supplied the wrong credentials (e.g. a bad password), or your browser doesn’t understand how to supply the credentials required.

Ранее такого не было и все работало нормально.

Подскажите пожалуйста, как вернуть работоспособность?

короче другой браузер попробуй

Following is working for me (using SolydK):

right click on «tray icon»
«C:Program FilesMozilla Firefoxfirefox.exe» %URL%

и все заработало..

свое написать на 1С на основе консольных утилит — есть батники, просто хотел использовать формы :)..

и еще вопрос, если так пошло уж..

пользуюсь pgAdmin 4.20, а есть уже 4.24, но она не запускается, там ошибка про то, что профиль на русском.

Источник

Thread: Running pgadmin4 as desktop application

Running pgadmin4 as desktop application

Attachment

Re: Running pgadmin4 as desktop application

Re: Running pgadmin4 as desktop application

Attachment

Re: Running pgadmin4 as desktop application

Re: Running pgadmin4 as desktop application

Attachment

Re: Running pgadmin4 as desktop application

Attachment

Re: Running pgadmin4 as desktop application

Re: Running pgadmin4 as desktop application

On Monday, October 10, 2016, Chris Mayo wrote:

> Ok, this worked on CentOS 7 box, but not on Fedora 24, which has QT5 and Python
> 3. Can you help me to debug this? The content of the file in Fedora 24 is:
>
> $ cat /etc/pgAdmin Development Team/pgAdmin 4.conf
> [General]
> ApplicationPath=../../../..// usr/lib/python3.5/site- packages/pgadmin4-web/
> PythonPath=»/usr/lib64/ python3.5/site-packages; /usr/lib/python3.5/site- packages»
>
>
> I’m still getting segfault, and:
>
> An error occurred initialising the application server:
>
> Failed to locate pgAdmin4.py, terminating server thread.

I suspect it is because the path is missing the xdg directory:
/etc/xdg/pgAdmin Development Team/pgAdmin 4.conf

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

Running pgadmin4 as desktop application

On Monday, October 10, 2016, Devrim GГјndГјz wrote:

On Thu, 2016-10-06 at 13:42 +0100, Dave Page wrote:
>
> The global config file that Qt will read by default seems to be
> «/etc/pgAdmin Development Team/pgAdmin 4.conf».
>
> I may change that for 1.1 to use a less obnoxious path. The contents
> of it seem to need to be:
>
> [General]
> ApplicationPath=../../../../us r/lib/python2.7/site-packages/ pgadmin4-web/
> PythonPath=»/usr/lib64/python2 .7/site-packages/;/usr/lib/ python2.7/site-
> packages/»
>
> The ApplicationPath is the directory containing pgAdmin4.py. Due to a
> bugette in the way the runtime works, it needs to be relative to the
> location of the runtime, hence all the back-tracking. The PythonPath
> needs to include both the 32 and 64 bit directories, as it seems that
> some of the Python modules end up in each.
>
> That was enough to get it to start for me.

Ok, this worked on CentOS 7 box, but not on Fedora 24, which has QT5 and Python
3. Can you help me to debug this? The content of the file in Fedora 24 is:

$ cat /etc/pgAdmin Development Team/pgAdmin 4.confВ
[General]
ApplicationPath=../../../..//u sr/lib/python3.5/site-packages /pgadmin4-web/
PythonPath=»/usr/lib64/python3 .5/site-packages; /usr/lib/python3.5/site-packag es»

I’m still getting segfault, and:

An error occurred initialising the application server:

Failed to locate pgAdmin4.py, terminating server thread.

> Then, we run into the tricky issues, where you may have to deal with
> conflicts between web and desktop mode. In our other installers, we
> ship a blank config_local.py file, with a simple comment at the top
> telling the user they can customise any settings in that file. For web
> users, we don’t want that, as it’s used as a security mechanism
> (startup will fail if it’s not present, and tell the user they must
> set some security-critical options). Those options don’t matter in
> desktop mode, hence why we pre-write the file.
>
> Perhaps the way around that is to have the shortcut on the menu call a
> script that can create config_local.py if needed? Though, I see you
> already have config_distro.py forcing the user into desktop mode,
> which is a potential conflict.

AFAICS, creating the file above helped to solve this issue, at least I can say
that both modes work on CentOS 7.

> The other issue I see is with the docs:
>
> 1) The path in config_distro.py is
> /usr/share/doc/pgadmin4-docs/e n_US/html/. That directory doesn’t exist
> — if the docs are compiled in-situ, they’ll end up in
> /usr/share/doc/pgadmin4-docs/e n_US/html/_build/html
>
> 2) The docs aren’t built, so there is no _build/html directory.

Actuallly they are installed via -docs subpackage, but I forgot to add this as
a dependency.

> 3) The docs are integrated into the application so really should be a
> dependency of the pgadmin4 RPM.

Ok, fixed. Pushed to 9.6 testing repo:

yum В —enablerepo pgdg96-updates-testing install pgadmin4 pgadmin4-web

Can you please test again?

Источник

when i open pgadmin4 in manjaro xfce
this error message pops up saying

An error occurred initializing the pgadmin 4 server:
Failed to launch application server, server thread exiting.

i checked the logs

startup log

2021-08-26 09:35:29: Checking for system tray...
2021-08-26 09:35:29: Starting pgAdmin4 server...
2021-08-26 09:35:29: Creating server object, port:42505, key:fdcf6315-03b8-4a0c-a4cc-c8e6efc3f38e, logfile:/home/thenujan/.local/share/pgadmin4.d41d8cd98f00b204e9800998ecf8427e.log
2021-08-26 09:35:29: Python Path: /usr/lib/python3.9:/usr/lib/python3.9/lib-dynload:/usr/lib/python3.9/site-packages
2021-08-26 09:35:29: Python Home: /usr/lib/python3.9
2021-08-26 09:35:29: Initializing Python...
2021-08-26 09:35:29: Python initialized.
2021-08-26 09:35:29: Adding new additional path elements
2021-08-26 09:35:29: Redirecting stderr...
2021-08-26 09:35:29: stderr redirected successfully.
2021-08-26 09:35:29: Initializing server...
2021-08-26 09:35:29: Webapp Path: /usr/lib/pgadmin4/web/pgAdmin4.py
2021-08-26 09:35:29: Server initialized, starting server thread...
2021-08-26 09:35:29: Open the application code and run it.
2021-08-26 09:35:29: Set the port number, key and force SERVER_MODE off
2021-08-26 09:35:29: PyRun_SimpleFile launching application server...
2021-08-26 09:35:30: Failed to launch the application server, server thread exiting.

server log

Traceback (most recent call last):
  File "/usr/lib/pgadmin4/web/pgAdmin4.py", line 35, in <module>
    import config
  File "/usr/lib/pgadmin4/web/config.py", line 25, in <module>
    from pgadmin.utils import env, IS_WIN, fs_short_path
  File "/usr/lib/pgadmin4/web/pgadmin/__init__.py", line 28, in <module>
    from flask_security import Security, SQLAlchemyUserDatastore, current_user
  File "/usr/lib/python3.9/site-packages/flask_security/__init__.py", line 15, in <module>
    from .core import Security, RoleMixin, UserMixin, AnonymousUser, current_user
  File "/usr/lib/python3.9/site-packages/flask_security/core.py", line 48, in <module>
    from .mail_util import MailUtil
  File "/usr/lib/python3.9/site-packages/flask_security/mail_util.py", line 14, in <module>
    import email_validator
ModuleNotFoundError: No module named 'email_validator'

i did try installing email_validator

by using pip
pip install email_validator
but its still showing me the same error

and pgadmin4 configurations seem right

and sometimes it strangely says failed to open system default web browser and that error message stops after the restart and then it comes back again after several attempts to open pgadmin4

and this web browser error only pops up when pgadmin4 is running in the background if i kill pgadmin4 then failed to launch application server error pops up when i open it