Odoo 10

Odoo 10

Installation

Prerequisite

Pyhton

apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent

Jnodes

apt-get install npm
ln -s /usr/bin/nodejs /usr/bin/node
npm install -g less less-plugin-clean-css

User odoo

adduser --system --home=/opt/odoo-10 --group odoo

PostGres Database odoo User

su - postgres
cd
createuser -s odoo
exit

Gdata

cd /opt/odoo-10
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz
tar zxvf gdata-2.0.18.tar.gz
chown -R odoo: gdata-2.0.18
gdata-2.0.18/
python setup.py install

Download from Github

cd /opt/odoo-10
wget https://github.com/odoo/odoo/archive/10.0.zip
unzip 10.0.zip
chown -R odoo: odoo-10.0

Create log directory

mkdir /var/log/odoo
chown -R odoo:root /var/log/odoo

Config file

mkdir /etc/odoo-10
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf
chown -R odoo: /etc/odoo-10

[options]
; This is the password that allows database operations:
admin_passwd = passowrd
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus
csv_internal_sep = ,
data_dir = /opt/odoo-10/.local/share/Odoo
db_host = False
db_maxconn = 64
db_maxconn = 128
db_name = False
db_password = False
db_port = False
db_template = template1
db_user = False
;###dbfilter = .*
demo = {}
email_from = False
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat
import_partial =
limit_memory_hard = 2684354560
limit_memory_soft = 2147483648
limit_request = 8192
limit_time_cpu = 60
limit_time_real = 120
list_db = True
log_db = False
log_db_level = warning
log_handler = :INFO
;###log_level = info
log_level = error
logfile = /var/log/odoo/odoo-server.log
logrotate = False
longpolling_port = 8072
max_cron_threads = 2
osv_memory_age_limit = 1.0
osv_memory_count_limit = False
pg_path = None
pidfile = None
proxy_mode = False
reportgz = False
server_wide_modules = None
smtp_password = False
smtp_port = 25
smtp_server = smtp.local
smtp_ssl = False
smtp_user = odoo
syslog = False
test_commit = False
test_enable = False
test_file = False
test_report_directory = False
translate_modules = ['all']
unaccent = False
without_demo = False
workers = 0
xmlrpc = True
xmlrpc_interface =
xmlrpc_port = 8069

Inti Script

vi /etc/systemd/system/odoo-server.service

[Unit]
Description=Odoo server
After=syslog.target network.target

[Service]
Type=simple
User=odoo
Group=odoo
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo

# Give a reasonable amount of time for the server to start up/shut down
TimeoutSec=300

[Install]
WantedBy=multi-user.target

Additional Modules

OAC on Github

Other

Account Link

Account Master

select id, name from account_account where name in ('Product Sales', 'Expenses');

 id | name
-----+---------------
  19 | Product Sales
  23 | Expenses
(2 rows)

Property

select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';

 id | name | type | fields_id | value_reference | res_id
----+--------------------------------+----------+-----------+--------------------+--------
  4 | property_account_expense_categ | many2one | 1947 | account.account,23 |
  5 | property_account_income_categ | many2one | 1948 | account.account,19 |
(2 rows)

Model

select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);

  id | model | name | relation | field_description
------+------------------+--------------------------------+-----------------+-------------------
 1947 | product.category | property_account_expense_categ | account.account | Expense Account
 1948 | product.category | property_account_income_categ | account.account | Income Account
(2 rows)