Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
reverse_proxydbfilter
2 Odpowiedzi
9065 Widoki
Awatar
M

WIth dbfilter = ^%d$ and reverse proxy: http://<databasename>.domain.com works great.

 <VirtualHost *:80> 
        ServerName domain.com
        ServerAlias *.domain.com // Use this if you want dbfillter on subdomain
        ErrorLog /var/log/openerp/openerp-error.log
        CustomLog /var/log/openerp/openerp-access.log combined
        <Proxy *>
            Order deny,allow
            Allow from all
        </Proxy>
        ProxyRequests Off
 ProxyPass / http://localhost:8069/ 
 ProxyPassReverse / http://localhost:8069/ 
        ProxyVia On
        LogLevel warn
    </VirtualHost>

What I also want is this:

www.website1.com => database: website1

www.website2.com => database: website2


But how to deal with dbfilter and reverse proxy?

Awatar
Odrzuć
Awatar
Ermin Trevisan
Najlepsza odpowiedź

As "dbfilter = ^%d$" is automatically cutting off "www." it works the same way if you define a virtual host for each domain name, such as one virtual host with ServerName www.website1.com and another one with ServerName www.website2.com, means www.website1.com becomes database website1 and www.website2.com becomes database website2.

Awatar
Odrzuć
Awatar
Ron Arts
Najlepsza odpowiedź

This is my Apache configuration (sub1 is the name of the database). What you are looking for is the X-ODOO_DBFILTER variable. dbfilter will pick this up. Adapted for your example:

<VirtualHost *:80>
    ServerName www.website1.com
    ErrorLog /var/log/httpd/www.website1.com-error.log
    CustomLog /var/log/httpd/www.website1.com-access.log combined
    ProxyRequests Off
    Header add X-ODOO_DBFILTER "website1"
    RequestHeader add X-ODOO_DBFILTER "website1"
    LogLevel warn
    <Location /web/database>
        Order Deny,Allow
        Deny from all
        Allow from my.home.ip.address
    </Location>
    ProxyPass /server-info !
    ProxyPass /server-status !
    ProxyPass / http://localhost:8069/
    ProxyPassReverse / http://localhost:8069/
    ProxyVia On
    ProxyTimeout 300
</VirtualHost>

And you can repeat this section for every new domain.


Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
Odoo 14 / bitanmi - dbFilter <again>
dbfilter
Awatar
0
gru 20
2144
odoo.sql_db: Closed 1 connections
dbfilter Docker
Awatar
0
lis 24
2104
Odoo 15 with SWAG Reverse Proxy
reverse_proxy Docker
Awatar
0
cze 23
2604
strange behaivor when odoo behind reverse proxy (haproxy) - cannot create PDFs anymore Rozwiązane
proxy reverse_proxy
Awatar
1
wrz 24
5737
Bypass or Override for dbfilter for Admin or database manager?
database dbfilter
Awatar
1
sie 24
8184