Styjun

Moving files accidentally to an not existing directory erases files?

How do professional electronic musicians/sound engineers combat listening fatigue?

Is it normal practice to screen share with a client?

Are gangsters hired to attack people at a train station classified as a terrorist attack?

What is "ass door"?

Company requiring me to let them review research from before I was hired

What is the purpose of the fuel shutoff valve?

What does Kasparov mean here?

How important is a good quality camera for good photography?

Is an easily guessed plot twist a good plot twist?

Marketing Cloud Query Activity is not pulling in data for newly added fields to target Data Extension

Other than a swing wing, what types of variable geometry have flown?

The seven story archetypes. Are they truly all of them?

What is the difference between 1/3, 1/2, and full casters?

Is the apartment I want to rent a scam?

How can I create a shape in Illustrator which follows a path in descending order size?

Explanation for a joke about a three-legged dog that walks into a bar

Why are so many countries still in the Commonwealth?

Sextortion with actual password not found in leaks

"I you already know": is this proper English?

Invert Some Switches on a Switchboard

Sitecore Powershell extensions module compatibility with Sitecore 9.2

Inadvertently nuked my disk permission structure - why?

Why did NASA use U.S customary units?

OperationalError: FATAL: role “…” does not exist

psql: FATAL: Ident authentication failed for user “postgres”PostgreSQL error: Fatal: role “username” does not existpsql: FATAL: role “postgres” does not existpsql: FATAL: database “<user>” does not existOpenerp cannot connect to postgresql databasepg_dump access denied under windowshow to install Odoo 9 on ubuntu?postgres users can login with any or no passwordpsycopg2.OperationalError: FATAL: role “postgresql” does not existError psycopg2.OperationalError: fe_sendauth: no password supplied even after postgres authorized connection

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

-1

I have a server (Ubuntu 12.4) with Openerp 7 and postgresql.
When I run openerp with this command :

 sudo service openerp start

