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

حول هذا المنتدى

المساعدة

Apache X-Odoo-dbfilter not working Odoo 12

proxy apache2 v12

4 الردود

5233 أدوات العرض

Jurn

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/ retry=0

ProxyPassReverse / http://localhost:8069/

However I still get redirected to webshop.mydomain.com/web/database/selector

If I add this in /etc/odoo/odoo.conf

dbfilter = myproductiondb

It works. But now it is always doing this, while I only want to force this on the webshop. So why is the RequestHeader functionality not working.

Hope someone can help me

Thanks

Paresh Wagh

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

bsach

list_db = false ?

VP Singh

Hi Jurn,

Facing exactly the same issue on Odoo 13.

What was the solution to your problem?

Thanks,

Varinder

Jurn

الكاتب

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

Paresh Wagh

No. The name of the database should match the domain. You can duplicate and rename the database if you are still in the development phase. If you are already in production, you will need to assess the impact of changing the name of the database. For example, you may have backup scripts that have the database name hard coded in them.

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
[8.0]Website Module Bad redirection behind apache proxy : slash missing تم الحل proxy apache2	1 مارس 15	5817
Error in redirecting a module to the website proxy apache2 odoo16	1 أغسطس 24	1833
Multiple OpenERP instance with port redirection تم الحل proxy hosting apache2	1 مارس 15	6757
Odoo 10 Can't restore Database with Database Manager behind Apache Proxy. proxy apache2 databasebackup odoo10	3 يوليو 21	9227
reverse proxy to subdirectory <host.domain.tld>/external/erp تم الحل proxy apache2 subdirectory reverse	5 أغسطس 15	57098

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!