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"
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.
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
|Asked: 9/26/13, 8:29 AM|
|Seen: 3949 times|
|Last updated: 3/16/15, 8:10 AM|