We are using v18CE and already have databases 'foo' and 'bar', domain names foo.com and bar.com, and would like the following:

1) odoo.foo.com connects to the Odoo backend using database 'foo' (login screen)

2) foo.com connects to a website in database 'foo' (homepage)

3) abc.foo.com connects to another website in database 'foo' (homepage)

4) xyz.com connects to the third website in 'foo' database (homepage)

5) odoo.bar.com connects to the Odoo backend using database 'bar' (login screen)

6) bar.com connects to a website in database 'bar' (homepage)

Q1: What should we put in /etc/odoo/odoo.conf for dbfilter?

Do we have to use 'foo.com', 'bar.com' as database names instead of 'foo' and 'bar'?

Or even 'odoo.foo.com' and 'odoo.bar.com', because %h is the whole hostname?

I didn't see any restrictions or warnings about db names needing to be hostnames during setup.
But the CLI documentation page says "%h is replaced by the whole hostname the request is made on", which would mean yes, database names have to be full hostnames if we want to use multiple domain names.

dbfilter = ^%h$ should work, but only if the database names are odoo.foo.com and odoo.bar.com?

And the websites are configured differently? I will need to read https://www.odoo.com/documentation/18.0/applications/websites/website/configuration/domain_names.html