Create Docker Image
-------------------

Creating a docker image consist of several steps:

    - collect all apt modules we need next to the one odoo is providing
    - collect all pip libraries we need next to the one odoo is providing
        This information we find in the site description files in a ::
        
            'extra_libs': {
                'pip' : [
                    'xmlsec',
                    'scrapy',
                    'html2text',
                ],
                'apt' : [
                    'python-dev',
                    'pkg-config',
                    'libxml2-dev',
                    'libxslt1-dev',
                    'libxmlsec1-dev',
                    'libffi-dev',
                ]
            },

        section
    - we neet to be able to log into docker hub to be able to push the image
    - downloading the actuall odoo source
    - creating a number of folders that will be copied into the image

This process is done semiautomatically by running the following command::

    wwb
    bin/d -dbi SITENAME -dbiC # where SITENAME could be afbstest


Create DB Image
---------------
before changing anything with an existing container, please check wher its data is by running::

    docker inspect db


docker_db_template::

    docker run -d -e POSTGRES_USER=odoo -e POSTGRES_PASSWORD=odoo \
    -v %(erp_server_data_path)s/database/data:/var/lib/postgresql/data --name db --restart always \
    -p 55432:5432 postgres:%(postgres_version)s



sample configuration created with https://pgtune.leopard.in.ua::

    # DB Version: 10
    # OS Type: linux
    # DB Type: web
    # Total Memory (RAM): 1 GB
    # Connections num: 500
    # Data Storage: hdd

    max_connections = 500
    shared_buffers = 256MB
    effective_cache_size = 768MB
    maintenance_work_mem = 64MB
    checkpoint_completion_target = 0.7
    wal_buffers = 7864kB
    default_statistics_target = 100
    random_page_cost = 4
    effective_io_concurrency = 2
    work_mem = 524kB
    min_wal_size = 1GB
    max_wal_size = 2GB


query settings::

    SELECT * FROM pg_settings;

    SELECT *
    FROM   pg_settings
    WHERE  name = 'max_connections';

Troubleshooting
***************
    ::

        ...

        Requirement already satisfied: chardet<3.1.0,>=3.0.2 in /usr/local/lib/python3.5/dist-packages 
            (from requests>=2.0.0; python_version >= "3.0"->twilio) (3.0.4)
        Requirement already satisfied: urllib3<1.25,>=1.21.1 in /usr/local/lib/python3.5/dist-packages 
            (from requests>=2.0.0; python_version >= "3.0"->twilio) (1.23)

        Exception:
        Traceback (most recent call last):
        File "/usr/local/lib/python3.5/dist-packages/pip/_internal/cli/base_command.py", line 154, in main
            status = self.run(options, args)
        File "/usr/local/lib/python3.5/dist-packages/pip/_internal/commands/install.py", line 346, in run
            session=session, autobuilding=True
        File "/usr/local/lib/python3.5/dist-packages/pip/_internal/wheel.py", line 788, in build
            assert building_is_possible
        AssertionError


        --------------------------------------------
        a new image coobytech for container coobytech could not be created
        ERROR: {'code': 2, 'message': "The command '/bin/sh -c set -x;             apt install default-libmysqlclient-dev         libffi-dev         libxslt1-dev         zlib1g-dev         libssl-dev         build-essential         libxml2-dev         python3-dev         python-dev ;    pip install xlrd email_validator mysql-connector sqlalchemy twilio phonenumbers validate_email' returned a non-zero code: 2"}
        To better understand what is the reason please inspect the generated
        Dockerfile: /home/robert/erp-workbench/coobytech/docker/Dockerfile
        You can try to build it like so:
        cd /home/robert/erp-workbench/coobytech/docker/
        docker build .
        ---------------------------------------------

In the above error message we see, that the build process failed while pip installing twilio.
So we edit the Dockerfile by removing twilio. If that helps, we try to find out why it could not be installed
and add the missing elements to the dockerfiles.

When we have the Dockerfile building, we must make sure to add the elements that we added to the Dockerfile to the
site-description from which the Dockerfile was generated.