Erreur installation application PGADMIN

Bonjour à tous,

J’ai une erreur d’installation lorsque je souhaite installer l’application Pgadmin. Mon serveur est un NUC intel assez basique (celeron, 4go de RAM et 2 to). J’avais déjà eu un problème lors de la migration progresql 9.4 à 9.6. C’est peut-être lié… Une idée?

Voici le journal:

2020-02-19 15:01:11,891: DEBUG - ++ ‘[’ -n /bin/bash ‘]’
2020-02-19 15:01:11,892: DEBUG - ++ hash -r
2020-02-19 15:01:11,894: DEBUG - + pip3 install --upgrade pip
2020-02-19 15:01:15,607: DEBUG - Collecting pip
2020-02-19 15:01:16,009: DEBUG - Using cached https://files.pythonhosted.org/packages/54/0c/d01aa759fdc501a58f431eb594a17495f15b88da142ce14b5845662c13f3/pip-20.0.2-py2.py3-none-any.whl
2020-02-19 15:01:16,210: DEBUG - Installing collected packages: pip
2020-02-19 15:01:16,210: DEBUG - Found existing installation: pip 9.0.1
2020-02-19 15:01:16,412: DEBUG - Uninstalling pip-9.0.1:
2020-02-19 15:01:16,414: DEBUG - Successfully uninstalled pip-9.0.1
2020-02-19 15:01:18,624: DEBUG - Successfully installed pip-20.0.2
2020-02-19 15:01:18,826: DEBUG - + pip3 install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
2020-02-19 15:01:19,933: DEBUG - Collecting pgadmin4==4.17
2020-02-19 15:01:20,637: WARNING - 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.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
2020-02-19 15:01:21,343: WARNING - 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.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
2020-02-19 15:01:22,552: WARNING - 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.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
2020-02-19 15:01:24,665: WARNING - 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.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
2020-02-19 15:01:28,788: WARNING - 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.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
2020-02-19 15:01:29,092: WARNING - 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.17/pip/pgadmin4-4.17-py2.py3-none-any.whl (Caused by SSLError(SSLError(1, ‘[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:720)’),))
2020-02-19 15:01:29,096: WARNING -
2020-02-19 15:01:29,400: DEBUG - + ynh_exit_properly
2020-02-19 15:01:29,403: DEBUG - + local exit_code=1
2020-02-19 15:01:29,404: DEBUG - + ‘[’ 1 -eq 0 ‘]’
2020-02-19 15:01:29,406: DEBUG - + trap ‘’ EXIT
2020-02-19 15:01:29,408: DEBUG - + set +eu
2020-02-19 15:01:29,409: DEBUG - + sleep 0.5
2020-02-19 15:01:30,115: DEBUG - + ynh_print_err ‘–message=!!\n pgadmin’’‘s script has encountered an error. Its execution was cancelled.\n!!’
2020-02-19 15:01:30,117: WARNING - e[91me[1m[ERR]e[0m !!
2020-02-19 15:01:30,120: DEBUG - + local legacy_args=m
2020-02-19 15:01:30,121: WARNING - pgadmin’s script has encountered an error. Its execution was cancelled.
2020-02-19 15:01:30,125: DEBUG - + args_array=([m]=message=)
2020-02-19 15:01:30,126: WARNING - !!
2020-02-19 15:01:30,127: DEBUG - + declare -Ar args_array
2020-02-19 15:01:30,127: WARNING -
2020-02-19 15:01:30,128: DEBUG - + local message
2020-02-19 15:01:30,129: DEBUG - + ynh_handle_getopts_args ‘–message=!!\n pgadmin’’‘s script has encountered an error. Its execution was cancelled.\n!!’
2020-02-19 15:01:30,129: DEBUG - + set +x
2020-02-19 15:01:30,129: DEBUG - + ynh_print_log ‘\e[91m\e[1m[ERR]\e[0m !!\n pgadmin’’‘s script has encountered an error. Its execution was cancelled.\n!!’
2020-02-19 15:01:30,130: DEBUG - + echo -e ‘\e[91m\e[1m[ERR]\e[0m !!\n pgadmin’’‘s script has encountered an error. Its execution was cancelled.\n!!’
2020-02-19 15:01:30,130: DEBUG - + ‘[’ api == cli ‘]’
2020-02-19 15:01:30,130: DEBUG - + type -t ynh_clean_setup
2020-02-19 15:01:30,131: DEBUG - + ynh_die
2020-02-19 15:01:30,131: DEBUG - + local legacy_args=mc
2020-02-19 15:01:30,131: DEBUG - + args_array=([m]=message= [c]=ret_code=)
2020-02-19 15:01:30,132: DEBUG - + declare -Ar args_array
2020-02-19 15:01:30,132: DEBUG - + local message
2020-02-19 15:01:30,132: DEBUG - + local ret_code
2020-02-19 15:01:30,132: DEBUG - + ynh_handle_getopts_args
2020-02-19 15:01:30,133: DEBUG - + set +x
2020-02-19 15:01:30,133: DEBUG - + echo ‘’
2020-02-19 15:01:30,133: DEBUG - + exit 1

Merci à tous pour votre aide.

Thomas

Pareil pour moi

C’est très étrange cette ligne provoque une erreur ssl

pip3 install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl

Par contre ça fonctionne parfaitement

pip install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl

Est il possible de modifier cette commande dans le script d’installation ?

Hello,

Ce bug est déjà connus ici : https://github.com/YunoHost-Apps/pgadmin_ynh/issues/3

Est tu sûr vraiment que la commande avec pip fonctionne alors que avec pip3 échoue ? J’ai un petit peux des doutes à ce propos étant donné que ces 2 commande ont exactement le même code exécuté (d’après ce que j’ai vu).

Les commandes fonctionnent normalement quand je les lances tel qu’écrite précédemment.
Par contre avec

yunohost app install -l pgAdmin GitHub - YunoHost-Apps/pgadmin_ynh: PostgreSQL web admin tool package for YunoHost

Attention : [ERR] !!
Attention : pgadmin’s script has encountered an error. Its execution was cancelled.
Attention : !!
Attention : Please find here an extract of the log before the crash:
Attention : [DEBUG]: DEBUG -’
Attention : [DEBUG]: DEBUG - +++ basename /opt/yunohost/pgadmin
Attention : [DEBUG]: DEBUG - ++ PS1=‘(pgadmin) ’
Attention : [DEBUG]: DEBUG - ++ export PS1
Attention : [DEBUG]: DEBUG - ++ alias pydoc
Attention : [DEBUG]: DEBUG -’
Attention : [DEBUG]: DEBUG - ++ hash -r
Attention : [DEBUG]: DEBUG - + pip3 install --upgrade pip
Attention : [DEBUG]: DEBUG - Collecting pip
Attention : [DEBUG]: DEBUG - Using cached https://files.pythonhosted.org/packages/54/0c/d01aa759fdc501a58f431eb594a17495f15b88da142ce14b5845662c13f3
/pip-20.0.2-py2.py3-none-any.whl
Attention : [DEBUG]: DEBUG - Installing collected packages: pip
Attention : [DEBUG]: DEBUG - Found existing installation: pip 9.0.1
Attention : [DEBUG]: DEBUG - Uninstalling pip-9.0.1:
Attention : [DEBUG]: DEBUG - Successfully uninstalled pip-9.0.1
Attention : [DEBUG]: DEBUG - Successfully installed pip-20.0.2
Attention : [DEBUG]: DEBUG - + pip3 install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
Attention : [DEBUG]: DEBUG - Collecting pgadmin4==4.17
Attention : [DEBUG]: WARNING - sslv3 alert handshake failure (_ssl.c:720)‘),)’: /pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
Attention : [DEBUG]: WARNING - sslv3 alert handshake failure (_ssl.c:720)‘),)’: /pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
Attention : [DEBUG]: WARNING - sslv3 alert handshake failure (_ssl.c:720)‘),)’: /pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
Attention : [DEBUG]: WARNING - sslv3 alert handshake failure (_ssl.c:720)‘),)’: /pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
Attention : [DEBUG]: WARNING - sslv3 alert handshake failure (_ssl.c:720)‘),)’: /pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
Attention : [DEBUG]: WARNING - sslv3 alert handshake failure (_ssl.c:720)'),))
Attention : [DEBUG]: WARNING -
Attention : [DEBUG]: DEBUG - + ynh_exit_properly

