Odoo Help

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,636 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--
1272
| 5 5 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.

About This Community

This platform 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.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)

Stats

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