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
list_dbdb_filter
11 Odpowiedzi
103828 Widoki
Awatar
bino oetomo

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 installation is in ubuntu using apt-get

Kindly please give me your enlighten

Sincerely

-bino-

Awatar
Odrzuć
Awatar
Rui Andrada
Najlepsza odpowiedź

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' following the example.

Starting the server with:

openerp-server --db-filter='^%d'

Filter name of any db starting with "hostname" domain part.

Awatar
Odrzuć
Rui Andrada

Hi Phoebe, As Thierry BOULOGNE have said you can do: ''' DAEMON_OPTS="-c $CONFIGFILE --db-filter=^%d$" ''' But in debian family like ubuntu, mintlinux and etc you can do that change this configuration in: ''' /etc/default/openerp ''' This setting are environment variables to openerp-server daemon, this variable added or changed in that file will be availbale to /etc/init.d/openerp script.

Awatar
Danimar Ribeiro
Najlepsza odpowiedź

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

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 :)

Awatar
Odrzuć
Awatar
Nikhil Krishnan
Najlepsza odpowiedź

dbfilter = example-com (DB name)

Give this in the .conf file ,

it will works. :)

Awatar
Odrzuć
DWARKANATH BARI

Hi i have a Test and Ecommerce db, my domain is www.simpleenergytech.com. when i enter this i want to connect Ecommerce db. How i can do this ? In which file need to make change ?

Nikhil Krishnan

you need to find the odoo configuration file,

its location is based on your installation,

preferable is go to /etc/odoo.conf

In the file please add a line,

dbfilter = Ecommerce

Awatar
Thierry BOULOGNE
Najlepsza odpowiedź

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

Awatar
Odrzuć
Awatar
Sarl
Najlepsza odpowiedź

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

Awatar
Odrzuć
TEIMI Yassine

Hey, does it work for a domain name mapping ? I want to map example.com to my database, so I created the database like : example-com as you said, and set : db_filter = ^%h$ but it doesn't work. Thanks for help.

Awatar
ABC
Najlepsza odpowiedź

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

Awatar
Odrzuć
Awatar
blh.omr@gmail.com
Najlepsza odpowiedź

-r yourpassword-w yourpassword -d my_data_base--db-filter= my_data_base --xmlrpc-port=8069 --db_host=localhost --addons-path=justice_addons --update=all

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
How to prevent user select specific db by add ?db=select_db in url ?
list_db db_filter
Awatar
Awatar
Awatar
Awatar
3
sie 21
17592
How to set default database for anonymous user?
db_filter
Awatar
Awatar
2
paź 16
9648
Database list only showing 1 database
db_filter odoo.conf
Awatar
Awatar
Awatar
2
wrz 23
10677
Where in code, i can find the db filter function? Rozwiązane
db_filter regex
Awatar
Awatar
1
maj 18
5519
How to set dbfilter in multi-domain, multi-subdomain and multi-database? Rozwiązane
db_filter dbfilter odoo16features
Awatar
Awatar
Awatar
3
paź 25
6081