===== odoo 12 install from source Debian 10 =====
Two servers:
  * Debian 10 to front end
  * Debian 10 to database

==== Both servers ====
<code>
sudo apt update
sudo apt upgrade -y
sudo apt -y install python3-pip sudo
sudo useradd odoo
sudo mkdir /home/odoo
sudo chown odoo.odoo /home/odoo/
</code>

==== Database ====
<code>
sudo apt install -y postgresql postgresql-client
sudo -u postgres createuser --createdb --username postgres --no-createrole --no-superuser odoo
sudo -u postgres psql -c '\x' -c 'ALTER USER odoo WITH SUPERUSER'
sudo -u postgres psql -c '\x' -c "ALTER USER odoo WITH PASSWORD 'odoo';"
sudo sed -i '/^host    all             all             127.0.0.1\/32            md5/a host    all             all             192.168.122.0\/24        md5' /etc/postgresql/11/main/pg_hba.conf
sudo sed -i "s/= 'localhost/= 'localhost,192.168.122.14/g" /etc/postgresql/11/main/postgresql.conf
sudo sed -i 's/#listen_addresses/listen_addresses/g' /etc/postgresql/11/main/postgresql.conf
sudo systemctl restart postgresql
</code>

==== Front-end ====
<code>
wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.5/wkhtmltox_0.12.5-1.buster_amd64.deb
sudo dpkg -i wkhtmltox_0.12.5-1.buster_amd64.deb
sudo apt-get -f install -y
sudo apt -y install python3-dev libxml2-dev libxslt1-dev libldap2-dev libsasl2-dev git python3-dev libpq-dev
sudo git clone --depth 1 --branch 12.0 https://www.github.com/odoo/odoo.git /opt/odoo
sudo chown -R odoo.odoo /opt/odoo/
cd /opt/odoo
sudo -u odoo pip3 install setuptools wheel
sudo -u odoo pip3 install -r requirements.txt
sudo mkdir /var/log/odoo
sudo chown odoo:root /var/log/odoo
cat <<'EOF' >> /etc/odoo.conf
[options]
db_host = 192.168.122.14
db_port = 5432
db_user = odoo
db_password = odoo
addons_path = /opt/odoo/addons
logfile = /var/log/odoo/odoo.log
EOF
chown odoo.odoo /etc/odoo.conf
</code>

Start odoo:
<code>
sudo -u odoo /usr/bin/python3 /opt/odoo/odoo-bin -c /etc/odoo.conf
</code>

==== Systemd ====
Create file /etc/systemd/system/odoo.service:
<code>
[Unit]
Description=odoo
After=network.target

[Service]
User=odoo
Group=odoo
ExecStart=/usr/bin/python3 /opt/odoo/odoo-bin -c /etc/odoo.conf
Restart=always

[Install]
WantedBy=multi-user.target
</code>

Install it:
<code>
systemctl daemon-reload
systemctl start odoo
systemctl enable odoo
</code>

==== FE ====
<code>
sudo -u odoo pip3 install xmlsig
sudo -u odoo pip3 install pyOpenSSL
sudo -u odoo pip3 install jsonschema
sudo -u odoo pip3 install phonenumbers
sudo -u odoo pip3 install xlsxwriter
sudo -u odoo pip3 install xlrd
sudo -u odoo pip3 install xlwt
</code>

==== Same as above but with one server ====
<code>
sudo apt update
sudo apt upgrade -y
sudo apt -y install python3-pip sudo
sudo useradd odoo
sudo mkdir /home/odoo
sudo chown odoo.odoo /home/odoo/
cat <<'EOF' >> /etc/odoo.conf
[options]
addons_path = /opt/odoo/addons
logfile = /var/log/odoo/odoo.log
EOF
chown odoo.odoo /etc/odoo.conf
sudo apt install -y postgresql postgresql-client
wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.5/wkhtmltox_0.12.5-1.buster_amd64.deb
sudo dpkg -i wkhtmltox_0.12.5-1.buster_amd64.deb
sudo apt -f install -y
sudo apt -y install python3-dev libxml2-dev libxslt1-dev libldap2-dev libsasl2-dev git python3-dev libpq-dev
sudo git clone --depth 1 --branch 12.0 https://www.github.com/odoo/odoo.git /opt/odoo
sudo chown -R odoo.odoo /opt/odoo/
cd /opt/odoo
sudo -u odoo pip3 install setuptools wheel
sudo -u odoo pip3 install -r requirements.txt
sudo mkdir /var/log/odoo
sudo chown odoo:root /var/log/odoo
sudo -u odoo pip3 install xmlsig
sudo -u odoo pip3 install pyOpenSSL
sudo -u odoo pip3 install jsonschema
sudo -u odoo pip3 install phonenumbers
sudo -u odoo pip3 install xlsxwriter
sudo -u odoo pip3 install xlrd
sudo -u odoo pip3 install xlwt
sudo -u odoo pip3 install zeep
sudo -u postgres createuser --createdb --username postgres --no-createrole --no-superuser odoo
sudo -u postgres psql -c '\x' -c 'ALTER USER odoo WITH SUPERUSER'
sudo -u postgres psql -c '\x' -c "ALTER USER odoo WITH PASSWORD 'odoo';"
cat <<'EOF' >> /etc/systemd/system/odoo.service
[Unit]
Description=odoo
After=network.target

[Service]
User=odoo
Group=odoo
ExecStart=/usr/bin/python3 /opt/odoo/odoo-bin -c /etc/odoo.conf
Restart=always

[Install]
WantedBy=multi-user.target
EOF
systemctl daemon-reload
systemctl start odoo
systemctl enable odoo
</code>

==== Resources ====
  * https://www.odoo.com/documentation/13.0/setup/install.html#id7
  * https://www.howtoforge.com/tutorial/install-odoo-erp-software-on-ubuntu-15-04/
  * https://www.odoo.yenthevg.com/installing-odoo-different-servers/
  * https://www.cybrosys.com/blog/install-odoo-13-on-ubuntu-18-04