Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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 18.104.22.168, and username is admin, then add similar line to pg_hba.conf:
host admin 22.214.171.124/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)
About This Community
This platform 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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 9/11/14, 4:13 AM|
|Seen: 24309 times|
|Last updated: 10/27/16, 3:00 AM|