Missing database seeding/migration on CentOS Stream 9

Technical assistance
1

Infos:

  • Used Zammad version: 7.1.1 RPM package
  • Used Zammad installation type: package
  • Operating system: CentOS Stream 9
  • Browser + version: Firefox, latest
  • PostGreSQL 13

Expected behavior:

  • Working Zammad instance.

Actual behavior:

  • NGINX returned HTTP 502.
  • Zammad services appeared active.
  • PostgreSQL service was running
  • No zammad PostgreSQL role or database existed.
  • /opt/zammad/config/database.yml expected database and username of “zammad”
  • zammad run rake db:create failed with “FATAL: role “zammad” does not exist”
  • production.log repeatedly reported “Database doesn’t exist.”

Steps to reproduce the behavior:

  • Just install via package manager on CentOS Stream 9, following the official guide.

I believe I’ve found an oversight in either the package version for this distro, or in the official documentation. I want to be clear that I have already solved this issue, prior to posting this. This is intended as a bug report; please direct me elsewhere if appropriate.

Steps to resolve:

  1. Manually logged into the PSQL DB as SU.
  2. Manually created the PSQL role zammad.
  3. Manually created the PSQL database zammad.
  4. sudo zammad run rake db:migrate
  5. sudo zammad run rake db:seed
  6. Restarted Zammad (and NGINX, for good measure).

After this, the web interface became accessible and I could move on with configuring the instance.

2

Please direct bug reports to GitHub - zammad/zammad: Zammad is a web based open source helpdesk/customer support system. · GitHub if you are certain you followed the documentation steps.

1 Like
3

Thank you! I will do that.

1 Like