Re: pgadmin4 3.0: OpenTagNotFoundError

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(at)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(at)gmail(dot)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(at)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<
>