Backups not working after ISPC update

Discussion in 'Installation/Configuration' started by Robetus, Apr 20, 2024.

  1. Robetus

    Robetus Member

    I updated to 3.2.11p2 in Feb 2024 and I didn't notice until now that website backups no longer function, manual backups no longer work either. I tried updating to 3.2.2 using https://www.ispconfig.org/blog/ispconfig-3-2-2-released-important-security-update/ which mentions a backup fix but I cannot upgrade, it only gives errors and with the normal upgrade script I'm told that there are no upgrade versions. No ISPC configuration was changed between updates.

    Backups were functioning until I upgraded, I see the last backup was date February 13, 2024.

    Here is the output of the test script:
    Code:
    @ispc:~# cat htf_report.txt | more
    
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] OS version is Ubuntu 22.04.3 LTS
     
    [INFO] uptime:  23:23:57 up 70 days, 19:53,  2 users,  load average: 0.13, 0.15, 0.11
     
    [INFO] memory:
                   total        used        free      shared  buff/cache   available
    Mem:            31Gi       4.0Gi       1.2Gi       175Mi        26Gi        26Gi
    Swap:          3.8Gi        21Mi       3.8Gi
     
    [INFO] systemd failed services status:
      UNIT                      LOAD   ACTIVE SUB    DESCRIPTION
    ● snap.lxd.activate.service loaded failed failed Service for snap application lxd.activate
    
    LOAD   = Reflects whether the unit definition was properly loaded.
    ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
    SUB    = The low-level unit activation state, values depend on unit type.
    1 loaded units listed.
    
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.2.11p2
    
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 8.1.27
    [INFO] php-cgi (used for cgi php in default vhost!) is version 8.1.27
    
    ##### 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 1118804)
    [INFO] I found the following mail server(s):
            Unknown process (smtpd) (PID 1300609)
    [INFO] I found the following pop3 server(s):
            Dovecot (PID 2714050)
    [INFO] I found the following imap server(s):
            Dovecot (PID 2714050)
    [INFO] I found the following ftp server(s):
            PureFTP (PID 2713385)
    The readout kept going and going so if someone needs to see a specific entry in the test, let me know.
     
  2. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

  3. till

    till Super Moderator Staff Member ISPConfig Developer

    3.2.2 is way older than 3.2.11 (the number 2 is lower than the number 11), so you tried to downgrade and not upgrade, and there are no issues in the backup function in ISPConfig 3.2.11p1, so downgrading makes no sense anyway, and will just break your system.

    Back to your original issue, run this command as root and post the output:

    crontab -l
     
  4. Robetus

    Robetus Member

    For some reason I associated 11 with 1.1 and not 2, don't know why. Anyway the attempted downgrade didn't work.
    Output of crontab -l in root:
    Code:
    29 0 * * * "/root/.acme.sh"/acme.sh --cron --home "/root/.acme.sh" > /dev/null
    # 0 9,21 * * * s3cmd sync --delete-removed -r /var/backup/ s3://ispconfig-backup > /dev/null 2>&1
    0 8 * * * s3cmd sync --delete-removed -r /var/backup/ s3://ispconfig-backup > /dev/null 2>&1
    * * * * * /usr/local/ispconfig/server/server.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done
    * * * * * /usr/local/ispconfig/server/cron.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done
    Settings:
    [​IMG]
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    1) Edit the crontab with the command 'crontab -e" and add a # in front of the line "
    * * * * * /usr/local/ispconfig/server/cron.sh"

    2) Run this SQL query in the dbispconfig database, e.g. using phpmyadmin or the mysql command.

    Code:
    DELETE FROM `sys_cron` WHERE `name` like "cronjob_backup%"
    3) Run

    Code:
    /usr/local/ispconfig/server/cron.sh
    as root and check if it throws any errors or if the backups get created now.
     
  6. Robetus

    Robetus Member

    With command:
    I'm only getting:
    Code:
    MariaDB [(none)]> DELETE FROM `sys_cron` WHERE `name` like "cronjob_backup%"
    
        -> 
    I'm also getting this in the notifications, is it related?:
    [​IMG]
     
  7. ztk.me

    ztk.me Well-Known Member HowtoForge Supporter

    How did you get out of the mariadb console? did you press ctrl+c or did you just enter
    ;
    end pressed return? as this was missing on tills sql statement :)
     
    Last edited: Apr 22, 2024
    ahrasis, Robetus and till like this.
  8. Robetus

    Robetus Member

    Thank you for that, missed it. Ran the mysql command and the cron.sh manually, there was no change so I just rebooted and now it appears to be working normally. I try that before anything next time or especially after I upgrade. Thank you for your help.
     
    ahrasis likes this.

Share This Page