Domain based db filter

Question

Actualy, I posted the same question here ()
But Since it got no response .. I repost it here, I apologie for this.
Version : OpenErp 7
I create 2 db : db1 and db2
I also have hostname setup on my dns server ; db1.erp.bno db2.erp.bno
and in my /etc/openerp/openerp-server.conf , I put :
list_db = False To disable the DB choice list, and
db_filter=^%d$ In hope that web UI will select the db in regards of hostname (first part of FQDN)
But both didn't work ,the DB choice list still there.
My installa

Rui Andrada · Accepted Answer

That is bug already know, as Danimar says
But I think hack the code is always not a good option.
You can use server startup with parameter --db-filter as:
'%d' or '^%d' or even '^%d$'
The value is a regular expression, you may use %d for a hostname part of domain or %h to full domain name.
E.g.
domain = hostname.domainname.com
OpenERP replaces like:
%d = hostname
%h = hostname.domainname.com
The '^' means start of line and the '$' end of line, so '^%d$' only filter db with name 'hostname' follow

Danimar Ribeiro · Answer

This a known bug with a fix of 3 characters.
https://bugs.launchpad.net/bugs/940439 [1]

Just change in config.py the line where it adds the dbfilter option from:
group.add_option("--db-filter", dest="dbfilter", default="./",
to
group.add_option("--db-filter", dest="dbfilter", my_default="./",

There is a merge proposal in the bug with this change, but is too hard to do that :)

[1] https://bugs.launchpad.net/bugs/940439

Nikhil Krishnan · Answer

dbfilter = example-com (DB name)
Give this in the .conf file ,
it will works. :)

Sarl · Answer

Hi all,
May be this help you.
We find a solution for use %h and subdomain, create your db in replace '.' by '-'.
Example : for the domaine erp.pharmacy.com, create db erp-pharmacy-com
And in your file .conf, at line dbfilter, write this : dbfilter = %h
Works for Odoo v8

ABC · Answer

Hi bino
Since OpenERP-Server didn't recognize this param in openerp-server.conf , you need to specify it in start command
openerp-server --db-filter ^%d$ -s /etc/openerp/openerp-server.conf
I've tested it on my computer and it works . You can have try .
Alex

Thierry BOULOGNE · Answer

Hello,
Another way to do it is to change the initscript (debian/ubuntu) :

DAEMON_OPTS="-c $CONFIGFILE --db-filter=^%d$"

You could make this change into : */etc/init.d/openerp-server* (replace with your init script name).
And then restart opener server.
Works great :-).
Regards

相關帖文	回覆	瀏覽次數
How to prevent user select specific db by add ?db=select_db in url ? list_db db_filter	3 8月 21	16373
How to set default database for anonymous user? db_filter	2 10月 16	8678
Database list only showing 1 database db_filter odoo.conf	2 9月 23	9007
Where in code, i can find the db filter function? 已解決 db_filter regex	1 5月 18	4563
How to set dbfilter in multi-domain, multi-subdomain and multi-database? db_filter dbfilter odoo16features	3 1月 25	4013

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！