FATAL: Peer authentication failed for user "discourse"


(Athithan) #1

Hi,
I am trying to deploy discourse using capistrano 3. 4. I believe I have done all necessary changes but getting some errors while deploying to Ubuntu Server. I have tried to figure it out but still I didn’t find any related answer.

https://drive.google.com/file/d/0B0QjFnNruQ3QVk11OEVDdHNqX3c/view?usp=sharing

https://drive.google.com/file/d/0B0QjFnNruQ3QYWhpRF94aXBvS2M/view?usp=sharing


(Sam Saffron) #2

you are entering a world of unsupported pain, why not use the Docker install?


(Jeff Atwood) #3

We regret that we can only support our Docker install here.


(Jens Maier) #4

For what it’s worth:

Your PostgreSQL is configured to use peer authentication; peer auth uses a feature provided by the Linux kernel that lets a program, here: the PostgreSQL server, reliably determine the userid of the remote program connecting to its UNIX domain socket. In other words, the connecting program’s system UID is used as the PostgreSQL username, any username or password given in the config is ignored.

You can configure PostgreSQL’s auth behaviour in /etc/postgresql-9.4/pg_hba.conf (the file may in a different location, depending on your Linux distro) or map system users to other PostgreSQL roles in pg_ident.conf (same folder as pg_hba.conf, depends on the auth configuration actually specifying a user map).

Good luck! :wink:


URGENT: FATAL: Peer authentication failed for user "discourse"
Restoring Discourse from another server