Re: pgadmin4 fails to start after upgrade

Perfect. This is exactly what I needed. Thank you.
I noticed that after rebuilding a completely new virtualenv, that pgadmin
still picked up the credentials that I had made for the previous
installation. So pgadmin must be storing the encrypted credentials file
somewhere outside of the virtualenv directory tree. Is it stored in a home
directory/file that is hidden ?

On Thu, Mar 24, 2022 at 9:31 PM Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:

> Hi,
>
> This is due to Jinja2's yesterday release (v.3.1.0).
> As a work around, please downgrade the Jinja2 to resolve this issue.
>
> $ pip uninstall jinja2
> $ pip install jinja2==3.0.3
>
> Thanks,
> Khushboo
>
>
> On Fri, Mar 25, 2022 at 2:51 AM David Bear <dbear(at)heritageacademyaz(dot)com>
> wrote:
>
>> I have been running pgadmin for in a virtual environment. Today I
>> upgraded to v 4.6.7. Now, starting pgadmin4 throws and exception
>>
>>
>> pgadmin4
>> Traceback (most recent call last):
>> File "/home/david/bin/bin/pgadmin4", line 5, in <module>
>> from pgadmin4.pgAdmin4 import main
>> File
>> "/home/david/bin/lib/python3.9/site-packages/pgadmin4/pgAdmin4.py", line
>> 98, in <module>
>> app = create_app()
>> File
>> "/home/david/bin/lib/python3.9/site-packages/pgadmin4/pgadmin/__init__.py",
>> line 233, in create_app
>> app.jinja_env.trim_blocks = True
>> File "/home/david/bin/lib/python3.9/site-packages/flask/helpers.py",
>> line 777, in __get__
>> return super().__get__(obj, type=type)
>> File "/home/david/bin/lib/python3.9/site-packages/werkzeug/utils.py",
>> line 97, in __get__
>> value = self.fget(obj) # type: ignore
>> File "/home/david/bin/lib/python3.9/site-packages/flask/app.py", line
>> 602, in jinja_env
>> return self.create_jinja_environment()
>> File "/home/david/bin/lib/python3.9/site-packages/flask/app.py", line
>> 694, in create_jinja_environment
>> rv = self.jinja_environment(self, **options)
>> File "/home/david/bin/lib/python3.9/site-packages/flask/templating.py",
>> line 42, in __init__
>> BaseEnvironment.__init__(self, **options)
>> File
>> "/home/david/bin/lib/python3.9/site-packages/jinja2/environment.py", line
>> 363, in __init__
>> self.extensions = load_extensions(self, extensions)
>> File
>> "/home/david/bin/lib/python3.9/site-packages/jinja2/environment.py", line
>> 117, in load_extensions
>> extension = t.cast(t.Type["Extension"], import_string(extension))
>> File "/home/david/bin/lib/python3.9/site-packages/jinja2/utils.py",
>> line 149, in import_string
>> return getattr(__import__(module, None, None, [obj]), obj)
>> AttributeError: module 'jinja2.ext' has no attribute 'autoescape'
>>
>> I've tried updating to all the latest versions of things in the
>> virtualenv -- incuding jinja2. results of the pip install pgadmin4
>> --force-reinstall were
>>
>> Attempting uninstall: pgadmin4
>> Found existing installation: pgadmin4 6.7
>> Uninstalling pgadmin4-6.7:
>> Successfully uninstalled pgadmin4-6.7
>> Successfully installed Authlib-0.15.5 Babel-2.9.1 Flask-2.0.3
>> Flask-Babel-2.0.0 Flask-Compress-1.11 Flask-Gravatar-0.5.0
>> Flask-Login-0.5.0 Flask-Mail-0.9.1 Flask-Migrate-3.1.0 Flask-Paranoid-0.2.0
>> Flask-Principal-0.4.0 Flask-SQLAlchemy-2.5.1 Flask-Security-Too-4.1.3
>> Flask-SocketIO-5.1.1 Flask-WTF-1.0.0 Jinja2-3.1.0 Mako-1.2.0
>> MarkupSafe-2.1.1 Pillow-9.0.1 SQLAlchemy-1.4.32 WTForms-3.0.1
>> Werkzeug-2.0.3 alembic-1.7.7 bcrypt-3.2.0 bidict-0.22.0 blinker-1.4
>> boto3-1.20.54 botocore-1.23.54 brotli-1.0.9 certifi-2021.10.8 cffi-1.15.0
>> chardet-4.0.0 click-8.0.4 cryptography-3.4.8 dnspython-2.2.1
>> email-validator-1.1.3 eventlet-0.33.0 greenlet-1.1.2 httpagentparser-1.9.2
>> idna-2.10 itsdangerous-2.1.2 jmespath-0.10.0 ldap3-2.9.1 paramiko-2.10.3
>> passlib-1.7.4 pgadmin4-6.7 psutil-5.9.0 psycopg2-binary-2.9.3 pyasn1-0.4.8
>> pycparser-2.21 pynacl-1.5.0 pyotp-2.6.0 python-dateutil-2.8.2
>> python-engineio-4.3.1 python-socketio-5.5.2 pytz-2021.3 qrcode-7.3.1
>> requests-2.25.1 s3transfer-0.5.2 simplejson-3.17.6 six-1.16.0
>> speaklater3-1.4 sqlparse-0.4.2 sshtunnel-0.4.0 ua-parser-0.10.0
>> urllib3-1.26.9 user-agents-2.2.0
>>
>> So it seems everything is at the correct levels. Is there a bug in the
>> current pgadmin4 code?
>>
>>
>>
>> --
>>
>> David Bear
>>
>> IT Manager
>>
>> Heritage Academy — an *A* rated school
>>
>> p: 480-461-4429
>>
>> w: www.hamesa.com e: dbear(at)heritageacademyaz(dot)com
>>
>> https://www.facebook.com/HeritageAcademyAZ/
>>
>>

--

David Bear

IT Manager

Heritage Academy — an *A* rated school

p: 480-461-4429

w: www.hamesa.com e: dbear(at)heritageacademyaz(dot)com

https://www.facebook.com/HeritageAcademyAZ/