Donc ? Peut tu ressayer (plusieurs fois) avec pip3 et pip histoire de vraiment valider que ça change quelque chose. Je suspecte que ca soie un peux une erreur random.

Les commandes pip et pip3 fonctionnent suite à cette commande

pip3 install requests --upgrade

mais l’erreur est toujours présente quand je fais

yunohost app install -l pgAdmin GitHub - YunoHost-Apps/pgadmin_ynh: PostgreSQL web admin tool package for YunoHost

Merci pour vos réponses.

Alors j’ai essayé les deux commande pip et pip 3, la pip3 n’a pas fonctionné.

J’ai déjà installé python3 avec la commande:
sudo apt-get install python3-pip

Puis j’ai retesté:
pip3 install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl

Voici le log avec un message d’entrée intéressant.

pip3 install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
WARNING: pip is being invoked by an old script wrapper. This will fail in a future version of pip.
Please see https://github.com/pypa/pip/issues/5599 for advice on fixing the underlying issue.
To avoid this problem you can invoke Python with ‘-m pip’ instead of running pip directly.
Defaulting to user installation because normal site-packages is not writeable
Collecting pgadmin4==4.17
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
.17/pip/pgadmin4-4.17-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
.17/pip/pgadmin4-4.17-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
.17/pip/pgadmin4-4.17-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
.17/pip/pgadmin4-4.17-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
.17/pip/pgadmin4-4.17-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.17/pip/pgadmin4-4.17-py2.py3-none-any.whl (Caused by SSLError(SSLError(1,
‘[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:720)’),))

