Odoo [Errno 98] Address already in use

Sometimes you may encounter an error in development or production [Errno 98] Address already in use.
This error is due to openerp-service or some other service already use port defined in your Odoo config.
You could try to change the port 8069 to any other port  and restart the server but that’s not the right way.

Just apply the command

sudo ps aux | grep openerp

which will show you the port on which openerp server is in running state.
Then kill the specific process.

sudo kill -9 id

For example sudo kill -9 999

Restart odoo server and that’s it.

 

Disable sudo timeout on Ubuntu in terminal

By default sudo remembers your password for 15 minutes.

Disable sudo timeout with this command:

sudo sh -c 'echo "\nDefaults timestamp_timeout=-1">>/etc/sudoers'

To re-enable sudo timeout use this command:

sudo sed -i "/Defaults timestamp_timeout=-1/d" /etc/sudoers

You can also change or disable sudo timeout with visudo.

sudo visudo

This opens an editor and points it to the sudoers file — Ubuntu defaults to nano, other systems use Vi.

To the defaults line, add :

timestamp_timeout=2

So it will look like this:

Defaults env_reset,timestamp_timeout=20

You might want to read the sudoers manual pages for additional information.

man sudoers

 

Remove LibreOffice on Ubuntu in terminal

To remove LibreOffice on Ubuntu in terminal:

sudo apt-get remove libreoffice-core

If you also want to remove LibreOffice configuration files, use the purge switch:

sudo apt-get remove --purge libreoffice-core

That’s all folks!

 

Sed replace path with slash separators

Sed replace path with slash separators by using a different separator char.

If you have an environment variable that contains a slash like a path, let say

addons_path = /home/netjunky/projects/odoo-dev/odoo/openerp/addons

and you want to replace “addons_path = /home/netjunky/projects/odoo-dev/odoo/openerp/addons” with “addons_path = /home/netjunky/projects/odoo-dev/odoo/custom/addons” using sed, usually you would try something like this

sudo sed -i  ‘s/addons_path = */addons_path = /home/netjunky/projects/odoo-dev/odoo/custom/addons/’ /home/netjunky/projects/odoo-dev/odoo/config/openerp-server.conf

this raise an error like

sed: -i expression #1, char 9: unknown option to `s’

but if you try

sudo sed -i  ‘s|addons_path = *|addons_path = /home/netjunky/projects/odoo-dev/odoo/custom/addons,|’ /home/netjunky/projects/odoo-dev/odoo/config/openerp-server.conf

It works!!!

You can use any other separator instead of |.

 

Odoo thousands separator

How to define Odoo thousands separator?

Accountants are used to the thousands separator e.g. 100000.00 EUR is represented as 100,000.00.
The setup of the thousands separator is located under:
Settings > Translations > Languages.

Odoo thousands separator

For each language, you can set a different separator format.

3 options modify the format of a number:

Separator format: number of digits between separators
Decimal Separator: character displayed before the decimals
Thousands Separator: the character displayed at each separation

The correct form for a separator between each 3 digits whatever the number of digits is: [3,0]

You have to logout and login again to see the change.

Odoo is a modern Software For Smart Businesses.
Boost your sales, step up productivity and manage all day-to-day activities. Fully integrated, simple and mobile.
More about odoo

That’s all folks!