Monday, 8 May 2017

Write web services using Odoo controllers

In Odoo you can write web-services for outside world. Let's discuss how it can be done using controllers.

Suppose I need cross domain API which will return data in json format. For that we have to enable CORS and have to setup nginx reverse proxy.

Example: API to send teachers data from odoo:

# -*- coding: utf-8 -*-
from odoo.tools.translate import _
from odoo import http
from odoo.http import request
import json
import sys

class odoo_public_data(http.Controller):
    @http.route('/get/teachers', type='http', methods=['GET'], auth="public")

    def get_teachers(self, **kwargs):
        teacher_model = request.env['dps.teacher']
        teacher_ids = teacher_model.sudo().search([])
        teacher_list = {'status': 1, 'data': []}
        try:
            if teacher_ids:
                for teacher in teacher_ids:
                    vals = {
                        'id': teacher.id,
                        'name': teacher.name,
                        'email': teacher.email,
                        'phone': teacher.phone,
                        'school': teacher.partner_id.name,
                    }
                    teacher_list['data'].append(vals)
            return json.dumps(teacher_list)
        except Exception as e:
            print str(e)
            return json.dumps({'status': 0, 'data': 'Some problem with API'})


Please set reverse proxy using tutorial if it's not already set. After that add lines from link(https://enable-cors.org/server_nginx.html) in location block, to enable CORS, of virtual host config file.

Thanks!!!!! Enjoy Programming!!! :)

Nginx reverse proxy on odoo

Let's discuss how to set nginx reverse proxy in odoo

Why we need revese proxy?

Odoo runs on 8069 port by default and if you want to route it through other port, say 80 we can use nginx reverse proxy for that. It will also help to handle web services, if any, your odoo instance is providing to outside world.

What to do?

1. Install nginx

2. Create virtual host for your website/odoo instance. Let's say you want to run it on myodoo.com. Please create config file at location:


/etc/nginx/sites-available/myodoo.domain.com

CREATE symbolic link for this at

/etc/nginx/sites-enabled/myodoo.domain.com

Following is the code for ssl enabled config file

upstream myodoo {
    server 127.0.0.1:8069;
}
server {
        listen 443 default;
        server_name myodoo.domain.com;
        access_log /var/log/nginx/oddo.access.log;
        error_log /var/log/nginx/oddo.error.log;
        if ($scheme = http) {
                return 301 https://myodoo.domain.com$request_uri;
        }
        # SSL cerificate details
        ssl on;
        ssl_certificate /etc/letsencrypt/live/myodoo.domain.com/fullchain.pem;
        ssl_certificate_key /etc/letsencrypt/live/myodoo.domain.com/privkey.pem; keepalive_timeout 60;
        ssl_ciphers EECDH+AES128:RSA+AES128:EECDH+AES256:RSA+AES256:EECDH+3DES:RSA+3DES:!MD5;
        ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
        ssl_prefer_server_ciphers on;
        proxy_buffers 16 64k;
        proxy_buffer_size 128k;
        location / {
                proxy_next_upstream error timeout invalid_header http_500 http_502  http_503 http_504;
                proxy_redirect off;
                proxy_set_header Host $host;
                proxy_set_header X-Real-IP $remote_addr;
                proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
                proxy_set_header X-Forwarded-Proto https;
                proxy_pass http://myodoo;
        }
        location ~* /web/static/ {
                proxy_cache_valid 200 60m;
                proxy_buffering on;
                expires 864000;
                proxy_pass http://myodoo;
        }
}

## http redirects to https ##
server {
    listen      80;
    server_name myodoo.domain.com;
    # Strict Transport Security
    add_header Strict-Transport-Security max-age=2592000;
    rewrite ^/.*$ https://$host$request_uri? permanent;
}


After this reload/restart your nginx (
sudo /etc/init.d/nginx reload) and your odoo instance will run on https://myodoo.domain.com and http will be rediected to https

I hope it will work for you as well. Please let me know if you are facing any issue.

Thanks!!!! Enjoy Programming!! :)

Wednesday, 12 April 2017

Postgres/Django: could not load library postgis-2.1.so

If you are getting error like this after postgresql update:

ERROR:  could not load library "/usr/local/Cellar/postgresql/9.5.6/lib/postgis-2.2.so": dlopen(/usr/local/Cellar/postgresql/9.5.6/lib/postgis-2.2.so, 10): Library not loaded: /usr/local/lib/libCGAL.10.dylib
  Referenced from: /usr/local/lib/libSFCGAL.1.dylib
  Reason: image not found 

or of library libspatialite

Run following command

brew reinstall sfcgal --build-from-source   

brew reinstall libspatialite --build-from-source

I hope it will fix your issue.

Thanks!!!! Enjoy Programming!!! :)

Monday, 3 April 2017

Enable pep8 autoformat in Sublime Text

Steps to install pep8 autoformat package in Sublime Editor

1. Download Mercurial from https://www.mercurial-scm.org/ and install it.

2. Go To Sublime Text -> Preferences -> Browse Packages -> Note down the location.

3. Open terminal and go to Sublime Packages location.

4. Get clone - hg clone https://bitbucket.org/StephaneBunel/pythonpep8autoformat 'Python PEP8 Autoformat'

5. Restart Sublime Text3

6. If pep8 max line length 80 not working - Go To Sublime Text -> Preferences -> Settings -> User - Add rules

"rulers": [80]


Thanks!!!! Enjoy Programming!!! :)

Sunday, 22 January 2017

Odoo: Change currency for Web Shop

If you are facing issue with currency changes for web shop following steps mentioned in post:

http://blog.instant-erp.com/2016/01/odoo-v90-changing-currency-for-e.html

It worked for me. Hopefully will work for you as well.

Thanks!!!! Enjoy Programming :)

Ubuntu: Red warning triangle in top bar

If you are getting Red warning triangle in top bar, run following command:

sudo dpkg --configure -a

and restart your system.

Thanks!!! Enjoy Programming!!! :)

Wednesday, 16 November 2016

Safari SVG Sprite Issue

Few days back, my team faced an issue with svg sprites not working in Safari browser. Tried number of options to make it work but in vain. Finally from some post(don't remember page url) we found this solution and it worked like a charm!! :)


<svg>
    <use xlink:href="/media/icons/sprite.svg#sprite_id"></use>
</svg>

Thanks!!! Enjoy Programming :)

Write web services using Odoo controllers

In Odoo you can write web-services for outside world. Let's discuss how it can be done using controllers. Suppose I need cross domain...