[solved] Zammad postrgesql password change

Technical assistance
1
  • Used Zammad version: 2.8.0
  • Used Zammad installation source:package
  • Operating system: Ubuntu 16.04

Requesting for help, looking for easy way how can i change password of postgresql database for zammad
As per Sir @MrGeneration if you install zammad via Deb there is no password and postgresql only allow local socket.

but i want more secure i want to set a password for postgresql database for zammad, my problem is im not familiar how to to do it , i read some tutorials using pgAdmin but installation is not so easy and I dont like to install many apps to the server,

Can someone please provide me a sample how to set password in postgresql using Terminal
Ex. username is zammad and password is z@mmadDat@

and if I not mistaken after I set the username and password to the postgresql I also need to edit the file
/opt/zammad/config/database.yml

Thank you in advance and More Power

2

I found how to do it,
Sharing the command
sudo -u postgres psql postgres (change postgres to your user like zammad)
Set the password:
\password postgres
Enter a password 2x
and exit

1 Like
3

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