- Used Zammad version: 4.0
- Used Zammad installation type: source
- Operating system: ubuntu lts 20.04
- Browser + version: firefox 111
Zammad database restore script should restore files and database.
Restore script can find the files backup but not the database backup and restore fails.
Steps to reproduce the behavior:
Do a Zammad backup on server1 with the provided backup script.
Copy the backup to server2, same directory /var/tmp/.
Start the restore with the provided backup script.
We are migrating from server1 to server2 because of unsuccessful attempts to update zammad to 5.0. We’ve set up a server2 with the same OS and installed Zammad 4.0 from source (we’ve used the migration guide). It’s a fresh install. The Zammad webservice is accessible, but the system isn’t configured yet.
A Zammad restore on an ubuntu lts 22.04 server with zammad 5.0 newly installed was finding the db backup file (but the restore was failing with other errors, not part of this ticket).
When trying to restore the backup file, following output is produced:
root@ticket:/opt/zammad/contrib/backup# ./zammad_restore.sh # Zammad restored started - Fri Mar 24 08:14:19 UTC 2023! The restore will delete your current config and database! Be sure to have a backup available! Enter 'yes' if you want to proceed! Restore?: yes adapter=postgresql mysql2 postgresql dbname=zammad zammad_development zammad_test dbuser=zammad zammad zammad dbpass= <Password> mypasswordhere Enter file date to restore: 20230322083347 20230323163618 20230323163909 File date: 20230322083347 Enter db date to restore: DB date: File /var/tmp/zammad_backup/_zammad_db..gz does not exist! Restore aborted!
The database.yml file looks like this (as the functions file reads out the db_adapter which should be psql, but the file is not found):
production: adapter: postgresql database: zammad pool: 50 timeout: 5000 encoding: utf8 username: zammad password: mypasswordhere
The backup files are:
drwxr-xr-x 2 root pbg-admin 4096 Mar 23 16:39 . drwxrwxrwt 8 root root 4096 Mar 24 02:00 .. -rw-rw-r-- 1 postgres postgres 60553259 Mar 22 08:58 20230322083347_zammad_db.psql.gz -rwxr-xr-x 1 root root 1515064312 Mar 22 08:57 20230322083347_zammad_files.tar.gz -rw-r--r-- 1 root root 27629774 Mar 23 16:36 20230323163618_zammad_files.tar.gz -rw-r--r-- 1 root root 27629827 Mar 23 16:39 20230323163909_zammad_files.tar.gz -rwxr-xr-x 1 root pbg-admin 60553259 Mar 22 08:58 latest_zammad_db.psql.gz lrwxrwxrwx 1 root root 57 Mar 23 16:39 latest_zammad_files.tar.gz -> /var/tmp/zammad_backup/20230323163909_zammad_files.tar.gz
I did some testing, which is why there are several files.
Many thanks in advance.