search

YunoHost-Apps / pgadmin_ynh

PostgreSQL web admin tool package for YunoHost
https://www.pgadmin.org/
GNU General Public License v2.0
5 stars 2 forks source link

Issue while installing #3

Closed stemy2 closed 4 years ago

stemy2 commented 5 years ago

Hello,

I tried to install it and it failed. The installation log.

Josue-T commented 5 years ago

Hello,

Sorry for the late answer.

Have you tried a second time the install ? If not can you try a new time because I don't really understand why it fail.

stemy2 commented 5 years ago

It failed again. For the exact same reason.

Josue-T commented 5 years ago

Ok, what is your hardware ?

stemy2 commented 5 years ago

A desktop PC x86_64.

Josue-T commented 5 years ago

A desktop PC x86_64.

Ok, I'll try to reproduce your issue.

stemy2 commented 4 years ago

Re-UP I still can't install it

Josue-T commented 4 years ago

Hello,

Can you try this command : wget https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.16/pip/pgadmin4-4.16-py2.py3-none-any.whl

stemy2 commented 4 years ago

OK, i downloaded the file, but now, i don't know what to do with it.

Josue-T commented 4 years ago

OK, i downloaded the file, but now, i don't know what to do with it.

Ok in this case can you try the install a new time ?

stemy2 commented 4 years ago

Tried again, it failed again for the exact same reason.

Josue-T commented 4 years ago

Ok,

So can you try this:

cd /tmp 
python3 -m venv venv_test
source venv_test/bin/activate
pip3 install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.16/pip/pgadmin4-4.16-py2.py3-none-any.whl
stemy2 commented 4 years ago

It failed too.

(venv_test) root@stemy:/tmp# pip3 install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.16/pip/pgadmin4-4.16-py2.py3-none-any.whl
Collecting pgadmin4==4.16 from https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.16/pip/pgadmin4-4.16-py2.py3-none-any.whl
Exception:
Traceback (most recent call last):
  File "/tmp/venv_test/share/python-wheels/urllib3-1.19.1-py2.py3-none-any.whl/urllib3/connectionpool.py", line 594, in urlopen
    chunked=chunked)
  File "/tmp/venv_test/share/python-wheels/urllib3-1.19.1-py2.py3-none-any.whl/urllib3/connectionpool.py", line 350, in _make_request
    self._validate_conn(conn)
  File "/tmp/venv_test/share/python-wheels/urllib3-1.19.1-py2.py3-none-any.whl/urllib3/connectionpool.py", line 837, in _validate_conn
    conn.connect()
  File "/tmp/venv_test/share/python-wheels/urllib3-1.19.1-py2.py3-none-any.whl/urllib3/connection.py", line 323, in connect
    ssl_context=context)
  File "/tmp/venv_test/share/python-wheels/urllib3-1.19.1-py2.py3-none-any.whl/urllib3/util/ssl_.py", line 324, in ssl_wrap_socket
    return context.wrap_socket(sock, server_hostname=server_hostname)
  File "/usr/lib/python3.5/ssl.py", line 385, in wrap_socket
    _context=self)
  File "/usr/lib/python3.5/ssl.py", line 760, in __init__
    self.do_handshake()
  File "/usr/lib/python3.5/ssl.py", line 996, in do_handshake
    self._sslobj.do_handshake()
  File "/usr/lib/python3.5/ssl.py", line 641, in do_handshake
    self._sslobj.do_handshake()
ssl.SSLError: [SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:720)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/venv_test/share/python-wheels/requests-2.12.4-py2.py3-none-any.whl/requests/adapters.py", line 423, in send
    timeout=timeout
  File "/tmp/venv_test/share/python-wheels/urllib3-1.19.1-py2.py3-none-any.whl/urllib3/connectionpool.py", line 624, in urlopen
    raise SSLError(e)
