phpmyadmin error 500

Discussion in 'Installation/Configuration' started by Lecrivain yoann, Jun 18, 2021.

  1. Lecrivain yoann

    Lecrivain yoann New Member

    hello, i use debian 10.

    Since install php8 and update last version ispconfig i have error 500 in phpmyadmin.

    I re configure default php by php 7.4.

    this is error :

     
    Last edited: Jun 18, 2021
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  3. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    Shouldn't it be php7.3 for Debian 10?
    And this should be checked too, right?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    phpmyadmin runs via mod_php, so you probably installed mod_php for PHP 8 and switched just back other PHP like php-cli but not mod_php.
     
    Th0m likes this.
  5. Lecrivain yoann

    Lecrivain yoann New Member

    Hello till,

    I have installed mod php with this command :
    But not resolve problem
     
  6. Lecrivain yoann

    Lecrivain yoann New Member

    I have testing multiple tuto,, i have the same error.
     
  7. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

  8. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    What you need to do is install mod-php for the PHP version PHPMyAdmin uses. On Debian 10 the default PHP version must be PHP 7.3, so install libapache2-mod-php7.3.
    It would help if you showed the results of common issues test script, I gave you the link in reply #2.
     
  9. Lecrivain yoann

    Lecrivain yoann New Member

    Hello, Taleman,

    Result for this answer 2:

    Code:
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] OS version is Debian GNU/Linux 10 (buster)
     
    [INFO] uptime:  14:08:08 up 112 days, 19:38,  2 users,  load average: 0.37, 0.38, 0.30
     
    [INFO] memory:
                  total        used        free      shared  buff/cache   available
    Mem:           15Gi       1.9Gi       739Mi       231Mi        12Gi        13Gi
    Swap:         511Mi        80Mi       431Mi
     
    [INFO] systemd failed services status:
    0 loaded units listed. Pass --all to see loaded but inactive units, too.
    To show all installed unit files use 'systemctl list-unit-files'.
    
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.2.5
    
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 7.4.20
    [INFO] php-cgi (used for cgi php in default vhost!) is version 7.4.20
    
    ##### PORT CHECK #####
    
    
    ##### MAIL SERVER CHECK #####
    
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
        Apache 2 (PID 25270)
    [INFO] I found the following mail server(s):
        Postfix (PID 18199)
    [INFO] I found the following pop3 server(s):
        Dovecot (PID 18282)
    [INFO] I found the following imap server(s):
        Dovecot (PID 18282)
    [INFO] I found the following ftp server(s):
        PureFTP (PID 18437)
    
    ##### LISTENING PORTS #####
    (only        ()
    Local        (Address)
    [localhost]:3306        (17948/mysqld)
    [localhost]:10027        (18199/master)
    [anywhere]:587        (18199/master)
    [localhost]:11211        (25665/memcached)
    [anywhere]:110        (18282/dovecot)
    [anywhere]:143        (18282/dovecot)
    [anywhere]:465        (18199/master)
    ***.***.***.***:53        (18447/named)
    [localhost]:53        (18447/named)
    [anywhere]:21        (18437/pure-ftpd)
    [anywhere]:22        (16789/sshd)
    [localhost]:953        (18447/named)
    [anywhere]:25        (18199/master)
    [anywhere]:993        (18282/dovecot)
    [anywhere]:995        (18282/dovecot)
    [localhost]:10025        (18199/master)
    *:*:*:*::*:587        (18199/master)
    [localhost]10        (18282/dovecot)
    [localhost]43        (18282/dovecot)
    *:*:*:*::*:8080        (25270/apache2)
    *:*:*:*::*:80        (25270/apache2)
    *:*:*:*::*:8081        (25270/apache2)
    *:*:*:*::*:465        (18199/master)
    *:*:*:*::*:53        (18447/named)
    *:*:*:*::*:21        (18437/pure-ftpd)
    *:*:*:*::*:22        (16789/sshd)
    *:*:*:*::*:25        (18199/master)
    *:*:*:*::*:443        (25270/apache2)
    *:*:*:*::*:993        (18282/dovecot)
    *:*:*:*::*:995        (18282/dovecot)
    
    
    
    
    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target     prot opt source               destination         
    f2b-pureftpd  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 21
    f2b-sshd   tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 22
    
    Chain FORWARD (policy ACCEPT)
    target     prot opt source               destination         
    
    Chain OUTPUT (policy ACCEPT)
    target     prot opt source               destination         
    
    Chain f2b-sshd (1 references)
    target     prot opt source               destination         
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***         [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***      [anywhere]/0            reject-with icmp-port-unreachable
    RETURN     all  --  [anywhere]/0            [anywhere]/0           
    
    Chain f2b-pureftpd (1 references)
    target     prot opt source               destination         
    RETURN     all  --  [anywhere]/0            [anywhere]/0           
    
    
    
    
    ##### LET'S ENCRYPT #####
    Certbot is installed in /usr/bin/letsencrypt
    
    
     
  10. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Code:
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 7.4.20
    [INFO] php-cgi (used for cgi php in default vhost!) is version 7.4.20
    
    ##### PORT CHECK #####
    ISPConfig supports only the default PHP version that comes with the OS ISPConfig is running on. For Debian 10 this is PHP 7.3.
    On how to repair, see https://www.howtoforge.com/tutorial...bian-default-php-back-to-the-original-version
    You can read that document from beginning to end to learn how to have multiple PHP version in a way that works.
     
  11. Lecrivain yoann

    Lecrivain yoann New Member

    Thank you,

    I go testing this instruction and make a feedback.
     
  12. Lecrivain yoann

    Lecrivain yoann New Member

    Hello,

    I have change version php, i use php 7.3.

    I have unistall all libapache2-mod-php7.* and i only reinstall libapache2-mod-php7.3.

    I have a same erreor, i not found how to repair my phpmyadmin.

    Regards
     
  13. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    How did you install phpmyadmin?
    What shows command
    Code:
    apt policy phpmyadmin
    Have you done
    Code:
    ispconfig_update.sh --force
     
  14. Lecrivain yoann

    Lecrivain yoann New Member

    Yes i have done
    ispconfig_update.sh --force
     
  15. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Jesse Norell likes this.
  16. Lecrivain yoann

    Lecrivain yoann New Member

  17. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    If you installed PHPMyAdmin manually that installed application is not working now. Try doing the installation and configuration again. Or debug more to find what is wrong.
     
  18. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

Share This Page