Hello,

Est-il possible d’essayer les commandes suivantes:

cd /tmp/
python3 -m venv venv
source venv/bin/activate
pip install --upgrade pip
pip3 install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
# Si la dernière commande échoue
pip install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl

Que donne :

dpkg -l | grep ca-certificate

Si ça ne donne rien, il faut tenter:

apt install ca-certificate

Salut à tous,

Josue, j’ai testé les différentes commandes.
Quand j’arrive à pip install --upgrade pip, aucune erreur à signaler:
Collecting pip
Using cached https://files.pythonhosted.org/packages/54/0c/d01aa759fdc501a58f431eb594a17495f15b88da142ce14b5845662c13f3/pip-20.0.2-py2.py3-none-any.w
hl
Installing collected packages: pip
Found existing installation: pip 9.0.1
Uninstalling pip-9.0.1:
Successfully uninstalled pip-9.0.1
Successfully installed pip-20.0.2

Ensuite la suivante:
pip3 install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl

       pip3 install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl        
    Collecting pgadmin4==4.17                                                                                                                              
      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.17/pip/pgadmin4-4.17-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.17/pip/pgadmin4-4.17-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.17/pip/pgadmin4-4.17-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.17/pip/pgadmin4-4.17-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.17/pip/pgadmin4-4.17-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.17/pip/pgadmin4-4.17-py2.py3-none-any.whl (Caused by SSLError(SSLError(1, '[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert ha
    ndshake failure (_ssl.c:720)'),))

Enfin la dernière commande
pip install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
donne exactement le même résultat que la précédente.

Voici le résultat:
ii ca-certificates 20161130+nmu1+deb9u1 all Common CA certificates
ii ca-certificates-java 20170929~deb9u3 all Common CA certificates (JKS keystore)

Mon problème proviendrait-il des certificats SSL?

Vu que ca-certificates est là je ne pense pas.

Les commandes de Josue (Merci beaucoup)

cd /tmp/
python3 -m venv venv
source venv/bin/activate

ensuite

python -m pip install pip==20.0.2
exit

désormais ça fonctionne :crazy_face:

pip3 install --upgrade --ignore-installed https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl

A voir si l’installation via yunohost fonctionne elle ?

Edit : b’en non toujours l’erreur avec le script d’install yunohost :sob:

@Obelix, La solution serait donc d’installer pip version 20.0.2 ?

Pourtant avec le script yunohost il y a un pip install --upgrade pip donc normalement il doit bien y avoir la version 20.0.2 installée.

D’après le post ici le bug est aussi présent avec la version 20.0.2…

J"ai ce log d’erreur

[DEBUG]: DEBUG -’
Attention : [DEBUG]: DEBUG - ++ hash -r
Attention : [DEBUG]: DEBUG - + pip3 install --upgrade pip
Attention : [DEBUG]: DEBUG - Collecting pip
Attention : [DEBUG]: DEBUG - Using cached https://files.pythonhosted.org/packages/54/0c/d01aa759fdc501a58f431eb594a17495f15b88da142ce14b5845662c13f3/pip-20.0.2-py2.py3-none-any.whl
Attention : [DEBUG]: DEBUG - Installing collected packages: pip
Attention : [DEBUG]: DEBUG - Found existing installation: pip 9.0.1
Attention : [DEBUG]: DEBUG - Uninstalling pip-9.0.1:
Attention : [DEBUG]: DEBUG - Successfully uninstalled pip-9.0.1
Attention : [DEBUG]: DEBUG - Successfully installed pip-20.0.2
Attention : [DEBUG]: DEBUG - + pip3 install --upgrade ‘Werkzeug<1.0’
Attention : [DEBUG]: DEBUG - Collecting Werkzeug<1.0
Attention : [DEBUG]: DEBUG - Using cached Werkzeug-0.16.1-py2.py3-none-any.whl (327 kB)
Attention : [DEBUG]: DEBUG - Installing collected packages: Werkzeug
Attention : [DEBUG]: DEBUG - Successfully installed Werkzeug-0.16.1
:lying_face:
Attention : [DEBUG]: DEBUG - + pip3 install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
Attention : [DEBUG]: DEBUG - Collecting pgadmin4==4.17
Attention : [DEBUG]: WARNING - sslv3 alert handshake failure (_ssl.c:720)‘),)’: /pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
Attention : [DEBUG]: WARNING - sslv3 alert handshake failure (_ssl.c:720)‘),)’: /pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
Attention : [DEBUG]: WARNING - sslv3 alert handshake failure (_ssl.c:720)‘),)’: /pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
Attention : [DEBUG]: WARNING - sslv3 alert handshake failure (_ssl.c:720)‘),)’: /pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
Attention : [DEBUG]: WARNING - sslv3 alert handshake failure (_ssl.c:720)‘),)’: /pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl
Attention : [DEBUG]: WARNING - sslv3 alert handshake failure (_ssl.c:720)'),))
Attention : [DEBUG]: WARNING -
Attention : [DEBUG]: DEBUG - + ynh_exit_properly

Enfin moi j’y connais rien, je suppose que dans le script il serait possible d’ajouter

> pip3 install --upgrade https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.17/pip/pgadmin4-4.17-py2.py3-none-any.whl --trusted-host ftp.postgresql.org

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.

J’ai le même souci, et c’est moi qui ai posté le ticket dans le dépôt github.

Le hic, c’est que malgré mes logs, le packager n’a pas la moindre idée d’où se trouve la couille, d’autant que chez lui, ça marche impec.