In addition Specifically regarding to openerp you need to deploy openerp using mod_proxy. Check this blog post for more details http://tinyurl.com/pztrfvh

To remove the need for ?db=mydb, you will have to run your server in Single Database Mode by adding the argument `--db-filter=mydb` when starting the server.

You are also supposed to be able to set the database filter in the config file but it doesn't always work perfectly for single database mode. The parameter is `dbfilter = mydb`

To remove the port, you would need to run the server on port 80. You can specify the port by adding the arguement `--xmlrpc-port=80` when starting the server. You can also change the port from 8069 to port 80 in the config file. The parameter is `xmlrpc_port = 80`.

Another way to use port 80 if you are behind a router or firewall is to have your router/firewall forward port 80 to port 8069 of your server. This will only work for connections coming in from outside.

To do that, you need to make a reverse-proxy. It is not very difficult (or yes ;-) to do it with Apache, or another webserver that has that kind of feature.

For Apache you need to install mod_proxy and add a little bit of configuration. Your customers will continue see the original URL, but internally Apache will redirect that connection to the new URL, without changing the cutomer browser's URL. That is the best option.

Take a look at these sites to get more information:

http://httpd.apache.org/docs/2.2/mod/mod_proxy.html

Alternativelly, you can make a redirect that visibly will change the user browser's URL, but I don't recommend you that way because it is less clean and exposes your real configuration to the word, and you will need to open a new port, 8069, to accept public connections.

To do that, you need to install mod_rewrite and add a little bit of configuration:

http://httpd.apache.org/docs/2.2/mod/mod_rewrite.html