yelizariev

Certificate issue in DNS manual mode

Done according to https://github.com/Neilpang/acme.sh/wiki/dns-manual-mode

Warning: DNS manual mode can not renew automatically. For renewal you need to repeat steps below each time. Certificate needs to be renewed within 90 days.

• Install client

  git clone https://github.com/Neilpang/acme.sh.git

yelizariev

Allows to create TODOs for a small group of users.

Tasks can have on of the following states:

• TODO -- to be done
• DONE -- done
• CANCELED -- nothing was done and not going to be done
• WAITING -- cannot be started and waits for something

Technical specification

yelizariev

The general idea is to ask a group (let's call it target group) via bot and get answer. The group might be:

• Support Team
• IT Department of your company
• etc.

TODO: text formatting is lost on resending. Use entities instead of text field

TODO: set debug level via Environment variables

yelizariev

Docker - How to cleanup (unused) resources

Once in a while, you may need to cleanup resources (containers, volumes, images, networks) ...

delete volumes

// see: https://github.com/chadoe/docker-cleanup-volumes

docker volume rm $(docker volume ls -qf dangling=true)

docker volume ls -qf dangling=true | xargs -r docker volume rm

yelizariev

Postgres

http://pgtune.leopard.in.ua/

Odoo

Workers

yelizariev

--- connection count
SELECT sum(numbackends) FROM pg_stat_database;

---  long running queries
SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,
  query,
  state
FROM pg_stat_activity

yelizariev

People

😄 😆 😊 😃 ☺️ 😏 😍

yelizariev

# 8.0
docker run -d -e POSTGRES_USER=odoo -e POSTGRES_PASSWORD=odoo --name db-geo-8 camptocamp/postgres
docker run -d --name geo-8 -p 8069:8069 -p 8072:8072 -e ODOO_MASTER_PASS=master --link db-geo-8:db -v /root/odoo/odoo-8.0/geospatial/:/mnt/addons/extra/geospatial -t itprojectsllc/install-odoo:8.0 -- --db-filter=^%d$
docker exec -u odoo -i -t geo-8 /bin/bash -c "export UPDATE_ADDONS_PATH='yes'; bash /install-odoo-saas.sh"

# 10.0
docker run -d -e POSTGRES_USER=odoo -e POSTGRES_PASSWORD=odoo --name db-geo-10 camptocamp/postgres
docker run -d --name geo-10 -p 8069:8069 -p 8072:8072 -e ODOO_MASTER_PASS=master --link db-geo-10:db -v /root/odoo/odoo-10.0/geospatial/:/mnt/addons/extra/geospatial -t itprojectsllc/install-odoo:10.0 -- --db-filter=^%d$
docker exec -u odoo -i -t geo-10 /bin/bash -c "export UPDATE_ADDONS_PATH='yes'; bash /install-odoo-saas.sh"
git -C /root/odoo/odoo-10.0/geospatial/ pull upstream pull/146/head

yelizariev

# For understanding LXC see https://wiki.debian.org/LXC

# Based on:
# lxd + docker: https://stgraber.org/2016/04/13/lxd-2-0-docker-in-lxd-712/
# lxd network (static ip): https://stgraber.org/2016/10/27/network-management-with-lxd-2-3/
LXD_NETWORK="dev-network2"

# install lxd 2.3+
apt-get install software-properties-common

yelizariev

// Step 1. Ask support team to set some temporar password on apps.odoo.com database
// Step 2. Login to https://apps.odoo.com/web in a usual way (via oauth)
// Step 3. Open browser console and change password by using js code below

odoo.define('www', function(require) {
"use strict";
var ajax = require('web.ajax');
// will only work after the password has been set by Odoo
ajax.jsonpRpc('/web/session/change_password', 'call', {
    'fields' : [