phpMyAdmin errors in combination with froxlor and php-fpm

The configuration file now needs a secret passphrase (blowfish_secret).

The $cfg['TempDir'] (/var/lib/phpmyadmin/tmp/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.

[proxy_fcgi:error] [pid 2106071] [client XXX.XXX.XXX.XXX:XXXXX] AH01071: Got error 'PHP message: phpmyadmin: Failed to load /var/lib/phpmyadmin/blowfish_secret.inc.php Check group www-data has read access and open_basedir restrictions.PHP message: phpmyadmin: Failed to load /etc/phpmyadmin/config-db.php Check group www-data has read access and open_basedir restrictions.'

touch /etc/php/8.1/fpm/pool.d/phpmyadmin.conf

[phpmyadmin]

listen = /run/php/php8.1-fpm.d/phpmyadmin.sock

listen.owner = www-data

listen.group = www-data



user = www-data

group = www-data



pm = dynamic

pm.max_children = 5

pm.start_servers = 3

pm.min_spare_servers = 1

pm.max_spare_servers = 3

pm.max_requests = 200



php_admin_value[upload_tmp_dir] = /var/lib/phpmyadmin/tmp

php_admin_value[open_basedir] = /usr/share/phpmyadmin/:/usr/share/doc/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/:/usr/share/javascript/

# limit libapache2-mod-php to files and directories necessary by pma

<IfModule mod_php7.c>

    php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp

    php_admin_value open_basedir /usr/share/phpmyadmin/:/usr/share/doc/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/:/usr/share/javascript/

</IfModule>

# Explicit FastCGI handler

ProxyPassMatch ^/phpmyadmin/(.*\.php)$ unix:/run/php/php8.1-fpm.d/phpmyadmin.sock|fcgi://localhost/usr/share/phpmyadmin/$1

ProxyPassMatch ^/phpmyadmin/(.*\.php)$ unix:/run/php/php8.1-fpm.d/phpmyadmin.sock|fcgi://localhost/usr/share/phpmyadmin$1index.php

<FilesMatch \.php$>

    SetHandler "proxy:unix:/run/php/php8.1-fpm-phpmyadmin.sock|fcgi://localhost/"

</FilesMatch>

# phpMyAdmin default Apache configuration



Alias /phpmyadmin /usr/share/phpmyadmin



<Directory /usr/share/phpmyadmin>

    Options SymLinksIfOwnerMatch

    DirectoryIndex index.php



    # limit libapache2-mod-php to files and directories necessary by pma

    <IfModule mod_php7.c>

        php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp

        php_admin_value open_basedir /usr/share/phpmyadmin/:/usr/share/doc/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/:/usr/share/jav>

    </IfModule>

</Directory>



# Explicit FastCGI handler

ProxyPassMatch ^/phpmyadmin/(.*\.php)$ unix:/run/php/php8.1-fpm.d/phpmyadmin.sock|fcgi://localhost/usr/share/phpmyadmin/$1

ProxyPassMatch ^/phpmyadmin/(.*\.php)$ unix:/run/php/php8.1-fpm.d/phpmyadmin.sock|fcgi://localhost/usr/share/phpmyadmin$1index.php



# Disallow web access to directories that don't need it

<Directory /usr/share/phpmyadmin/templates>

    Require all denied

</Directory>

<Directory /usr/share/phpmyadmin/libraries>

    Require all denied

</Directory>

systemctl restart php8.1-fpm

systemctl restart apache2