Apache X-Odoo-dbfilter not working Odoo 12

Question

We have Odoo 12 (enterprise) on Ubuntu 18 running.

I want to force a database selection when a request comes from a certain domain (the webshop domain)

So https://webshop.mydomain.com should only use the production "myproductiondb"

In /etc/odoo/odoo.conf I have set this:
server_wide_modules = base,web,dbfilter_from_header
proxy_mode = True

In Apache:
ProxyRequests Off
RequestHeader set X-Odoo-dbfilter "myproductiondb"

#Redirect to ODOO
ProxyPreserveHost On
ProxyPass / http://localhost:8069/

Paresh Wagh · Answer

Hi Jurn:
There may be a simpler way to do this by using *%d* in the *dbfilter* setting in odoo.conf
Take a look at the 2nd example provided here:
https://www.odoo.com/documentation/12.0/setup/deploy.html#configuration-samples [1]

[1] https://www.odoo.com/documentation/12.0/setup/deploy.html#configuration-samples

bsach · Answer

list_db = false ?

VP Singh · Answer

Hi Jurn,
Facing exactly the same issue on Odoo 13.
What was the solution to your problem?
Thanks,
Varinder

Jurn · Answer

Hi Paresh,
Thanks! However does this work if the database name is " myproductiondb" and the domain " webshop.mydomain.com" (so no relation in name)?
Or does this automatically work when the system parameter web.url is set to  in the database  myproductiondb?

Thanks

관련 게시물	답글	화면
[8.0]Website Module Bad redirection behind apache proxy : slash missing 해결 완료 proxy apache2	1 3월 15	5821
Error in redirecting a module to the website proxy apache2 odoo16	1 8월 24	1841
Multiple OpenERP instance with port redirection 해결 완료 proxy hosting apache2	1 3월 15	6768
Odoo 10 Can't restore Database with Database Manager behind Apache Proxy. proxy apache2 databasebackup odoo10	3 7월 21	9230
reverse proxy to subdirectory <host.domain.tld>/external/erp 해결 완료 proxy apache2 subdirectory reverse	5 8월 15	57109

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!