Re: pgadmin4 3.0: OpenTagNotFoundError - Mailing list pgadmin-support

From Murtuza Zabuawala
Subject Re: pgadmin4 3.0: OpenTagNotFoundError
Date
Msg-id CAKKotZR1029Fxeaetnn_7wE8pLFnGGM14DFj34Zkc-2HLe8F+w@mail.gmail.com
Whole thread Raw
In response to pgadmin4 3.0: OpenTagNotFoundError  (David Gilman <davidgilman1@gmail.com>)
List pgadmin-support
Hi,

I can see there are many extra python modules are present in your virtual environment, It seems like there must be some python module conflicting with pgAdmin4 modules.

This is what I've in my fresh pgAdmin4 virtual environment,

(venv_pg4) murtuza@b0x:~/Documents/prj/pgadmin4$ pip freeze
alembic==0.9.9
asn1crypto==0.24.0
Babel==2.5.3
bcrypt==3.1.4
blinker==1.4
cffi==1.11.5
chromedriver-installer==0.0.6
click==6.7
cryptography==2.2.2
extras==1.0.0
fixtures==3.0.0
Flask==0.12.2
Flask-BabelEx==0.9.3
Flask-Gravatar==0.5.0
Flask-HTMLmin==1.3.2
Flask-Login==0.3.2
Flask-Mail==0.9.1
Flask-Migrate==2.1.1
Flask-Paranoid==0.2.0
Flask-Principal==0.4.0
Flask-Security==3.0.0
Flask-SQLAlchemy==2.3.2
Flask-WTF==0.14.2
html5lib==1.0.1
htmlmin==0.1.12
idna==2.6
itsdangerous==0.24
Jinja2==2.10
linecache2==1.0.0
Mako==1.0.7
MarkupSafe==1.0
paramiko==2.4.1
passlib==1.7.1
pbr==3.1.1
psycopg2==2.7.4
pyasn1==0.4.2
pycodestyle==2.3.1
pycparser==2.18
pycrypto==2.6.1
PyNaCl==1.2.1
pyperclip==1.6.0
pyrsistent==0.14.2
pytest-runner==4.2
python-dateutil==2.7.2
python-editor==1.0.3
python-mimeparse==1.6.0
pytz==2018.3
selenium==3.11.0
setuptools-scm==2.0.0
simplejson==3.13.2
six==1.11.0
speaklater==1.3
SQLAlchemy==1.2.7
sqlparse==0.2.4
sshtunnel==0.1.3
testscenarios==0.5.0
testtools==2.3.0
traceback2==1.4.0
unittest2==1.1.0
webencodings==0.5.1
Werkzeug==0.14.1
WTForms==2.1

Could you please check again with the clean virtual environment where you do not have any unwanted modules included in it?

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


On Sun, May 27, 2018 at 9:02 PM, David Gilman <davidgilman1@gmail.com> wrote:
After upgrading to pgadmin4 3.0 I am frequently greeted with this fatal error when trying to load pgadmin4:

[wsgi:error] mod_wsgi (pid=22889): Exception occurred processing WSGI script '/home/pgadmin/venv/lib/python2.7/site-packages/pgadmin4/pgAdmin4.wsgi'.
[wsgi:error] Traceback (most recent call last):
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line 1997, in __call__
[wsgi:error]     return self.wsgi_app(environ, start_response)
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line 1985, in wsgi_app
[wsgi:error]     response = self.handle_exception(e)
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line 1540, in handle_exception
[wsgi:error]     reraise(exc_type, exc_value, tb)
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line 1982, in wsgi_app
[wsgi:error]     response = self.full_dispatch_request()
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line 1615, in full_dispatch_request
[wsgi:error]     return self.finalize_request(rv)
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line 1632, in finalize_request
[wsgi:error]     response = self.process_response(response)
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line 1856, in process_response
[wsgi:error]     response = handler(response)
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask_htmlmin.py", line 35, in response_minify
[wsgi:error]     self.html_minify.minify(response.get_data(as_text=True))
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/main.py", line 162, in minify
[wsgi:error]     self.input(*input)
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/main.py", line 174, in input
[wsgi:error]     self._parser.feed(i)
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/python3html/parser.py", line 125, in feed
[wsgi:error]     self.goahead(0)
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/python3html/parser.py", line 185, in goahead
[wsgi:error]     k = self.parse_starttag(i)
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/python3html/parser.py", line 359, in parse_starttag
[wsgi:error]     self.handle_starttag(tag, attrs)
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/parser.py", line 278, in handle_starttag
[wsgi:error]     self._in_pre_tag -= self._close_tags_up_to(t[0])
[wsgi:error]   File "/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/parser.py", line 261, in _close_tags_up_to
[wsgi:error]     raise OpenTagNotFoundError()
[wsgi:error] OpenTagNotFoundError