requests.packages.urllib3.exceptions.SSLError: [SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:720)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/venv_test/lib/python3.5/site-packages/pip/basecommand.py", line 215, in main
    status = self.run(options, args)
  File "/tmp/venv_test/lib/python3.5/site-packages/pip/commands/install.py", line 353, in run
    wb.build(autobuilding=True)
  File "/tmp/venv_test/lib/python3.5/site-packages/pip/wheel.py", line 749, in build
    self.requirement_set.prepare_files(self.finder)
  File "/tmp/venv_test/lib/python3.5/site-packages/pip/req/req_set.py", line 380, in prepare_files
    ignore_dependencies=self.ignore_dependencies))
  File "/tmp/venv_test/lib/python3.5/site-packages/pip/req/req_set.py", line 620, in _prepare_file
    session=self.session, hashes=hashes)
  File "/tmp/venv_test/lib/python3.5/site-packages/pip/download.py", line 821, in unpack_url
    hashes=hashes
  File "/tmp/venv_test/lib/python3.5/site-packages/pip/download.py", line 659, in unpack_http_url
    hashes)
  File "/tmp/venv_test/lib/python3.5/site-packages/pip/download.py", line 853, in _download_http_url
    stream=True,
  File "/tmp/venv_test/share/python-wheels/requests-2.12.4-py2.py3-none-any.whl/requests/sessions.py", line 501, in get
    return self.request('GET', url, **kwargs)
  File "/tmp/venv_test/lib/python3.5/site-packages/pip/download.py", line 386, in request
    return super(PipSession, self).request(method, url, *args, **kwargs)
  File "/tmp/venv_test/share/python-wheels/requests-2.12.4-py2.py3-none-any.whl/requests/sessions.py", line 488, in request
    resp = self.send(prep, **send_kwargs)
  File "/tmp/venv_test/share/python-wheels/requests-2.12.4-py2.py3-none-any.whl/requests/sessions.py", line 609, in send
    r = adapter.send(request, **kwargs)
  File "/tmp/venv_test/share/python-wheels/CacheControl-0.11.7-py2.py3-none-any.whl/cachecontrol/adapter.py", line 47, in send
    resp = super(CacheControlAdapter, self).send(request, **kw)
  File "/tmp/venv_test/share/python-wheels/requests-2.12.4-py2.py3-none-any.whl/requests/adapters.py", line 497, in send
    raise SSLError(e, request=request)
requests.exceptions.SSLError: [SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:720)
Josue-T commented 4 years ago

Hello,

Sorry for the late answer. Have you any behind any proxy or something else ?

It's really strange because it work on my side.

Can you try this command on an other computer ideally on the same network ?

stemy2 commented 4 years ago

I tried on my local PC, and it worked, but it failed on my server that is on the same network.

Josue-T commented 4 years ago

I tried on my local PC, and it worked, but it failed on my server that is on the same network.

And what is the OS of your local PC (for comparison) ?

stemy2 commented 4 years ago

I tried on my local PC, and it worked, but it failed on my server that is on the same network.

And what is the OS of your local PC (for comparison) ?

Debian

Josue-T commented 4 years ago

Ok, which version ?

stemy2 commented 4 years ago

Debian stable

Josue-T commented 4 years ago

OK, maybe the difference is between debian 9 and debian 10.

Can you try a new time with the last pip version:

cd /tmp 
python3 -m venv venv_test
source venv_test/bin/activate
pip3 install --upgrade pip
pip3 install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.16/pip/pgadmin4-4.16-py2.py3-none-any.whl
stemy2 commented 4 years ago

It failed too.

WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLError(1, '[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:720)'),)': /pub/pgadmin/pgadmin4/v4.16/pip/pgadmin4-4.16-py2.py3-none-any.whl
  WARNING: Retrying (Retry(total=3, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLError(1, '[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:720)'),)': /pub/pgadmin/pgadmin4/v4.16/pip/pgadmin4-4.16-py2.py3-none-any.whl
  WARNING: Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLError(1, '[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:720)'),)': /pub/pgadmin/pgadmin4/v4.16/pip/pgadmin4-4.16-py2.py3-none-any.whl
  WARNING: Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLError(1, '[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:720)'),)': /pub/pgadmin/pgadmin4/v4.16/pip/pgadmin4-4.16-py2.py3-none-any.whl
  WARNING: Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLError(1, '[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:720)'),)': /pub/pgadmin/pgadmin4/v4.16/pip/pgadmin4-4.16-py2.py3-none-any.whl
ERROR: Could not install packages due to an EnvironmentError: HTTPSConnectionPool(host='ftp.postgresql.org', port=443): Max retries exceeded with url: /pub/pgadmin/pgadmin4/v4.16/pip/pgadmin4-4.16-py2.py3-none-any.whl (Caused by SSLError(SSLError(1, '[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:720)'),))

This is not a network problem, my server was able to make a curl of the ftp.postgresql.org

Josue-T commented 4 years ago

This is not a network problem, my server was able to make a curl of the ftp.postgresql.org

And with wget ?

stemy2 commented 4 years ago

Yep, i was able to download the file.

So i did a pip install on the local file, and it seemed to work, but i'm not sure.

Processing ./pgadmin4-4.16-py2.py3-none-any.whl
Collecting Flask-WTF==0.14.2 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/60/3a/58c629472d10539ae5167dc7c1fecfa95dd7d0b7864623931e3776438a24/Flask_WTF-0.14.2-py2.py3-none-any.whl
Collecting psycopg2-binary>=2.8 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/92/5e/3a4df6594c8ba3b2dc6fc643a1cbb9da7b52bd13b5f179a7043611a02679/psycopg2_binary-2.8.4-cp35-cp35m-manylinux1_x86_64.whl (2.9MB)
    100% |████████████████████████████████| 2.9MB 137kB/s 
