Old zammad version : 4.1.x
postgres (PostgreSQL) 9.2.24
Elasticsearch: “number” : “7.14.1”,
Operating System: CentOS Linux 7 (Core)
Install from Package
New zammad version : 5.2.3
postgres (PostgreSQL) 12.12
Elasticsearch: “number” : “7.17.7”,
Operating System: Ubuntu 20.04.5 LTS
Trying to restore backup from old to new zammad but getting below error
Following this URL: Restore — Zammad documentation
https://docs.zammad.org/en/latest/appendix/backup-and-restore/configuration.html
root@helpdesk1:/opt/zammad/contrib/backup# ./zammad_restore.sh
Zammad restore started - Thu 24 Nov 2022 01:50:47 PM IST!
The restore will delete your current database!
Be sure to have a backup available!
Please ensure to have twice the storage of the uncompressed backup size!
Note that the restoration USUALLY requires root permissions as services are stopped!
Enter ‘yes’ if you want to proceed!
Restore?: yes
Enter file date to restore:
20221121233001
File date: 20221121233001
Enter db date to restore:
20221121233001
DB date: 20221121233001
Stopping Zammad
Checking requirements
… Dropping current database zammad
Dropped database ‘zammad’
… Creating database zammad for owner zammad
CREATE DATABASE
Restoring PostgreSQL DB
513;
ERROR: relation “public.online_notifications” does not exist
STATEMENT: ALTER TABLE ONLY public.online_notifications DROP CONSTRAINT fk_rails_0c0055c5df;
ERROR: relation “public.ticket_state_types” does not exist
STATEMENT: ALTER TABLE ONLY public.ticket_state_types DROP CONSTRAINT fk_rails_0b22ef689c;
ERROR: relation “public.http_logs” does not exist
STATEMENT: ALTER TABLE ONLY public.http_logs DROP CONSTRAINT fk_rails_0a97b58d1a;
ERROR: relation “public.templates_groups” does not exist
STATEMENT: ALTER TABLE ONLY public.templates_groups DROP CONSTRAINT fk_rails_0a96dcaf02;
ERROR: relation “public.schedulers” does not exist
STATEMENT: ALTER TABLE ONLY public.schedulers DROP CONSTRAINT fk_rails_08966259e8;
ERROR: relation “public.ticket_states” does not exist
STATEMENT: ALTER TABLE ONLY public.ticket_states DROP CONSTRAINT fk_rails_0853e2d094;
ERROR: relation “public.karma_activity_logs” does not exist
STATEMENT: ALTER TABLE ONLY public.karma_activity_logs DROP CONSTRAINT fk_rails_0517d121f2;
ERROR: relation “public.chat_topics” does not exist
STATEMENT: ALTER TABLE ONLY public.chat_topics DROP CONSTRAINT fk_rails_05113b359f;
ERROR: relation “public.ticket_article_types” does not exist
STATEMENT: ALTER TABLE ONLY public.ticket_article_types DROP CONSTRAINT fk_rails_01020bb700;
ERROR: index “links_uniq_total” does not exist
STATEMENT: DROP INDEX public.links_uniq_total;
ERROR: index “index_users_on_source” does not exist
STATEMENT: DROP INDEX public.index_users_on_source;
ERROR: index “index_users_on_phone” does not exist
STATEMENT: DROP INDEX public.index_users_on_phone;
ERROR: index “index_users_on_out_of_office_replacement_id” does not exist
STATEMENT: DROP INDEX public.index_users_on_out_of_office_replacement_id;
ERROR: index “index_users_on_organization_id” does not exist
STATEMENT: DROP INDEX public.index_users_on_organization_id;
ERROR: index “index_users_on_mobile” does not exist
STATEMENT: DROP INDEX public.index_users_on_mobile;
ERROR: index “index_users_on_login” does not exist
ERROR: relation “public.ticket_articles” does not exist
STATEMENT: ALTER TABLE ONLY public.ticket_articles DROP CONSTRAINT fk_rails_537ac1f42c;
ERROR: relation “public.ticket_article_types” does not exist
STATEMENT: ALTER TABLE ONLY public.ticket_article_types DROP CONSTRAINT fk_rails_521ad892f1;
ERROR: relation “public.knowledge_base_locales” does not exist
STATEMENT: ALTER TABLE ONLY public.knowledge_base_locales DROP CONSTRAINT fk_rails_50dd37ac55;
ERROR: relation “public.email_addresses” does not exist
STATEMENT: ALTER TABLE ONLY public.email_addresses DROP CONSTRAINT fk_rails_4f204b5369;
ERROR: relation “public.authorizations” does not exist
STATEMENT: ALTER TABLE ONLY public.authorizations DROP CONSTRAINT fk_rails_4ecef5b8c5;
ERROR: relation “public.groups_users” does not exist
STATEMENT: ALTER TABLE ONLY public.groups_users DROP CONSTRAINT fk_rails_4e63edbd27;
ERROR: relation “public.ticket_time_accountings” does not exist
STATEMENT: ALTER TABLE ONLY public.ticket_time_accountings DROP CONSTRAINT fk_rails_4d0cbf7278;
ERROR: relation “public.postmaster_filters” does not exist
STATEMENT: ALTER TABLE ONLY public.postmaster_filters DROP CONSTRAINT fk_rails_4b17873e0f
ERROR: relation “public.ticket_articles” does not exist
STATEMENT: ALTER TABLE ONLY public.ticket_articles DROP CONSTRAINT fk_rails_38b783461b;
ERROR: relation “public.ticket_flags” does not exist
STATEMENT: ALTER TABLE ONLY public.ticket_flags DROP CONSTRAINT fk_rails_373b7f0039;
ERROR: relation “public.avatars” does not exist
STATEMENT: ALTER TABLE ONLY public.avatars DROP CONSTRAINT fk_rails_36592d9368;
ERROR: relation “public.triggers” does not exist
STATEMENT: ALTER TABLE ONLY public.triggers DROP CONSTRAINT fk_rails_35c0846653;
ERROR: relation “public.templates_groups” does not exist
STATEMENT: ALTER TABLE ONLY public.templates_groups DROP CONSTRAINT fk_rails_35b66d746f;
ERROR: relation “public.users” does not exist
ERROR: must be owner of schema public
STATEMENT: DROP SCHEMA public;
ERROR: schema “public” already exists
STATEMENT: CREATE SCHEMA public;
ERROR: must be owner of schema public
STATEMENT: COMMENT ON SCHEMA public IS ‘standard public schema’;
Restoring Files
Ensuring correct file permissions …
Clearing Cache …
/opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/digest.rb:16:in const_missing': library not found for class Digest::SHA1 -- digest/sha1 (LoadError) from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/digest.rb:100:in block in Digest’
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/digest.rb:98:in synchronize' from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/digest.rb:98:in Digest’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/shared_helpers.rb:225:in digest' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:287:in uri_hash’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:321:in git_scope' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:216:in cache_path’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:299:in git_proxy' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:225:in revision’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:76:in to_s' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in each’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in sort_by' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in lock_sources’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:104:in replace_sources!' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:674:in converge_sources’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:120:in initialize' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:234:in new’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:234:in to_definition' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:13:in evaluate’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:34:in build' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler.rb:135:in definition’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler.rb:101:in setup' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/setup.rb:10:in <top (required)>’
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require' from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require’
from /opt/zammad/config/boot.rb:3:in <top (required)>' from /opt/zammad/bin/rails:8:in require_relative’
from /opt/zammad/bin/rails:8:in <main>' /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require’: libssl.so.10: cannot open shared object file: No such file or directory - /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/x86_64-linux/digest/sha1.so (LoadError)
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require' from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/digest.rb:17:in const_missing’
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/digest.rb:100:in block in Digest' from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/digest.rb:98:in synchronize’
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/digest.rb:98:in Digest' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/shared_helpers.rb:225:in digest’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:287:in uri_hash' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:321:in git_scope’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:216:in cache_path' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:299:in git_proxy’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:225:in revision' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:76:in to_s’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in each' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in sort_by’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in lock_sources' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:104:in replace_sources!’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:674:in converge_sources' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:120:in initialize’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:234:in new' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:234:in to_definition’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:13:in evaluate' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:34:in build’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler.rb:135:in definition' from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler.rb:101:in setup’
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/setup.rb:10:in <top (required)>' from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require’
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require' from /opt/zammad/config/boot.rb:3:in <top (required)>’
from /opt/zammad/bin/rails:8:in require_relative' from /opt/zammad/bin/rails:8:in ’
./zammad_restore.sh: line 37: ore: command not found
Zammad restore started - Thu 24 Nov 2022 01:52:43 PM IST!
The restore will delete your current database!
Be sure to have a backup available!
Please ensure to have twice the storage of the uncompressed backup size!
Note that the restoration USUALLY requires root permissions as services are stopped!
Enter ‘yes’ if you want to proceed!
Restore?: yes
Enter file date to restore:
20221121233001
File date: 20221121233001
Enter db date to restore:
20221121233001
DB date: 20221121233001
Stopping Zammad
Checking requirements
… Dropping current database zammad
bundler: failed to load command: rake (/opt/zammad/vendor/bundle/ruby/2.6.0/bin/rake)
LoadError: library not found for class Digest::SHA1 – digest/sha1
/opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/digest.rb:16:in const_missing' /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/digest.rb:100:in block in Digest’
/opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/digest.rb:98:in synchronize' /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/digest.rb:98:in Digest’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/shared_helpers.rb:225:in digest' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:287:in uri_hash’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:321:in git_scope' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:216:in cache_path’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:299:in git_proxy' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:225:in revision’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:76:in to_s' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in each’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in sort_by' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in lock_sources’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:104:in replace_sources!' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:674:in converge_sources’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:120:in initialize' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:234:in new’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:234:in to_definition' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:13:in evaluate’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:34:in build' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler.rb:135:in definition’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler.rb:101:in setup' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/setup.rb:10:in <top (required)>’
/opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require' /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require’
… Creating database zammad for owner zammad
ERROR: database “zammad” already exists
Restoring PostgreSQL DB
Password for user zammad:
psql: error: fe_sendauth: no password supplied
ERROR(2) - Database credentials are wrong or database server configuration is invalid.
#-> RESTORE WAS NOT SUCCESSFUL
root@helpdesk1:/opt/zammad/contrib/backup#