Zammad not working after restart

  • Used Zammad version: 6(letest)
  • Used Zammad installation type: package
  • Operating system: CentOS 7
  • Browser + version: firefox,chrome letest build

Hey freshly installed zammad ticketing system on centos 7 is not working after restarting server
It gives 500 and 502 error

I started all its services and its running properly

Consult your production log, it should hold the reason if it’s an issue with Zammad itself.

Please find logs

Delete that. It contains sensitive information wtf.

I went through your logfile for you, here’s the reason:

F, [2023-08-22T08:42:55.093305#10158-110160] FATAL -- :   
[bf029190-972c-4a15-9306-b4b97621f561] ActiveRecord::NoDatabaseError (FATAL:  role "zammad" does not exist
):
[bf029190-972c-4a15-9306-b4b97621f561]   
[bf029190-972c-4a15-9306-b4b97621f561] app/models/setting.rb:105:in `load'
[bf029190-972c-4a15-9306-b4b97621f561] app/models/setting.rb:56:in `get'
[bf029190-972c-4a15-9306-b4b97621f561] lib/omni_auth/strategies/saml_database.rb:7:in `setup'
[bf029190-972c-4a15-9306-b4b97621f561] lib/omni_auth/strategies/saml_database.rb:38:in `initialize'

How do i fix this ??

Hey do you know any solution?

su - zammad
psql

Should provide a postgresql prompt. If it doesn’t and complains about a missing role as well, then it most likely is a missing user you have or you accidently removed your database. Don’t know.

Hard to tell with the provided information.
A mere restart wouldn’t cause this. What have you done before restarting?

You could try manually re-adding the pgsql user with createdb zammad -O zammad as postgres user.
Apart from that I’m afraid I won’t be able to help you.