Jump to content
jnrmy

phpMyAdmin ne fonctionne plus

Recommended Posts

Bonjour tout le monde,

J'ai un petit soucis avec phpMyAdmin sur mon container. Pour pouvoir activer HTTP2 sur mes sites, j'ai du passer de prefork à event sur Apache. Pour cela j'ai aussi dû aussi désactiver PHP 7.0 (c'était la version de PHP avec laquelle j'ai installé mon serveur il y a deux ans).

Depuis, problème : quand je me rends sur adressedemonserveur.fr/phpmyadmin je n'ai plus qu'une page de code php en brut.

J'avais déjà remarqué ce problème quand je suis passé de PHP 7.0 à 7.3 en pensant retirer la 7.0, ce que je n'ai finalement pas fait. Aujourd'hui la version principalement utilisée est la 7.4. Il y a aussi la 5.6 pour faire fonctionner un vieux Drupal qui n'est plus à jour depuis bien longtemps.

J'ai tenté de réinstaller phpMyAdmin, mis à jour avec la dernière version, mais rien n'y fait, j'ai toujours une page de code php affichée au lieu de PMA.

Quelqu'un aurait une idée de comment retrouver PMA sans devoir utiliser PHP 7.0 ?

Merci d'avance,
JR

Share this post


Link to post
Share on other sites

Bonjour,

Si vous avez une page "brut" c'est que php n'est pas chargé.
Essayez d'installer ce package : php7.4-fpm (ou php7.3-fpm si vous êtes en 7.3)

Cordialement,
Mick

Share this post


Link to post
Share on other sites
Posted (edited)

Bonjour,

Pouvez-vous nous donner le résultat des commandes : apache2 -V   puis   dpkg -l | grep php   (pour debian/ubuntu, à adapter selon la distrib)

Je vais m'installer un petit container vite fait pour tester (car chez moi je n'utilise que des nginx)

Cordialement,
Mick

Edited by Mickelebof

Share this post


Link to post
Share on other sites

apache2 -V :

AH00548: NameVirtualHost has no effect and will be removed in the next release /etc/apache2/sites-enabled/000-ispconfig.conf:73
Server version: Apache/2.4.25 (Debian)
Server built:   2019-10-13T15:43:54
Server's Module Magic Number: 20120211:68
Server loaded:  APR 1.5.2, APR-UTIL 1.5.4
Compiled using: APR 1.5.2, APR-UTIL 1.5.4
Architecture:   64-bit
Server MPM:     event
  threaded:     yes (fixed thread count)
    forked:     yes (variable process count)
Server compiled with....
 -D APR_HAS_SENDFILE
 -D APR_HAS_MMAP
 -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
 -D APR_USE_SYSVSEM_SERIALIZE
 -D APR_USE_PTHREAD_SERIALIZE
 -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
 -D APR_HAS_OTHER_CHILD
 -D AP_HAVE_RELIABLE_PIPED_LOGS
 -D DYNAMIC_MODULE_LIMIT=256
 -D HTTPD_ROOT="/etc/apache2"
 -D SUEXEC_BIN="/usr/lib/apache2/suexec"
 -D DEFAULT_PIDLOG="/var/run/apache2.pid"
 -D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
 -D DEFAULT_ERRORLOG="logs/error_log"
 -D AP_TYPES_CONFIG_FILE="mime.types"
 -D SERVER_CONFIG_FILE="apache2.conf"

dpkg -l | grep php :

