I'm trying to configure domain in a way, so I could use subdomain for accessing database. For example if my domain is `domain.com` and I have databases `demo` and `demo2`. Then I should be able to access it by writing `demo.domain.com` and `demo2.domain.com`. But none of this work. I followed this guide: http://opensourceholic.com/2014/05/09/deploy-openerp-using-mod_proxy-and-mod_wsgi-on-linux-server/
After doing everything by the guide, what I was able to do, was I can only access Odoo web by writing `domain.com`, but if I write `demo.domain.com`, I will only get this message `This webpage is not available`.
So what I did:
My apache2 configuration files:
`openerp.conf`
<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://domain.com:8069/
ProxyPassReverse / http://domain.com:8069/
ProxyVia On
LogLevel warn
</VirtualHost>
`openerp-wsgi.conf`:
<VirtualHost *:80>
ServerName domain.com
ServerAlias *.domain.com // Use this if you want dbfillter on subdomain
WSGIScriptAlias / /opt/openerp/server/openerp-wsgi.py
WSGIDaemonProcess oe user=user group=oerp processes=2 python-path=/opt/openerp/server/ display-name=apache-openerp
WSGIProcessGroup oe
ErrorLog /var/log/openerp/openerp-error.log
CustomLog /var/log/openerp/openerp-access.log combined
<Directory /opt/openerp/server>
Order allow,deny
Allow from all
</Directory>
</VirtualHost>
My `openerp-wsgi.py` configuration:
import openerp
#----------------------------------------------------------
# Common
#----------------------------------------------------------
openerp.multi_process = True # Nah!
# Equivalent of --load command-line option
openerp.conf.server_wide_modules = ['web']
conf = openerp.tools.config
# Path to the OpenERP Addons repository (comma-separated for
# multiple locations)
conf['addons_path'] = '/opt/openerp/server/addons/,/opt/openerp/server/openerp/addons/'
# Optional database config if not using local socket
#conf['db_name'] = 'demo'
conf['db_host'] = '127.0.0.1'
conf['db_user'] = 'user'
conf['db_port'] = 5433
conf['db_password'] = 'password'
#conf['dbfilter'] = '%d'
#----------------------------------------------------------
# Generic WSGI handlers application
#----------------------------------------------------------
application = openerp.service.wsgi_server.application
openerp.service.server.load_server_wide_modules()
#----------------------------------------------------------
# Gunicorn
#----------------------------------------------------------
# Standard OpenERP XML-RPC port is 8069
bind = '0.0.0.0:8069'
pidfile = '.gunicorn.pid'
workers = 4
timeout = 240
max_requests = 2000
And even after doing this, it still was not working, so I added this line in /etc/hosts:
`127.0.0.1 domain.com` Then I was able to access OpenERP when entering domain.com address, but only this. If I add suggested filter (either directly in config file or in openerp-wsgi.py file), then system does not find any database and I can't access any of it, even in the list not to mention the main reason I'm doing this to access by subdomain (as written in an example).
So what is wrong here?
Note. I'm trying this on Odoo v8.