wiki v1

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Deploy OTOBO no Docker ======
<file bash>
$ git clone https://github.com/RotherOSS/otobo-docker.git --branch <BRANCH> --single-branch
$ git clone https://github.com/RotherOSS/otobo-docker.git --branch rel-10_1 --single-branch
$ cp -a otobo-docker otobo-ti
</file>

<file bash>
$ cd otobo-ti
$ cp .docker_compose_env_http .env
</file>

<file bash>
$ vim .env
[...]
COMPOSE_PROJECT_NAME=otobo-ti
[...]
OTOBO_DB_ROOT_PASSWORD=senha
[...]
</file>

==== Configuração do volumes ====
<file bash>
$ mkdir -p volumes/{elasticsearch_data,mariadb_data,opt_otobo,redis_data}
$ sudo chown systemd-timesync. volumes/mariadb_data/ -R
</file>

**Aterar de:**
<file bash docker-compose/otobo-base.yml>
$ vim docker-compose/otobo-base.yml
# Docker compose file for the OTOBO webapp.
# Note that no port is exposed as both HTTP and HTTPS are supported.
# For HTTP see the extension file docker-compose/otobo-override-http.yml.
# For HTTPS see the extension file docker-compose/otobo-override-https.yml.

# See also README.md.

# most current docker-compose file version, as of 2020-05-21
version: '3.3'

services:

  # the database
  db:
    image: ${OTOBO_IMAGE_DB:-mariadb:10.5}
    user: mysql:mysql
    cap_drop:
        - ALL
    cap_add:
        - CAP_SYS_CHROOT
    restart: always
    logging:
        driver: "local"
        options:
            max-file: "5"
            max-size: "10m"
    volumes:
      - mariadb_data:/var/lib/mysql

    # Within the container network the MariaDB server listens to its default port 3306.
    # Per default this port is not exposed to the outside world.
    # One can use 'docker-compose exec -it db mysql ...' when access to the database is needed.
    # But for development it can be useful to expose the port 3306. E.g. when a graphical client
    # like MySQL Workbench is used. Uncomment the following lines for making MariaDB available
    # on port 3307 on the Docker host. A non-standard port is chosen here, because 3306 is
    # often already used on the Docker host.
    # ports:
    #   - "3307:3306"

    # Set the db root password which has to be entered when running otobo/installer.pl.
    # The passwort is secret and can be stored in the file .env.
    # The content of the .env file is something like:
    # OTOBO_DB_ROOT_PASSWORD=otobo_root
    environment:
      MYSQL_ROOT_PASSWORD: ${OTOBO_DB_ROOT_PASSWORD:?err}
    command: --max-allowed-packet=68157440 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci --innodb-log-file-size=268435456 --query-cache-size=${OTOBO_DB_QUERY_CACHE_SIZE:-33554432}

    # "mysqladmin ping" sets the exit code $?. The exit code will be 0 (success) when the server can be reached,
    # not 0 (failure) otherwise.
    # The host is given as db, because localhost might not be resolved on some systems.
    # The credentials are not really needed for pinging, but without them we would get "Access denied" log messages
    # every time the health check is executed.
    # Note: alternatively /usr/local/bin/healthcheck.sh could be used.
    healthcheck:
      test: mysqladmin -h db --user=root --password='${OTOBO_DB_ROOT_PASSWORD}' ping

  # a container running a webserver
  web:
    # The services 'web' and 'daemon' use the same image.
    image: ${OTOBO_IMAGE_OTOBO:-rotheross/otobo:latest-10_0}
    cap_drop:
        - ALL
    #cap_add:
    depends_on:
      - db
      - elastic
      - redis
    restart: always
    logging:
        driver: "local"
        options:
            max-file: "5"
            max-size: "10m"
    # The HTTP port might be specified in a docker-compose extension file, e.g. docker-compose/otobo-override-http.yml.
    # For HTTPS no HTTP port is exposed.
    #ports:
    #    - "80:5000"
    volumes:
      - opt_otobo:/opt/otobo
    command: web
    healthcheck:
      test: curl -s -f http://localhost:5000/otobo/index.pl

  # a container running the OTOBO daemon
  daemon:
    # The services 'web' and 'daemon' use the same image.
    image: ${OTOBO_IMAGE_OTOBO:-rotheross/otobo:latest-10_0}
    cap_drop:
        - ALL
    #cap_add:
    depends_on:
      - web
    restart: always
    logging:
        driver: "local"
        options:
            max-file: "5"
            max-size: "10m"
    volumes:
      - opt_otobo:/opt/otobo
    command: daemon
    healthcheck:
      test: ./bin/otobo.Daemon.pl status | grep 'Daemon running'

  # a container running Elasticsearch
  elastic:
    image: ${OTOBO_IMAGE_OTOBO_ELASTICSEARCH:-rotheross/otobo-elasticsearch:latest-10_0}
    cap_drop:
        - ALL
    cap_add:
        - CAP_SYS_CHROOT
        - CAP_SETUID
        - CAP_SETGID
    restart: always
    logging:
        driver: "local"
        options:
            max-file: "5"
            max-size: "10m"
    environment:
      discovery.type: single-node
      ES_JAVA_OPTS: ${OTOBO_ELASTICSEARCH_ES_JAVA_OPTS:?err}
    volumes:
      - elasticsearch_data:/usr/share/elasticsearch/data
    healthcheck:
      test: curl -s -f http://localhost:9200/_cat/health

  # a container running Redis
  redis:
    image: ${OTOBO_IMAGE_REDIS:-redis:6.0-alpine}
    user: redis:redis
    cap_drop:
        - ALL
    #cap_add:
    restart: always
    logging:
        driver: "local"
        options:
            max-file: "5"
            max-size: "10m"
    volumes:
      - redis_data:/data
    healthcheck:
      test: redis-cli ping


