Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
6019 Lượt xem

Hi, as a DevOps Consultant, I want to run Odoo in a more hardened way. For me that implies, to work with an external database (e.g. AWS RDS) with a db user with least privileges possible (no "CREATEDB" role attribute).

So what I was trying now since two days on odoo 16 and odoo 17, installation from source, as well from debian packages (always community, no enterprise yet) is the following:

I run a dedicated postgres node.

I created an odoo_cc user and a odoo_demo database, which is accessable for the odoo_cc user from my odoo box.

I have set the following configuration in odoo.conf:


db_host = postgresql.my.domain

db_port = 5432

db_user = odoo_cc

db_password = MyPasswd

addons_path = /usr/lib/python3/dist-packages/odoo/addons

db_name = odoo_demo

list_db = False


For my understanding, that should deactivate the database manager and enforce odoo, to just make use of that one database "odoo_demo".


Sadly it is failing (on all four combinations) with the following error message:


failed: FATAL:  no pg_hba.conf entry for host "192.168.33.40", user "odoo_cc", database "postgres", no encryption


How do I need to configure odoo, if I want to fix it to one single database and what steps do I need to apply to initialize that database (if that is even necessary).

Since I'm currently experimenting with odoo, I'm still on the community edition, but planning to change to enterprise soon. I just want to have it under my own control and stable operability is key to us, as we want to make use of the website module as well and therefore run it public internet facing.

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Hi Andre, did you find a working solution because I kind of got the same situation. 

Ảnh đại diện
Huỷ bỏ
Tác giả Câu trả lời hay nhất

Does anyone have any specific idea on this? I can't imagine, I'm the only person of having this problem.

Ảnh đại diện
Huỷ bỏ

PostgreSQL server has rejected the connection attempt. Have you updated pg_hba.conf for this "192.168.33.40" host?

Bài viết liên quan Trả lời Lượt xem Hoạt động
0
thg 7 25
1329
2
thg 10 24
3049
2
thg 8 24
1779
3
thg 7 24
8131
0
thg 4 24
1556