ii  libapache2-mod-php                2:7.4+75+0~20200423.24+debian9~1.gbp7ccdd5                    all          server-side, HTML-embedded scripting language (Apache 2 module) (default)
ii  libapache2-mod-php5.6             5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        server-side, HTML-embedded scripting language (Apache 2 module)
ii  libapache2-mod-php7.0             7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        server-side, HTML-embedded scripting language (Apache 2 module)
ii  libapache2-mod-php7.3             7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        server-side, HTML-embedded scripting language (Apache 2 module)
ii  libapache2-mod-php7.4             7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        server-side, HTML-embedded scripting language (Apache 2 module)
ii  php-apcu                          5.1.18+4.0.11-1+0~20191219.13+debian9~1.gbpa99079             amd64        APC User Cache for PHP
ii  php-apcu-bc                       1.0.5-1+0~20191128.11+debian9~1.gbp90a6a0                     amd64        APCu Backwards Compatibility Module
ii  php-auth-sasl                     1.0.6-3                                                       all          Abstraction of various SASL mechanism responses
ii  php-bz2                           2:7.4+75+0~20200423.24+debian9~1.gbp7ccdd5                    all          bzip2 module for PHP [default]
ii  php-common                        2:75+0~20200423.24+debian9~1.gbp7ccdd5                        all          Common files for PHP packages
ii  php-gettext                       1.0.12-0.1                                                    all          transitional dummy package for php-php-gettext
ii  php-igbinary                      3.1.2+2.0.8-1+0~20200225.15+debian9~1.gbp1a098b               amd64        igbinary PHP serializer
ii  php-imagick                       3.4.4-4+0~20200302.14+debian9~1.gbp2925ae                     amd64        Provides a wrapper to the ImageMagick library
ii  php-mail-mime                     1.10.0-2                                                      all          PHP PEAR module for creating MIME messages
ii  php-mbstring                      2:7.4+75+0~20200423.24+debian9~1.gbp7ccdd5                    all          MBSTRING module for PHP [default]
ii  php-memcached                     3.1.5+2.2.0-1+0~20200321.18+debian9~1.gbpb3c6fc               amd64        memcached extension module for PHP, uses libmemcached
ii  php-msgpack                       2.1.0+0.5.7-1+0~20200302.13+debian9~1.gbp2567f1               amd64        PHP extension for interfacing with MessagePack
ii  php-mysql                         2:7.4+75+0~20200423.24+debian9~1.gbp7ccdd5                    all          MySQL module for PHP [default]
ii  php-net-smtp                      1.7.1-2                                                       all          PHP PEAR module implementing SMTP protocol
ii  php-net-socket                    1.0.14-2                                                      all          Network Socket Interface
ii  php-pear                          1:1.10.9+submodules+notgz-1+0~20191119.13+debian9~1.gbp296d25 all          PEAR Base System
ii  php-php-gettext                   1.0.12-0.1                                                    all          read gettext MO files directly, without requiring anything other than PHP
ii  php-phpseclib                     2.0.4-1                                                       all          implementations of an arbitrary-precision integer arithmetic library
ii  php-tcpdf                         6.2.12+dfsg2-1                                                all          PHP class for generating PDF files on-the-fly
ii  php-xml                           2:7.4+75+0~20200423.24+debian9~1.gbp7ccdd5                    all          DOM, SimpleXML, WDDX, XML, and XSL module for PHP [default]
ii  php5.6                            5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   all          server-side, HTML-embedded scripting language (metapackage)
ii  php5.6-bz2                        5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        bzip2 module for PHP
ii  php5.6-cgi                        5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        server-side, HTML-embedded scripting language (CGI binary)
ii  php5.6-cli                        5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        command-line interpreter for the PHP scripting language
ii  php5.6-common                     5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        documentation, examples and common module for PHP
ii  php5.6-curl                       5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        CURL module for PHP
ii  php5.6-fpm                        5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        server-side, HTML-embedded scripting language (FPM-CGI binary)
ii  php5.6-gd                         5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        GD module for PHP
ii  php5.6-json                       5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        JSON module for PHP
ii  php5.6-mbstring                   5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        MBSTRING module for PHP
ii  php5.6-mysql                      5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        MySQL module for PHP
ii  php5.6-opcache                    5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        Zend OpCache module for PHP
ii  php5.6-readline                   5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        readline module for PHP
ii  php5.6-xml                        5.6.40-27+0~20200419.33+debian9~1.gbp02e670                   amd64        DOM, SimpleXML, WDDX, XML, and XSL module for PHP
ii  php7.0                            7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   all          server-side, HTML-embedded scripting language (metapackage)
ii  php7.0-bz2                        7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        bzip2 module for PHP
ii  php7.0-cgi                        7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        server-side, HTML-embedded scripting language (CGI binary)
ii  php7.0-cli                        7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        command-line interpreter for the PHP scripting language
ii  php7.0-common                     7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        documentation, examples and common module for PHP
ii  php7.0-curl                       7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        CURL module for PHP
ii  php7.0-fpm                        7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        server-side, HTML-embedded scripting language (FPM-CGI binary)
ii  php7.0-gd                         7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        GD module for PHP
ii  php7.0-imap                       7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        IMAP module for PHP
ii  php7.0-intl                       7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        Internationalisation module for PHP
ii  php7.0-json                       7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        JSON module for PHP
ii  php7.0-mbstring                   7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        MBSTRING module for PHP
ii  php7.0-mcrypt                     7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        libmcrypt module for PHP
ii  php7.0-mysql                      7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        MySQL module for PHP
ii  php7.0-opcache                    7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        Zend OpCache module for PHP
ii  php7.0-pspell                     7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        pspell module for PHP
ii  php7.0-readline                   7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        readline module for PHP
ii  php7.0-recode                     7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        recode module for PHP
ii  php7.0-soap                       7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        SOAP module for PHP
ii  php7.0-sqlite3                    7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        SQLite3 module for PHP
ii  php7.0-tidy                       7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        tidy module for PHP
ii  php7.0-xml                        7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        DOM, SimpleXML, WDDX, XML, and XSL module for PHP
ii  php7.0-xmlrpc                     7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        XMLRPC-EPI module for PHP
ii  php7.0-xsl                        7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   all          XSL module for PHP (dummy)
ii  php7.0-zip                        7.0.33-27+0~20200419.34+debian9~1.gbpf45092                   amd64        Zip module for PHP
ii  php7.3                            7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    all          server-side, HTML-embedded scripting language (metapackage)
ii  php7.3-bcmath                     7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        Bcmath module for PHP
ii  php7.3-bz2                        7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        bzip2 module for PHP
ii  php7.3-cgi                        7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        server-side, HTML-embedded scripting language (CGI binary)
ii  php7.3-cli                        7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        command-line interpreter for the PHP scripting language
ii  php7.3-common                     7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        documentation, examples and common module for PHP
ii  php7.3-curl                       7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        CURL module for PHP
ii  php7.3-fpm                        7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        server-side, HTML-embedded scripting language (FPM-CGI binary)
ii  php7.3-gd                         7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        GD module for PHP
ii  php7.3-imap                       7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        IMAP module for PHP
ii  php7.3-intl                       7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        Internationalisation module for PHP
ii  php7.3-json                       7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        JSON module for PHP
ii  php7.3-mbstring                   7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        MBSTRING module for PHP
ii  php7.3-mysql                      7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        MySQL module for PHP
ii  php7.3-opcache                    7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        Zend OpCache module for PHP
ii  php7.3-pspell                     7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        pspell module for PHP
ii  php7.3-readline                   7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        readline module for PHP
ii  php7.3-recode                     7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        recode module for PHP
ii  php7.3-soap                       7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        SOAP module for PHP
ii  php7.3-sqlite3                    7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        SQLite3 module for PHP
ii  php7.3-tidy                       7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        tidy module for PHP
ii  php7.3-xml                        7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        DOM, SimpleXML, WDDX, XML, and XSL module for PHP
ii  php7.3-xmlrpc                     7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        XMLRPC-EPI module for PHP
ii  php7.3-xsl                        7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    all          XSL module for PHP (dummy)
ii  php7.3-zip                        7.3.17-1+0~20200419.57+debian9~1.gbp0fda17                    amd64        Zip module for PHP
ii  php7.4-bz2                        7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        bzip2 module for PHP
ii  php7.4-cgi                        7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        server-side, HTML-embedded scripting language (CGI binary)
ii  php7.4-cli                        7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        command-line interpreter for the PHP scripting language
ii  php7.4-common                     7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        documentation, examples and common module for PHP
ii  php7.4-curl                       7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        CURL module for PHP
ii  php7.4-fpm                        7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        server-side, HTML-embedded scripting language (FPM-CGI binary)
ii  php7.4-gd                         7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        GD module for PHP
ii  php7.4-imap                       7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        IMAP module for PHP
ii  php7.4-intl                       7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        Internationalisation module for PHP
ii  php7.4-json                       7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        JSON module for PHP
ii  php7.4-mbstring                   7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        MBSTRING module for PHP
ii  php7.4-mysql                      7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        MySQL module for PHP
ii  php7.4-opcache                    7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        Zend OpCache module for PHP
ii  php7.4-readline                   7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        readline module for PHP
ii  php7.4-soap                       7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        SOAP module for PHP
ii  php7.4-sqlite3                    7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        SQLite3 module for PHP
ii  php7.4-tidy                       7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        tidy module for PHP
ii  php7.4-xml                        7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        DOM, SimpleXML, XML, and XSL module for PHP
ii  php7.4-xmlrpc                     7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        XMLRPC-EPI module for PHP
ii  php7.4-xsl                        7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     all          XSL module for PHP (dummy)
ii  php7.4-zip                        7.4.5-1+0~20200419.16+debian9~1.gbpc40fd0                     amd64        Zip module for PHP
ii  phpmyadmin                        4:4.6.6-4                                                     all          MySQL web administration tool

 

Share this post


Link to post
Share on other sites
Posted (edited)

Bonjour,

J'ai réussi à reproduire l'erreur sur mon container ;)

Pour ma part la conf php7.4-fpm n'était pas activée, je l'ai donc chargée : a2enconf php7.4-fpm
J'ai également activé le proxy  cgi : a2enmod proxy_fcgi
redémarrage d'apache : systemctl restart apache2.service
Et phpmyadmin fonctionne.

Cordialement,
Mick

Edited by Mickelebof

Share this post


Link to post
Share on other sites

Et bien pareil. Le proxy cgi était activé mais pas la conf php7.4-fpm. Bien vu.

Merci!

  • Upvote 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...