Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
2 Odpowiedzi
6049 Widoki

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.

Awatar
Odrzuć
Najlepsza odpowiedź

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

Awatar
Odrzuć
Autor Najlepsza odpowiedź

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

Awatar
Odrzuć

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

Powiązane posty Odpowiedzi Widoki Czynność
0
lip 25
1339
2
paź 24
3069
2
sie 24
1796
3
lip 24
8157
0
kwi 24
1564