Error 500 on phpmyadmin

Discussion in 'Installation/Configuration' started by Cris Kolkman, Jul 6, 2021.

  1. Cris Kolkman

    Cris Kolkman Member

    Hello,
    All of the sudden I get an error 500 when I go to the phpmyadmin on my ISPConfig server.
    Only thing I changed was the php version for a different site.
    What could cause it, and do you need more info to address the issue?

    ISPConfig Version: 3.1.15p3
     
  2. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

  3. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    You should upgrade this to the latest.
     
  4. Cris Kolkman

    Cris Kolkman Member

    I have updated ISPConfig to the latest version (still same error 500 for phpmyadmin), below the result for the script:

    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:  12:40:23 up 182 days,  1:34,  1 user,  load average: 0.29, 0.28, 0.36
    
    [INFO] memory:
                  total        used        free      shared  buff/cache   available
    Mem:          3.9Gi       1.7Gi       413Mi       101Mi       1.7Gi       1.7Gi
    Swap:         4.0Gi       105Mi       3.9Gi
    
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.2.5
    
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 7.0.33-52+0~20210701.57+debian10~1.gbp8e49b6
    [INFO] php-cgi (used for cgi php in default vhost!) is version 7.4.21
    
    ##### PORT CHECK #####
    
    
    ##### MAIL SERVER CHECK #####
    
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
            Apache 2 (PID 1283)
    [INFO] I found the following mail server(s):
            Postfix (PID 1072)
    [INFO] I found the following pop3 server(s):
            Dovecot (PID 1233)
    [INFO] I found the following imap server(s):
            Dovecot (PID 1233)
    [INFO] I found the following ftp server(s):
            PureFTP (PID 1337)
    
    ##### LISTENING PORTS #####
    (only           ()
    Local           (Address)
    [anywhere]:993          (1233/dovecot)
    [anywhere]:995          (1233/dovecot)
    [localhost]:10023               (770/postgrey)
    [localhost]:10024               (1218/amavisd-new)
    [localhost]:10025               (1072/master)
    [localhost]:10026               (1218/amavisd-new)
    [localhost]:10027               (1072/master)
    [anywhere]:587          (1072/master)
    [localhost]:11211               (586/memcached)
    [anywhere]:110          (1233/dovecot)
    [anywhere]:143          (1233/dovecot)
    [anywhere]:465          (1072/master)
    ***.***.***.***:53              (1417/named)
    [localhost]:53          (1417/named)
    [anywhere]:21           (1337/pure-ftpd)
    [anywhere]:22           (626/sshd)
    [localhost]:953         (1417/named)
    [anywhere]:25           (1072/master)
    *:*:*:*::*:993          (1233/dovecot)
    *:*:*:*::*:995          (1233/dovecot)
    *:*:*:*::*:10023                (770/postgrey)
    *:*:*:*::*:10024                (1218/amavisd-new)
    *:*:*:*::*:10026                (1218/amavisd-new)
    *:*:*:*::*:3306         (826/mysqld)
    *:*:*:*::*:587          (1072/master)
    [localhost]10           (1233/dovecot)
    [localhost]43           (1233/dovecot)
    *:*:*:*::*:8080         (1283/apache2)
    *:*:*:*::*:80           (1283/apache2)
    *:*:*:*::*:8081         (1283/apache2)
    *:*:*:*::*:465          (1072/master)
    *:*:*:*::*:53           (1417/named)
    *:*:*:*::*:21           (1337/pure-ftpd)
    *:*:*:*::*:22           (626/sshd)
    *:*:*:*::*:953          (1417/named)
    *:*:*:*::*:25           (1072/master)
    *:*:*:*::*:443          (1283/apache2)
    
    
    
    
    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target     prot opt source               destination
    
    Chain FORWARD (policy ACCEPT)
    target     prot opt source               destination
    
    Chain OUTPUT (policy ACCEPT)
    target     prot opt source               destination
    
    
    
    
    ##### LET'S ENCRYPT #####
    Certbot is installed in /usr/bin/letsencrypt
     
  5. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    It seems like your default php version is wrong, as instead of 7.0 or 7.4, it should all be 7.3 for Debian 10.
     
  6. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    For you access phpmyadmin through the individual sites or via the server hostname? Did the latter work?
    Check the apache and php error logs for more info when the error 500 happens.
     
  7. Cris Kolkman

    Cris Kolkman Member

    Okay so I corrected the PHP versions, but still no luck :(

    It justed to work on both, now on neither of the individual sites or server hostname.

    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:  15:19:19 up 9 min,  1 user,  load average: 0.04, 0.18, 0.17
    
    [INFO] memory:
                  total        used        free      shared  buff/cache   available
    Mem:          3.9Gi       1.8Gi       1.2Gi        86Mi       909Mi       1.8Gi
    Swap:         4.0Gi          0B       4.0Gi
    
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.2.5
    
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 7.3.29-1+0~20210701.86+debian10~1.gbp7ad6eb
    [INFO] php-cgi (used for cgi php in default vhost!) is version 7.3.29
    
    ##### PORT CHECK #####
    
    
    ##### MAIL SERVER CHECK #####
    
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
            Apache 2 (PID 1052)
    [INFO] I found the following mail server(s):
            Postfix (PID 960)
    [INFO] I found the following pop3 server(s):
            Dovecot (PID 619)
    [INFO] I found the following imap server(s):
            Dovecot (PID 619)
    [INFO] I found the following ftp server(s):
            PureFTP (PID 1112)
    
    ##### LISTENING PORTS #####
    (only           ()
    Local           (Address)
    [localhost]:10025               (960/master)
    [localhost]:10026               (1136/amavisd-new)
    [localhost]:10027               (960/master)
    [anywhere]:587          (960/master)
    [localhost]:11211               (612/memcached)
    [anywhere]:110          (619/dovecot)
    [anywhere]:143          (619/dovecot)
    [anywhere]:465          (960/master)
    [anywhere]:21           (1112/pure-ftpd)
    ***.***.***.***:53              (624/named)
    [localhost]:53          (624/named)
    [anywhere]:22           (722/sshd)
    [anywhere]:25           (960/master)
    [localhost]:953         (624/named)
    [anywhere]:993          (619/dovecot)
    [anywhere]:995          (619/dovecot)
    [localhost]:10023               (878/postgrey)
    [localhost]:10024               (1136/amavisd-new)
    *:*:*:*::*:10026                (1136/amavisd-new)
    *:*:*:*::*:3306         (721/mysqld)
    *:*:*:*::*:587          (960/master)
    [localhost]10           (619/dovecot)
    [localhost]43           (619/dovecot)
    *:*:*:*::*:8080         (1052/apache2)
    *:*:*:*::*:80           (1052/apache2)
    *:*:*:*::*:8081         (1052/apache2)
    *:*:*:*::*:465          (960/master)
    *:*:*:*::*:21           (1112/pure-ftpd)
    *:*:*:*::*:53           (624/named)
    *:*:*:*::*:22           (722/sshd)
    *:*:*:*::*:25           (960/master)
    *:*:*:*::*:953          (624/named)
    *:*:*:*::*:443          (1052/apache2)
    *:*:*:*::*:993          (619/dovecot)
    *:*:*:*::*:995          (619/dovecot)
    *:*:*:*::*:10023                (878/postgrey)
    *:*:*:*::*:10024                (1136/amavisd-new)
    
    
    
    
    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target     prot opt source               destination
    
    Chain FORWARD (policy ACCEPT)
    target     prot opt source               destination
    
    Chain OUTPUT (policy ACCEPT)
    target     prot opt source               destination
    
    
    
    
    ##### LET'S ENCRYPT #####
    Certbot is installed in /usr/bin/letsencrypt
     
  8. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    If they worked before, try rechecking your PMA installation and configuration, then if all are good, force update ISPConfig reconfiguring all services. I am just guessing as no logs was provided.
     
  9. Cris Kolkman

    Cris Kolkman Member

    Tried this all, re-install phpmyadmin and forced ISPConfig update with reconfigure services, still no luck :(
     
  10. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    What shows up in your apache and php error logs when you get "error 500" for phpmyadmin?
     
  11. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    How do you access your PMA when it was fine before? Can you compare your back up vhost file or other directives that you were using with the ones you are facing error 500 now?
     
  12. Cris Kolkman

    Cris Kolkman Member

    I don't see a lot regarding this in the error logs.
    Maybe I'm looking in the wrong ones? Can you point me to the correct ones?
     
  13. Cris Kolkman

    Cris Kolkman Member

    Just like the way I always did (and do it now), via ispconfigurl.com:8080/phpmyadmin
     
  14. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    What is in the PMA block in your current ispconfig.vhost?
     
  15. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    /var/log/apache2/error.log for the server apache error log (individual sites each have their own); for php it depends what mode you're using, I think mod_php messages would be in that same apache error.log, or php-fpm has a separate log file for each version, eg. /var/log/php7.3-fpm.log.
     

Share This Page