Ispconfig Backups won't be created after upgrading to ubuntu 24.04

Discussion in 'General' started by johnymas, Nov 2, 2024 at 11:07 AM.

  1. johnymas

    johnymas Member

    I have got many errors you can see the picture. Is there a problem due to php 8.3?
     

    Attached Files:

  2. till

    till Super Moderator Staff Member ISPConfig Developer

    That's unlikely, as it works on many other Ubuntu 24.04 systems. More likely, an application needed for the backups is missing after the upgrade. There is a cron_debug.php script in ISPConfig that you can use to manually run the backup cron plugin to see why it fails to create backups on your system.
     
    ahrasis likes this.
  3. johnymas

    johnymas Member

    Did you mean to run /usr/local/ispconfig/server/server.sh?
    I have also tried to create backup manually but the same result. I forgot to mention you that the backups of web files work good on all webs, problem exists only with MySQL Databases on web pages that were created on ispconfig2
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    No. There is a cron_debug.php script in ISPConfig .
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    On ISPConfig 2? ISPConfig 2 does not exist anymore for more than 15 years and an update from ISPconfig 2 to ISPConfig 3 is technically not possible. So, you can not have an ISPConfig 3 server with databases created by ISPConfig 2.
     
  6. johnymas

    johnymas Member

    Sorry, you didn't understand me. Yes I have used ispconfig for very very long time started with ispconfig2. As I said that I found out that I have backup problems only on a very very old pages. I don't know why but I could tell you that problem didn't exist on version ubuntu 22.04
     
  7. johnymas

    johnymas Member

    I found another problem trying to edit client
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM `sys_group` WHERE client_id IN (SELECT client_id FROM `client` WHERE' at line 1
     

    Attached Files:

  8. johnymas

    johnymas Member

  9. till

    till Super Moderator Staff Member ISPConfig Developer

  10. johnymas

    johnymas Member

    Yes, exactly but I don't know how to start cron_debug.php script. I found something like php /usr/local/ispconfig/server/cron_debug.php but I'm not sure that is correct
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    That is correct and when you enter cron_debug.php in the search field here in the forum, then you find various threads that discuss how to use it. The corn plugins are all in /usr/local/ispconfig/server/lib/classes/cron.d/
     
  12. johnymas

    johnymas Member

    I run the script and immediately got a lot f errors
     

    Attached Files:

  13. till

    till Super Moderator Staff Member ISPConfig Developer

    These buffer overflows are not from ISPConfig, they are from an external program. This means one binary application that is used in the backup process fails. This can either be e.g. mysqldump, or its the binary used for compressing the SQL dump file, which depends on the compression mode you have chosen.
     
  14. johnymas

    johnymas Member

  15. johnymas

    johnymas Member

    Now I solved the problem *** buffer overflow detected ***: terminated
    03.11.2024-08:46 - ERROR - Backup of web files for domain example.domain failed using path /var/www/clients/client1/web32 failed.

    I've just changed backup mode in ispconfig server settings

    from
    Backup web files owned by web user as zip
    to
    Backup all files in web directory as root user
     

    Attached Files:

  16. till

    till Super Moderator Staff Member ISPConfig Developer

    Okay, so your zip binary is likely faulty, as the other mode uses tar. By the way, using zip was a bad choice for web backups anyway as it can not store file permissions, and you will lose them when you restore such a backup.
     
  17. johnymas

    johnymas Member

  18. johnymas

    johnymas Member

    Just one question more. It is not related to this thread.
    As I found earlier I still have problem with customer->edit->address and customer->edit->limits
    with error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM `sys_group` WHERE client_id IN (SELECT client_id FROM `client` WHERE' at line 1

    So I replaced the line from solution you gave here and now it works now...seems good
    What do you suggest is it safe to use this solution until version of ispconfig will be updated?
     
  19. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes, that's fine.
     
    ahrasis likes this.

Share This Page