Skip ke Konten
Odoo Menu
  • Login
  • Uji coba gratis
  • Aplikasi
    Keuangan
    • Akuntansi
    • Faktur
    • Pengeluaran
    • Spreadsheet (BI)
    • Dokumen
    • Tanda Tangan
    Sales
    • CRM
    • Sales
    • POS Toko
    • POS Restoran
    • Langganan
    • Rental
    Website
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventaris
    • Manufaktur
    • PLM
    • Purchase
    • Maintenance
    • Kualitas
    Sumber Daya Manusia
    • Karyawan
    • Rekrutmen
    • Cuti
    • Appraisal
    • Referensi
    • Armada
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Acara
    • Otomatisasi Marketing
    • Survei
    Layanan
    • Project
    • Timesheet
    • Layanan Lapangan
    • Meja Bantuan
    • Planning
    • Appointment
    Produktivitas
    • Discuss
    • Kecerdasan Buatan
    • IoT
    • VoIP
    • Pengetahuan
    • WhatsApp
    Aplikasi pihak ketiga Odoo Studio Platform Odoo Cloud
  • Industri
    Retail
    • Toko Buku
    • Toko Baju
    • Toko Furnitur
    • Toko Kelontong
    • Toko Hardware
    • Toko Mainan
    Makanan & Hospitality
    • Bar dan Pub
    • Restoran
    • Fast Food
    • Rumah Tamu
    • Distributor Minuman
    • Hotel
    Real Estate
    • Agensi Real Estate
    • Firma Arsitektur
    • Konstruksi
    • Manajemen Properti
    • Perkebunan
    • Asosiasi Pemilik Properti
    Konsultansi
    • Firma Akuntansi
    • Mitra Odoo
    • Agensi Marketing
    • Firma huku
    • Talent Acquisition
    • Audit & Sertifikasi
    Manufaktur
    • Tekstil
    • Logam
    • Perabotan
    • Makanan
    • Brewery
    • Corporate Gift
    Kesehatan & Fitness
    • Sports Club
    • Toko Kacamata
    • Fitness Center
    • Wellness Practitioners
    • Farmasi
    • Salon Rambut
    Perdagangan
    • Handyman
    • IT Hardware & Support
    • Sistem-Sistem Energi Surya
    • Pembuat Sepatu
    • Cleaning Service
    • Layanan HVAC
    Lainnya
    • Organisasi Nirlaba
    • Agen Lingkungan
    • Rental Billboard
    • Fotografi
    • Penyewaan Sepeda
    • Reseller Software
    Browse semua Industri
  • Komunitas
    Belajar
    • Tutorial-tutorial
    • Dokumentasi
    • Sertifikasi
    • Pelatihan
    • Blog
    • Podcast
    Empower Education
    • Program Edukasi
    • Game Bisnis 'Scale Up!'
    • Kunjungi Odoo
    Dapatkan Softwarenya
    • Download
    • Bandingkan Edisi
    • Daftar Rilis
    Kolaborasi
    • Github
    • Forum
    • Acara
    • Terjemahan
    • Menjadi Partner
    • Layanan untuk Partner
    • Daftarkan perusahaan Akuntansi Anda.
    Dapatkan Layanan
    • Temukan Mitra
    • Temukan Akuntan
    • Konsultasi
    • Layanan Implementasi
    • Referensi Pelanggan
    • Bantuan
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Dapatkan demo
  • Harga
  • Bantuan
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Help

Odoo 18 multi domains with multi databases dbfilter

Langganan

Dapatkan notifikasi saat terdapat aktivitas pada post ini

Pertanyaan ini telah diberikan tanda
automaticlist_dbdbfiltermultidomainmultidatabase
3 Replies
182 Tampilan
Avatar
Asep Sidhi

I have several domains with multiple existing databases in my Odoo 18. I already activate the website app and set each domain within website > setting for each database.


   DatabaseA for mydomain1.com

   DBossB for myurl2.com


I want each domains automatically connect with its default database without database selector or create a new database.


within odoo.conf, I try to use :

dbfilter = ^%d$ 

list_db = False


and it variants (using ^%d or ^%h$ or ^%h ), but it always ask me to create new database . 


How to solve this problem ? Looking forward for how to solve this ....

0
Avatar
Buang
Avatar
Host4Geeks
Jawaban Terbai

The reason every variant sends you to the create-database screen is that dbfilter doesn't map "domain → database" the way the names suggest. Odoo takes the incoming hostname, substitutes it into the pattern, and matches the result against your database names:

  • %h = the full hostname (e.g. mydomain1.com)
  • %d = the first label of the hostname, i.e. everything before the first dot (e.g. mydomain1)

So dbfilter = ^%d$ on a request to mydomain1.com resolves to ^mydomain1$ and looks for a database literally named mydomain1. Your databases are named DatabaseA and DBossB, which match none of these patterns, Odoo finds zero eligible databases and falls through to the manager.

The easiest way to fix this would be to rename DatabaseA → mydomain1.com and DBossB → myurl2.com, then:

[options]
proxy_mode = True
dbfilter = ^%h$
list_db = False

