I saw threads about it on this forum but nothing helped. Owner of folder is hestiamail:www-data, full rights, in openbasedir php_admin_value[open_basedir] = /home/user/.composer:/home/user/web/forum.happypc.ru/public_html:/home/user/web/forum.happypc.ru/private:/home/user/web/forum.happypc.ru/public_shtml:/home/user/tmp:/tmp:/var/www/html:/bin:/usr/bin:/usr/local/bin:/usr/share:/opt:/usr/share/phpmyadmin/tmp
Please help me solve it
To fix it take a look to this post:
Greetings! Thanks but it doesn’t help. Same warning
Show the output of these commands:
cat -A /etc/phpmyadmin/conf.d/02-tempdir.php
ls -la /var/lib/phpmyadmin/tmp
curl -fsSLm30 https://7j.gg/hcpver | bash
root@wolf:\~# cat -A /etc/phpmyadmin/conf.d/02-tempdir.php
<?php$
$cfg['TempDir'] = '/var/lib/phpmyadmin/tmp';$
root@wolf:~# ls -la /var/lib/phpmyadmin/tmp
total 8
drwxrwxr-x 2 hestiamail www-data 4096 Feb 21 02:25 .
drwxr-xr-x 3 root root 4096 Feb 21 02:25 ..
root@wolf:~# curl -fsSLm30 https://7j.gg/hcpver | bash
Software Version
-------- -------
OS Ubuntu 22.04.5 LTS
Hestia 1.9.6
Hestia-nginx 1.30.2
Hestia-php 8.4.21
FileGator 7.14.3
Nginx 1.31.2
Apache2 2.4.68
PHP8.2 8.2.31
PHP8.1 8.1.34
PHP8.0 8.0.30
PHP7.4 7.4.33
PHP7.3 7.3.33
PHP7.2 7.2.34
PHP7.1 7.1.33
PHP7.0 7.0.33
PHP5.6 5.6.40
Awstats 7.8
Exim4 4.95
Vsftpd 3.0.5
Bind9 9.18.39
Mariadb 10.11.18
phpMyAdmin 5.2.3
Fail2ban 0.11.2
root@wolf:~#
That should work fine.
What’s the exact error you see now in phpMyAdmin?
Show also the output of this command:
grep -A10 -B2 foreach /etc/phpmyadmin/config.inc.php
root@wolf:\~# grep -A10 -B2 foreach /etc/phpmyadmin/config.inc.php
//start with 1 other wise it doesn't work
$i = 1;
foreach (glob("/etc/phpmyadmin/conf.d/\*.php") as $filename) {
include $filename;
/*Don't remove / alter code here below this will add SSO support for all servers*/
//Add Hestia SSO code here
$i++;
}
root@wolf:\~#
Your phpMyAdmin installation is not getting the new conf and looks you have more issues.
Show this:
dpkg -l | grep -i phpmyadmin
empty output
Now this:
v-list-default-php
cat -A /etc/phpmyadmin/conf.d/01-localhost.php | grep -v controlpass
## root@wolf:\~# v-list-default-php
VERSION
8.2
root@wolf:\~# cat -A /etc/phpmyadmin/conf.d/01-localhost.php | grep -v controlpas s
<?php $
$cfg['Servers'][$i]['host'] = 'localhost';$
$cfg['Servers'][$i]['port'] = '3306';$
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';$
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';$
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';$
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';$
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';$
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';$
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';$
$cfg['Servers'][$i]['users'] = 'pma__users';$
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';$
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';$
$cfg['Servers'][$i]['controluser'] = 'pma';$
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';$
$cfg['Servers'][$i]['relation'] = 'pma__relation';$
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';$
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';$
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';$
$cfg['Servers'][$i]['history'] = 'pma__history';$
$cfg['Servers'][$i]['recent'] = 'pma__recent';$
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';$
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';$
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';$
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';$
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';$
$cfg['Servers'][$i]['hide_db'] = 'information_schema';$
Could you please double check the file /etc/phpmyadmin/config.inc.php? Because I see the * is escaped here foreach (glob("/etc/phpmyadmin/conf.d/\*.php") and I don’t know whether it is because of the copy/paste or it is really escaping the wildcard \*
Ok, I see no obvious problem but phpMyAdmin is not getting the new conf, and I don’t know the reason.
It’s sad… But thank you so much for your time <3
Show the output of these commands:
dpkg -l | grep apache2-mod-php
apache2ctl -M | grep -Ei 'php|mpm'
cat /etc/apache2/conf.d/phpmyadmin.inc
root@wolf:\~# dpkg -l | grep apache2-mod-php
ii libapache2-mod-php7.4 1:7.4.33-28+ubuntu22.04.1+deb.sury.org+ 1 amd64 server-side, HTML-embedded scripting language (Apache 2 m odule)
ii libapache2-mod-php8.1 8.1.34-8+ubuntu22.04.1+deb.sury.org+1 amd64 server-side, HTML-embedded scripting language (Apache 2 m odule)
root@wolf:\~# apache2ctl -M | grep -Ei 'php|mpm'
AH00558: apache2: Could not reliably determine the server's fully qualified doma in name, using 127.0.0.1. Set the 'ServerName' directive globally to suppress th is message
mpm_prefork_module (shared)
root@wolf:\~# cat /etc/apache2/conf.d/phpmyadmin.inc
# phpMyAdmin default Apache configuration
Alias /phpmyadmin /usr/share/phpmyadmin
<Directory /usr/share/phpmyadmin>
Options FollowSymLinks
DirectoryIndex index.php
# Use www.conf instead
<FilesMatch .php$>
SetHandler "proxy:unix:/run/php/www.sock|fcgi://localhost"
# Disallow web access to directories that don't need it
<Directory /usr/share/phpmyadmin/libraries>
Order Deny,Allow
Deny from All
<Directory /usr/share/phpmyadmin/setup>
Order Deny,Allow
Deny from All
<Directory /usr/share/phpmyadmin/sql>
Order Deny,Allow
Deny from All
<Directory /usr/share/phpmyadmin/vendor>
Order Deny,Allow
Deny from All
<Directory /usr/share/phpmyadmin/templates>
Order Deny,Allow
Deny from All
<Directory /usr/share/phpmyadmin/locale>
Order Deny,Allow
Deny from All
root@wolf:\~#
Your Apache is using mpm_prefork instead of mpm_event. Also, even though you installed libapache2-mod-php, it doesn’t seem to be enabled, at least it doesn’t appear in the apache2ctl output, which is unusual.
In addition, the output of phpmyadmin.inc is incomplete. I’m not sure what happened during the copy/paste but it’s not showing the full output.
I would suggest enabling mpm_event, but I don’t have enough information about your current conf.
Before I tell you the commands to switch to mpm_event, can you first confirm whether this command does not show php module in the output? I need to be sure.
apache2ctl -M | grep -Ei 'php|mpm'
I also need the output of these commands:
ls -l /etc/apache2/conf.d/
grep '^Include' /etc/apache2/apache2.conf