Odoo Help


Automatically choose database based on subdomain

Timo Goosen
on 11/24/14, 9:21 AM 2,949 views

I'm using Odoo + Nginx as a reverse SSL proxy. I followed this guide to get it setup:



I'd like to type in somessubdomain.example.com and have it redirected to the login page for that given database.  In the background this should be happening:

When I request:


This should be returned https://somessubdomain.example.com

And in the background I would like this to happen:


On OpenERP 7 + Apache2 I know how to set this up , but I'm not sure how to do this with Nginx.


Someone refered me this guide but is not helping much: https://www.odoo.com/forum/help-1/question/domain-based-db-filter-6583


Hope you understand my question.  Your help would be much appreciated.

On 3/11/15, 5:05 PM

I think your problem is due to the following: with the most common nginx reverse proxy I've seen on the web, all https requests for subdomains are forwarded to the same server:



that is the domain that reaches dbfilter!!

The solution I found was:

  • Add dbfilter=%d to your config file. I have tried several other options like ^%d$, and this is the only one that worked!
  • restart odoo
  • Then, for each subdomain you want to add:
    • Configure your dns so that it points to the right ip
    • Add a line to /etc/hosts with
    • subdomain.localhost
    • Create a new site in nginx with server_name subdomain.example.com that does a proxy_pass to http://subdomain.localhost:8069
    • restart nginx
    • create the database whose name is *exactly* subdomain

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 11/24/14, 9:21 AM
Seen: 2949 times
Last updated: 10/28/16, 4:43 AM