Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Openerp ver 7 service could not start give error "Peer authentication failed for user "root"

By
Jagdish Panchal
on 9/26/13, 8:29 AM 4,193 views

Hi,

I have in stall debian pacakage of openerp version 7 in my local pc, i write script start openerp service but it not working give me error

"Peer authentication failed for user "root"

0

Brett Lehrer

--Brett Lehrer--
1252
| 5 4 8
Milwaukee, United States
--Brett Lehrer--
Director of IT and open source enthusiast.
Brett Lehrer
On 10/24/13, 2:48 AM

This is a postgres authentication error. You're trying to run OpenERP as root (not recommended), but your postgres server is not allowing local peer authentication on root.

I suggest making a system account named 'openerp':

sudo adduser --system --home=/opt/openerp --group openerp

Use this account to start and stop the server. You'll need to chown the entire openerp folder, and I don't recall offhand where the .deb package puts that. Once that's done, check pg_hba.conf in your postgres configuration folder and make sure local connections allow 'peer' authentication on all databases for the 'openerp' user. The comments in that file explain how to set that up properly. IIRC it looks something like this:

local    all    openerp        peer

Postgres will check the system login making the request to connect, and if it's the 'openerp' user, immediately grant database access.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 9/26/13, 8:29 AM
Seen: 4193 times
Last updated: 3/16/15, 8:10 AM