%h$ now resolves to the full hostname per request and matches the identically-named DB. proxy_mode = True is required so Odoo trusts the Host/X-Forwarded-* headers from your proxy instead of seeing localhost. This is the easiest setup.

The reverse proxy setup for Nginx or Apache would look like this:

Nginx

upstream odoo { server 127.0.0.1:8069; }

server {
listen 80;
server_name mydomain1.com;
location / {
proxy_set_header Host $host;
proxy_set_header X-Forwarded-Host $host;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
proxy_redirect off;
proxy_pass http://odoo;
}
}

Duplicate that block with server_name myurl2.com;

If you're using Apache as your Reverse Proxy:

<VirtualHost *:80>
ServerName mydomain1.com
ProxyPreserveHost On
RequestHeader set X-Forwarded-Proto "http"
ProxyPass / http://127.0.0.1:8069/
ProxyPassReverse / http://127.0.0.1:8069/
</VirtualHost>

ProxyPreserveHost On is the Apache counterpart to nginx's proxy_set_header Host.


0
Avatar
Buang
Avatar
Zehntech Technologies Inc.
Jawaban Terbai

Hello, 

This is usually caused by the dbfilter pattern not matching your actual database names.

The configuration dbfilter = ^%d$ works only when the database name matches the domain name (for example, mydomain1 → mydomain1.com).

If your databases are named differently (e.g., DatabaseA and DBossB), Odoo will not find a matching database and may redirect to the database manager page.

Please verify:

  • The database names match your dbfilter rule.
  • proxy_mode = True is enabled if you are using Nginx/Apache as a reverse proxy.
  • The domains are correctly pointing to the Odoo instance and sending the proper Host header.

In cases where database names differ from domain names, you may need a custom dbfilter expression or rename the databases to align with the domain pattern.

Hope this works for you! If you need any help implementing this or want a more optimized approach, feel free to reach out for further discussion.

Regards,

Zehntech Technologies Inc.

santosh.sekwadia@zehntech.com

0
Avatar
Buang
Avatar
Gharis Javed
Jawaban Terbai

The issue is that dbfilter = ^%d$ relies on the subdomain matching the database name exactly. When your domain is mydomain1.com, Odoo extracts the hostname and tries to match it against the regex pattern — but mydomain1.com does not match DatabaseA because there is no subdomain to extract.

The production-safe solution is to use %h with nginx rewriting the Host header per domain.

Step 1 — odoo.conf

dbfilter = ^%h$
list_db = False

Step 2 — nginx config for each domain

For mydomain1.com:

server {
    server_name mydomain1.com;
    location / {
        proxy_pass http://127.0.0.1:8069;
        proxy_set_header Host DatabaseA;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
    }
}

For myurl2.com:

server {
    server_name myurl2.com;
    location / {
        proxy_pass http://127.0.0.1:8069;
        proxy_set_header Host DBossB;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
    }
}

Why this works:

proxy_set_header Host DatabaseA rewrites the Host header Odoo receives to match your database name exactly. The dbfilter ^%h$ then matches the rewritten host against your database name and connects automatically with no selector shown.

Why your current setup fails:

^%d$ extracts only the subdomain portion. On a root domain like mydomain1.com there is no subdomain — %d returns empty, the filter matches nothing, and Odoo falls back to the database creation screen.

After updating nginx:

sudo nginx -t && sudo systemctl reload nginx
sudo systemctl restart odoo

Muhammad Gharis Javed — Odoo v17/18/19 Backend Engineer

0
Avatar
Buang
Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar
Post Terkait Replies Tampilan Aktivitas
Odoo 14 / bitanmi - dbFilter <again>
dbfilter
Avatar
0
Des 20
2703
Welcome message whatsapp
automatic WhatsApp
Avatar
Avatar
Avatar
2
Jun 26
458
Managing 2 companies with separate databases
database multidatabase
Avatar
Avatar
1
Jul 25
2232
odoo.sql_db: Closed 1 connections
dbfilter Docker
Avatar
0
Nov 24
2741
Odoo 14-Automated action
automatic PythonCode
Avatar
Avatar
1
Jan 24
2786
Komunitas
  • Tutorial-tutorial
  • Dokumentasi
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Terjemahan
Layanan
  • Odoo.sh Hosting
  • Bantuan
  • Peningkatan
  • Custom Development
  • Pendidikan
  • Temukan Akuntan
  • Temukan Mitra
  • Menjadi Partner
Tentang Kami
  • Perusahaan kami
  • Aset Merek
  • Hubungi kami
  • Karir
  • Acara
  • Podcast
  • Blog
  • Pelanggan
  • Hukum • Privasi
  • Keamanan
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk Slovenščina Español (América Latina) Español Svenska ภาษาไทย Türkçe українська Tiếng Việt

Odoo adalah software terintegrasi dengan 70+ aplikasi seperti CRM, Akuntansi, Inventaris, Sales, eCommerce, Marketing, POS; plus fitur lokal Indonesia!

Mudah digunakan dan terintegrasi penuh pada saat yang sama adalah value proposition unik Odoo.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now