跳至内容
Odoo 菜单
  • 登录
  • 免费试用
  • 应用程序
    财务
    • 会计
    • 发票
    • 费用
    • 电子表格 (BI)
    • 文档
    • 电子签名
    销售
    • 客户关系管理
    • 销售
    • POS 销售点管理-零售
    • POS 销售点管理 - 餐厅
    • 订阅
    • 租赁
    网站
    • 网站设计
    • 电子商务
    • 博客
    • 论坛
    • 在线客服
    • 在线学习
    供应链
    • 库存
    • 制造
    • 产品生命周期
    • 采购
    • 维护保养
    • 品控
    人力资源
    • 员工
    • 招聘
    • 休假
    • 评价
    • 内部推荐
    • 车队
    营销
    • 社媒营销
    • 电邮营销
    • 短信营销
    • 近期活动
    • 营销自动化
    • 网上调查
    服务
    • 项目管理
    • 工时单
    • 现场服务
    • 服务台
    • 排期
    • 预约
    生产力
    • 讨论
    • 批核
    • IoT物联网
    • VoIP
    • 知识库
    • WhatsApp
    第三方应用软件 Odoo 定制 Odoo云端平台
  • 行业
    零售
    • 书店
    • 服装店
    • 家具店
    • 食品杂货店
    • 五金店
    • 玩具店
    餐饮与酒店服务
    • 酒吧及酒馆
    • 餐厅
    • 快餐
    • 民宿
    • 饮品分销商
    • 酒店
    房地产
    • 房地产代理
    • 建筑师事务所
    • 建造业
    • 地产管理
    • 园艺
    • 业主协会
    咨询
    • 会计师事务所
    • Odoo合作伙伴
    • 市场推广公司
    • 律师事务所
    • 人才招聘
    • 审核 & 认证
    制造
    • 纺织
    • 金属
    • 家具
    • 食品
    • 啤酒厂
    • 企业礼品
    保健与健身
    • 体育俱乐部
    • 眼镜店
    • 健身中心
    • 健康从业者
    • 药房
    • 发型屋
    商贸服务
    • 维修人员
    • IT 硬件及支持
    • 太阳能系统
    • 鞋匠
    • 清洁服务
    • 暖通空调服务
    其他
    • 非营利组织
    • 环境机构
    • 广告牌租赁
    • 摄影服务
    • 自行车租赁
    • 软件经销商
    浏览所有行业
  • 社区
    学习
    • 教学视频
    • 文档
    • 认证
    • 培训
    • 博客
    • 播客
    赋能教育
    • 教育计划
    • Scale Up! 商业游戏
    • 参观Odoo
    获取软件
    • 下载
    • 版本对比
    • 发布
    合作
    • Github
    • 论坛
    • 近期活动
    • 翻译
    • 成为合作伙伴
    • 合作伙伴服务
    • 注册您的会计事务所
    获取服务
    • 寻找合作伙伴
    • 查找会计服务
    • 预约顾问咨询
    • 安装及推行服务
    • 客户参考
    • 支持
    • 升级
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    获取演示
  • 定价
  • 技术支持

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • 客户关系管理
  • e-Commerce
  • 会计
  • 库存
  • PoS
  • 项目
  • MRP
All apps
只限注册用戶才可与社群互动。
所有帖文 人 徽章
标签 (查看所有)
odoo accounting v14 pos v15
关于此论坛区
只限注册用戶才可与社群互动。
所有帖文 人 徽章
标签 (查看所有)
odoo accounting v14 pos v15
关于此论坛区
帮助

How to access database of Odoo using pgAdmin III

订阅

此帖文有活动时,接收通知

此问题已终结
postgresqlodoo
14 回复
103086 查看
形象
Lakay lakay

Hi, 

i want to access Odoo database using pgAdmin3,

My scenario:

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:

Name:    odoo

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)

Group: Servers

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

 

 

 

 

1
形象
丢弃
形象
Temur
最佳答案

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 200.200.200.200, and username is admin, then add similar line to pg_hba.conf:

host    admin    200.200.200.200/32   md5

- and do not forget about restarting of database server, once you've changed the config file.

 

3
形象
丢弃
Temur

For verify if you're using correct username and password, please consult "openerp-server.conf" file (in Debian it's full path is: "/etc/openerp/openerp-server.conf", you've to find its equivalent on Ubuntu), where 'db_user' property will show you correct username. As password, please use one that allows you copy/drop/create databases in openerp "Manage Databases" page (This page is accessible in openerp login page, before you login to openerp).

Lakay lakay
编写者

Hi, Temur i already added in my pg_hba.conf (in my ubuntu server)on the most bottom the line host openerp 192.168.1.114/24 md5 (this is my ip in the ubuntu server) also i added another line host all all 192.168.1.114/24 md5 (restart my server , same error) also in my openerp-server.conf in the debian this is my configuration [options] ; This is the password that allows database operations: ; admin_passwd = admin db_host = False db_port = False db_user = openerp db_password = False ~ ~ i tried to change the db_password with 'admin' and when i tried it on pgAdmin3 with Host=localhost username=openerp password =admin , same error also when i run the openerp-server the logs says that openerp: database hostname:localhost openerp:database port:5432 openerp:database user: myuser why is it contradicting to the one in the openerp-server.conf?

Lakay lakay
编写者

in reply to your comment that the password that must be used is the one in odoo wherein it allows you copy/drop/create database. that password is 'admin' but in my openerp-server.conf the db_password=False why is it? what should i write in the pgAdmin3?

Temur

