Skip to Content
This question has been flagged
db_filterodoo.conf
2 Respostes
10619 Vistes
Avatar
Ben Quan

I have created 3 databases, but when I run ./odoo-bin only one db is shown (the database name is ben like  the OS user).

I searched the forums and I get that it should be related to the owner of the database in postgresql, but the 3 databases have the same owner (ben).

The odoo.conf has these lines:

db_host = False
db_maxconn = 64
db_name =
db_password = False
db_port = False
db_sslmode = prefer
db_template = template0
db_user = False
dbfilter = .*


but dbfilter there does not seem to work.

The only way to make them show is if I run it as: ./odoo-bin --db-filter '.*'

Can anyone point where the problem is?

 

Avatar
Descartar
Kabeer KB

@Ben Quan, have you got a solution? i am facing the same issue.

Avatar
Mehjabin Farsana
Best Answer

Hi,

If you specify db_filter or db_name in the odoo configuration file, then you will get only filtered databases.

Suppose if you set a db filter, then db's matching given filter will be listed and if you specify db_name in conf file, only that database will be shown.

Also if you are running via service file or command line, make sure you didn't pass db name in -d 


Thanks

Avatar
Descartar
Avatar
Hilar Andikkadavath
Best Answer

You only need this min configuration to run ODOO.

db_host = localhost
db_port = 5432
db_password = postgres
db_user = odoo
xmlrpc_port = 8013
debug_mode = False
;data_dir=/home/dell/.local/share/Odoo/filestore
addons_path = /opt/odoo/addons

make sure you needed db_template, db_name, db_filter.
You don't need to specify db_filter if you need full list of dbs

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Can't find my odoo.conf file after installing odoo 17 on debian 12
odoo.conf
Avatar
Avatar
2
de des. 23
8479
How to splice lines for odoo.conf file configuration Solved
odoo.conf
Avatar
Avatar
1
de nov. 22
3187
Where is the the file odoo.conf in Odoo 13? Solved
odoo.conf
Avatar
Avatar
1
de nov. 23
62356
How to set default database for anonymous user?
db_filter
Avatar
Avatar
2
d’oct. 16
9612
[NOT SOLVED yet] I can't set up/push my module with odoo.conf addons_path or scaffold command
modules odoo.conf
Avatar
Avatar
2
d’oct. 23
583