​​​​​​​​​​✅ Múltiplos atendentes - 1 número, vários usuários + METABASE​ - SUPORTE 15 99856-6622​ (wa.me/5515998566622​)

📁 Arquivos disponíveis para download nessa aula​

👉 Instruções Vídeo 1 (Windows)

1- INSTALAR O WHATICKET

2- BAIXAR O METABASE.JAR

a. baixar e executar metabase.jar

b. configuração inicial de usuário

c. configuração de database

d. configuração de compartilhamento

e. criação da view

3- CONFIGURAR O FRONTEND WHATICKET

a. incorporar a view​

​👉 Instruções Vídeo 2 (VPS)

CRIAR 1 SUBDOMINIO E APONTAR PARA O IP DA SUA VPS

SUB: FRONTEND DO METABASE > metabase.zapdasgalaxias.com.br

sudo apt update

sudo apt upgrade

sudo apt install openjdk-11-jdk openjdk-11-jre

java --version

sudo mysql -u root -p

mysql> CREATE DATABASE metabase;

mysql> CREATE USER 'metabase_user'@'localhost' IDENTIFIED BY 'Strong_Password';

mysql> GRANT ALL ON metabase.* TO 'metabase_user'@'localhost' WITH GRANT OPTION;

mysql> FLUSH PRIVILEGES;

mysql> EXIT;

sudo mkdir /home/metabase

cd /home/metabase

sudo wget https://downloads.metabase.com/v0.36.7/metabase.ja...

sudo groupadd -r metabase

sudo useradd -r -s /bin/false -g metabase metabase

sudo chown -R metabase:metabase /home/metabase

sudo touch /var/log/metabase.log

sudo chown metabase:metabase /var/log/metabase.log

sudo touch /etc/default/metabase

sudo chmod 640 /etc/default/metabase

sudo nano /etc/systemd/system/metabase.service

[Unit]

Description=Metabase server

After=syslog.target

After=network.target

[Service]

WorkingDirectory=/home/metabase/

ExecStart=/usr/bin/java -jar /home/metabase/metabase.jar

EnvironmentFile=/etc/default/metabase

User=metabase

Type=simple

StandardOutput=syslog

StandardError=syslog

SyslogIdentifier=metabase

SuccessExitStatus=143

TimeoutStopSec=120

Restart=always

[Install]

WantedBy=multi-user.target

sudo nano /etc/rsyslog.d/metabase.conf

if $programname == 'metabase' then /var/log/metabase.log

& stop

sudo systemctl restart rsyslog.service

sudo nano /etc/default/metabase

MB_PASSWORD_COMPLEXITY=strong

MB_PASSWORD_LENGTH=10

MB_DB_TYPE=mysql

MB_DB_DBNAME=metabase

MB_DB_PORT=3306

MB_DB_USER=metabase_user

MB_DB_PASS=Strong_Password

MB_DB_HOST=localhost

MB_EMOJI_IN_LOGS=true

MB_JETTY_PORT=3030

sudo systemctl daemon-reload

sudo systemctl start metabase

sudo systemctl status metabase

sudo systemctl enable metabase

sudo nano /etc/nginx/sites-available/whaticket-metabase

server {

  server_name metabase.zapdasgalaxias.com.br;

  location / {

    proxy_pass http://127.0.0.1:3030;

    proxy_http_version 1.1;

    proxy_set_header Upgrade $http_upgrade;

    proxy_set_header Connection 'upgrade';

    proxy_set_header Host $host;

    proxy_set_header X-Real-IP $remote_addr;

    proxy_set_header X-Forwarded-Proto $scheme;

    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;

    proxy_cache_bypass $http_upgrade;

  }

  }

cd /etc/nginx/sites-available/

ls

sudo ln -s /etc/nginx/sites-available/whaticket-metabase /etc/nginx/sites-enabled

sudo nginx -t

sudo service nginx restart

sudo certbot --nginx​