# no volumes need to be exposed across services
volumes:
  mariadb_data: {}
  opt_otobo: {}
  elasticsearch_data: {}
  redis_data: {}
</file>

**Para:** 
<file bash docker-compose/otobo-base.yml >
$ cat docker-compose/otobo-base.yml 
# Docker compose file for the OTOBO webapp.
# Note that no port is exposed as both HTTP and HTTPS are supported.
# For HTTP see the extension file docker-compose/otobo-override-http.yml.
# For HTTPS see the extension file docker-compose/otobo-override-https.yml.

# See also README.md.

# most current docker-compose file version, as of 2020-05-21
version: '3.3'

services:

  # the database
  db:
    image: ${OTOBO_IMAGE_DB:-mariadb:10.5}
    user: mysql:mysql
    cap_drop:
        - ALL
    cap_add:
        - CAP_SYS_CHROOT
    restart: always
    logging:
        driver: "local"
        options:
            max-file: "5"
            max-size: "10m"
    volumes:
      #- mariadb_data:/var/lib/mysql <= Default
      # Adicionar
      - "../volumes/mariadb_data:/var/lib/mysql" 

    # Within the container network the MariaDB server listens to its default port 3306.
    # Per default this port is not exposed to the outside world.
    # One can use 'docker-compose exec -it db mysql ...' when access to the database is needed.
    # But for development it can be useful to expose the port 3306. E.g. when a graphical client
    # like MySQL Workbench is used. Uncomment the following lines for making MariaDB available
    # on port 3307 on the Docker host. A non-standard port is chosen here, because 3306 is
    # often already used on the Docker host.
    # ports:
    #   - "3307:3306"

    # Set the db root password which has to be entered when running otobo/installer.pl.
    # The passwort is secret and can be stored in the file .env.
    # The content of the .env file is something like:
    # OTOBO_DB_ROOT_PASSWORD=otobo_root
    environment:
      MYSQL_ROOT_PASSWORD: ${OTOBO_DB_ROOT_PASSWORD:?err}
    command: --max-allowed-packet=68157440 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci --innodb-log-file-size=268435456 --query-cache-size=${OTOBO_DB_QUERY_CACHE_SIZE:-33554432}

    # "mysqladmin ping" sets the exit code $?. The exit code will be 0 (success) when the server can be reached,
    # not 0 (failure) otherwise.
    # The host is given as db, because localhost might not be resolved on some systems.
    # The credentials are not really needed for pinging, but without them we would get "Access denied" log messages
    # every time the health check is executed.
    # Note: alternatively /usr/local/bin/healthcheck.sh could be used.
    healthcheck:
      test: mysqladmin -h db --user=root --password='${OTOBO_DB_ROOT_PASSWORD}' ping

  # a container running a webserver
  web:
    # The services 'web' and 'daemon' use the same image.
    image: ${OTOBO_IMAGE_OTOBO:-rotheross/otobo:latest-10_0}
    cap_drop:
        - ALL
    #cap_add:
    depends_on:
      - db
      - elastic
      - redis
    restart: always
    logging:
        driver: "local"
        options:
            max-file: "5"
            max-size: "10m"
    # The HTTP port might be specified in a docker-compose extension file, e.g. docker-compose/otobo-override-http.yml.
    # For HTTPS no HTTP port is exposed.
    #ports:
    #    - "80:5000"
    volumes:
      #- opt_otobo:/opt/otobo <= Default
      # Adicionar:
      - "../volumes/opt_otobo:/opt/otobo"
    command: web
    healthcheck:
      test: curl -s -f http://localhost:5000/otobo/index.pl

  # a container running the OTOBO daemon
  daemon:
    # The services 'web' and 'daemon' use the same image.
    image: ${OTOBO_IMAGE_OTOBO:-rotheross/otobo:latest-10_0}
    cap_drop:
        - ALL
    #cap_add:
    depends_on:
      - web
    restart: always
    logging:
        driver: "local"
        options:
            max-file: "5"
            max-size: "10m"
    volumes:
      #- opt_otobo:/opt/otobo <= Default
      # Adicionar: 
      - "../volumes/opt_otobo:/opt/otobo"
    command: daemon
    healthcheck:
      test: ./bin/otobo.Daemon.pl status | grep 'Daemon running'

  # a container running Elasticsearch
  elastic:
    image: ${OTOBO_IMAGE_OTOBO_ELASTICSEARCH:-rotheross/otobo-elasticsearch:latest-10_0}
    cap_drop:
        - ALL
    cap_add:
        - CAP_SYS_CHROOT
        - CAP_SETUID
        - CAP_SETGID
    restart: always
    logging:
        driver: "local"
        options:
            max-file: "5"
            max-size: "10m"
    environment:
      discovery.type: single-node
      ES_JAVA_OPTS: ${OTOBO_ELASTICSEARCH_ES_JAVA_OPTS:?err}
    volumes:
      #- elasticsearch_data:/usr/share/elasticsearch/data <= Default
      # Adicionar: 
      - "../volumes/elasticsearch_data:/usr/share/elasticsearch/data"
    healthcheck:
      test: curl -s -f http://localhost:9200/_cat/health

  # a container running Redis
  redis:
    image: ${OTOBO_IMAGE_REDIS:-redis:6.0-alpine}
    user: redis:redis
    cap_drop:
        - ALL
    #cap_add:
    restart: always
    logging:
        driver: "local"
        options:
            max-file: "5"
            max-size: "10m"
    volumes:
      #- redis_data:/data <= Default
      # Adicionar:
      - "../volumes/redis_data:/data"
    healthcheck:
      test: redis-cli ping