The error is intermittent, it seems that by restart apache you can sometimes make it work but right now I seem to be in a situation where I can't get pgadmin4 to start at all.

System details:

root@dgilman:/# cat /etc/debian_version
9.4

mod_wsgi for python 2.7 configuration:

WSGIDaemonProcess pgadmin processes=1 threads=10 user=pgadmin group=pgadmin python-home=/home/pgadmin/venv
WSGIScriptAlias /pgadmin /home/pgadmin/venv/lib/python2.7/site-packages/pgadmin4/pgAdmin4.wsgi
<Directory /home/pgadmin/venv/lib/python2.7/site-packages/pgadmin4>
AuthType Basic
AuthName pgadmin4
AuthUserFile /etc/apache2/htpasswds
Require user asdfjkl

WSGIProcessGroup pgadmin
WSGIApplicationGroup %{GLOBAL}
        </Directory>

pip freeze output:

alembic==0.9.5
attrs==16.3.0
Babel==2.3.4
backports.csv==1.0.5
bcrypt==3.1.2
beautifulsoup4==4.4.1
blinker==1.4
chardet==2.3.0
click==6.6
colorama==0.3.7
constantly==15.1.0
cryptography==1.7.1
defusedxml==0.4.1
enum34==1.1.6
extras==1.0.0
feedparser==5.1.3
fixtures==3.0.0
Flask==0.12.2
Flask-Babel==0.11.1
Flask-BabelEx==0.9.3
Flask-Gravatar==0.5.0
Flask-HTMLmin==1.3.2
Flask-Login==0.3.2
Flask-Mail==0.9.1
Flask-Migrate==2.1.1
Flask-Paranoid==0.2.0
Flask-Principal==0.4.0
Flask-Script==2.0.6
Flask-Security==3.0.0
Flask-SQLAlchemy==2.3.2
Flask-WTF==0.14.2
fpconst==0.7.2
html5lib==1.0.1
htmlmin==0.1.11
icalendar==3.6.1
idna==2.2
importlib==1.0.4
incremental==16.10.1
ipaddress==1.0.17
isodate==0.5.4
itsdangerous==0.24
Jinja2==2.7.3
keyring==10.1
keyrings.alt==1.3
linecache2==1.0.0
lxml==3.7.1
Mako==1.0.7
MarkupSafe==0.23
mysqlclient==1.3.7
passlib==1.7.1
pbr==3.1.1
pgadmin4==3.0
pkg-resources==0.0.0
psycopg2==2.7.3.2
pyasn1==0.1.9
pyasn1-modules==0.0.7
pycrypto==2.6.1
Pygments==2.2.0
pygobject==3.22.0
pylibacl==0.5.3
pyOpenSSL==16.2.0
pyparsing==2.1.10
pyrsistent==0.14.2
pyspatialite==3.0.1
python-dateutil==2.7.3
python-editor==1.0.3
python-mimeparse==1.6.0
pytz==2018.3
pyxattr==0.6.0
pyxdg==0.25
rdflib==4.2.1
rdiff-backup==1.2.8
SecretStorage==2.3.1
service-identity==16.0.0
simplejson==3.13.2
six==1.11.0
SOAPpy==0.12.22
SPARQLWrapper==1.7.6
speaklater==1.3
SQLAlchemy==1.2.7
sqlparse==0.2.4
testtools==2.3.0
traceback2==1.4.0
Twisted==16.6.0
unittest2==1.1.0
virtualenv==15.1.0
webencodings==0.5
Werkzeug==0.9.6
wokkel==0.7.1
wstools==0.4.3
WTForms==2.1
zope.interface==4.3.2

--
David Gilman
:DG<

pgadmin-support by date:

Previous
From: David Gilman
Date:
Subject: pgadmin4 3.0: OpenTagNotFoundError
Next
From: Khushboo Vashi
Date:
Subject: Re: Internal Server Error When Trying to Display Trigger Functions