KIBINDE OMBIONYO Franck Landry

I think that you need to check that you have the following:

1- At least 2 Odoo instances with dbfilter set in the config options file for the value of each database, like:

#for the config of the instance 1

dbfilter = ^database1$

#for the config of the instance 2

dbfilter = ^database2$

2- Make sure that you point the virtual host domains to the correspondent port of each instance

3- Make sure that Apache is set to deliver the proper headers to Odoo like host and others needed for Odoo to run successfully behind Apache as reverse proxy using:

ProxyPreserveHost On

Read more about it here:

https://www.digitalocean.com/community/tutorials/how-to-use-apache-http-server-as-reverse-proxy-using-mod_proxy-extension

or switch to any other reverse proxy that works better for you

Hi KIBINDE OMBIONYO Franck Landry,

You can create 2 odoo instance for 2 domains. Every instance, you can create other role in postgres.

ex:

In postgres, you create 2 role: db_firstodoodomain, db_secondodoodomain

in firstodoodomain.com.conf => db_user = db_firstodoodomain

in secondodoodomain.com.conf => db_user = db_secondodoodomain

When your enter www.firstodoodomain.com the selection of database in the manage select automatically (if you create 1 database for db_user = db_firstodoodomain)

You do not need different ports as long as you do not explicitely want to run separate instances of Odoo. Use dbfilter instead as it was already recommended to you in your other threads with the same question. Please refrain from asking the same question again and again and read the answers you have already received.