it works (I think it's called the daemon).

So i tried to execute it "directly" with the executable file:

 sudo service openerp stop
 /usr/bin/python /usr/bin/openerp -c /etc/openerp/openerp-server.conf

At the begginning there was the error as follows "OperationalError: fe_sendauth: no password supplied**" so I edited the pg_hba.conf like I saw in this website
http://ujwalafossist.blogspot.com/2015/01/operationalerror-fesendauth-no-password.html

I tried many things and now my pg_hba.conf file is like this :

So now when I run

 /usr/bin/python /usr/bin/openerp -c /etc/openerp/openerp-server.conf

and refresh openerp in my navigator I have got errors

Maybe it's a tip, but when I execute the command, before refreshing I see in the terminal

But i don't want to use eggs i want to use eggspg

---

EDIT : when I run 'sudo su postgres', I enter in my database and enter du : I have 3 roles : eggspg, openerp and postgres (but no eggs).

Therefore when I run the daemon it works; and when I run the command directly, the configuration file has db_user = eggspg

postgresql openerp-7

share|improve this question

edited Mar 26 at 16:33

Kishiro

asked Mar 26 at 15:55

KishiroKishiro

661313 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  On a Odoo v10 I succeed, I edited the pg_hba file (sudo gedit /etc/postgresql/9.1/main/pg_hba.conf) but beside # "local" is for Unix domain socket connections only, not beside #Database administrative login by inux domain socket and giving access right to a directory sudo chown -R adquat .local/
  
  – Kishiro
  Apr 5 at 13:03
  
  

  
  
  
  

add a comment | 

-1

I have a server (Ubuntu 12.4) with Openerp 7 and postgresql.
When I run openerp with this command :

 sudo service openerp start

it works (I think it's called the daemon).

So i tried to execute it "directly" with the executable file:

 sudo service openerp stop
 /usr/bin/python /usr/bin/openerp -c /etc/openerp/openerp-server.conf

At the begginning there was the error as follows "OperationalError: fe_sendauth: no password supplied**" so I edited the pg_hba.conf like I saw in this website
http://ujwalafossist.blogspot.com/2015/01/operationalerror-fesendauth-no-password.html

I tried many things and now my pg_hba.conf file is like this :

So now when I run

 /usr/bin/python /usr/bin/openerp -c /etc/openerp/openerp-server.conf

and refresh openerp in my navigator I have got errors

Maybe it's a tip, but when I execute the command, before refreshing I see in the terminal

But i don't want to use eggs i want to use eggspg

---

EDIT : when I run 'sudo su postgres', I enter in my database and enter du : I have 3 roles : eggspg, openerp and postgres (but no eggs).

Therefore when I run the daemon it works; and when I run the command directly, the configuration file has db_user = eggspg

postgresql openerp-7

share|improve this question

edited Mar 26 at 16:33

Kishiro

asked Mar 26 at 15:55

KishiroKishiro

661313 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  On a Odoo v10 I succeed, I edited the pg_hba file (sudo gedit /etc/postgresql/9.1/main/pg_hba.conf) but beside # "local" is for Unix domain socket connections only, not beside #Database administrative login by inux domain socket and giving access right to a directory sudo chown -R adquat .local/
  
  – Kishiro
  Apr 5 at 13:03
  
  

  
  
  
  

add a comment | 

I have a server (Ubuntu 12.4) with Openerp 7 and postgresql.
When I run openerp with this command :

 sudo service openerp start

it works (I think it's called the daemon).

So i tried to execute it "directly" with the executable file:

 sudo service openerp stop
 /usr/bin/python /usr/bin/openerp -c /etc/openerp/openerp-server.conf

At the begginning there was the error as follows "OperationalError: fe_sendauth: no password supplied**" so I edited the pg_hba.conf like I saw in this website
http://ujwalafossist.blogspot.com/2015/01/operationalerror-fesendauth-no-password.html

I tried many things and now my pg_hba.conf file is like this :

So now when I run

 /usr/bin/python /usr/bin/openerp -c /etc/openerp/openerp-server.conf

and refresh openerp in my navigator I have got errors

Maybe it's a tip, but when I execute the command, before refreshing I see in the terminal

But i don't want to use eggs i want to use eggspg

---

EDIT : when I run 'sudo su postgres', I enter in my database and enter du : I have 3 roles : eggspg, openerp and postgres (but no eggs).

Therefore when I run the daemon it works; and when I run the command directly, the configuration file has db_user = eggspg

postgresql openerp-7

share|improve this question

edited Mar 26 at 16:33

Kishiro

asked Mar 26 at 15:55

KishiroKishiro

661313 bronze badges

 sudo service openerp start

 sudo service openerp stop
 /usr/bin/python /usr/bin/openerp -c /etc/openerp/openerp-server.conf

 /usr/bin/python /usr/bin/openerp -c /etc/openerp/openerp-server.conf

share|improve this question

edited Mar 26 at 16:33

Kishiro

asked Mar 26 at 15:55

KishiroKishiro

661313 bronze badges

share|improve this question

edited Mar 26 at 16:33

Kishiro

asked Mar 26 at 15:55

KishiroKishiro

661313 bronze badges

asked Mar 26 at 15:55

KishiroKishiro

661313 bronze badges

asked Mar 26 at 15:55

KishiroKishiro

661313 bronze badges

1 Answer
1

active

oldest

votes

0

Solution : its mandatory to change the pg_hba file

' # "local" is for Unix domain socket connections only '

' local all all trust '

and to use the db user and the db password :

python /usr/bin/openerp -c /etc/openerp/openerp-server.conf -r openerp -w mypassword
or

python /usr/bin/openerp -c /etc/openerp/openerp-server.conf --db_user=openerp --db_password=mypassword

share|improve this answer

answered Apr 15 at 7:12

KishiroKishiro

661313 bronze badges

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55361376%2foperationalerror-fatal-role-does-not-exist%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Solution : its mandatory to change the pg_hba file

' # "local" is for Unix domain socket connections only '

' local all all trust '

and to use the db user and the db password :

python /usr/bin/openerp -c /etc/openerp/openerp-server.conf -r openerp -w mypassword
or

python /usr/bin/openerp -c /etc/openerp/openerp-server.conf --db_user=openerp --db_password=mypassword

share|improve this answer

answered Apr 15 at 7:12

KishiroKishiro

661313 bronze badges

add a comment | 

0

Solution : its mandatory to change the pg_hba file

' # "local" is for Unix domain socket connections only '

' local all all trust '

and to use the db user and the db password :

python /usr/bin/openerp -c /etc/openerp/openerp-server.conf -r openerp -w mypassword
or

python /usr/bin/openerp -c /etc/openerp/openerp-server.conf --db_user=openerp --db_password=mypassword

share|improve this answer

answered Apr 15 at 7:12

KishiroKishiro

661313 bronze badges

add a comment | 

Solution : its mandatory to change the pg_hba file

' # "local" is for Unix domain socket connections only '

' local all all trust '

and to use the db user and the db password :

python /usr/bin/openerp -c /etc/openerp/openerp-server.conf -r openerp -w mypassword
or

python /usr/bin/openerp -c /etc/openerp/openerp-server.conf --db_user=openerp --db_password=mypassword

share|improve this answer

answered Apr 15 at 7:12

KishiroKishiro

661313 bronze badges

share|improve this answer

answered Apr 15 at 7:12

KishiroKishiro

661313 bronze badges

answered Apr 15 at 7:12

KishiroKishiro

661313 bronze badges

answered Apr 15 at 7:12

KishiroKishiro

661313 bronze badges