How to filter database in odoo.conf file for different versions Ex: 12, 13, 14 in localhost

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

How to filter database in odoo.conf file for different versions Ex: 12, 13, 14 in localhost

versions config different filter_domain dbfilter

2 Antwoorden

6089 Weergaven

Denisse Pacheco

I want my odoo.conf only to show database related to the Odoo version currently running in my pycharm, but I see all.
Of course, db from a different version shows an alert icon, since the current settings running can not open them.

When working in localhost, I usually work with different Odoo DB, some from V12, some from V14, etc..
All db usually have different names, since I use clients backup with its date in the name.
Ex: db2506, abc0105, odoo14, odoo12, land0105, etc.
I have one odoo.conf for each version, I used a different http_port for each, since both works on localhost.
I tried changing http_interface to 127.0.0.1 for one of them.
I have seen the dbfilter option, but it only work on domains..

Is there a way to do this?

Divyansh Tripathi

Beste antwoord

Hi,

You can achieve this by creating different PSQL users for different Odoo versions. Once you do that, assign the user to that Odoo version with the help of odoo.conf file, in the odoo.conf file add the user against the db_user parameter. Once you do so, rest of the hierarchy will be taken care of automatically and then you'll only see the databases for that specific odoo users/ versions.

Thanks and Regards,

Divyansh

Denisse Pacheco

Auteur

I'll try it and tell you if it worked..

Denisse Pacheco

Auteur

Hi, I did what you suggested, though it took me a while, it worked!

After creating the new role, I changed the owner of my V.14 dbs, and put the new role on the .conf file. Then I noticed that role still did not have permissions, so privileges where granted. But it still could not access ir.module.module table, thus I ended adding SUPERUSER to my new role and it finally worked. Now I see all my db related to each version.

Thanks.

Paresh Wagh

Hi Denisse:

One option is to add the "-d database_name" argument to your command that starts up the odoo server.

Denisse Pacheco

Auteur

But that would only show me one db.. and when doing some testing, I change db to test on the others..

Paresh Wagh

Correct. Isn't that what you are looking for?

Denisse Pacheco

Auteur

I want to show all my db of specific version.. of I have 3 or 10 db of version 12, I don't want to type the name of them each time..

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
dbfilter based on ip address config dbfilter v15	0 dec. 22	2399
filter_partner not working Opgelost filter_domain	1 sep. 23	1326
how can change field domains like onchange return do? filter_domain	1 nov. 21	4511
How to transform search value when applying filter_domain? filter_domain	0 mei 21	2714
Odoo 14 / bitanmi - dbFilter <again> dbfilter	0 dec. 20	1674

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!