Friday, 24 November 2017

RHEL wsgi nginx error: permission denied while connecting to upstream




I had the same issue. What I found is that "SELinux" was blocking nginx from using the socket. If SELinux is enabled you can check the status (which should look similar to below):

[root@localhost ~]# sestatus
SELinux status: enabled
SELinuxfs mount: /selinux
Current mode: enforcing
Mode from config file: enforcing
Policy version: 21
Policy from config file: targeted



You can add an NGINX SELinux policy or just disable SELinux to get around the issue. 

  • Check the status of SELinux using 
    #sestatus
  • If it says enabled, vi into /etc/sysconfig/selinux. This is a symlink to /etc/selinux/config so modify this file in case you don't find the above file. 
    Terminal command: sudo vi /etc/sysconfig/selinux

    The file is highly self-explanatory. Just change the value of         SELINUX to "disabled" -- without quotes.

Saturday, 16 September 2017

Odoo 10: Link external url to menu


Hi, following code can be used to link menu to external url:

<record id="external_link" model="ir.actions.act_url">
        <field name="name">Odoobiz</field>
        <field name="type">ir.actions.act_url</field>
        <field name="target">new</field>
        <field name="url">http://blog.odoobiz.com</field>
</record>

<menuitem action="external_link" name="Odoobiz" id="menu_odoobiz_link" parent="website_blog.menu_website_blog_root"/>

This code will create Odoobiz menu under Blog menu and link it to http://blog.odoobiz.com. This will open link in new tab. If you want to open it in same tab itself. Please use -

<field name="target">self</field>

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


Friday, 15 September 2017

PostgreSQL: Scheduler to take db backup every two hours



Hi, Today we are going to write a scheduler to take PostgreSQL db dump every two hours in ubuntu OS.

1. Create a folder called backup in your home directory where we are going to store all the dump files.

2. Because it's cron script so can provide password at runtime, we are going to store required details in ~/.pgpass file in following format

hostname:port:database:username:password


localhost:5432:mydb:user1:test123

don't forget to change it's permission to 0600 (chmod 0600 ~/.pgpass)

Note: You can change localhost with Server IP if you have

3. Create a file to write script for db backup. Let's create it in home directory itself and call it db_backup.sh

Add following command to the file.

pg_dump -d mydb -h localhost -p 5432 -U user1 -w  | gzip > /home/ubuntu/backup/$(date +%Y-%m-%d-%H:%m:%s).psql.gz

It will save the dump file with date and time as name. e.g 2017-09-16-07:09:1505546517.psql.gz

Don't forget to make db_backup.sh file executable (chmod +x db_backup.sh)

4. Now it's the time to set scheduler:



crontab -e

It will open scheduler file. Add following line at the end of file

1 */2 * * * /home/ubuntu/db_backup.sh

To know how these parameters work please visit https://crontab.guru/every-2-hours

That's it.

Now backup will be taken every two hours and backup file will be stored in ~/backup folder.


Thanks!!!! Enjoy Programming!! :)


Wednesday, 6 September 2017

Odoo10: Automatically Update Currency Exchange Rates



Hi, we have developed a module to automatically update currency exchange rates with respect to your company's base currency. This module can be used with any of the following API:

OANDA EXCHANGE RATE API

CURRENCYLAYER EXCHANGE RATE API 

FOREX CURRENCY CONVERSION API

You can buy this module directly from us or from apps.odoo.com using following url:

https://www.odoo.com/apps/modules/10.0/odoobiz_exchange_rates/


Thanks!!!! Enjoy Programming!! :)

Odoo10: Invoice Report with Bank Details



Hi, we have developed a module which will help companies to add bank details on invoice. You can download the same from apps.odoo.com

https://www.odoo.com/apps/modules/10.0/odoobiz_invoice_report/


Thanks!!!! Enjoy Programming :)

Odoo 10 Backend Themes



Hi, we have developed some free backend themes to help community and individual people who don't like default theme from odoo

You can download these themes from following links and make changes as per your personal and business needs:

https://www.odoo.com/apps/themes/browse?search=odoobiz

https://www.odoo.com/apps/themes/10.0/estate_backend_theme/

https://www.odoo.com/apps/themes/10.0/sarahah_backend_theme/

https://www.odoo.com/apps/themes/10.0/poil_backend_theme/

