Zammad not working after restart

Technical assistance
1
  • 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

images
images586×523 14 KB

2

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

3

Please find logs

4

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'
5

How do i fix this ??

6

Hey do you know any solution?

7 
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.