Errors after upgrading from Debian Bullseys to Bookworm

Discussion in 'Installation/Configuration' started by Nomis, Jul 10, 2026 at 9:45 AM.

  1. Nomis

    Nomis Member

    Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]:

    Creating backup of "/usr/local/ispconfig" directory...
    Creating backup of "/etc" directory...
    Creating backup of "/root/.acme.sh" directory...
    Creating backup of "/etc/letsencrypt" directory...
    Checking MariaDB version 10.11.14 .. OK
    Checking ISPConfig database .. mysqlcheck: unknown variable 'max_allowed_packet=500m'
    OK
    ERROR 1698 (28000): Access denied for user 'root'@'localhost'
    Unable to call mysql command line with credentials from mysql_clientdb.conf
    ( I have checked the password in the /usr/local/ispconfig/server/lib/mysql_clientdb.conf,
    It is correct)
    I can also login -
    mysql -u root -p
    But not into
    root@ns:~# mysql -h 127.0.0.1 -u root -p
    Enter password:
    ERROR 1698 (28000): Access denied for user 'root'@'localhost'
    root@ns:~#
     
    Nomis, Jul 10, 2026 at 9:45 AM
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Then you probably changed the root password for 'localhost' but not '127.0.0.1', or you disabled networking in MariaDB after you installed ISPConfig. Ensure that both root users, the one for localhost and the one for IP 127.0.0.1 in MariaDB use the same password and that this password is set in the mysql_clientdb.conf file. Also, do not disable networking in MariaDB, as this shuts down access via 127.0.0.1.
     
    till, Jul 10, 2026 at 9:51 AM
    #2
  3. Nomis

    Nomis Member

    Hi Till
    1. Where do i check the 127.0.0.1 password
    2. Where do confirm the networking status for MariaDB
     
    Nomis, Jul 10, 2026 at 10:09 AM
    #3
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    In MariaDB, e.g. with phpmyadmin. Or use the mysql command.

    Check MariaDB config files to ensure you do not have skip-networking set.
     
    till, Jul 10, 2026 at 10:44 AM
    #4
  5. Nomis

    Nomis Member

    Hi Till
    Ok I can now log in to both
    mysql -u root -p
    mysql -h 127.0.0.1 -u root -p
    https://ip_Address/phpmyadmin/
    usr/local/ispconfig/server/lib/mysql_clientdb.conf
    $clientdb_host = 'localhost';
    $clientdb_user = 'root';
    $clientdb_password = 'Input_password_here';
    ?>

    But still get the following

    Checking ISPConfig database .. mysqlcheck: unknown variable 'max_allowed_packet=500m'
    OK
    ERROR 1698 (28000): Access denied for user 'root'@'localhost'
    Unable to call mysql command line with credentials from mysql_clientdb.conf
    root@ns:~#

    /etc/mysql/mariadb.conf.d/50-server.cnf
    # Instead of skip-networking the default is now to listen only on
    # localhost which is more compatible and is not less secure.
    bind-address = 127.0.0.1
     
    Nomis, Jul 10, 2026 at 12:26 PM
    #5
  6. Nomis

    Nomis Member

    Any update
     
    Nomis, Jul 13, 2026 at 4:24 PM
    #6

Share This Page