Hi! I've recently updated from Debian 9 to Debian 10, I've followed the guide provided by Howtoforge, but in step of installing phpmyadmin, I've used a repository as phpmyadmin resource. I prefer this method to have it automatically updated. The problem I met now is, when an user try to login using phpmyadmin, he/she gets a blank screen as response. The error is: Code: [proxy_fcgi:error] [pid 24123] [client 185.243.94.162:54254] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: SELECT command denied to user 'c5larendija'@'localhost' for table 'user' in /usr/share/phpmyadmin/libraries/classes/Dbi/DbiMysqli.php:199\nStack trace:\n#0 /usr/share/phpmyadmin/libraries/classes/Dbi/DbiMysqli.php(199): mysqli->query()\n#1 /usr/share/phpmyadmin/libraries/classes/DatabaseInterface.php(316): PhpMyAdmin\\Dbi\\DbiMysqli->realQuery()\n#2 /usr/share/phpmyadmin/libraries/classes/DatabaseInterface.php(2390): PhpMyAdmin\\DatabaseInterface->tryQuery()\n#3 /usr/share/phpmyadmin/libraries/classes/DatabaseInterface.php(2332): PhpMyAdmin\\DatabaseInterface->isUserType()\n#4 /usr/share/phpmyadmin/libraries/server_common.inc.php(43): PhpMyAdmin\\DatabaseInterface->isSuperuser()\n#5 /usr/share/phpmyadmin/index.php(116): include('...')\n#6 {main}\n thrown in /usr/share/phpmyadmin/libraries/classes/Dbi/DbiMysqli.php on line 199PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: SELECT command denied to user 'c5larendija'@'localhost' for table 'user' in /usr/share/phpmyadmin/libraries/classes/Dbi/DbiMysqli.php:199\nStack trace:\n#0 /usr/share/phpmyadmin/libraries/classes/Dbi/DbiMysqli.php(199): mysqli->query()\n#1 /usr/share/phpmyadmin/libraries/classes/DatabaseInterface.php(316): PhpMyAdmin\\Dbi\\DbiMysqli->realQuery()\n#2 /usr/share/phpmyadmin/libraries/classes/DatabaseInterface.php(2390): PhpMyAdmin\\DatabaseInterface->tryQuery()\n#3 /usr/share/phpmyadmin/libraries/classes/DatabaseInterface.php(2332): PhpMyAdmin\\DatabaseInterface->isUserType()\n#4 /usr/share/phpmyadmin/libraries/classes/Menu.php(562): PhpMyAdmin\\DatabaseInterface->isSuperuser()\n#5 /usr/share/phpmyadmin/libraries/classes/Menu.php(107): PhpMyAdmin\\Menu->_getServerTabs()\n#6 /usr/share/phpmyadmin/libraries/classes/Menu.php(70): PhpMyAdmin\\Menu->_getMenu()\n#7 /usr/share/phpmyadmin/libraries/classes/Header.php(445): PhpMyAdmin\\Menu->getDisplay()\n#8 /usr/sh...' The user and database exist in ispconfig, but it's true if a log in the mariadb console, pma__users table from phpmyadmin is empty. Please, could you tell me what's wrong? thanks!
Which guide exactly. Code: SELECT command denied to user 'c5larendija'@'localhost' That looks like wrong password, or that user is not in database users. Do this: https://forum.howtoforge.com/threads/please-read-before-posting.58408/ Updating the OS should be done following Debian upgrading instructions for Debian 10, available in several languages: https://www.debian.org/releases/buster/releasenotes Then follow ISPConfig Installation Howto for Debian 10, to install and configure everything.
yeah, sorry I mean I followed official guidelines for upgrading Debian, and double checked the configuration of the different packages following the howtoforge installation guide (can't post link) Step about configuring phpmyadmin is different as I installed it via apt. my htf_report.txt: 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:14:51 up 7 days, 23:59, 1 user, load average: 0,99, 1,22, 1,30 [INFO] memory: total used free shared buff/cache available Mem: 8,0Gi 4,0Gi 1,1Gi 881Mi 3,0Gi 4,1Gi Swap: 4,0Gi 346Mi 3,7Gi [INFO] ISPConfig is installed. ##### ISPCONFIG ##### ISPConfig version is 3.2.8p1 ##### VERSION CHECK ##### [INFO] php (cli) version is 7.3.33-4+0~20220627.98+debian10~1.gbp40b3e4 [INFO] php-cgi (used for cgi php in default vhost!) is version 7.3.33 ##### PORT CHECK ##### [WARN] Port 22 (SSH server) seems NOT to be listening ##### MAIL SERVER CHECK ##### ##### RUNNING SERVER PROCESSES ##### [INFO] I found the following web server(s): Apache 2 (PID 23553) [INFO] I found the following mail server(s): Postfix (PID 23107) [INFO] I found the following pop3 server(s): Dovecot (PID 23447) [INFO] I found the following imap server(s): Dovecot (PID 23447) [INFO] I found the following ftp server(s): PureFTP (PID 23676) ##### LISTENING PORTS ##### (only () Local (Address) [anywhere]:993 (23447/dovecot) [anywhere]:995 (23447/dovecot) [localhost]:10023 (509/postgrey) [localhost]:10024 (23276/amavisd-new) [localhost]:10025 (23107/master) [localhost]:10026 (23276/amavisd-new) [localhost]:3306 (22815/mysqld) [localhost]:10027 (23107/master) [anywhere]:587 (23107/master) [localhost]:11211 (190/memcached) [localhost]:12301 (419/opendkim) [anywhere]:110 (23447/dovecot) [anywhere]:143 (23447/dovecot) [anywhere]:24752 (311/sshd) [anywhere]:465 (23107/master) [localhost]:44819 (25902/Passenger) ***.***.***.***:53 (23684/named) ***.***.***.***:53 (23684/named) [localhost]:53 (23684/named) [anywhere]:21 (23676/pure-ftpd) [localhost]:953 (23684/named) [anywhere]:25 (23107/master) *:*:*:*::*:993 (23447/dovecot) *:*:*:*::*:995 (23447/dovecot) *:*:*:*::*:10024 (23276/amavisd-new) *:*:*:*::*:10026 (23276/amavisd-new) *:*:*:*::*:587 (23107/master) [localhost]10 (23447/dovecot) [localhost]43 (23447/dovecot) *:*:*:*::*:8080 (23553/apache2) *:*:*:*::*:80 (23553/apache2) *:*:*:*::*:24752 (311/sshd) *:*:*:*::*:8081 (23553/apache2) *:*:*:*::*:465 (23107/master) *:*:*:*::*:53 (23684/named) *:*:*:*::*:21 (23676/pure-ftpd) *:*:*:*::*:953 (23684/named) *:*:*:*::*:25 (23107/master) *:*:*:*::*:443 (23553/apache2) ##### IPTABLES ##### Chain INPUT (policy ACCEPT) target prot opt source destination f2b-pure-ftpd tcp -- [anywhere]/0 [anywhere]/0 multiport dports 21 f2b-postfix-sasl tcp -- [anywhere]/0 [anywhere]/0 multiport dports 25 f2b-dovecot tcp -- [anywhere]/0 [anywhere]/0 multiport dports 110,995,143,993,587,465,4190 Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination Chain f2b-dovecot (1 references) target prot opt source destination REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable RETURN all -- [anywhere]/0 [anywhere]/0 Chain f2b-postfix-sasl (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-pure-ftpd (1 references) target prot opt source destination RETURN all -- [anywhere]/0 [anywhere]/0 ##### LET'S ENCRYPT ##### [WARN] You have both certbot and acme.sh installed. This can lead to problems. Certbot: /usr/local/bin/certbot acme.sh: /root/.acme.sh/acme.sh user exists as I can login via Mariadb console, and webpage is working well thanks and cheers!
This recent thread may help: https://forum.howtoforge.com/threads/solved-blank-phpmyadmin-page.89395/ Could you clarify what you did to install phpmyadmin? Installed it from buster backports or what? Code: ##### LET'S ENCRYPT ##### [WARN] You have both certbot and acme.sh installed. This can lead to problems. Certbot: /usr/local/bin/certbot acme.sh: /root/.acme.sh/acme.sh
Hi Taleman, Yes, it's installed from buster-backports well, in this thread the apache error was not posted, and finally was solved by purging the installation :-S I'd prefer to find the problem if possible. thanks!
You may not have the exactly same problem, but my understanding is there was a typo in one of the configuration files. Peruse all of them carefully, until you find it. Or them, maybe there are several.
Hi! well, it seems not to be related to ispconfig, it could be a bug in phpmyadmin. https://github.com/phpmyadmin/phpmyadmin/issues/17706 I'll tell you back what I get, of course thanks!