Reset/Find database user password

Technical assistance
1

Hello,

I am trying to connect with Metabase to Zammad but I don’t know how to find the database password.
Is there a way to look for it?

I am running Zammad 3.X.X with Postgresql.

Thanks!

Andrei F.

2

Is it in zammad/config/database.yml or zammad/config/database/database.yml ?
With Respect
Nangi

3

Hi,

I have allready checked but there is not password…just the username.

Any other ideea?

4

Check the pg_hba.conf - it’s very likely that Zammad uses ident/peer auth, that is, no database password at all. If you need password access, especially from another host, you may need to adapt the pg_hba.conf, listen_addresses in postgresql.conf, and you may need to create a new role with a password or set a password for an existing role.

1 Like
5

That’s correct, by default Zammad does use user based sockets.
The user here is zammad.

6

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