Skip to content

Instantly share code, notes, and snippets.

View beingsane's full-sized avatar

Stéfano Araujo beingsane

17 followers · 41 following
View GitHub Profile
@beingsane
beingsane / common.py
Created April 17, 2020 18:25 — forked from isaqueprofeta/common.py
Coleção de funções de manipulação para python
#!/usr/bin/python3.5
import os
def importa_ssl():
"""
Importa certificados SSL
"""
# CentOS 7.5
if os.path.exists("/etc/pki/ca-trust/extracted/openssl/ca-bundle.trust.crt"):
@beingsane
beingsane / zabbix_lld_json.py
Created April 17, 2020 18:25 — forked from isaqueprofeta/zabbix_lld_json.py
Modelo base para criar saídas lld para o zabbix
#!/usr/bin/python3.5
# Bibliotecas necessárias
import json,collections
# Prepara container lld do zabbix
lld = { 'data' : [] }
# Lógica de acesso a fonte dos dados do LLD
# O array de dicionario funciona como teste para esse exemplo
@beingsane
beingsane / custom_login_grafana.md
Created April 17, 2020 18:25 — forked from isaqueprofeta/custom_login_grafana.md

Customização da tela de Login do Grafana

1) Instalar dependências:

1.1) Golang:

cd /tmp
curl -O https://storage.googleapis.com/golang/go1.9.3.linux-amd64.tar.gz
tar -xvf go1.9.3.linux-amd64.tar.gz
@beingsane
beingsane / instala_ccd_serpro_ubuntu.sh
Created April 17, 2020 18:25 — forked from isaqueprofeta/instala_ccd_serpro_ubuntu.sh
Passos para instalação de certificados do SERPRO no Ubuntu
# FECHAR TODOS OS BROWSERS !!!
# Entrar na pasta de certificados do sistema:
# Ubuntu anterior ao 18:
sudo mkdir /usr/share/ca-certificates/serpro/
sudo cd /usr/share/ca-certificates/serpro/
# Ubuntu 18:
sudo mkdir /usr/local/share/ca-certificates/serpro/
sudo cd /usr/local/share/ca-certificates/serpro/
@beingsane
beingsane / instala_ccd_serpro_centos.sh
Created April 17, 2020 18:25 — forked from isaqueprofeta/instala_ccd_serpro_centos.sh
Passos para instalação de certificados do SERPRO no CentOS
# Entrar na pasta de certificados do sistema:
sudo cd /etc/pki/ca-trust/source/anchors/
# Baixar os certificados do repositorio:
sudo wget -r --no-check-certificate https://repositorio.serpro.gov.br/docs/
# Remover apenas os certificados de interesse:
sudo mv repositorio.serpro.gov.br/docs/*.crt .
# Limpar o restante do wget:
sudo rm -rf repositorio.serpro.gov.br/
# Executar compilação dos certificados para o sistema:
sudo update-ca-trust extract
@beingsane
beingsane / Dockerfile
Created April 17, 2020 18:25 — forked from isaqueprofeta/Dockerfile
Install OpenJDK in Jessie Docker image
FROM debian:jessie
RUN set -ex && \
echo 'deb http://deb.debian.org/debian jessie-backports main' \
> /etc/apt/sources.list.d/jessie-backports.list && \
apt update -y && \
apt install -t \
jessie-backports \
openjdk-8-jre-headless \
@beingsane
beingsane / php_zabbix_api.md
Created April 17, 2020 18:25 — forked from isaqueprofeta/php_zabbix_api.md
Usando a API do zabbix rapidamente em PHP

Instalar PHP:

sudo apt-get install php7.0 php7.0-cli php7.0-common php7.0-curl

Instalar Composer:

sudo php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
sudo php composer-setup.php
sudo php -r "unlink('composer-setup.php');"
@beingsane
beingsane / Dockerfile
Created April 17, 2020 18:25 — forked from isaqueprofeta/Dockerfile
phpipam_docker_72
FROM php:7.2-apache
MAINTAINER Pierre Cheynier <[email protected]>
ENV PHPIPAM_SOURCE https://github.com/phpipam/phpipam/
ENV PHPIPAM_VERSION 1.3.1
ENV PHPMAILER_SOURCE https://github.com/PHPMailer/PHPMailer/
ENV PHPMAILER_VERSION 5.2.21
ENV PHPSAML_SOURCE https://github.com/onelogin/php-saml/
ENV PHPSAML_VERSION 2.10.6
ENV WEB_REPO /var/www/html
@beingsane
beingsane / docker-compose.yml
Created April 17, 2020 18:25 — forked from isaqueprofeta/docker-compose.yml
Postgres and Pgadmin4 with volumes
version: '2'
volumes:
db_data:
driver: local
pgadmin_data:
driver: local
services:
db:
@beingsane
beingsane / laravel_postgresschema2json.php
Created April 17, 2020 18:25 — forked from isaqueprofeta/laravel_postgresschema2json.php
<?php
use Illuminate\Support\Facades\DB;
$query = "SELECT tables.table_name, columns.column_name, columns.data_type, columns.udt_name FROM information_schema.tables AS tables JOIN information_schema.columns AS columns ON tables.table_name = columns.table_name WHERE tables.table_type = 'BASE TABLE' AND tables.table_schema NOT IN ('pg_catalog', 'information_schema')";
$data = json_decode(collect(DB::select($query)));