Peer authentication failed for user "odoo"

Nero Ouali

I'm on Odoo 9, I have an issue when lunching odoo server $odoo.py -r odoo -w password, the localhost:8069 doesn't load and I get an error on terminal "Peer authentication failed for user "odoo"".

I already created a user "odoo" on postgres.
When lunching $odoo.py I can load the odoo page on browser but I can't create database (as default user).

It was working and i already created database but when I logged out I couldn't connect to my database account anymore.

Any ideas ?

lsilva

You need to change your pg_hba.conf configuration. This error means that you are using peer authentication, so you need to change it for md5 or something that suits you.

You can find more information here: http://www.postgresql.org/docs/9.4/static/auth-pg-hba-conf.html

If you are connecting locally you will need to change the following entrance from

local all all peer

to something like this :

local all all md5

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Java

psql: FATAL: Peer authentication failed for user "dev"

From Dev

FATAL: Peer authentication failed for user "rails"

From Dev

FATAL: Peer authentication failed for user "shop"

From Dev

Peer authentication failed for user with all privileges in Postgres 9.5

From Java

Getting error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails

From Dev

django.db.utils.OperationalError: FATAL: Peer authentication failed for user "deadlylaid"

From Dev

PostgreSQL: MD5 Authentication in pg_hba.conf gives me FATAL: Peer authentication failed for user "postgres"

From Dev

Psycopg2 peer authentication for user postgres

From Dev

Authentication failed for user: null

From Dev

Authentication failed for user: null

From Dev

error: Ident authentication failed for user

From Dev

Payflow reports "User authentication failed"

From Java

Postgresql: password authentication failed for user "postgres"

From Dev

FATAL: password authentication failed for user "postgres"

From Dev

psql: FATAL: PAM authentication failed for user

From Dev

PHP PayFlow Pro - User Authentication Failed

From Dev

PSQL - password authentication failed for user "postgres"

From Dev

error: password authentication failed for user "myuser"

From Dev

Login as user hdfs failed:su: Authentication failure

From Dev

jitterbit-password authentication failed for user "postgres"

From Dev

Devise: Redirect to different path on failed user authentication

From Dev

Password authentication failed for a user not in my role list

From Dev

PostgreSQL SSPI authentication - FATAL: 2801: password authentication failed for user "xxx"

From Dev

Failed to authenticate SIP peer

From Dev

Is PostgreSQL peer authentication safe for production?

From Dev

28P01--Password authentication failed for user in DataGrip

From Dev

Connection failed to SQL Server Express using user with SQL Server authentication

From Java

FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

From Dev

Fatal! Authentication for user postgres failed, multiples OS, nothing work

Related Related

  1. 1

    psql: FATAL: Peer authentication failed for user "dev"

  2. 2

    FATAL: Peer authentication failed for user "rails"

  3. 3

    FATAL: Peer authentication failed for user "shop"

  4. 4

    Peer authentication failed for user with all privileges in Postgres 9.5

  5. 5

    Getting error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails

  6. 6

    django.db.utils.OperationalError: FATAL: Peer authentication failed for user "deadlylaid"

  7. 7

    PostgreSQL: MD5 Authentication in pg_hba.conf gives me FATAL: Peer authentication failed for user "postgres"

  8. 8

    Psycopg2 peer authentication for user postgres

  9. 9

    Authentication failed for user: null

  10. 10

    Authentication failed for user: null

  11. 11

    error: Ident authentication failed for user

  12. 12

    Payflow reports "User authentication failed"

  13. 13

    Postgresql: password authentication failed for user "postgres"

  14. 14

    FATAL: password authentication failed for user "postgres"

  15. 15

    psql: FATAL: PAM authentication failed for user

  16. 16

    PHP PayFlow Pro - User Authentication Failed

  17. 17

    PSQL - password authentication failed for user "postgres"

  18. 18

    error: password authentication failed for user "myuser"

  19. 19

    Login as user hdfs failed:su: Authentication failure

  20. 20

    jitterbit-password authentication failed for user "postgres"

  21. 21

    Devise: Redirect to different path on failed user authentication

  22. 22

    Password authentication failed for a user not in my role list

  23. 23

    PostgreSQL SSPI authentication - FATAL: 2801: password authentication failed for user "xxx"

  24. 24

    Failed to authenticate SIP peer

  25. 25

    Is PostgreSQL peer authentication safe for production?

  26. 26

    28P01--Password authentication failed for user in DataGrip

  27. 27

    Connection failed to SQL Server Express using user with SQL Server authentication

  28. 28

    FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

  29. 29

    Fatal! Authentication for user postgres failed, multiples OS, nothing work

HotTag

Archive