what exactly are you doing and what is not working? Are there any error messages appearing?
I can connect to my postgres db just fine with the zammad db user by firing
Hi @svnr-dvnkln , thank you for the response,
There is no error I am just asking a question,
I want to access to database using: psql DBNAME USERNAME -> I dont know the name of the database or the username( I am used to configure manually ma databases so in the case of zammad I dont know the parameter of the database or in which directory I can find the configuration of postgresql)
I have tried #psql zammad zammad
this is the error : psql: FATAL: authentification peer échouée pour l’utilisateur « zammad »
You will find the username (most certainly
zammad) and password within
database.yml. Assuming Zammad was installed to
/opt/zammad, please run the following command:
(or open the file in your favourite editor, i.e.
nano and look for
and then I used #psql zammad zammad
'this is the error) # psql: FATAL: authentification peer échouée pour l’utilisateur « zammad »
I have solved my question:
to be able to access to my zammad database I had to change a line in the pg_hba.conf file:
->add: local all all trust
(dont forget to restart service)
#psql zammad zammad
I hope this will help others
Just my two cents:
Allowing “all all” even if it’s just local, you’re basically disabling all authorization parts for your local environment. While this may be super easy to you, this might get a security issue on the other hand.
If you want to authenticate against psql, use either a password or su into the user Zammad.
Also, try to avoid to fiddle around in the database (especially as you’re talking about “manipulate”).
This might cause issues with your application nobody can foresee and help you with.
This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.