Mudanças entre as edições de "Metabase"

De MochilaWiki
Ir para navegaçãoIr para pesquisar
Linha 42: Linha 42:
 
   
 
   
 
  [Service]
 
  [Service]
 +
MB_PASSWORD_COMPLEXITY=strong
 +
MB_PASSWORD_LENGTH=12
 +
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
 
  WorkingDirectory=/home/metabase/
 
  WorkingDirectory=/home/metabase/
 
  ExecStart=/usr/bin/java -jar /home/metabase/metabase.jar
 
  ExecStart=/usr/bin/java -jar /home/metabase/metabase.jar
Linha 58: Linha 67:
  
 
em /etc/rsyslog.d/metabase.conf
 
em /etc/rsyslog.d/metabase.conf
 +
if $programname == 'metabase' then /var/log/metabase.log
 +
& stop
 +
 +
<source lang="bash">
 +
systemctl restart rsyslog.service
 +
</source>
 +
 +
em /etc/default/metabase (alternativa, mas não funcionou no meu teste... deu certo inserindo no service)
 +
MB_PASSWORD_COMPLEXITY=strong #weak|strong
 +
MB_PASSWORD_LENGTH=10
 +
MB_DB_TYPE=mysql #postgres|mysql|h2
 +
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 #true|false
 +
 +
iniciando metabase e habilitando para iniciar no boot
 +
<source lang="bash">
 +
systemctl daemon-reload
 +
systemctl start metabase
 +
systemctl enable metabase
 +
</source>
 +
 +
=== instalando e configurando o nginx ===
 +
<source lang="bash">
 +
apt install nginx
 +
</source>
 +
 +
em /etc/nginx/sites-available/metabase
 +
<source lang="nginx">
 +
server {
 +
listen 80;
 +
listen [::]:80;
 +
server_name example.com;
 +
location / {
 +
proxy_pass http://127.0.0.1:3000;
 +
}
 +
}
 +
</source>
 +
 +
reiniciando nginx e habilitando para iniciar no boot
 +
<source lang="bash">
 +
ln -s /etc/nginx/sites-available/metabase /etc/nginx/sites-enabled/metabase
 +
systemctl daemon-reload
 +
systemctl restart nginx
 +
systemctl enable nginx
 +
</source>

Edição das 02h14min de 1 de junho de 2021

Instalando em Ubuntu 20.04

dependências

apt update
apt install openjdk-11-jdk openjdk-11-jre
apt install mariadb-server
systemctl start mariadb
systemctl enable mariadb
mysql -u root -p

criando banco de dados

CREATE DATABASE metabase;
CREATE USER 'metabase_user'@'localhost' IDENTIFIED BY 'Strong_Password';
GRANT ALL ON metabase.* TO 'metabase_user'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;

instalando

mkdir /home/metabase
cd /home/metabase
wget https://downloads.metabase.com/v0.39.3/metabase.jar
groupadd -r metabase
useradd -r -s /bin/false -g metabase metabase
chown -R metabase:metabase /home/metabase
touch /var/log/metabase.log
chown metabase:metabase /var/log/metabase.log
touch /etc/default/metabase
chmod 640 /etc/default/metabase

em /etc/systemd/system/metabase.service

[Unit]
Description=Metabase server
After=syslog.target
After=network.target

[Service]
MB_PASSWORD_COMPLEXITY=strong
MB_PASSWORD_LENGTH=12
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
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

em /etc/rsyslog.d/metabase.conf

if $programname == 'metabase' then /var/log/metabase.log
& stop
systemctl restart rsyslog.service

em /etc/default/metabase (alternativa, mas não funcionou no meu teste... deu certo inserindo no service)

MB_PASSWORD_COMPLEXITY=strong #weak|strong
MB_PASSWORD_LENGTH=10
MB_DB_TYPE=mysql #postgres|mysql|h2
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 #true|false

iniciando metabase e habilitando para iniciar no boot

systemctl daemon-reload
systemctl start metabase
systemctl enable metabase

instalando e configurando o nginx

apt install nginx

em /etc/nginx/sites-available/metabase

server {
listen 80;
listen [::]:80;
server_name example.com;
location / {
proxy_pass http://127.0.0.1:3000;
}
}

reiniciando nginx e habilitando para iniciar no boot

ln -s /etc/nginx/sites-available/metabase /etc/nginx/sites-enabled/metabase
systemctl daemon-reload
systemctl restart nginx
systemctl enable nginx