Migrating 3.4.0 to 5.3.0

Technical assistance
9

Ok. Some days soon we are going to cancel the use of Zammad because the migration has failed after many days, approaches and different ways to install. This here being the main and initial post I would like to summarize what was done and what has failed so far.

  1. Migrating MariaDB to Postgres on Zammad 3.4.0:
    Failed because Zammad is too old:
    Migrate to PostgreSQL, rake aborted, Ruby Version Mismatch

  2. Install from package on OpenSuse LEAP 15.3:
    Trying to use the https://dl.packager.io/srv/rpm/zammad/zammad/develop/sles/12/x86_64 repo obviously failed due to package conflicts.

  3. Install with Docker Compose:
    This worked after several approaches:
    Docker-compose, postgresql database files are incompatible with server
    Docker-compose, postgresql database files are incompatible with server #2
    But as we need to start with Zammad 4.0.0 for step-wise upgrade, it failed to sync the docker-compose to that version:
    Migrating 3.4.0 to 5.3.0 - #7 by mssm

  4. Using Docker-compose with MariaDB:
    Not possible:
    Migrate to PostgreSQL, rake aborted, Ruby Version Mismatch - #10 by MrGeneration

  5. Install from source on OpenSuse TW:
    Elasticsearch fails to start:
    Installing from source, Elasticsearch does not start

  6. Install from package on recent Ubuntu 22.10:
    Obviously failed due to version mismatch.

  7. Install from package on older Ubuntu 20.04:
    This worked. However there is no historical repo to switch back to Zammad 4.0.0 in order to do the step-wise migration.
    We tried migrating from 3.4.0 anyway, imported and connected our MariaDB and it seems to be failing on DB migration:

E, [2023-01-20T13:30:15.585632 #30962-111940] ERROR -- : Mysql2::Error: Table 'zammad_production.mentions' doesn't exist (ActiveRecord::StatementInvalid)
E, [2023-01-20T13:30:15.591787 #30962-111940] ERROR -- : execute Ticket.process_escalation (try_count 0) exited with error #<NameError: uninitialized constant Transaction::Karma> in: 0.104320367 seconds.
E, [2023-01-20T13:30:16.610141 #30962-111940] ERROR -- : Mysql2::Error: Table 'zammad_production.mentions' doesn't exist (ActiveRecord::StatementInvalid)
E, [2023-01-20T13:30:21.613494 #30962-112460] ERROR -- : execute ImportJob.start_registered (try_count 0) exited with error #<ActiveRecord::StatementInvalid: Mysql2::Error: Table 'zammad_production.ldap_sources' doesn't exist> in: 0.122160206 seconds.
...
E, [2023-01-20T13:31:27.297338 #30962-113160] ERROR -- : Scheduler Generate user based stats. reached retry limit while being executed (BackgroundServices::Service::ProcessScheduledJobs::RetryLimitReachedError)
  1. Install from sources on Ubuntu 20.04:
    Following the guide but downloading wget https://ftp.zammad.com/zammad-4.0.0.tar.gz
    The guide failed at the step bundle install:
    Your Ruby version is 3.0.4, but your Gemfile specified 2.6.6
    I tried proceeding with
$ rvm install ruby-2.6.6
...
No binary rubies available for: ubuntu/20.04/x86_64/ruby-2.6.6.
...
No fallback URL could be found,...