Thanks!!! Enjoy Programming :)

Tuesday, 18 July 2017

Gmail: Download blocked file




                                         

Hi, today we are going to learn, how to download blocked file in gmail.

Sometimes you see following message in gmail:


and you can't download attached file

Follow steps to download file:

1. Open original message as shown in image

2. Download Original


let's name it download_original.txt

3.  Save following python script in same directory. Let's name it import_file.py

import email
import sys

if __name__=='__main__':
    if len(sys.argv)<2:
        print "Please enter a file to extract attachments from"
        sys.exit(1)

    msg = email.message_from_file(open(sys.argv[1]))
    for pl in msg.get_payload():
        if pl.get_filename(): # if it is an attachment
            open(pl.get_filename(), 'wb').write(pl.get_payload(decode=True))

4. Go to Python console

If you are using MAC book or Linux OS - open terminal and type python

type

python   import_file.py    download_original.txt

It will download your blocked file in same directory.

That's it.

Thanks!!! Enjoy Programming :)


References:

https://spapas.github.io/2014/10/23/retrieve-gmail-blocked-attachments/

Friday, 14 July 2017

Blogger: Set subdomain for blog using Cloudflare



If you want to point you blog hosted at blogspot.com to subdomain like http://blog.xxxx.com using Cloudflare, following are the steps:

1. Go to Basic Settings of your blog

2. Click on Third-party domain settings under Publishing


3. It will ask you to add two CNAME entries under your DNS settings. You can add as follow in Cloudflare


4. Set domain in your blog settings as http://blog.xxx.com. Save.

That's it. Sometimes it reflects immediately, sometimes it takes 24 to 48 hours as well.

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

Wednesday, 14 June 2017

Odoo 10: Close wizard and open standard form



Hi, Today we are going to learn how to open standard form after saving data in wizard.

Let's say I have created an wizard to fill basic User details and once saved open default User form. Here is the xml code for my wizrd:

<record id="view_custom_user_wizard" model="ir.ui.view">
        <field name="name">Create User</field>
        <field name="model">res.users</field>
        <field name="arch" type="xml">
            <form string="Create User">
                <group>
            <field name="company_id" />
            <field name="name" required="1"/>
            <field name="login" required="1"/>
            <field name="password" required="1" password="True" />
            <footer>
                        <button name="create_user" string="Create User" type="object" class="btn-primary"/>
                    </footer>
        </group>
            </form>
       </field>
</record>

And here is the python code for "create_user" function:

@api.multi
def create_user(self):
    # We need to get view_id where we are going the user to redirect
    self._cr.execute("select res_id from ir_model_data where name = 'view_users_form'")
    result = self._cr.fetchone()
    form_obj_id = result[0]
    return {
        'name': _('User'),
        'view_type': 'form',
        'view_mode': 'form',
        'view_id': form_obj_id,
        'res_model': 'res.users',
        'domain': [],
        'context': dict(self._context, active_ids=self.ids),
        'type': 'ir.actions.act_window',
        'target': 'current',
        'res_id': self.id, #represents user id

    }
    

That's it!!!

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

Tuesday, 6 June 2017

Odoo: Download Binary File in v10



To download any binary file in Odoo10 following is the link:

http://127.0.0.1:8069/web/content?model=<module_name>&field=<field_name>&filename_field=<field_filename>&id=<object_id>


module_name   - the name of the model with the Binary field
field_name        - the name of the Binary field
object_id           - id of the record containing particular file.
field_filename   - name of a Char field containing file's name (optional).


So if you want to call a function on button click and download the file, code is as follow:

file_url = "http://127.0.0.1:8069/web/content?model=<module_name>&field=<field_name>&filename_field=<field_filename>&id=<object_id>"
return {
    'type': 'ir.actions.act_url',
    'url': file_url,
    'target': 'new'
}

In Reports or web page, you can use it as:


<t t-foreach="files" t-as="f">
    <tr>
        <td><t t-esc="f.name"/></td>
        <td><a t-attf-href="/web/content?model=<module_name>&field=<field_name>&filename_field=<field_filename>&id=<object_id>">Download</a></td>
    </tr>
</t>

Where files is a list of files

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

Emails not working in PHP/Ubuntu



Hi, lot of solutions are there to fix this problem but I feel somewhere, sometimes we miss the basic part...