Collecting Flask==1.0.2 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/7f/e7/08578774ed4536d3242b14dacb4696386634607af824ea997202cd0edb4b/Flask-1.0.2-py2.py3-none-any.whl (91kB)
    100% |████████████████████████████████| 92kB 211kB/s 
Collecting sshtunnel>=0.1.4 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/c5/5c/4b320d7ec4b0d5d4d6df1fdf66a5799625b3623d0ce4efe81719c6f8dfb3/sshtunnel-0.1.5.tar.gz (49kB)
    100% |████████████████████████████████| 51kB 75kB/s 
Collecting Flask-Login==0.4.1 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
Collecting passlib==1.7.1 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/ee/a7/d6d238d927df355d4e4e000670342ca4705a72f0bf694027cf67d9bcf5af/passlib-1.7.1-py2.py3-none-any.whl (498kB)
    100% |████████████████████████████████| 501kB 115kB/s 
Collecting python-dateutil>=2.8.0 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/d4/70/d60450c3dd48ef87586924207ae8907090de0b306af2bce5d134d78615cb/python_dateutil-2.8.1-py2.py3-none-any.whl (227kB)
    100% |████████████████████████████████| 235kB 263kB/s 
Collecting Werkzeug>=0.15.0 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/ba/a5/d6f8a6e71f15364d35678a4ec8a0186f980b3bd2545f40ad51dd26a87fb1/Werkzeug-1.0.0-py2.py3-none-any.whl (298kB)
    100% |████████████████████████████████| 307kB 168kB/s 
Collecting Flask-Security>=3.0.0 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/88/47/4908a5040120768ff4fb2465c7eeafeb9239c27d2919bd67c4ccc1b43e14/Flask_Security-3.0.0-py2.py3-none-any.whl (68kB)
    100% |████████████████████████████████| 71kB 135kB/s 
Collecting six>=1.12.0 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/65/eb/1f97cb97bfc2390a276969c6fae16075da282f5058082d4cb10c6c5c1dba/six-1.14.0-py2.py3-none-any.whl
Collecting WTForms==2.2.1 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/9f/c8/dac5dce9908df1d9d48ec0e26e2a250839fa36ea2c602cc4f85ccfeb5c65/WTForms-2.2.1-py2.py3-none-any.whl (166kB)
    100% |████████████████████████████████| 174kB 288kB/s 
Collecting speaklater==1.3 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/11/92/5ae1effe0ccb8561c034a0111d53c8788660ddb7ed4992f0da1bb5c525e5/speaklater-1.3.tar.gz
Collecting Flask-Principal==0.4.0 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Using cached https://files.pythonhosted.org/packages/14/c7/2531aca6ab7baa3774fde2dfc9c9dd6d5a42576a1013a93701bfdc402fdd/Flask-Principal-0.4.0.tar.gz
Collecting SQLAlchemy>=1.2.18 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/8c/30/4134e726dd5ed13728ff814fa91fc01c447ad8700504653fe99d91fdd34b/SQLAlchemy-1.3.15.tar.gz (6.1MB)
    100% |████████████████████████████████| 6.1MB 105kB/s 
Collecting simplejson==3.16.0 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
Collecting Flask-Paranoid==0.2.0 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/0e/14/359033a218c5403872e11ff7267e6c638c0279067fa932d93653188f4052/Flask_Paranoid-0.2.0-py2.py3-none-any.whl
Collecting Flask-Mail==0.9.1 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/05/2f/6a545452040c2556559779db87148d2a85e78a26f90326647b51dc5e81e9/Flask-Mail-0.9.1.tar.gz (45kB)
    100% |████████████████████████████████| 51kB 347kB/s 
Collecting blinker==1.4 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Using cached https://files.pythonhosted.org/packages/1b/51/e2a9f3b757eb802f61dc1f2b09c8c99f6eb01cf06416c0671253536517b6/blinker-1.4.tar.gz
Collecting Flask-SQLAlchemy==2.3.2 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/a1/44/294fb7f6bf49cc7224417cd0637018db9fee0729b4fe166e43e2bbb1f1c8/Flask_SQLAlchemy-2.3.2-py2.py3-none-any.whl
Collecting Flask-Compress==1.4.0 (from pgadmin4==4.16)
  Downloading https://files.pythonhosted.org/packages/0e/2a/378bd072928f6d92fd8c417d66b00c757dc361c0405a46a0134de6fd323d/Flask-Compress-1.4.0.tar.gz
