odoo

pip install pyodbc failing: error: command ‘x86_64-linux-gnu-gcc’ failed with exit status 1


ODBC header files need to be installed.
1. sudo apt-get install unixodbc-dev
2. sudo pip install pyodbc

Advertisements

How to run automated actions at a specific time everyday


<record id="ir_cron_module_get_active_sr" model="ir.cron">
        <field name="name">Get Active Srs</field>
        <field eval="True" name="get_active_srs" />
        <!--<field name="user_id" ref="base.user_root" />-->
        <field name="interval_number">1</field>
        <field name="nextcall" eval="(DateTime.now() + timedelta(days=1)).strftime('%Y-%m-%d 12:00:00')" />        
        <!--<field name="nextcall" eval="(DateTime.now().date() + timedelta(days=1)).strftime('%Y-%m-%d 21:00:00')"/>-->
        <field name="interval_type">days</field>
        <field name="numbercall">-1</field>
        <field eval="False" name="doall" />
        <field eval="'hr.attendance'" name="model" />
        <field eval="'get_active_srs'" name="function" />
        <field eval="'(None,)'" name="args" />
        <field name="priority">1000</field>
</record>

OSError: [Errno 98] Address already in use



odoo@odoo-11:~/odoo$ ps -fA | grep python

root 1680 1 1 09:16 ? 00:00:01 /usr/bin/python3 /usr/sbin/aptd
odoo 2369 2350 0 09:19 pts/10 00:00:00 grep python
odoo 5760 1 0 يون10 ? 00:01:07 python3 ./odoo-bin -d hr

odoo@odoo-11:~/odoo$ sudo kill 1680
odoo@odoo-11:~/odoo$ sudo kill 2369
odoo@odoo-11:~/odoo$ sudo kill 5760

Dump Postgresql


OPTION 1
Dump DB
$ sudo pg_dump --no-owner db_name > /opt/db_name.sql or .dump

Restore DB
$ sudo su postgres
$ psql
$ create database db_name;
$ psql db_name > db_name.sql
OPTION 2
Dump DB
$ sudo pg_dump --no-owner db_name | gzip > /opt/db_name.sql.gz

Restore DB
createdb  db_name -T template1 -U odoo -h localhost
zless db_name.sql.gz | psql db_name

VirtualBox can’t find host-only adapters on Windows 10


I get the same results when using the command lines tools. The creation of new interfaces works without problems:

C:\> VBoxManage.exe hostonlyif create
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Interface 'VirtualBox Host-Only Ethernet Adapter #5' was successfully created

But VirtualBox can’t find the adapters, as the following command does not return any output:

$ VBoxManage.exe list hostonlyifs