Linux

comandos uteis linux

Geral

Ver ip externo

wget -qO- ifconfig.co/ip

Listar links simbolicos

find . -type l -ls

Reload Bash

source ~/.bashrc

Verificar espaço

du -shc *

Vim

(ctrl v mouse)

/.vimrc set mouse-=a

Setar timezone

sudo timedatectl set-timezone America/Sao_Paulo

Tar

tar -cvf sampleArchive.tar /sampleArchive

tar -xvf sampleArchive.tar

Status e Versões

service --status-all

java -version

Logs

journalctl -xe

journalctl -f -e -u nome_app

limpa os logs com + de 10 dias

journalctl --vacuum-time=10d

Composer

Download

curl -sS https://getcomposer.org/installer -o composer-setup.php

Instalar

sudo php composer-setup.php --install-dir=/usr/local/bin --filename=composer

Crontab

• ver log: /var/mail/

Find

Dentro do ditetorio

find .

Somente diretorios

-type d

Somente arquivos

-type f

com permissoes diferentes

find / -type f ! -perm 777

Arquivos acessados nas ultimas 12 horas find . -type f -ctime -0.5 -exec ls -l {} \;

Metabase

BI de dados

Instalação

Processo de instalação do metabase

https://www.metabase.com/docs/latest/installation-and-operation/running-metabase-on-debian

https://www.letscloud.io/community/how-to-install-metabase-on-ubuntu-20-04-as-a-service-with-nginx

Antes de tudo

• apt-get update
• apt-get install vim
• apt-get install rsyslog
• apt install snapd
• apt install -y default-jdk
• java -version
• timedatectl set-timezone America/Sao_Paulo

Maria Db

apt install mariadb-server

systemctl start mariadb

systemctl enable mariadb

mysql_secure_installation

mysql -u root

CREATE database metabase;

CREATE USER 'metabase'@'%' IDENTIFIED BY 'senha';

GRANT ALL PRIVILEGES ON metabase.* to 'metabase'@'%';

FLUSH PRIVILEGES;

Ngix

apt install nginx

vi /etc/nginx/sites-available/metabase

1. sample nginx.conf
2. proxy requests to Metabase instance

server {

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

}

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

nginx -t

SSL

sudo snap install --classic certbot

sudo ln -s /snap/bin/certbot /usr/bin/certbot

sudo certbot --nginx

Linux

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 syslog:adm /var/log/metabase.log (no)

sudo touch /etc/default/metabase

sudo chmod 640 /etc/default/metabase

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

vi /etc/systemd/system/metabase.service

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

& stop

sudo systemctl restart rsyslog.service

sudo vi /etc/default/metabase

MB_PASSWORD_COMPLEXITY=normal #<weak|normal|strong>

MB_PASSWORD_LENGTH=10

1. MB_JETTY_HOST=<0.0.0.0>

1. MB_JETTY_PORT=<12345>

MB_DB_TYPE=mysql #<postgres|mysql|h2>

MB_DB_DBNAME= your_metabase_db_name

MB_DB_PORT=3306

MB_DB_USER=your_metabase_db_user

MB_DB_PASS=ssshhhh

MB_DB_HOST=localhost

MB_EMOJI_IN_LOGS=true #<true|false>

1. any other env vars you want available to Metabase

sudo systemctl daemon-reload

sudo systemctl start metabase.service

sudo systemctl status metabase.service

sudo systemctl enable metabase.service

Atualização

• Stop metabase
• Download da nova versão e backup anterior
• Copia para pasta
• Start e reinicia

sudo systemctl stop metabase.service

sudo systemctl start metabase.service

sudo systemctl status metabase.service

Manutenção

ver status: ver status service --status-all

reload daemon systemctl daemon-reload

journalctl -xe

journalctl -f -e -u metabase

java -version

Banco de Dados

1. Criação do banco

CREATE DATABASE metabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

1. Configuração

export MB_DB_TYPE=mysql

export MB_DB_DBNAME=metabase

export MB_DB_PORT=3306

export MB_DB_USER=<username>

export MB_DB_PASS=<password>

export MB_DB_HOST=localhost

java -jar metabase.jar

Docker

Processo de uso do metabase via docker

Atualização

- abrir o arquivo docker-compose.yml

- editar a linha da imagem e colocar a nova versao (evite usar latest)

- docker compose pull metabase

- docker-compose down

- docker-compose up -d

- docker-compose logs -f metabase

Rocket Chat

Programa de chat empresarial

https://github.com/RocketChat

Certficado SSL

Atualização de certificado ssl https:

1. stop ngix

/etc/init.d/nginx stop

1. renew certificate

certbot renew

1. start

/etc/init.d/nginx start

1. delete

sudo certbot delete

sudo certbot delete --cert-name example.com

Atualizar/Manutenção

Documentação:

https://rocket.chat/docs/installation/manual-installation/ubuntu/snaps/

https://snapcraft.io/rocketchat-server

Checar versão do snap:

snap --version

Checar versão programas instalados

snap list

Ver informações

snap info rocketchat-server

How do I manually update to a new release?

While updates happen automatically usually within 6 hours from time of release, you can update manually by issuing this command:

sudo snap refresh rocketchat-server

• opção de escolher canal

--channel=canal/stable

Trocar de versão

snap switch rocketchat-server --channel=7.x/stable

How do I tell if Rocket.Chat is actually running?

You can check on the status of Rocket.Chat with:

sudo service snap.rocketchat-server.rocketchat-server status

To restart Rocket.Chat:

sudo service snap.rocketchat-server.rocketchat-server restart

Chat por departamento

Chat padrão

<script type="text/javascript"> (function(w, d, s, u) { w.RocketChat = function(c) { w.RocketChat._.push(c) }; w.RocketChat._ = []; w.RocketChat.url = u; w.RocketChat.setDepartment('FILL HERE DEPARTMENT NAME - case sensitive'); var h = d.getElementsByTagName(s)[0], j = d.createElement(s); j.async = true; j.src = 'https://chat.sistemaprever.com.br/livechat/rocketchat-livechat.min.js?_=201903270000'; h.parentNode.insertBefore(j, h); })(window, document, 'script', 'https://chat.sistemaprever.com.br/livechat'); </script>

Atribuir departamento ao chat do livechat

<script type="text/javascript"> RocketChat(function() { this.setDepartment('FILL HERE DEPARTMENT NAME - case sensitive'); }); </script>