It may be possibility that we don't have sendemail utility itself not installed. Please install by running following command.

sudo apt-get install sendmail -y

If issue is still there please check following link:

https://www.digitalocean.com/community/questions/do-i-need-to-configure-anything-to-use-php-mail-function-on-fresh-lamp-install

Thanks!!!! Enjoy Programming :)

Thursday, 1 June 2017

Odoo: Set/use context in email templates



Today we are going to discuss, how to use/change the context in dynamic/custom templates.

Let's say we want to send some values to an email template other than normal object id, here is the code for that

In controllers/main.py

local_context = request.env.context.copy()

In module.py file

local_context = self.env.context.copy()
local_context.update({
    'name': 'Shiv',
    'place': 'Bangalore'
})

template = request.env.ref('module_name.email_template_id')
            template.with_context(local_context).send_mail(object.id, force_send=True, raise_exception=True)

In email template code you can access context as:

<p>${ctx['name']}</p>
<p>${ctx['place']}</p>

That's it.

To know how to create a custom email template, please check here: http://www.odoo.yenthevg.com/creating-mail-templates/


Thanks!!! Enjoy Programming!!! :)

Monday, 29 May 2017

Odoo: Upload binary images from backend using API




If you want to upload a binary image to Odoo using API..here are the steps:

controllers/main.py

# -*- coding: utf-8 -*-
from odoo.tools.translate import _
from odoo import http
from odoo.http import request
from odoo.addons import web
from time import strftime
import functools
import datetime
import json
import base64
import sys
import copy
from dateutil import parser
import logging
from operator import itemgetter
logger = logging.getLogger(__name__)


def serialize_exception(f):
    @functools.wraps(f)
    def wrap(*args, **kwargs):
        try:
            return f(*args, **kwargs)
        except Exception, e:
            logger.debug("An exception occured during an http request")
            #se = _serialize_exception(e)
            error = {
                'code': 200,
                'message': "Odoo Server Error",
                'data': str(e)
            }
            return json.dumps(error)
    return wrap


class Binary(web.controllers.main.Binary):
    @http.route('/api/upload_images', type='http', auth="public", csrf=False)
    @serialize_exception
    def upload_attachment(self, uid, ufile, ufile_name):
        user_model = request.env['res.users']
        user_ids = user_model.sudo().browse([('id', '=', uid)])
        if user_ids:
            user_obj = user_ids[0]
            try:
                user_obj.write({
                    'uploaded_files': base64.encodestring(ufile.read()),
                    'uploaded_files_filename': ufile_name,
                })
            except Exception:
                args = {'status': 0, 'error': "Something horrible happened."}
                return json.dumps(args)
            return json.dumps({'status': 1, 'message': 'File uploaded successfully'})
        else:
            return json.dumps({'status': 0, 'message': 'User does not exist.'})



Where fields are:

uploaded_files = fields.Binary(string=_('Files'), attachment=True, store=True)
uploaded_files_filename = fields.Char("Filename")

and JS code is:

<script>
    // grab your file object from a file input
    // Where fileInput is
    // <input id="fileInput" type="file" />
    $('#fileInput').change(function () {
        sendFile(this.files[0]);
    });

    function sendFile(file) {
        var querydata = new FormData();
        querydata.append('ufile',file);
        querydata.append('ufile_name',file.name);
        querydata.append('uid', 10);
        //querydata.append('multi', 'true');
        $.ajax({
            url: "http://xxxxx:8069/api/upload_images",
            data: querydata,
            type: "POST",
            cache: false,
            processData: false, 
            contentType: false,
            dataType: "json",
            beforeSend: function (xhr) {

            },
            success: function (result) {
                console.log(result);
                console.log(result.status);   
            },
            error: function (err) {
                console.log(err);
            }
        });
    }
</script>


References:

https://www.odoo.com/forum/help-1/question/openerp-multiple-file-upload-54736 
https://code.tutsplus.com/tutorials/base64-encoding-and-decoding-using-python--cms-25588
https://www.odoo.com/forum/help-1/question/change-filename-on-field-binary-52235

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

Monday, 8 May 2017

Write web services using Odoo controllers




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

Suppose I need a cross-domain API that 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 the link(https://enable-cors.org/server_nginx.html) in the location block, to enable CORS, of a 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 an 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 any issue with currency changes for a webshop following steps mentioned in the 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!!! :)