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

How to change the user running the Odoo process?

By
Kasper Souren
on 7/7/14, 2:15 PM 3,227 views

This runs fine as my normal user: `cd /opt/odoo; python openerp-server --addons-path=addons`

But when I want to run it as another user, e.g. through

     sudo su odoo -c "cd /opt/odoo; python openerp-server --addons-path=addons"

I get this error: `OperationalError: FATAL:  role "odoo" does not exist`

I found out it breaks less after `createuser odoo` but then my existing installation is not there anymore. What is a smooth way to change the user running the process? Where is the database configuration?

How come it's breaking for odoo while it's working for my normal user and how to fix it?

Are there other things to change as well?

1

Leonardo Donelli

--Leonardo Donelli--
1040
| 5 4 8
Cave, Italy
--Leonardo Donelli--

Physics student and part-time developer.

Leonardo Donelli
On 7/7/14, 3:13 PM

OperationalError: FATAL:  role "odoo" does not exist`

This is a PostgreSQL error, saying that the database user odoo does not exist.

It probably means that your postgresql is using peer or ident authentication: instead for asking for user and password (postgres user and password, not your openerp one! they are different) it runs as the same user as the OS one. So, when you change the user you run the process as with sudo su, you are also chaning the user you're trying to connect to postgresql with.

"createuser odoo" creates an odoo user in postgres, but you probably created the openerp db with your "normal" user, so odoo has no databases associated with it.

The solution:

You should decouple your system user from your database user. You can, for example, use "normal" postgresql password authentication, that lets you specify which user you want to connect to postgres as.

-1
Wouter Tebbens
On 7/8/14, 3:38 AM

Hi Kasper,

I understand that you have set up the whole installation based on your normal user instead of an openerp or odoo user.  Most howtos explain how you set it up for such specific user, which keeps you more in control of this specific process and adds to your systsem's security.

If you look at this forum's Howto or the Opensourcerer's: https://www.odoo.com/forum/Help-1/question/How-to-install-OpenERP-V70-on-Ubuntu-1204-from-Launchpad-sources-2562, http://www.theopensourcerer.com/2012/12/how-to-install-openerp-7-0-on-ubuntu-12-04-lts/

You'll see howto create the openerp/odoo user correctly in postgres. Personally I'm not sufficiently skilled in Postgres to tell you in detail on how to change your current settings, but those howto's can hopefully help you out.

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

1 follower(s)

Stats

Asked: 7/7/14, 2:15 PM
Seen: 3227 times
Last updated: 3/16/15, 8:10 AM