Skip to content

Instantly share code, notes, and snippets.

View isaqueprofeta's full-sized avatar
🎯
Focusing

Isaque Profeta isaqueprofeta

🎯
Focusing
View GitHub Profile
@isaqueprofeta
isaqueprofeta / Vagrantfile
Created June 27, 2024 16:21
Grafana on Debian 12
Vagrant.configure("2") do |config|
config.vm.define "laboratorio" do |laboratorio|
# ======= OPCOES DO VIRTUALBOX =======
# VM BASE DO DEBIAN
laboratorio.vm.box = "debian/bookworm64"
# HOSTNAME DA VM
laboratorio.vm.hostname = "grafana-debian"
# REDE DA VM
@isaqueprofeta
isaqueprofeta / opencti_docker_ubuntu22.sh
Created February 20, 2024 18:27
Instalação OpenCTI com Docker no Ubuntu 22.04
#!/bin/bash
# DEFINA AS CREDENCIAIS E CUSTOMIZACOES AQUI
export OPENCTI_BASE_URL="http://localhost:8080"
export OPENCTI_ADMIN_EMAIL="admin@opencti.io"
export OPENCTI_ADMIN_PASSWORD="ChangeMePlease"
export RABBITMQ_DEFAULT_USER="guest"
export RABBITMQ_DEFAULT_PASS="guest"
export SMTP_HOSTNAME="localhost"
export ELASTIC_MEMORY_SIZE="4G"
@isaqueprofeta
isaqueprofeta / .000_Como_Usar.md
Last active January 15, 2024 12:52
Elastic Trial Docker

Elastic Trial Docker

Como usar

  • Copiar ambos os arquivos desde gist (Os arquivos abaixo, chamados .env e docker-compose.yml) dentro de um diretório e acessar esse diret
  • Editar o .env com as opções de credencial
    • Para usar sem o trial, trocar no .env o LICENSE para basic: LICENSE=basic
  • Ligando o ambiente
    • Rodar o docker-compose up -d
    • Rodar o docker-compose logs -f kibana
  • Aguardar o Kibana parar de carregar mensagens por mais de 30 segundos (quer dizer que ele terminou de carregar)
@isaqueprofeta
isaqueprofeta / zabbix60_ubuntu22_timescaledb_nginx.sh
Last active August 1, 2024 17:12
Instalação Zabbix 6.0 com TimescaleDB (PG15) e Nginx no Ubuntu 22.04
#!/bin/bash
DATABASE_PASSWORD=${1:-Z4bb1xD4t4b4s3}
echo "######################################################################"
echo " INSTALACAO DO ZABBIX "
echo " SISTEMA OPERACIONAL UBUNTU "
echo "######################################################################"
echo " FONTE DO SCRIPT: "
echo " https://github.com/isaqueprofeta/zabbix-pipe2bash/ "
@isaqueprofeta
isaqueprofeta / cria_pendrive_bootavel.sh
Last active August 30, 2022 00:40
Criar pendrive bootavel a partir de ISO
#!/bin/bash
PATHTOISO = $1
DISKTOWRITE = $2
dd bs=4M if=$PATHTOISO of=$DISKTOWRITE conv=fdatasync
@isaqueprofeta
isaqueprofeta / siem_training.md
Last active November 11, 2024 16:42
SIEM Training
@isaqueprofeta
isaqueprofeta / CONTEXT.md
Last active July 6, 2022 23:42
Zabbix JS Script item for count of day-before Alerts
  • Where? https://t.me/ZabbixTech

  • Question: Hi team...is there any query where we can get the count of alarms raised per day?

  • Answer: Since version 6.0 you can create an API key and then do an JavaScript Script Item to check the information from Zabbix API using time_from and time_till parameters to filter the day before. Didn't tested, just prototyped the idea below, and before trying the code, remember to add the "url" and "apikey" to the item Parameters, (and please use a macro with vault for your apikey), in this case I'd configure the item interval as an scheduled one to run everyday at 1 or 2 AM:

@isaqueprofeta
isaqueprofeta / 00-README.md
Created April 24, 2022 18:36
Laboratório de eventos real-time do Zabbix para OpenSearch usando Logstash

Laboratório de eventos real-time do Zabbix para OpenSearch usando Logstash

TL;DR: O ingestão e atualizaçao dos dados foi feita com sucesso, a PoC terminou no ponto onde o Logstash para o OpenSearch não se mostrou interessante do ponto de vista de não ter recursos (que em pesquisa existem plugins do logstash para a versão proprietária do ElasticSearch) para calcular em novos campos no processo de atualização o tempo de duração dos eventos para facilitar o desenvolvimento de dashboards de apresentação de dados. Concluindo-se assim que seria mais interessante um python no lugar do logstash para executar funções de "update by query".

Composição

  • Logstash para processamento dos dados vindos de triggers do real-time export do Zabbix
  • OpenSearch para armazenamento e pesquisa
  • OpenSearch Dashboards para analise de dados e dashboard
@isaqueprofeta
isaqueprofeta / zabbix60_rocky8_timescaledb_nginx.sh
Last active August 1, 2024 17:11
Instalação Zabbix 6.0 com TimescaleDB (PG15) e Nginx no Rocky/Alma 8
#!/bin/bash
DATABASE_PASSWORD=${1:-Z4bb1xD4t4b4s3}
echo "######################################################################"
echo " INSTALACAO DO ZABBIX "
echo " SISTEMAS OPERACIONAIS RHEL-LIKE ROCKY/ALMA LINUX "
echo "######################################################################"
echo " FONTE DO SCRIPT: "
echo " https://github.com/isaqueprofeta/zabbix-pipe2bash "
@isaqueprofeta
isaqueprofeta / zabbix60_bullseye_timescaledb_nginx.sh
Last active March 8, 2024 19:07
Instalação Zabbix 6.0 com TimescaleDB (PG15) e Nginx no Debian 11
#!/bin/bash
DATABASE_PASSWORD=${1:-Z4bb1xD4t4b4s3}
echo "######################################################################"
echo " INSTALACAO DO ZABBIX "
echo " SISTEMA OPERACIONAL DEBIAN "
echo "######################################################################"
echo " FONTE DO SCRIPT: "
echo " https://github.com/isaqueprofeta/zabbix-pipe2bash "