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

We have in aour production postgresql cluster databases for odoo and for other products. By watching odoo log files, we saw that ir_cron try to work with non Odoo db. We have a dbfilter in our conf file : dbfilter='^LIB_.*'

Does exist a way to prevent those warning ?

​2019-06-12 10:50:09,033 36 ERROR zato odoo.sql_db: bad query: b"SELECT latest_version FROM ir_module_module WHERE name='base'"
ERROR: relation "ir_module_module" does not exist
LINE 1: SELECT latest_version FROM ir_module_module WHERE name='base...

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

In standard Odoo should be installed with user = odoo. In this case all Odoo databases has owner = odoo. Your bases must have probably another owner.

ALTER DATABASE name OWNER TO new_owner;


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

There are many cases where multiple Odoo instances are sharing a same postgress cluster. It is certainly not a requirement that databases have odoo as owner. If there are multiple instances, that would actually be a security breach. Odoo should respect dbfilter. This not happening is a bug.

Bài viết liên quan Trả lời Lượt xem Hoạt động
0
thg 3 15
5308
0
thg 5 21
2391
0
thg 7 25
1522
2
thg 11 24
6546
2
thg 10 24
3487