Home/ Questions/How to solve pg::connectionbad: fe_sendauth: no password supplied problem?
Next
Answered
Ruth Thomas
  • 3
Asked: 2022-07-24T03:53:03+00:00 In:

How to solve pg::connectionbad: fe_sendauth: no password supplied problem?

  • 3

. Advertisement .

..3..

. Advertisement .

..4..

Hi everyone.

I’m a newbie to this field, so I am really confused when facing the error message: pg::connectionbad: fe_sendauth: no password supplied.

Please take some of your precious time to help me solve this problem. Thanks in advance.

Share

1 Answer

  1. Best Answer
    Expert

    The cause:

    According to your pg_hba.conf, localhost as a host indicates a TCP connection, which indicates the authentication method is md5 (password demanded):

    # IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5

    Solution:

    You must establish a connection using Unix domain sockets in order to use the peer method, and as you appear to be running a debian-like operating system, you must enter /var/run/postgresql in the host field, otherwise, nothing is impacted.

    EDIT: The syntax might be as follows when utilizing database URIs:

    • test: “postgresql://localhost/myapp_test” for localhost.
    • test: “postgresql:///myapp_test” for the pre – defined Unix socket domain (host field left unfilled).
    • 3

Leave an answer

You must login to add an answer.

Need An Account,