Microsoft 365 "ssl_certificates" does not exist

Infos:

  • Used Zammad version: upgrade from 6.1.0-1701163867.5a81e629.focal to 6.3.1-1727673033.7f65c063.focal and migrate db from Maria to PostgresQL
  • Used Zammad installation type: (source, package, docker-compose, …) package
  • Operating system: Ubuntu
  • Browser + version:

Expected behavior:

  • fully working instance

Actual behavior:

There are no SSL certificates, but these errors appear under the 365 apps. I am unable to delete them so I can add them back. I am unable to make any changes other than disabling. I cannot re-authenticate without experiencing error 2.

  • Error 1:
    Can’t use Channel::Driver::Imap: #<ActiveRecord::StatementInvalid:“PG::UndefinedTable: ERROR: relation "ssl_certificates" does not exist\nLINE 9: WHERE a.attrelid = ‘"ssl_certificates"’::regclass\n ^\n”>

  • Error 2:
    PG::UndefinedTable: ERROR: relation “ssl_certificates” does not exist LINE 1: SELECT “sslcertificates”. FROM “sslcertificates” ^

I followed these steps listed here: Mail channel not running after Upgrade to 6.2
Try /opt/zammad/contrib/packager.io/postinstall.sh
I think it starts the migration.

After that I would clear the cache by zammad run rails r "Rails.cache.clear"

but they did not solve the issue as they seem to have for other folks.

Steps to reproduce the behavior:

  • update

Did the postinstall.sh throw any errors? It looks pretty much like that there are some migrations which did not run. Can you share the output?

You’re right - it failed almost immediately after running, but I missed it because I didn’t scroll up to see it at the top.

root@helpdesk:/home/zammad# /opt/zammad/contrib/packager.io/postinstall.sh
# Enforcing Redis...
# Creating Redis bootstart
Synchronizing state of redis-server.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable redis-server
# Starting Redis server
# Redis server is running.
# (Re)creating init scripts
Nothing to do.
Nothing to do.
Nothing to do.
# Enabling Zammad on boot
# Stopping Zammad
# Clear cache...
# database.yml found. Updating db...
== 20230807051414 InputFieldsOperatorRenaming: migrating ======================
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled: (StandardError)

Validation failed: The required 'perform' value for x-zammad-ticket-owner_id, value is missing!
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/validations.rb:80:in `raise_validation_error'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/validations.rb:53:in `save!'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/transactions.rb:302:in `block in save!'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/connection_adapters/abstract/database_statements.rb:314:in `transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/transactions.rb:350:in `with_transaction_returning_status'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/transactions.rb:302:in `save!'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/suppressor.rb:54:in `save!'
/opt/zammad/db/migrate/20230807051414_input_fields_operator_renaming.rb:32:in `block in update_postmaster_filter'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches/batch_enumerator.rb:54:in `each'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches/batch_enumerator.rb:54:in `block in each_record'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches.rb:245:in `block in in_batches'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches.rb:229:in `loop'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches.rb:229:in `in_batches'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches/batch_enumerator.rb:53:in `each'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches/batch_enumerator.rb:53:in `each_record'
/opt/zammad/db/migrate/20230807051414_input_fields_operator_renaming.rb:22:in `update_postmaster_filter'
/opt/zammad/db/migrate/20230807051414_input_fields_operator_renaming.rb:8:in `change'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:905:in `exec_migration'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:889:in `block (2 levels) in migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:888:in `block in migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:887:in `migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1095:in `migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1409:in `block in execute_migration_in_transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.8.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.8.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.8.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.8.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/transactions.rb:209:in `transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1460:in `ddl_transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1408:in `execute_migration_in_transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1382:in `each'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1382:in `migrate_without_lock'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1331:in `block in migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1481:in `block in with_advisory_lock'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1496:in `with_advisory_lock_connection'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1477:in `with_advisory_lock'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1331:in `migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1166:in `up'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1141:in `migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/tasks/database_tasks.rb:262:in `migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/railties/databases.rake:92:in `block (2 levels) in <main>'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/rake-13.1.0/exe/rake:27:in `<top (required)>'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/cli/exec.rb:58:in `load'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/cli/exec.rb:58:in `kernel_load'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/cli/exec.rb:23:in `run'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/cli.rb:492:in `exec'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/vendor/thor/lib/thor/command.rb:28:in `run'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/vendor/thor/lib/thor.rb:527:in `dispatch'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/cli.rb:34:in `dispatch'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/vendor/thor/lib/thor/base.rb:584:in `start'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/cli.rb:28:in `start'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/exe/bundle:37:in `block in <top (required)>'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/friendly_errors.rb:117:in `with_friendly_errors'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/exe/bundle:29:in `<top (required)>'
/opt/zammad/bin/bundle:121:in `load'
/opt/zammad/bin/bundle:121:in `<main>'

