ERROR 1356 (HY000) at line 1: View 'mysql.user' references invalid table(s) or column(s) or function

Hi,

setting up a new server with debian 11
with this tutorial as there is no newer on the documentation page
https://www.howtoforge.com/perfect-server-debian-10-buster-apache-bind-dovecot-ispconfig-3-1/

in this step

Code:

Set the password authentication method in MariaDB to native so we can use PHPMyAdmin later to connect as root user:

echo "update mysql.user set plugin = 'mysql_native_password' where user='root';" | mysql -u root

I get

Code:

ERROR 1356 (HY000) at line 1: View 'mysql.user' references invalid table(s) or column(s) or function

does it matter?

(yes root password is ok)

 

Code:

[ERROR] Exception occured: ISPConfigOSException -> Command a2enmod suexec rewrite ssl actions include dav_fs dav auth_digest cgi headers proxy_fcgi alias http2 mpm_event 2>&1 failed. (/ispconfig.ai.php:15)

 

hello, thanks for help.
Last night I tried a clean install an autosetup is working and ispconfig is installed without error

except I see in my syslog

Code:

May 29 09:40:01 router1 mariadbd[179138]: 2022-05-29  9:40:01 1895 [Warning] Aborted connection 1895 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)

 

ok thanks

when browsing in phpmyadmin
I see errors like

Code:

Notice in ./libraries/classes/Display/Results.php#1210
[IMG]http://<myip>/phpmyadmin/themes/dot.gif[/IMG] Trying to access array offset on value of type bool

Backtrace

./libraries/classes/Display/Results.php#1328: PhpMyAdmin\Display\Results->_getTableHeadersForColumns(
array,
array,
array,
array,
array,
boolean false,
string 'SELECT * FROM `mail_user` ',
)
./libraries/classes/Display/Results.php#4277: PhpMyAdmin\Display\Results->_getTableHeaders(
array,
array,
string 'SELECT * FROM `mail_user` ',
array,
array,
array,
boolean false,
)
./libraries/classes/Sql.php#1747: PhpMyAdmin\Display\Results->getTable(
,
array,
array,
boolean false,
)
./libraries/classes/Sql.php#2044: PhpMyAdmin\Sql->getHtmlForSqlQueryResultsTable(
,
string './themes/pmahomme/img/',
NULL,
array,
boolean true,
integer 2,
integer 2,
NULL,
,
array,
)
./libraries/classes/Sql.php#2269: PhpMyAdmin\Sql->getQueryResponseForResultsReturned(
,
array,
string 'dbispconfig',
string 'mail_user',
NULL,
NULL,
,
string './themes/pmahomme/img/',
integer 2,
integer 2,
NULL,
NULL,
NULL,
NULL,
NULL,
string 'SELECT * FROM `mail_user`',
NULL,
)
./libraries/classes/Sql.php#2125: PhpMyAdmin\Sql->executeQueryAndGetQueryResponse(
array,
boolean true,
string 'dbispconfig',
string 'mail_user',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `mail_user`',
NULL,
NULL,
)
./sql.php#215: PhpMyAdmin\Sql->executeQueryAndSendQueryResponse(
array,
boolean true,
string 'dbispconfig',
string 'mail_user',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `mail_user`',
NULL,
NULL,
)

 

no as I got so much errors yesterday I want it clean

Only

Code:

wget -O - https://get.ispconfig.org | sh -s -- --use-ftp-ports=40110-40210 --unattended-upgrades

phpmyadmin shows:

Code:

Versie-informatie: 4.9.0.1, meest recente versie: 5.2.0