Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Website and OpenERP on a VPS Server with subdomain, How to ?

By
ThackerS (ts)
on 8/31/14, 8:58 PM 2,687 views

Good evening everyone.
For 5 days, I'm stuck on a problem I have to solve for one of my clients. Here's the problem.
My client has a VPS server. The server has an IP address (eg 192.168.1.1) and is connected to a domain name (eg http://www.bigme.com).

The customer wants his website and openerp is available on the same VPS.

Website coded in php would be available at http://www.bigme.com and openerp would be available at http://demo.bigme.com where demo is openerp database. Here's an example of what I have realized :

website: http://www.dailyerp.net/
openerp: http://lonlon.dailyerp.net/
lonlon is the database of openerp.
(eg: If I select the database "tutu", so I will get : http://tutu.bigme.com)

Actually, I know that the problem can be solved with a configuration at the web server. Which web server should i use apache2 or nginx for better performance ? How i can do it ? How I should proceed?
Any help would be welcome.

NB: I use openerp version 7

0

Ben Bernard

--Ben Bernard--
1083
| 4 3 6
Jakarta, Indonesia
--Ben Bernard--
Ben Bernard
On 9/1/14, 3:20 AM

Which web server should i use apache2 or nginx for better performance ?

I have learnt that performance is not a real issue in an early project. In your case I will choose nginx because its simplicity. For me, nginx configuration is easier to read than apache configuration.

My solution is something like this.

  • dabase name convention : should be in lowercase
  • default server is www.localhost.local (php web server). It should be replaced with real domain.
  • openerp server is openerp.localhost.local
  • any access to subdomain other than 'openerp' will be redirected to openerp.localhost.local

The http context is something like the following.

http {
    include       mime.types;
    default_type  application/octet-stream;

    #log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
    #                  '$status $body_bytes_sent "$http_referer" '
    #                  '"$http_user_agent" "$http_x_forwarded_for"';

    #access_log  logs/access.log  main;

    sendfile        on;
    #tcp_nopush     on;

    #keepalive_timeout  0;
    keepalive_timeout  65;

    #gzip  on;

    server_names_hash_bucket_size 64;
    
    upstream openerp {
        server 127.0.0.1:8869;
    }
        
    server {
        listen       80;
        server_name  www.localhost.local;

        #charset koi8-r;

        #access_log  logs/host.access.log  main;

        location / {
            # it could be php app
            try_files $uri $uri/ /index.html;
        }
         
        #error_page  404              /404.html;

        # redirect server error pages to the static page /50x.html
        #
        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
            root   html;
        }
    }

    server {
        listen       80;
        server_name ~^(?<subdomain>.*)\.localhost\.local$;
        
        if ($subdomain != 'openerp') {
            rewrite ^ http://openerp.localhost.local/?db=$subdomain last;
        }
    }
    
    server {
        listen       80;
        server_name  openerp.localhost.local;

        #charset koi8-r;

        #access_log  logs/host.access.log  main;

        location / {
            try_files $uri @python_openerp;
        }

        location @python_openerp {
            proxy_set_header  X-Forwarded-For $proxy_add_x_forwarded_for;
            proxy_set_header  X-Forwarded-Proto $scheme;
            proxy_set_header Host $host;
            proxy_redirect off;
            proxy_read_timeout 300;
            proxy_pass http://openerp;
        }       
        #error_page  404              /404.html;

        # redirect server error pages to the static page /50x.html
        #
        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
            root   html;
        }
    }
}

And don't forget to edit the hosts file.

Hi dear Ben. Thank you for your reply. i have many question : 1) upstream openerp { server 127.0.0.1:8869; } In my case, if my VPS IP is 192.168.12.1, i will have : upstream openerp { server 192.168.12.1:8069; } where 8069 is the port of openerp ?? 2) server { listen 80; server_name www.localhost.local; .... } In my case, if my domain is www.bigme.com, i will have servername www.bigme.com ?? 3) server { listen 80; server_name openerp.localhost.local; ... } In my case, if my domain is www.bigme.com, i will have openerp.bigme.com ?? 4) With the nginx code above, i will get subdomain dynamically ( something like db1.bigme.com if i select the database db1 of openerp) ?? 5) Finally, you talk about the hosts file of my VPS ? If yes why should i edit it ? thankk you.

ThackerS (ts)
on 9/1/14, 3:53 AM

1) yes. 2) yes. 3) yes. 4) No, this configuration is for reverse behavior, ie. you type db1.bigme.com and it will be redirected to openerp.bigme.com/?db=db1. 5) To resove your subdomain name in test mode. In production, maybe you should edit your dns record.

Ben Bernard
on 9/1/14, 4:22 AM

As a second though, depends on reverse proxy configuration is limited to number of odoo services and odoo default url scheme. There is another solution where you can make one odoo instance per subdomain (and hide the ?db=mydb url option). Other solution is to hack odoo code and make the db filtered by subdomain. My point is to make no redundant data about which db is being chosen, either from subdomain or url.

Ben Bernard
on 9/1/14, 8:16 AM

Hi Ben. I see you master the subject. Please, could you give me some links that will help me, because I have not understood.

ThackerS (ts)
on 9/1/14, 9:30 AM

Please sees the 2 links (http://www.dailyerp.net/ and http://lonlon.dailyerp.net/) ==> it's exactly what i want to do. And my openerp instance can be run with the url : db.mydomain.com with db= my openerp database.

ThackerS (ts)
on 9/1/14, 9:34 AM

Maybe you interested with this question https://www.odoo.com/forum/help-1/question/separate-databases-on-different-ports-61813

Ben Bernard
on 9/3/14, 11:13 AM

it's not my real thinking

ThackerS (ts)
on 9/3/14, 12:18 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

4 follower(s)

Stats

Asked: 8/31/14, 8:58 PM
Seen: 2687 times
Last updated: 3/16/15, 8:10 AM