update stuck on "creating backup" (Debian 11 to 12 then update)

Discussion in 'General' started by ledufinfra, Jun 15, 2024.

  1. ledufinfra

    ledufinfra New Member

    hello , i have a multi server ispconfig install.
    All my server are update to debian 12. (howtoforge.com/how-to-upgrade-from-debian-11-to-debian-12)
    Then follow : howtoforge.com/update-the-ispconfig-perfect-server-from-debian-11-to-debian-12

    But i got stuck here : (/usr/local/ispconfig = 1.4GB)

    >> Update
    Operating System: Debian 12.0 (Bookworm) or compatible
    This application will update ISPConfig 3 on your server.
    Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]:
    Creating backup of "/usr/local/ispconfig" directory...

    Does someone encounter this issue ?
     
  2. ledufinfra

    ledufinfra New Member

    ok after 23mn ... backup is ok.

    But now i can't update other server :
    Got this ...

    Code:
    Checking MariaDB version 10.11.6 .. OK
    MySQL master server hostname [web1.auvergnux.org]:
    
    MySQL master server port []: 3306
    
    MySQL master server root username [root]:
    
    MySQL master server root password []: i********                                           
    
    MySQL master server database name [dbispconfig]:
    
    Checking ISPConfig database .. mysqlcheck: Got error: 1698: Access denied for user 'root'@'localhost' when trying to connect
    OK
    ERROR 1698 (28000): Access denied for user 'root'@'localhost'
    Unable to call mysql command line with credentials from mysql_clientdb.conf
    
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    You likely have altered the MySQL root password after installing ISPConfig but missed to set the new MySQL root password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf
     
  4. ledufinfra

    ledufinfra New Member

    First hi till to see you again here ;-)
    nope, i solve the issue with :


     
  5. ledufinfra

    ledufinfra New Member

    in this file the user/password was good.
    in mysql db (of each server : ns, db , mail), in user table , the user root@local was set in "unix_socket", why ? i dont know.

    but with the code below i came back (or put in !!) : in "mysql_native_password", and update work fine.
     
  6. ledufinfra

    ledufinfra New Member

    i have a lot of errors to troubleshoot after the update (DEbian 12 then last ispconfig ... inplace upgrade , lot of issue)
    bad gateway 502 (probably FASTCGIPASS) => Need to re-enable all PHP: PHP-FPM in webGui (!!!)
    cert error => none
    Rspamd => not installed ? (strange because it' was installed before)
     
    Last edited: Jun 16, 2024

Share This Page