Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
databasesubdomainodooV8dbfilter
1 ตอบกลับ
10046 มุมมอง
อวตาร
Cyrus Waithaka

I am trying to set up odoo v8 with dbfilter on subdomains. I have created two subdomains on my server. db1.mydomain.com and db2.mydomain.com. ( I am using virtual min to manage the subdomains). I have then added the line dbfilter = ^%d$ in my odoo configuration file. However, I cannot access any of the databases. What am I doing wrong? Here is my apache2 config file. Openerp.conf

<VirtualHost *:80>
ServerName mydomain.com
ServerAlias *mydomain.com
WSGIScriptAlias / /opt/odoo/openerp-wsgi.py
WSGIDaemonProcess oe user=odoo group=odoo processes=2 python-path=/opt/odoo/ display-name=apache-odoo
WSGIProcessGroup oe
ErrorLog /var/log/odoo/odoo-error.log
CustomLog /var/log/odoo/odoo-access.log combined
<Directory /opt/odoo>
#Order allow,deny
#Allow from all
Options All
AllowOverride All
Require all granted
</Directory>
</VirtualHost>

อวตาร
ละทิ้ง
อวตาร
Axel Mendoza
คำตอบที่ดีที่สุด

You aren't doing anything wrong, you just need to setup more subdomains or a wildcard one for the rest of the dbs. If you are not seeing any database it's because you aren't sending the correct headers information so your virtualmin could act as reverse proxy for Odoo. Search for how to do deploy it here

https://www.odoo.com/documentation/8.0/setup/deploy.html

for nginx I set this headers with their values:

 proxy_set_header Host $host;
 proxy_set_header X-Real-IP $remote_addr;
 proxy_set_header X-Forward-For $proxy_add_x_forwarded_for;
 proxy_set_header X-Scheme $scheme;

You need to find how to do it in virtualmin

อวตาร
ละทิ้ง
Cyrus Waithaka
ผู้เขียน

Hi Axel. Thank you for the quick response. I only have two databases and each has a subdomain. However, if I visit the subdomains, I don't get any database. How can I ensure that correct header information is sent?

Axel Mendoza

I update the answer with how I do it with nginx

Axel Mendoza

check this
http://www.nkr1ptd.com/2014/11/using-apache-with-odoo-8-and-ubuntu-1404.html

Cyrus Waithaka
ผู้เขียน

After following everything in all the guides that I could find online, including that one, dbfilter just couldnt work on virtual min. It finally worked after trying several thing. Not sure what exactly was the issue. Here is a list of everything that I did. 1. In /openerp/tools/config.py, ensure line 185 rreads group.add_option("--db-filter", dest="dbfilter", my_default='.*', 2. I updated virtual min to the latest version. 3. I then changed PHP script execution mode run from the web server user in Server Configuration> Website Options "Apache mod_php (run as Apache's user)". I then restarted odoo and apache2 service. These steps somehow worked.

Related Posts ตอบกลับ มุมมอง กิจกรรม
Bypass or Override for dbfilter for Admin or database manager?
database dbfilter
อวตาร
1
ส.ค. 24
8086
Is there a way to clear a database of all posted transactions, stock movement and activity without changing configurations and settings in the modules? (Odoo V8) แก้ไขแล้ว
database odooV8
อวตาร
อวตาร
อวตาร
3
ม.ค. 24
8137
Odoo server error แก้ไขแล้ว
hr database odooV8
อวตาร
อวตาร
อวตาร
อวตาร
อวตาร
5
ก.ค. 23
51875
Odoo dbfilter in conf file
database dbfilter multi-website
อวตาร
อวตาร
อวตาร
4
ธ.ค. 21
22811
How to search through a database?
database odooV8 odoo8.0
อวตาร
อวตาร
2
ส.ค. 19
6390