Restore Backup v5 password promt

Technical assistance
1

Infos:

  • Used Zammad version: 5
  • Used Zammad installation type: package
  • Operating system: Debian 10

Expected behavior:

When restoring backup from diffrent system with same version on it it should restore with out problems

Actual behavior:

Restores DB Update and asks for password.

Steps to reproduce the behavior:

  • Have two servers
  • Backup one
  • Transfer packed backup to new server
  • Try restore

Restore script output

zammad User 
root@system:/path# sudo -u zammad ./zammad_restore.sh


# Zammad restored started - Sun 07 Nov 2021 09:10:43 PM UTC!

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
Enter file date to restore:
20211027011525
20211107165255
File date: 20211107165255
Enter db date to restore:
20211027011525
20211107165255
DB date: 20211027011525
# Stopping Zammad
Failed to stop zammad.service: Access denied
See system logs and 'systemctl status zammad.service' for details.
# Checking requirements
# ... Dropping current database zammad
Dropped database 'zammad'
# ... Creating database zammad for owner zammad
Password:
root User 
root@system:/path# ./zammad_restore.sh

# Zammad restored started - Sun 07 Nov 2021 09:22:22 PM UTC!

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
Enter file date to restore:
20211027011525
20211107165255
File date: 20211107165255
Enter db date to restore:
20211027011525
20211107165255
DB date: 20211027011525
# Stopping Zammad
# Checking requirements
# ... Dropping current database zammad
Dropped database 'zammad'
# ... Creating database zammad for owner zammad
CREATE DATABASE
# Restoring PostgreSQL DB
psql: FATAL:  Peer authentication failed for user "zammad"
# Restoring Files
# Ensuring correct file rights ...
# Clearing Cache ...
# Starting Zammad

# Zammad restored successfully - Sun 07 Nov 2021 09:22:49 PM UTC!

File permission

/opt/zammad/contrib/backup 
root@system:/opt/zammad/contrib/backup# ls -lA
total 28
-rw-r--r-- 1 zammad zammad  117 Nov  7 15:30 config
-rw-r--r-- 1 zammad zammad  117 Nov  5 16:02 config.dist
-rw-r--r-- 1 zammad zammad 8411 Nov  5 16:02 functions
-rwxr-xr-x 1 zammad zammad  768 Nov  5 16:02 zammad_backup.sh
-rwxr-xr-x 1 zammad zammad  692 Nov  5 16:02 zammad_restore.sh
/var/tmp/zammad_backup 
root@system:/var/tmp/zammad_backup# ls -lA
total 1490244
-rw-r--r-- 1 postgres postgres 242929271 Oct 26 23:17 20211027011525_zammad_db.psql.gz
-rw-r--r-- 1 zammad   zammad   457650101 Oct 26 23:16 20211027011525_zammad_files.tar.gz
-rw-r--r-- 1 postgres postgres   2026340 Nov  7 16:53 20211107165255_zammad_db.psql.gz
-rw-r--r-- 1 zammad   zammad   127325529 Nov  7 16:53 20211107165255_zammad_files.tar.gz
lrwxrwxrwx 1 zammad   zammad          55 Nov  7 16:53 latest_zammad_db.psql.gz -> /var/tmp/zammad_backup/20211107165255_zammad_db.psql.gz
lrwxrwxrwx 1 zammad   zammad          57 Nov  7 16:53 latest_zammad_files.tar.gz -> /var/tmp/zammad_backup/20211107165255_zammad_files.tar.gz

The system where I try to restore is a fresh installed system via package and on Debian 10.
I hope someone can help here

2

We have exactly the same problem. There are already some topics with this problem. None of the solutions shown do not work. Is there no solution here? Can someone recommend a professional service to solve the problem. Our Zammad stands still and I don’t know what to do next.

Please help !!!

3

Sorry for the inconvenience.
Zammad GmbH offers professional services as vendor - you can learn more here:

Please note that you may have to accept waiting times depending on our support load.

4

Thank you. Is there no light at the end of the tunnel to fix the error in the restore script?

5

Time has come:

The fix itself is technically not too complex.
However, it needs verifications on every supported installation type etc.

This is a very time consuming process.
The Fix itself took me about 4 hours, verification processes 10 hours.
Documentation about 16 hours.

And that all happens in between other tasks and needs to be done carefully so.

6

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.