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

Impossible to login on localhost: where can I see what is the password for admin

By
july
on 2/3/14, 4:32 PM 1,871 views

Hello,

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!

Julie

Well, you can try entering there by console or with PgAdmin. Users are stored on res_users table

GH Mediacloud, Grover Menacho
on 2/3/14, 5:22 PM

because I did try : psql -dl mycompany postgres without success. I tried with admin as well, not working either. Would be extremely nice if u could provide some command line!

july
on 2/3/14, 5:37 PM
0
Daniele Bondì
On 2/3/14, 6:53 PM

This works for me.

psql -U user -d database
table res_users; (don't forget the semicolon)

The password is the 4th column.

Thanks or your reply, unfortunately it doesnt work by me. I did as u said but i got a peer authentification error for openerp, and the same for postgres and for admin. I checked in pgadmin: it is admin admin, but on localhost it doesnt work. I also removed and reinstall openerp, postgresql and pgadmin, still the same. Now i created a second database, because i need to go forward. But i would very like to understand what is wrong in my installation.

july
on 2/4/14, 6:03 PM
0
Jakub Krzempek
On 2/4/14, 7:03 AM

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.

Thanks or your reply, unfortunately it doesnt work. I did as u said but i got a peer authentification error for openerp, and the same for postgres and for admin. I checked in pgadmin: it is admin admin, but on localhost it doesnt work. Now i created a second database, because i need to go forward. But i would very like to understand what is wrong in my installation. I also removed and reinstall openerp, postgresql and pgadmin, still the same.

july
on 2/4/14, 6:02 PM

Take a look at this

stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge

And this for an explanation of the peer auth error

http://stackoverflow.com/questions/17443379/psql-fatal-peer-authentication-failed-for-user-dev

Daniele Bondì
on 2/5/14, 4:33 PM

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: 2/3/14, 4:32 PM
Seen: 1871 times
Last updated: 3/16/15, 8:10 AM