i want to access Odoo database using pgAdmin3,
I have my Odoo running on ubuntu server in virtual box
I have installed pgAdmin3 on my localhost machine
when opening pgAdmin3 and selecting New Server Registration
this is my entry:
Host: 192.168.1.114 (this is the ip if you 'ifconfig' in the virtual box )
Port: 5432 (default didn't change anything)
Username: admin (this is my usernane in odoo , admin account)
Password: admin (my ppassword in odoo)
There is error after proceeding
An error has occurred:
Error connecting to the server: FATAL: password authentication failed for user "admin"
FATAL: password authentication failed for user "admin"
what (username and password) should i enter there to connect to Odoo, i want to see records of tables there for example res_users
Your input to pgadmin connection fields are all Ok (considering that username and password should be valid database username and password). I think your problem is that you haven't set an access rules in database configuration ( in your ubuntu server in virtual box)
you have to add access rule in config file of postgresql (file name is "pg_hba.conf", in 'Debian' full path is /etc/postgresql/9.1/main/pg_hba.conf ) for a host FROM which you are connecting to database
As you find "pg_hba.conf', you have to add access rule, something like:
host <user name> <ip/network> md5
let's say your host ip, from which you are connecting is 126.96.36.199, and username is admin, then add similar line to pg_hba.conf:
host admin 188.8.131.52/32 md5
- and do not forget about restarting of database server, once you've changed the config file.
Name: Whatever you like, odoo is fine.
Host: This is localhost or 127.0.0.1 (is the same) not your IP
Port: 5432 (this is right)
Username: This is not your odoo's user, is the user you use to connect to the DB, you can see it in openerp-server.conf or in the log when you run openerp (Mine is openuser)
Password: The password of the user of the BD, not the one in odoo. (eg. password)
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/11/14, 4:13 AM|
|Seen: 16206 times|
|Last updated: 8/25/16, 4:11 AM|