# Default
# no volumes need to be exposed across services
#volumes:
#  mariadb_data: {}
#  opt_otobo: {}
#  elasticsearch_data: {}
#  redis_data: {}
</file>

**Trechos modificados**
<file bash>
db:
[...]
    volumes:
      #- mariadb_data:/var/lib/mysql <= Default
      # Adicionar
      - "../volumes/mariadb_data:/var/lib/mysql" 
[...]

web:
[...]
volumes:
      #- opt_otobo:/opt/otobo <= Default
      # Adicionar:
      - "../volumes/opt_otobo:/opt/otobo"
[...]

daemon:
[...]
volumes:
      #- opt_otobo:/opt/otobo <= Default
      # Adicionar: 
      - "../volumes/opt_otobo:/opt/otobo"
[...]

elastic:
[...]
volumes:
      #- elasticsearch_data:/usr/share/elasticsearch/data <= Default
      # Adicionar: 
      - "../volumes/elasticsearch_data:/usr/share/elasticsearch/data"
[...]

redis:
[...]
volumes:
      #- redis_data:/data <= Default
      # Adicionar:
      - "../volumes/redis_data:/data"
[...]

# Default
# no volumes need to be exposed across services
#volumes:
#  mariadb_data: {}
#  opt_otobo: {}
#  elasticsearch_data: {}
#  redis_data: {}
</file>

==== Alterar a porta ====
<file bash>
$ vim docker-compose/otobo-override-http.yml 
# Run the OTOBO web app via HTTP on the port $OTOBO_WEB_HTTP_PORT or port 80 per default.
# The HTTP port is set up in a extension file because there are use cases that have no HTTP port exposed.

# See also README.md.

# most current docker-compose file version, as of 2020-05-21
version: '3.3'

services:

  web:
    ports:
      #- "${OTOBO_WEB_HTTP_IPADDR:-0.0.0.0}:${OTOBO_WEB_HTTP_PORT:-80}:5000" <= Default
      - "${OTOBO_WEB_HTTP_IPADDR:-0.0.0.0}:${OTOBO_WEB_HTTP_PORT:-8085}:5000"
</file>

==== Executando o deploy ====

<file bash>
$ docker-compose up -d
</file>

===== Configuração do nginx =====

<file bash otobo-ti.juntotelecom.com.br>
$ sudo vim /etc/nginx/sites-available/otobo-ti.juntotelecom.com.br 
server {
	listen 80;
	server_name otobo-ti.juntotelecom.com.br;

        location / {
                proxy_http_version 1.1;
                proxy_set_header Host $host;
                proxy_set_header X-Real-IP $remote_addr;
                proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
                proxy_set_header X-Forwarded-Proto $scheme;
                proxy_set_header Upgrade $http_upgrade;
                proxy_set_header Connection "upgrade";
                proxy_pass http://localhost:8085;
        }
}
</file>

<file bash>
$ sudo ln -s /etc/nginx/sites-available/otobo-ti.juntotelecom.com.br /etc/nginx/sites-enabled/
</file>

<file bash>
$ sudo nginx -t
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful
</file>

<file bash>
$ sudo systemctl restart nginx
</file>

==== Instalação ====

''http://otobo-ti.juntotelecom.com.br/otobo/installer.pl''

{{:captura_de_tela_de_2022-12-05_11-47-19.png|}}

{{:captura_de_tela_de_2022-12-05_11-47-52.png|}}

{{:captura_de_tela_de_2022-12-05_11-48-09.png|}}

{{:captura_de_tela_de_2022-12-05_11-55-39.png|}}

{{:captura_de_tela_de_2022-12-05_11-56-13.png|}}

{{:captura_de_tela_de_2022-12-05_11-57-30.png|}}

{{:captura_de_tela_de_2022-12-05_12-01-27.png|}}

{{:captura_de_tela_de_2022-12-05_12-01-54.png|}}