I am using OpenErp version 7 on Ubuntu 12.04 LTS. I have created a company, named "mycompany", and I should connect myself as admin with password admin on localhost. Now the thing is, when I connect with admin and admin, it says: invalid username or password.
I checked in sudo kate /etc/postgresql/9.1/main/pg_hba.conf, I see inside only postgres user (postgres) I put trust around it, but it doesnt change a thing.
I tried a killall -HUP psql: I got a "no process found". Then I tried a psql -U admin mycompany: I got a FATAL Peer authentication failed for user "admin"
Could somebody help me to recover my admin password? I tried all of those I had in my memory but nothing works. It would be very nice.
Thanks and keep the good work, its a great tool!
My 2 cents: in psql command you have to provide user from your OS who owns the database you want to access. Most likely it is postgres, openerp or your user you are login into your operating system. Knowing that and issuing the commands
psql -U <OS user> -d <database> table res_users;
from Daniele Bondi answer should give you the password of your openerp users. Which pretty much sucks considering security.
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: 2/3/14, 4:32 PM|
|Seen: 1870 times|
|Last updated: 3/16/15, 8:10 AM|