phpmyadmin reporting 502

Discussion in 'Installation/Configuration' started by Kashinoda, Jan 3, 2023.

  1. Kashinoda

    Kashinoda New Member

    Hi,
    I installed 3.2.9 on a fresh Ubuntu 22.04 install using the new install script and everything is working without issue, though navigating to sub-domain.domain.eu:8081/phpmyadmin/ returns a 502 error.

    Here is is the error Nginx throws:
    Code:
    2023/01/03 08:18:54 [error] 242213#242213: *1 connect() failed (111: Unknown error) while connecting to upstream, client: 88.88.88.88, server: _, request: "GET /phpmyadmin/ HTTP/2.0", upstream: "fastcgi://127.0.0.1:9000", host: "sub-domain.domain.eu:8081"
    2023/01/03 08:18:57 [error] 242213#242213: *1 directory index of "/var/www/apps/" is forbidden, client: 88.88.88.88, server: _, request: "GET / HTTP/2.0", host: "sub-domain.domain.eu:8081"
    
    The install arguments used were as follows:
    Code:
    wget -O - https://get.ispconfig.org | sh -s -- --use-php=8.1 --use-certbot --use-nginx --no-dns --no-mail --no-roundcube --no-mailman --no-quota
    Here is the relevant block in apps.vhost
    Code:
            location /phpmyadmin {
                   root /usr/share/;
                   index index.php index.html index.htm;
                   location ~ ^/phpmyadmin/(.+\.php)$ {
                           try_files $uri =404;
                           root /usr/share/;
                           fastcgi_param   QUERY_STRING            $query_string;
                           fastcgi_param   REQUEST_METHOD          $request_method;
                           fastcgi_param   CONTENT_TYPE            $content_type;
                           fastcgi_param   CONTENT_LENGTH          $content_length;
    
                           fastcgi_param   SCRIPT_FILENAME         $request_filename;
                           fastcgi_param   SCRIPT_NAME             $fastcgi_script_name;
                           fastcgi_param   REQUEST_URI             $request_uri;
                           fastcgi_param   DOCUMENT_URI            $document_uri;
                           fastcgi_param   DOCUMENT_ROOT           $document_root;
                           fastcgi_param   SERVER_PROTOCOL         $server_protocol;
    
                           fastcgi_param   GATEWAY_INTERFACE       CGI/1.1;
                           fastcgi_param   SERVER_SOFTWARE         nginx/$nginx_version;
    
                           fastcgi_param   REMOTE_ADDR             $remote_addr;
                           fastcgi_param   REMOTE_PORT             $remote_port;
                           fastcgi_param   SERVER_ADDR             $server_addr;
                           fastcgi_param   SERVER_PORT             $server_port;
                           fastcgi_param   SERVER_NAME             $server_name;
    
                           fastcgi_param   HTTPS                   $https;
    
                           # PHP only, required if PHP was built with --enable-force-cgi-redirect
                           fastcgi_param   REDIRECT_STATUS         200;
                           # To access phpMyAdmin, the default user (like www-data on Debian/Ubuntu) must be used
                           fastcgi_pass 127.0.0.1:9000;
                           #fastcgi_pass unix:/var/lib/php8.1-fpm/apps.sock;
                           fastcgi_index index.php;
                           fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
                           fastcgi_buffer_size 128k;
                           fastcgi_buffers 256 4k;
                           fastcgi_busy_buffers_size 256k;
                           fastcgi_temp_file_write_size 256k;
                           fastcgi_read_timeout 1200;
                   }
                   location ~* ^/phpmyadmin/(.+\.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ {
                           root /usr/share/;
                   }
            }
            location /phpMyAdmin {
                   rewrite ^/* /phpmyadmin last;
            }
    
     
    Last edited: Jan 3, 2023
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. Kashinoda

    Kashinoda New Member

    Thanks for the reply, here's the output:
    Code:
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] OS version is Ubuntu 22.04.1 LTS
    
    [INFO] uptime:  09:09:24 up  7:05,  3 users,  load average: 0.19, 0.15, 0.11
    
    [INFO] memory:
                   total        used        free      shared  buff/cache   available
    Mem:            31Gi       2.1Gi        22Gi        34Mi       6.5Gi        28Gi
    Swap:          511Mi          0B       511Mi
    
    [INFO] systemd failed services status:
      UNIT LOAD ACTIVE SUB DESCRIPTION
    0 loaded units listed.
    
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.2.9
    
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 8.1.13
    [INFO] php-cgi (used for cgi php in default vhost!) is version 8.1.13
    
    ##### PORT CHECK #####
    
    [WARN] Port 143 (IMAP server) seems NOT to be listening
    [WARN] Port 993 (IMAP server SSL) seems NOT to be listening
    [WARN] Port 110 (POP3 server) seems NOT to be listening
    [WARN] Port 995 (POP3 server SSL) seems NOT to be listening
    [WARN] Port 465 (SMTP server SSL) seems NOT to be listening
    [WARN] Port 22 (SSH server) seems NOT to be listening
    
    ##### MAIL SERVER CHECK #####
    
    [WARN] I found no "submission" entry in your postfix master.cf
    [INFO] this is not critical, but if you want to offer port 587 for smtp connections you have to enable this.
    [WARN] I found no "smtps" entry in your postfix master.cf
    [INFO] this is not critical, but if you want to offer SSL for smtp (not TLS) connections you have to enable this.
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
        Unknown process (nginx:) (PID 243635)
    [INFO] I found the following mail server(s):
        Postfix (PID 53948)
    [WARN] I could not determine which pop3 server is running.
    [WARN] I could not determine which imap server is running.
    [INFO] I found the following ftp server(s):
        PureFTP (PID 239811)
    
    ##### LISTENING PORTS #####
    (only        ()
    Local        (Address)
    [localhost]:34881        (209578/sinusbot)
    [anywhere]:30033        (193551/./ts3server)
    [localhost]:953        (54004/named)
    [localhost]:953        (54004/named)
    [localhost]:953        (54004/named)
    [localhost]:953        (54004/named)
    [localhost]:953        (54004/named)
    [localhost]:953        (54004/named)
    [localhost]:953        (54004/named)
    [localhost]:953        (54004/named)
    [localhost]:53        (54004/named)
    [localhost]:53        (54004/named)
    [localhost]:53        (54004/named)
    [localhost]:53        (54004/named)
    [localhost]:53        (54004/named)
    [localhost]:53        (54004/named)
    [localhost]:53        (54004/named)
    [localhost]:53        (54004/named)
    [localhost]:25        (53948/master)
    [localhost]:8087        (209578/sinusbot)
    [anywhere]:10080        (193551/./ts3server)
    [anywhere]:10011        (193551/./ts3server)
    [anywhere]:10022        (193551/./ts3server)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    [localhost]:6010        (246092/sshd:)
    [localhost]:11211        (49664/memcached)
    [anywhere]:6001        (241972/Xtightvnc)
    [anywhere]:5901        (241972/Xtightvnc)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    ***.***.***.***:53        (54004/named)
    [anywhere]:8080        (243635/nginx:)
    [anywhere]:8081        (243635/nginx:)
    [anywhere]:56959        (220023/sshd:)
    [anywhere]:443        (243635/nginx:)
    [anywhere]:80        (243635/nginx:)
    [anywhere]:21        (239811/pure-ftpd)
    ***.***.***.***:53        (207930/systemd-reso)
    [anywhere]:3306        (243697/mariadbd)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:30033        (193551/./ts3server)
    [localhost]0080        (193551/./ts3server)
    [localhost]0011        (193551/./ts3server)
    [localhost]0022        (193551/./ts3server)
    *:*:*:*::*1eb7:2cff:feb0:53        (54004/named)
    *:*:*:*::*1eb7:2cff:feb0:53        (54004/named)
    *:*:*:*::*1eb7:2cff:feb0:53        (54004/named)
    *:*:*:*::*1eb7:2cff:feb0:53        (54004/named)
    *:*:*:*::*1eb7:2cff:feb0:53        (54004/named)
    *:*:*:*::*1eb7:2cff:feb0:53        (54004/named)
    *:*:*:*::*1eb7:2cff:feb0:53        (54004/named)
    *:*:*:*::*1eb7:2cff:feb0:53        (54004/named)
    *:*:*:*::*:953        (54004/named)
    *:*:*:*::*:953        (54004/named)
    *:*:*:*::*:953        (54004/named)
    *:*:*:*::*:953        (54004/named)
    *:*:*:*::*:953        (54004/named)
    *:*:*:*::*:953        (54004/named)
    *:*:*:*::*:953        (54004/named)
    *:*:*:*::*:953        (54004/named)
    *:*:*:*::*:25        (53948/master)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:53        (54004/named)
    *:*:*:*::*:8080        (243635/nginx:)
    *:*:*:*::*:8081        (243635/nginx:)
    *:*:*:*::*:56959        (220023/sshd:)
    *:*:*:*::*:6010        (246092/sshd:)
    *:*:*:*::*:443        (243635/nginx:)
    *:*:*:*::*:80        (243635/nginx:)
    *:*:*:*::*:21        (239811/pure-ftpd)
    *:*:*:*::*:3306        (243697/mariadbd)
    
    ##### LET'S ENCRYPT #####
    Certbot is installed in /usr/bin/letsencrypt
    The service appears to be running fine, though I have restarted it to check:
    Code:
    ● php8.1-fpm.service - The PHP 8.1 FastCGI Process Manager
         Loaded: loaded (/lib/systemd/system/php8.1-fpm.service; enabled; vendor preset: enabled)
         Active: active (running) since Tue 2023-01-03 09:19:28 UTC; 5min ago
           Docs: man:php-fpm8.1(8)
        Process: 246760 ExecStartPost=/usr/lib/php/php-fpm-socket-helper install /run/php/php-fpm.sock /etc/php/8.1/fpm/pool.d/www.conf 81 (code=exited, status=0/SUCCESS)
       Main PID: 246753 (php-fpm8.1)
         Status: "Processes active: 0, idle: 6, Requests: 54, slow: 0, Traffic: 0.1req/sec"
          Tasks: 7 (limit: 38246)
         Memory: 25.7M
            CPU: 716ms
         CGroup: /system.slice/php8.1-fpm.service
                 ├─246753 "php-fpm: master process (/etc/php/8.1/fpm/php-fpm.conf)" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" ""
                 ├─246754 "php-fpm: pool apps-{fpm_domain}" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" >
                 ├─246755 "php-fpm: pool apps-{fpm_domain}" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" >
                 ├─246756 "php-fpm: pool ispconfig" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "">
                 ├─246757 "php-fpm: pool ispconfig" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "">
                 ├─246758 "php-fpm: pool www" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "">
                 └─246759 "php-fpm: pool www" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "">
    
    Jan 03 09:19:28 ns3036176 systemd[1]: Starting The PHP 8.1 FastCGI Process Manager...
    Jan 03 09:19:28 ns3036176 systemd[1]: Started The PHP 8.1 FastCGI Process Manager.
     
  4. Kashinoda

    Kashinoda New Member

    Got it to work by changing fastcgi_pass to use a Unix socket rather than a TCP connection in apps.vhost
    Code:
    #fastcgi_pass 127.0.0.1:9000;
    fastcgi_pass unix:/var/lib/php8.1-fpm/apps.sock;
    Not sure if that matters but this mirrors apps.conf in /etc/php/8.1/fpm/pool.d
    Code:
    [apps-{fpm_domain}]
    
    listen = /var/lib/php8.1-fpm/apps.sock
    listen.owner = ispapps
    listen.group = ispapps
    listen.mode = 0660
     
    Last edited: Jan 4, 2023
  5. till

    till Super Moderator Staff Member ISPConfig Developer

  6. Kashinoda

    Kashinoda New Member

    Not sure if this is a red herring but when performing ispconfig_update.sh --force just now (because I purged my cronjob o_O), the following error was shown:
    Everything is working anyway, thanks for all yoru hard work on ISPConfig!
     

Share This Page