hi, 1) USERNAME... ; admin_passwd = admin above line starts with ';' (semicolon symbol), so this line is just a comment. the real passwor may be different, you do NOT need to change this line. you should consult "openerp-server.conf" only for username and the 'db_user' property gives you correct username that you have to use in pgadmin. 2) PASSWORD... The correct password you have to use is that you allows database operations in Openerp "Manage Databases" page. this page is accessible from login page of openerp (when you connect to your Openerp from browser, you can go to "Manage Databases" page before you login. and there if you create new database, you have to type password. AFAIK you set this password when you install openerp.) make sure you know correct password by creating new database from that page. If so, you know the password that you have to use in pgadmin. 3) ACCESS RULE... you need to add access rule in "pg_hba.conf" in a host you are connecting to (your Ubuntu server) for a machine FROM WHERE you are trying to connect. 192.168.1.114/24 is wrong entry. 192.168.1.114 -is your Ubuntu server IP, you have to use in this rule IP of your machine instead (IP of machine you are connecting from). and one more thing, if you prefer to use network mask: /24, then replace last number by zero: 192.168.1.0/24 4) make sure you ping 192.168.1.114 (virtual box, Ubuntu) from your machine, and oppositely, ping your machine from the Ubuntu. also check the type of network connection of Ubuntu virtual machine in a settings of your Ubuntu virtual machine (in virtualbox settings of Ubunty appliance). consider to using "bridged connection" as network connection type, if you have trouble to ping. (attention, verify IP after this change, it may be changed also) SUMMARY: lets say 'A' is machine you are connecting from. 'B' is machine you are connecting to (it's your virtual box Ubuntu) Then consult "openerp-server.conf" on machine 'B' for username. Add access rule in "pg_hba.conf" on machine 'B' and in this rule use IP of machine 'A' (or network of machine 'A'). As I guess , your error is using IP of machine B, instead of IP of machine A. For verify password, create/drop database from openerp "Manage Databases" page, if you can do these operations, then password you need is that you are typing in this page.

OdooBot
in reply to your comment that you've tried on pgAdmin3 with Host=localhost username=openerp password =admin. Host=localhost -is wrong. You have to use Host = localhost ONLY IF you are runing pgAdmin3 on the same host as openerp and database servers. i.e. if you run your pgAdmin3 in your Ubuntu, together with openerp, then you can use Host=localhost . however your case is different, you are connecting to database from another machine, so you need Host = "IP OF MACHINE YOU ARE CONNECTING TO". As I already mentioned at start of my reply, your inputs to pgAdmin3 are all OK, if username and password are correct.

On 09/12/2014 06:08 AM, Lakay lakay wrote:
<blockquote cite="mid:1410487735.236974954605103.434429518844372-openerp-62485-forum.post@accounts.odoo.com" type="cite">

in reply to your comment that the password that must be used is the one in odoo wherein it allows you copy/drop/create database. that password is 'admin' but in my openerp-server.conf the db_password=False why is it? what should i write in the pgAdmin3?

--
Lakay lakay
Sent by OpenERP S.A. using Odoo about Forum Post False
形象
Francis Louie Del Rosario
最佳答案

Hello Lakay,

this forum can help you


https://stackoverflow.com/questions/10845998/i-forgot-the-password-i-entered-during-postgres-installation

0
形象
丢弃
形象
Jose M
最佳答案

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) 

Group: Servers

0
形象
丢弃
Lakay lakay
编写者

i have trouble in the password, what password are you referring? thanks for your answer.

Lakay lakay
编写者

Password: The password of the user of the BD, not the one in odoo. (eg. password) ->> you mean DB? i have many 5 users in my postgresql which one is it?

Lakay lakay
编写者

Password: The password of the user of the BD, not the one in odoo. (eg. password) ->> you mean DB? i have many 5 users in my postgresql which one is it?

Lakay lakay
编写者

Password: The password of the user of the BD, not the one in odoo. (eg. password) ->> you mean DB? i have many 5 users in my postgresql which one is it?

Jose M

You can see openerp-server.conf -> db_password. Is the password of the user you use to acces database.

Lakay lakay
编写者

the db_password there is set to false (db_password=False) i tried to change it like this (db_password=admin), and when i tried it to pgAdmin3 same error ? this is my configuration as shown below: [options] ; This is the password that allows database operations: ; admin_passwd = admin db_host = False db_port = False db_user = openerp db_password = False ~ Thanks for replying..

喜欢讨论吗?不要只阅读,加入进来!

立即创建账户,享受专属功能,与我们的精彩社区互动!

注册
相关帖文 回复 查看 活动
Digitalocean issue
postgresql odoo
形象
0
12月 21
3390
2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc`
postgresql odoo
形象
形象
2
2月 19
10949
How to get second and fourth saturday of given month in posstgresql ?
postgresql odoo
形象
0
9月 17
3529
how odoo communicates with postgresql technically ?
postgresql odoo
形象
0
3月 15
4817
Record From Odoo must placed also in postgresql database
postgresql odoo
形象
形象
1
3月 15
5872
社区
  • 教学视频
  • 文档
  • 论坛
开源
  • 下载
  • Github
  • Runbot
  • 翻译
服务
  • Odoo.sh 托管
  • 支持
  • 升级
  • 自定义开发服务
  • 教育
  • 查找会计服务
  • 寻找合作伙伴
  • 成为合作伙伴
关于我们
  • 我们的公司
  • 品牌资产
  • 联系我们
  • 招聘
  • 近期活动
  • 播客
  • 博客
  • 客户
  • 法律 • 隐私
  • 安全
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo致力于为企业管理提供高效智能的开源解决方案,是全球业内高速成长的软件服务商之一,逾七百五十万用户选择Odoo进行数字化升级。通过一系列全业务链覆盖、高度集成、简单易用的商业应用,助力企业实现信息化改革、降本增效并释放公司增长潜力。

Odoo独特的价值在于是一款非常容易使用又完全集成的应用。

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now