Collecting pytz==2018.9 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/61/28/1d3920e4d1d50b19bc5d24398a7cd85cc7b9a75a490570d5a30c57622d34/pytz-2018.9-py2.py3-none-any.whl (510kB)
    100% |████████████████████████████████| 512kB 216kB/s 
Collecting sqlparse==0.2.4 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/65/85/20bdd72f4537cf2c4d5d005368d502b2f464ede22982e724a82c86268eda/sqlparse-0.2.4-py2.py3-none-any.whl
Collecting Flask-Gravatar==0.5.0 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/58/4a/b20260e8d383d0037f2791dd8a3f3ea729ca9f02d7638677a34a236a8702/Flask_Gravatar-0.5.0-py2.py3-none-any.whl
Collecting Flask-Migrate==2.4.0 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/07/6a/53695aab4c7cf7b230e46a5e4f06e0c9719c01a51223590fd75804439a01/Flask_Migrate-2.4.0-py2.py3-none-any.whl
Collecting psutil==5.5.1 (from pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/c7/01/7c30b247cdc5ba29623faa5c8cf1f1bbf7e041783c340414b0ed7e067c64/psutil-5.5.1.tar.gz (426kB)
    100% |████████████████████████████████| 430kB 219kB/s 
Collecting Jinja2>=2.10 (from Flask==1.0.2->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/27/24/4f35961e5c669e96f6559760042a55b9bcfcdb82b9bdb3c8753dbe042e35/Jinja2-2.11.1-py2.py3-none-any.whl (126kB)
    100% |████████████████████████████████| 133kB 140kB/s 
Collecting itsdangerous>=0.24 (from Flask==1.0.2->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Using cached https://files.pythonhosted.org/packages/76/ae/44b03b253d6fade317f32c24d100b3b35c2239807046a4c953c7b89fa49e/itsdangerous-1.1.0-py2.py3-none-any.whl
Collecting click>=5.1 (from Flask==1.0.2->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/dd/c0/4d8f43a9b16e289f36478422031b8a63b54b6ac3b1ba605d602f10dd54d6/click-7.1.1-py2.py3-none-any.whl (82kB)
    100% |████████████████████████████████| 92kB 175kB/s 
Collecting paramiko>=1.15.2 (from sshtunnel>=0.1.4->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/06/1e/1e08baaaf6c3d3df1459fd85f0e7d2d6aa916f33958f151ee1ecc9800971/paramiko-2.7.1-py2.py3-none-any.whl (206kB)
    100% |████████████████████████████████| 215kB 73kB/s 
Collecting Flask-BabelEx>=0.9.3 (from Flask-Security>=3.0.0->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/0c/f2/a9b45a4729b7169d51b32fdeb526491b7e8f872abf4b9e049e489a52c519/Flask_BabelEx-0.9.4-py3-none-any.whl
Collecting alembic>=0.7 (from Flask-Migrate==2.4.0->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/60/1e/cabc75a189de0fbb2841d0975243e59bde8b7822bacbb95008ac6fe9ad47/alembic-1.4.2.tar.gz (1.1MB)
    100% |████████████████████████████████| 1.1MB 199kB/s 
Collecting MarkupSafe>=0.23 (from Jinja2>=2.10->Flask==1.0.2->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/6e/57/d40124076756c19ff2269678de7ae25a14ebbb3f6314eb5ce9477f191350/MarkupSafe-1.1.1-cp35-cp35m-manylinux1_x86_64.whl
Collecting cryptography>=2.5 (from paramiko>=1.15.2->sshtunnel>=0.1.4->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/45/73/d18a8884de8bffdcda475728008b5b13be7fbef40a2acc81a0d5d524175d/cryptography-2.8-cp34-abi3-manylinux1_x86_64.whl (2.3MB)
    100% |████████████████████████████████| 2.3MB 103kB/s 
Collecting bcrypt>=3.1.3 (from paramiko>=1.15.2->sshtunnel>=0.1.4->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/8b/1d/82826443777dd4a624e38a08957b975e75df859b381ae302cfd7a30783ed/bcrypt-3.1.7-cp34-abi3-manylinux1_x86_64.whl (56kB)
    100% |████████████████████████████████| 61kB 75kB/s 
Collecting pynacl>=1.0.1 (from paramiko>=1.15.2->sshtunnel>=0.1.4->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/27/15/2cd0a203f318c2240b42cd9dd13c931ddd61067809fee3479f44f086103e/PyNaCl-1.3.0-cp34-abi3-manylinux1_x86_64.whl (759kB)
    100% |████████████████████████████████| 768kB 108kB/s 
Collecting Babel>=1.0 (from Flask-BabelEx>=0.9.3->Flask-Security>=3.0.0->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/15/a1/522dccd23e5d2e47aed4b6a16795b8213e3272c7506e625f2425ad025a19/Babel-2.8.0-py2.py3-none-any.whl (8.6MB)
    100% |████████████████████████████████| 8.6MB 56kB/s 
Collecting Mako (from alembic>=0.7->Flask-Migrate==2.4.0->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/50/78/f6ade1e18aebda570eed33b7c534378d9659351cadce2fcbc7b31be5f615/Mako-1.1.2-py2.py3-none-any.whl (75kB)
    100% |████████████████████████████████| 81kB 104kB/s 
Collecting python-editor>=0.3 (from alembic>=0.7->Flask-Migrate==2.4.0->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/c6/d3/201fc3abe391bbae6606e6f1d598c15d367033332bd54352b12f35513717/python_editor-1.0.4-py3-none-any.whl
Collecting cffi!=1.11.3,>=1.8 (from cryptography>=2.5->paramiko>=1.15.2->sshtunnel>=0.1.4->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/d6/7f/7acc85c478f5056b98c9961a31697b1e53fbec158ee5f723097e1c355660/cffi-1.14.0-cp35-cp35m-manylinux1_x86_64.whl (399kB)
    100% |████████████████████████████████| 409kB 133kB/s 
Collecting pycparser (from cffi!=1.11.3,>=1.8->cryptography>=2.5->paramiko>=1.15.2->sshtunnel>=0.1.4->pgadmin4==4.16)
  Cache entry deserialization failed, entry ignored
  Cache entry deserialization failed, entry ignored
  Downloading https://files.pythonhosted.org/packages/ae/e7/d9c3a176ca4b02024debf82342dab36efadfc5776f9c8db077e8f6e71821/pycparser-2.20-py2.py3-none-any.whl (112kB)
    100% |████████████████████████████████| 112kB 207kB/s 
Building wheels for collected packages: sshtunnel, speaklater, Flask-Principal, SQLAlchemy, Flask-Mail, blinker, Flask-Compress, psutil, alembic
  Running setup.py bdist_wheel for sshtunnel ... error
  Complete output from command /root/venv_test/bin/python3 -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-8eb_9fm6/sshtunnel/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/tmpi4u7ee_ppip-wheel- --python-tag cp35:
  usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]
     or: -c --help [cmd1 cmd2 ...]
     or: -c --help-commands
     or: -c cmd --help

  error: invalid command 'bdist_wheel'

  ----------------------------------------
  Failed building wheel for sshtunnel
  Running setup.py clean for sshtunnel
  Running setup.py bdist_wheel for speaklater ... error
  Complete output from command /root/venv_test/bin/python3 -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-8eb_9fm6/speaklater/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/tmpgrklqzxrpip-wheel- --python-tag cp35:
  usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]
     or: -c --help [cmd1 cmd2 ...]
     or: -c --help-commands
     or: -c cmd --help

  error: invalid command 'bdist_wheel'

  ----------------------------------------
  Failed building wheel for speaklater
  Running setup.py clean for speaklater
  Running setup.py bdist_wheel for Flask-Principal ... error
  Complete output from command /root/venv_test/bin/python3 -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-8eb_9fm6/Flask-Principal/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/tmp7yuaqsnwpip-wheel- --python-tag cp35:
  usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]
     or: -c --help [cmd1 cmd2 ...]
     or: -c --help-commands
     or: -c cmd --help

  error: invalid command 'bdist_wheel'

  ----------------------------------------
  Failed building wheel for Flask-Principal
  Running setup.py clean for Flask-Principal
  Running setup.py bdist_wheel for SQLAlchemy ... error
  Complete output from command /root/venv_test/bin/python3 -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-8eb_9fm6/SQLAlchemy/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/tmprltd03_cpip-wheel- --python-tag cp35:
  /usr/lib/python3.5/distutils/dist.py:261: UserWarning: Unknown distribution option: 'project_urls'
    warnings.warn(msg)
  usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]
     or: -c --help [cmd1 cmd2 ...]
     or: -c --help-commands
     or: -c cmd --help

  error: invalid command 'bdist_wheel'

  ----------------------------------------
  Failed building wheel for SQLAlchemy
  Running setup.py clean for SQLAlchemy
  Running setup.py bdist_wheel for Flask-Mail ... error
  Complete output from command /root/venv_test/bin/python3 -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-8eb_9fm6/Flask-Mail/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/tmpqfkfxatzpip-wheel- --python-tag cp35:
  usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]
     or: -c --help [cmd1 cmd2 ...]
     or: -c --help-commands
     or: -c cmd --help

  error: invalid command 'bdist_wheel'

  ----------------------------------------
  Failed building wheel for Flask-Mail
  Running setup.py clean for Flask-Mail
  Running setup.py bdist_wheel for blinker ... error
  Complete output from command /root/venv_test/bin/python3 -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-8eb_9fm6/blinker/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/tmpkttedy58pip-wheel- --python-tag cp35:
  usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]
     or: -c --help [cmd1 cmd2 ...]
     or: -c --help-commands
     or: -c cmd --help

  error: invalid command 'bdist_wheel'

  ----------------------------------------
  Failed building wheel for blinker
  Running setup.py clean for blinker
  Running setup.py bdist_wheel for Flask-Compress ... error
  Complete output from command /root/venv_test/bin/python3 -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-8eb_9fm6/Flask-Compress/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/tmpay0d_wqxpip-wheel- --python-tag cp35:
  usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]
     or: -c --help [cmd1 cmd2 ...]
     or: -c --help-commands
     or: -c cmd --help

  error: invalid command 'bdist_wheel'

  ----------------------------------------
  Failed building wheel for Flask-Compress
  Running setup.py clean for Flask-Compress
  Running setup.py bdist_wheel for psutil ... error
  Complete output from command /root/venv_test/bin/python3 -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-8eb_9fm6/psutil/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/tmpc6kbghbkpip-wheel- --python-tag cp35:
  usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]
     or: -c --help [cmd1 cmd2 ...]
     or: -c --help-commands
     or: -c cmd --help

  error: invalid command 'bdist_wheel'

  ----------------------------------------
  Failed building wheel for psutil
  Running setup.py clean for psutil
  Running setup.py bdist_wheel for alembic ... error
  Complete output from command /root/venv_test/bin/python3 -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-8eb_9fm6/alembic/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/tmpp9b96ub9pip-wheel- --python-tag cp35:
  /usr/lib/python3.5/distutils/dist.py:261: UserWarning: Unknown distribution option: 'project_urls'
    warnings.warn(msg)
  usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]
     or: -c --help [cmd1 cmd2 ...]
     or: -c --help-commands
     or: -c cmd --help

  error: invalid command 'bdist_wheel'

  ----------------------------------------
  Failed building wheel for alembic
  Running setup.py clean for alembic
Failed to build sshtunnel speaklater Flask-Principal SQLAlchemy Flask-Mail blinker Flask-Compress psutil alembic
Installing collected packages: MarkupSafe, Jinja2, itsdangerous, Werkzeug, click, Flask, WTForms, Flask-WTF, psycopg2-binary, pycparser, cffi, six, cryptography, bcrypt, pynacl, paramiko, sshtunnel, Flask-Login, passlib, python-dateutil, blinker, Flask-Mail, Flask-Principal, speaklater, pytz, Babel, Flask-BabelEx, Flask-Security, SQLAlchemy, simplejson, Flask-Paranoid, Flask-SQLAlchemy, Flask-Compress, sqlparse, Flask-Gravatar, Mako, python-editor, alembic, Flask-Migrate, psutil, pgadmin4
  Running setup.py install for sshtunnel ... done
  Running setup.py install for blinker ... done
  Running setup.py install for Flask-Mail ... done
  Running setup.py install for Flask-Principal ... done
  Running setup.py install for speaklater ... done
  Running setup.py install for SQLAlchemy ... done
  Running setup.py install for Flask-Compress ... done
  Running setup.py install for alembic ... done
  Running setup.py install for psutil ... done
Successfully installed Babel-2.8.0 Flask-1.0.2 Flask-BabelEx-0.9.4 Flask-Compress-1.4.0 Flask-Gravatar-0.5.0 Flask-Login-0.4.1 Flask-Mail-0.9.1 Flask-Migrate-2.4.0 Flask-Paranoid-0.2.0 Flask-Principal-0.4.0 Flask-SQLAlchemy-2.3.2 Flask-Security-3.0.0 Flask-WTF-0.14.2 Jinja2-2.11.1 Mako-1.1.2 MarkupSafe-1.1.1 SQLAlchemy-1.3.15 WTForms-2.2.1 Werkzeug-1.0.0 alembic-1.4.2 bcrypt-3.1.7 blinker-1.4 cffi-1.14.0 click-7.1.1 cryptography-2.8 itsdangerous-1.1.0 paramiko-2.7.1 passlib-1.7.1 pgadmin4-4.16 psutil-5.5.1 psycopg2-binary-2.8.4 pycparser-2.20 pynacl-1.3.0 python-dateutil-2.8.1 python-editor-1.0.4 pytz-2018.9 simplejson-3.16.0 six-1.14.0 speaklater-1.3 sqlparse-0.2.4 sshtunnel-0.1.5
Josue-T commented 4 years ago

Hello,

I did some investigations. Can you give me the result of theses command:

python3 -c 'import ssl; print(ssl.OPENSSL_VERSION)'
pip3 list
stemy2 commented 4 years ago

OK

root@stemy:~# python3 -c 'import ssl; print(ssl.OPENSSL_VERSION)'
OpenSSL 1.1.1d  10 Sep 2019
root@stemy:~# pip3 list
DEPRECATION: The default format will switch to columns in the future. You can use --format=(legacy|columns) (or define a format=(legacy|columns) in your pip.conf under the [list] section) to disable this warning.
beautifulsoup4 (4.5.3)
bottle (0.12.13)
chardet (2.3.0)
cryptography (1.7.1)
cycler (0.10.0)
docker-py (1.9.0)
fail2ban (0.9.6)
Glances (2.7.1)
html5lib (0.999999999)
httplib2 (0.11.3)
idna (2.2)
keyring (10.1)
keyrings.alt (1.3)
lxml (3.7.1)
matplotlib (2.0.0)
netifaces (0.10.4)
numpy (1.12.1)
Pillow (4.0.0)
pip (9.0.1)
psutil (5.0.1)
pyasn1 (0.1.9)
pycrypto (2.6.1)
pycurl (7.43.0)
pygobject (3.22.0)
pyinotify (0.9.6)
pyOpenSSL (16.2.0)
pyparsing (2.1.10)
pysnmp (4.3.2)
pystache (0.5.4)
python-apt (1.4.1)
python-dateutil (2.5.3)
python-debian (0.1.30)
python-debianbts (2.6.1)
pytz (2016.7)
pyxdg (0.25)
reportbug (7.1.7)
requests (2.12.4)
SecretStorage (2.3.1)
setuptools (33.1.1)
six (1.10.0)
systemd-python (233)
unattended-upgrades (0.1)
urllib3 (1.19.1)
virtualenv (15.1.0)
webencodings (0.5)
websocket-client (0.37.0)
wheel (0.29.0)
Josue-T commented 4 years ago

Ok and ?

dpkg -l | grep ssl
stemy2 commented 4 years ago 
ii  erlang-ssl                            1:22.3-1                                                      amd64        Erlang/OTP implementation of SSL
ii  libevent-openssl-2.0-5:amd64          2.0.21-stable-3                                               amd64        Asynchronous event notification library (openssl)
ii  libflac8:amd64                        1.3.2-1                                                       amd64        Free Lossless Audio Codec - runtime C library
ii  libio-socket-ssl-perl                 2.044-1                                                       all          Perl module implementing object oriented interface to SSL sockets
ii  libnet-smtp-ssl-perl                  1.04-1                                                        all          Perl module providing SSL support to Net::SMTP
ii  libnet-ssleay-perl                    1.80-1                                                        amd64        Perl module for Secure Sockets Layer (SSL)
ii  libssl-dev:amd64                      1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf                    amd64        Secure Sockets Layer toolkit - development files
ii  libssl-doc                            1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf                    all          Secure Sockets Layer toolkit - development documentation
ii  libssl1.0.2:amd64                     1.0.2u-1~deb9u1                                               amd64        Secure Sockets Layer toolkit - shared libraries
ii  libssl1.1:amd64                       1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf                    amd64        Secure Sockets Layer toolkit - shared libraries
ii  libwavpack1:amd64                     5.0.0-2+deb9u2                                                amd64        audio codec (lossy and lossless) - library
ii  libzstd1                              1.1.2-1                                                       amd64        fast lossless compression algorithm
ii  openssl                               1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf                    amd64        Secure Sockets Layer toolkit - cryptographic utility
ii  perl-openssl-defaults:amd64           3                                                             amd64        version compatibility baseline for Perl OpenSSL packages
ii  python-openssl                        16.2.0-1                                                      all          Python 2 wrapper around the OpenSSL library
ii  python3-openssl                       16.2.0-1                                                      all          Python 3 wrapper around the OpenSSL library
ii  ssl-cert                              1.0.39                                                        all          simple debconf wrapper for OpenSSL
Josue-T commented 4 years ago

Oh, did you upgrade openssl from some unofficial repository ? On my side I've this version 1.1.0l-1~deb9u1

stemy2 commented 4 years ago

Maybe not intentionally, i don't know.

Josue-T commented 4 years ago

Maybe it could be good to know if downgrading this fix the issue.

stemy2 commented 4 years ago

OK. How do i have to proceed ?

Josue-T commented 4 years ago

Maybe can you share me the result of this

dpkg -l | grep gbpd6badf

To see all of package upgraded, mybe I'll see why did you do this upgrade.

stemy2 commented 4 years ago 
ii  libssl-dev:amd64                      1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf                    amd64        Secure Sockets Layer toolkit - development files
ii  libssl-doc                            1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf                    all          Secure Sockets Layer toolkit - development documentation
ii  libssl1.1:amd64                       1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf                    amd64        Secure Sockets Layer toolkit - shared libraries
ii  openssl                               1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf                    amd64        Secure Sockets Layer toolkit - cryptographic utility
Josue-T commented 4 years ago

Can you try this:

apt install libssl-dev=1.1.0l-1~deb9u1 libssl-doc=1.1.0l-1~deb9u1openssl=1.1.0l-1~deb9u1 libssl1.0.2=1.0.2u-1~deb9u1
nicofrand commented 4 years ago

Hi, I have the same issue :).

ii  openssl                                      1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf                    amd64      Secure Sockets Layer toolkit - cryptographic utility

It comes from sury:

# apt-cache policy openssl
openssl:
  Installed: 1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf
  Candidate: 1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf
  Version table:
 *** 1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf 200
        200 https://packages.sury.org/php stretch/main amd64 Packages
        100 /var/lib/dpkg/status
     1.1.0l-1~deb9u1 500
        500 http://security.debian.org stretch/updates/main amd64 Packages
        500 http://debian.mirrors.ovh.net/debian stretch/main amd64 Packages

This repository is added by the nextcloud package at least: https://github.com/YunoHost-Apps/nextcloud_ynh/blob/afbe4378c1e664362fed355cf046e8b57a48ed9d/scripts/_common.sh#L645

Josue-T commented 4 years ago

OK, but If you downgrade openssl does it fix the issue ?

stemy2 commented 4 years ago

Can you try this:

apt install libssl-dev=1.1.0l-1~deb9u1 libssl-doc=1.1.0l-1~deb9u1openssl=1.1.0l-1~deb9u1 libssl1.0.2=1.0.2u-1~deb9u1

Nope

E: Unable to locate package libssl-doc=1.1.0l-1~deb9u1openssl
E: Couldn't find any package by glob 'libssl-doc=1.1.0l-1~deb9u1openssl'
E: Couldn't find any package by regex 'libssl-doc=1.1.0l-1~deb9u1openssl'
nicofrand commented 4 years ago

Downgrade worked for me!

But I then hit another issue (due to sqlite, weird: https://nicofrand.eu/yunohost/admin/#/tools/logs/20200331-113848-app_install-pgadmin) so I cannot be 100% sure.

nicofrand commented 4 years ago

@stemy2 you are missing a whitespace before openssl.

stemy2 commented 4 years ago

@stemy2 you are missing a whitespace before openssl.

I don't understand your message, i copypasted the code you provided in the console.

nicofrand commented 4 years ago

@Josue-T did.

But here is the correct version:

apt install  libssl1.1=1.1.0l-1~deb9u1 libssl-dev=1.1.0l-1~deb9u1 libssl-doc=1.1.0l-1~deb9u1 openssl=1.1.0l-1~deb9u1
stemy2 commented 4 years ago

Now i'm having another error.

he following packages have unmet dependencies:
 libssl-dev : Depends: libssl1.1 (= 1.1.0l-1~deb9u1) but 1.1.1d-1+0~20191009.15+debian9~1.gbpd6badf is to be installed
E: Unable to correct problems, you have held broken packages.
nicofrand commented 4 years ago

I edited my message, please try again with the edited version.

stemy2 commented 4 years ago

OK, i reinstalled it with the whl file, and it seemed to work.

But now, how do i access to pgadmin ?

Josue-T commented 4 years ago

Normally the user that you give at the install should have a tile in the SSO. And after you can authenticate with the email of this user and the password that you give at the install.

stemy2 commented 4 years ago

I just made a pip install of the whl file and had no errors message, so i though that full install succeeded. But it failed again when i tried to install it with the web interface.

Josue-T commented 4 years ago

pip._vendor.urllib3.exceptions.ReadTimeoutError: HTTPSConnectionPool(host='ftp.postgresql.org', port=443): Read timed out.

Look like an other problem. Maybe a connectivity problem ?

stemy2 commented 4 years ago

pip._vendor.urllib3.exceptions.ReadTimeoutError: HTTPSConnectionPool(host='ftp.postgresql.org', port=443): Read timed out.

Look like an other problem. Maybe a connectivity problem ?

I don't think so,my server don't have any connectivity problem right now outside of this one and can curl the said sit without any problem, i don't understand why it can't in this case.

Josue-T commented 4 years ago

Ok but it was maybe a temporary problem.

stemy2 commented 4 years ago

A temporary problem that happens only when i'm trying to install this particular app, this is a strange coincidence.

stemy2 commented 4 years ago

I just installed it on a fresh YNH install, and now it works. We'll never know what was the problem.