Caused by:
ActiveRecord::RecordInvalid: Validation failed: The required 'perform' value for x-zammad-ticket-owner_id, value is missing! (ActiveRecord::RecordInvalid)
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/validations.rb:80:in `raise_validation_error'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/validations.rb:53:in `save!'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/transactions.rb:302:in `block in save!'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/connection_adapters/abstract/database_statements.rb:314:in `transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/transactions.rb:350:in `with_transaction_returning_status'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/transactions.rb:302:in `save!'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/suppressor.rb:54:in `save!'
/opt/zammad/db/migrate/20230807051414_input_fields_operator_renaming.rb:32:in `block in update_postmaster_filter'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches/batch_enumerator.rb:54:in `each'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches/batch_enumerator.rb:54:in `block in each_record'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches.rb:245:in `block in in_batches'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches.rb:229:in `loop'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches.rb:229:in `in_batches'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches/batch_enumerator.rb:53:in `each'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/relation/batches/batch_enumerator.rb:53:in `each_record'
/opt/zammad/db/migrate/20230807051414_input_fields_operator_renaming.rb:22:in `update_postmaster_filter'
/opt/zammad/db/migrate/20230807051414_input_fields_operator_renaming.rb:8:in `change'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:905:in `exec_migration'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:889:in `block (2 levels) in migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:888:in `block in migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:887:in `migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1095:in `migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1409:in `block in execute_migration_in_transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.8.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.8.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.8.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.8.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/transactions.rb:209:in `transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1460:in `ddl_transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1408:in `execute_migration_in_transaction'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1382:in `each'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1382:in `migrate_without_lock'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1331:in `block in migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1481:in `block in with_advisory_lock'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1496:in `with_advisory_lock_connection'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1477:in `with_advisory_lock'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1331:in `migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1166:in `up'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/migration.rb:1141:in `migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/tasks/database_tasks.rb:262:in `migrate'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.8.4/lib/active_record/railties/databases.rake:92:in `block (2 levels) in <main>'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/rake-13.1.0/exe/rake:27:in `<top (required)>'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/cli/exec.rb:58:in `load'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/cli/exec.rb:58:in `kernel_load'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/cli/exec.rb:23:in `run'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/cli.rb:492:in `exec'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/vendor/thor/lib/thor/command.rb:28:in `run'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/vendor/thor/lib/thor.rb:527:in `dispatch'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/cli.rb:34:in `dispatch'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/vendor/thor/lib/thor/base.rb:584:in `start'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/cli.rb:28:in `start'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/exe/bundle:37:in `block in <top (required)>'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/lib/bundler/friendly_errors.rb:117:in `with_friendly_errors'
/opt/zammad/vendor/bundle/ruby/3.2.0/gems/bundler-2.4.22/exe/bundle:29:in `<top (required)>'
/opt/zammad/bin/bundle:121:in `load'
/opt/zammad/bin/bundle:121:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
# Updating translations...
# No custom packages detected...
# Configuring Elasticsearch...
-> removing [ingest-attachment]...
-> Installing ingest-attachment
-> Downloading ingest-attachment from elastic
[=================================================] 100%
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@     WARNING: plugin requires additional permissions     @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
* java.lang.RuntimePermission accessClassInPackage.sun.java2d.cmm.kcms
* java.lang.RuntimePermission accessDeclaredMembers
* java.lang.RuntimePermission getClassLoader
* java.lang.reflect.ReflectPermission suppressAccessChecks
* java.security.SecurityPermission createAccessControlContext
See https://docs.oracle.com/javase/8/docs/technotes/guides/security/permissions.html
for descriptions of what these permissions allow and the associated risks.

-> Installed ingest-attachment
-> Please restart Elasticsearch to activate any plugins installed
# Enforcing 0600 on database.yml ...
# Starting Zammad
# Creating webserver bootstart
Synchronizing state of nginx.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable nginx
# Restarting webserver nginx
####################################################################################

Add your fully qualified domain name or public IP to servername directive of
nginx, if this installation is done on a remote server. You have to change:
/etc/nginx/sites-available/zammad.conf and restart nginx process.
Otherwise just open http://localhost/ in your browser to start using Zammad.

####################################################################################
root@helpdesk:/home/zammad#

Are you still able to use your UI ?

If yes, then go into your postmaster filters and repair them. There must be some kind of invalid postmaster filter which has an action to set an owner with an empty value. Remove them or fill the action value.

Then rerun the postinstall.sh again and share the result.

1 Like

DUDE, you’re the best. I have about 150 filters setup and I found one where the owner was blank. Deleted the rule, re-ran the script and now that seems to have fixed the issue!

Thanks so much!!

root@helpdesk:/home/zammad# /opt/zammad/contrib/packager.io/postinstall.sh
# Enforcing Redis...
# Creating Redis bootstart
Synchronizing state of redis-server.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable redis-server
# Starting Redis server
# Redis server is running.
# (Re)creating init scripts
Nothing to do.
Nothing to do.
Nothing to do.
# Enabling Zammad on boot
# Stopping Zammad
# Clear cache...
# database.yml found. Updating db...
== 20230807051414 InputFieldsOperatorRenaming: migrating ======================
== 20230807051414 InputFieldsOperatorRenaming: migrated (0.1556s) =============

== 20230807171019 PostmasterFilterRegexOperator: migrating ====================
== 20230807171019 PostmasterFilterRegexOperator: migrated (0.2323s) ===========

== 20230817130057 UpdateApiPasswordAccessFrontend: migrating ==================
== 20230817130057 UpdateApiPasswordAccessFrontend: migrated (0.1379s) =========

== 20230823082823 UpdateFormatSettings: migrating =============================
== 20230823082823 UpdateFormatSettings: migrated (0.0156s) ====================

== 20230825101042 ShowPackageUrl: migrating ===================================
-- add_column(:packages, :url, :string, {:limit=>512})
   -> 0.0027s
== 20230825101042 ShowPackageUrl: migrated (0.0084s) ==========================

== 20230825150332 Issue4657TimeAccountingSelector: migrating ==================
== 20230825150332 Issue4657TimeAccountingSelector: migrated (0.0063s) =========

== 20230829085650 LdapSourceConfig: migrating =================================
== 20230829085650 LdapSourceConfig: migrated (0.0109s) ========================

== 20230830100819 CreateSSLCertificates: migrating ============================
-- create_table(:ssl_certificates)
   -> 0.0312s
== 20230830100819 CreateSSLCertificates: migrated (0.0319s) ===================

== 20230904123822 SetIdoitSSLDefault: migrating ===============================
== 20230904123822 SetIdoitSSLDefault: migrated (0.0010s) ======================

== 20230905073448 SetGitLabSSLDefault: migrating ==============================
== 20230905073448 SetGitLabSSLDefault: migrated (0.0051s) =====================

== 20230905074116 SetElasticSearchSSL: migrating ==============================
== 20230905074116 SetElasticSearchSSL: migrated (0.0069s) =====================

== 20230906162437 SetMailSSLDefault: migrating ================================
== 20230906162437 SetMailSSLDefault: migrated (0.0635s) =======================

== 20230912080534 GroupHierarchy: migrating ===================================
-- change_column(:groups, :name, :string, {:limit=>970})
   -> 0.0037s
-- add_column(:groups, :name_last, :string, {:limit=>160, :null=>true})
   -> 0.0004s
-- add_column(:groups, :parent_id, :integer, {:null=>true})
   -> 0.0003s
-- add_foreign_key(:groups, :groups, {:column=>:parent_id})
   -> 0.0040s
-- change_column(:groups, :name_last, :string, {:limit=>160, :null=>false})
   -> 0.0015s
== 20230912080534 GroupHierarchy: migrated (0.1930s) ==========================

== 20231011055535 SamlSignEncrypt: migrating ==================================
== 20231011055535 SamlSignEncrypt: migrated (0.0075s) =========================

== 20231016120344 SearchIndexSettings: migrating ==============================
== 20231016120344 SearchIndexSettings: migrated (0.0040s) =====================

== 20231017091313 LoopProtectionSettings: migrating ===========================
== 20231017091313 LoopProtectionSettings: migrated (0.0107s) ==================

== 20231024103209 Issue4838DataRetention: migrating ===========================
-- add_column(:jobs, :object, :string, {:limit=>100, :null=>true})
   -> 0.0008s
-- change_column(:jobs, :object, :string, {:limit=>100, :null=>false})
   -> 0.0012s
== 20231024103209 Issue4838DataRetention: migrated (0.0066s) ==================

== 20231107090334 SimpleStorageConfigurationCheck: migrating ==================
== 20231107090334 SimpleStorageConfigurationCheck: migrated (0.0049s) =========

== 20231122123502 Issue4848FixOverviewBulkScreen: migrating ===================
== 20231122123502 Issue4848FixOverviewBulkScreen: migrated (0.1282s) ==========

== 20231129085408 DropRemovedState: migrating =================================
== 20231129085408 DropRemovedState: migrated (0.0147s) ========================

== 20231130211242 AddAdminTicketStateAndPriorityPermission: migrating =========
== 20231130211242 AddAdminTicketStateAndPriorityPermission: migrated (0.0512s)

== 20240202122403 Issue5028BodyRequired: migrating ============================
== 20240202122403 Issue5028BodyRequired: migrated (0.0059s) ===================

== 20240203201031 Issue5028Undo: migrating ====================================
== 20240203201031 Issue5028Undo: migrated (0.0052s) ===========================

== 20240207144547 UpdateUserAttributes: migrating =============================
== 20240207144547 UpdateUserAttributes: migrated (0.0105s) ====================

== 20240213214825 WhatsappSupport: migrating ==================================
== 20240213214825 WhatsappSupport: migrated (0.0090s) =========================

== 20240227104106 UpdateUploadCacheObjectId: migrating ========================
-- change_column(:stores, :o_id, :string, {:limit=>255})
   -> 2.2201s
== 20240227104106 UpdateUploadCacheObjectId: migrated (2.2212s) ===============

== 20240312110258 CreateFailedEmails: migrating ===============================
-- create_table(:failed_emails)
   -> 0.0170s
== 20240312110258 CreateFailedEmails: migrated (111.9301s) ====================

== 20240314093207 TriggerSchedulerLocalizationImprovements: migrating =========
-- change_table(:triggers)
   -> 0.0046s
-- change_table(:jobs)
   -> 0.0009s
== 20240314093207 TriggerSchedulerLocalizationImprovements: migrated (0.0147s)

== 20240314105755 GroupMaxLevelExtension: migrating ===========================
-- change_column(:groups, :name, :string, {:limit=>1618, :null=>false})
   -> 0.0044s
== 20240314105755 GroupMaxLevelExtension: migrated (0.0067s) ==================

== 20240318132554 Issue5091TimezoneDefault: migrating =========================
== 20240318132554 Issue5091TimezoneDefault: migrated (0.0255s) ================

== 20240320092523 PermissionSettingWording: migrating =========================
== 20240320092523 PermissionSettingWording: migrated (0.1253s) ================

== 20240320115157 GeoLocationBackendOsm: migrating ============================
== 20240320115157 GeoLocationBackendOsm: migrated (0.0053s) ===================

== 20240321081409 Issue5083ChatPermission: migrating ==========================
== 20240321081409 Issue5083ChatPermission: migrated (0.0190s) =================

== 20240416163429 CalendarPublicHolidayCleanup: migrating =====================
== 20240416163429 CalendarPublicHolidayCleanup: migrated (0.6488s) ============

== 20240612071836 CleanupObsoleteTranslations: migrating ======================
== 20240612071836 CleanupObsoleteTranslations: migrated (0.1370s) =============

== 20240717152405 Issue5268UpdateStateObjectManagerAttribute: migrating =======
== 20240717152405 Issue5268UpdateStateObjectManagerAttribute: migrated (0.0176s)

# Updating translations...
# No custom packages detected...
# Configuring Elasticsearch...
-> removing [ingest-attachment]...
-> Installing ingest-attachment
-> Downloading ingest-attachment from elastic
[=================================================] 100%
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@     WARNING: plugin requires additional permissions     @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
* java.lang.RuntimePermission accessClassInPackage.sun.java2d.cmm.kcms
* java.lang.RuntimePermission accessDeclaredMembers
* java.lang.RuntimePermission getClassLoader
* java.lang.reflect.ReflectPermission suppressAccessChecks
* java.security.SecurityPermission createAccessControlContext
See https://docs.oracle.com/javase/8/docs/technotes/guides/security/permissions.html
for descriptions of what these permissions allow and the associated risks.

-> Installed ingest-attachment
-> Please restart Elasticsearch to activate any plugins installed
# Enforcing 0600 on database.yml ...
# Starting Zammad
# Creating webserver bootstart
Synchronizing state of nginx.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable nginx
# Restarting webserver nginx
####################################################################################

Add your fully qualified domain name or public IP to servername directive of
nginx, if this installation is done on a remote server. You have to change:
/etc/nginx/sites-available/zammad.conf and restart nginx process.
Otherwise just open http://localhost/ in your browser to start using Zammad.

####################################################################################
root@helpdesk:/home/zammad#
1 Like

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