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

Discussion in 'Installation/Configuration' started by commentator, May 28, 2022.

  1. commentator

    commentator Member

    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)
     
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

  3. commentator

    commentator Member

    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)
    
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Run the command as root:

    a2enmod suexec rewrite ssl actions include dav_fs dav auth_digest cgi headers proxy_fcgi alias http2 mpm_event

    and post the output that you get on the shell.
     
  5. commentator

    commentator Member

    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)
    
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    That might be just the MySQL service online check, so nothing to worry about.
     
  7. commentator

    commentator Member

    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,
    )
    
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Most likely the PHP version you use is too new for that phpmyadmin version. Did you change anything in the setup after the auto installation?
     
  9. commentator

    commentator Member

    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
     
  10. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

Share This Page