updated from debian 9 to debian 10, phpmyadmin not working, users can't log in

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!