Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

View juliosmelo's full-sized avatar
🏠
Working from home

Julio Silveira Melo juliosmelo

🏠
Working from home
43 followers · 16 following
  • laboratoriohacker.com
  • Blue earth
View GitHub Profile
@juliosmelo
juliosmelo / Dockerfile
Created December 21, 2016 17:45 — forked from yefim/Dockerrun.aws.json
Build a Docker image, push it to AWS EC2 Container Registry, then deploy it to AWS Elastic Beanstalk
# Example Dockerfile
FROM hello-world
@juliosmelo
juliosmelo / cpf_consulta_api_sus.py
Created December 5, 2016 12:17 — forked from jh00nbr/cpf_consulta_api_sus.py
Script simples para consulta de dados na base dados nacional do SUS utilizando o CPF.
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import requests,json,sys
# Script simples para consulta de dados na base dados nacional do SUS utilizando o CPF.
# Jhonathan Davi A.K.A jh00nbr / Insightl4b lab.insightsecurity.com.br
# Blog: lab.insightsecurity.com.br
# Github: github.com/jh00nbr
# Twitter @jh00nbr
@juliosmelo
juliosmelo / MySQL size of tables in MB
Created June 1, 2016 17:12
SELECT table_name AS "Tables",
round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
FROM information_schema.TABLES
WHERE table_schema = "t8_auth"
ORDER BY (data_length + index_length) DESC;'
@juliosmelo
juliosmelo / Kill sleep or slow query in mysql
Created June 1, 2016 17:10
#!/usr/bin/python
# -*- coding: utf-8 -*-
import logging
import MySQLdb as mdb
from datetime import datetime
import sys
logging.basicConfig(
filename='killed_queries.log',
filemode='w',
@juliosmelo
juliosmelo / Nginx cache for Wordpress
Created June 1, 2016 17:07
upstream backend{
# Defines backends.
# Extracting here makes it easier to load balance
# in the future. Needs to be specific IP as Plesk
# doesn't have Apache listening on localhost.
ip_hash;
server 127.0.0.1:8080; # IP goes here.
}
server {
@juliosmelo
juliosmelo / Brazil geoJSON
Created June 1, 2016 17:06
This file has been truncated, but you can view the full file.
{
"type": "FeatureCollection",
"features": [
{ "type": "Feature", "properties": { "UF_05": "AC", "MICRO": "BRASILEIA", "MESO": "VALE DO ACRE", "REGIAO": "Norte", "NOME_UF": "Acre", "GEOCODIGO": "12" }, "geometry": { "type": "Polygon", "coordinates": [ [ [ -73.800983150850584, -7.111457753361378 ], [ -73.737625150791587, -7.134317253382619 ], [ -72.90061215001208, -7.436948253664468 ], [ -72.588010149720958, -7.550250253770059 ], [ -72.3029271494554, -7.584564753801942 ], [ -72.168962149330582, -7.600226253816572 ], [ -71.957814649133979, -7.624874753839549 ], [ -71.381112148596912, -7.691940753901918 ], [ -71.087928648323896, -7.725894253933575 ], [ -70.515258647790461, -7.791927253995141 ], [ -70.132605647434161, -7.83582675403602 ], [ -70.051806147358889, -7.847003754046341 ], [ -69.801148147125446, -8.060750754245419 ], [ -69.442709146791572, -8.366957254530575 ], [ -69.212413146577092, -8.56399675471414 ], [ -68.9223356463070
@juliosmelo
juliosmelo / Nginx for wodpress
Created June 1, 2016 17:04
upstream fpm_example.com1{
server unix:/var/run/php5-fpm.sock;
server unix:/var/run/php5-fpm1.sock;
keepalive 128;
}
upstream admin {
server unix:/var/run/php5-fpm1.sock;
server unix:/var/run/php5-fpm2.sock;
keepalive 128;
}
@juliosmelo
juliosmelo / ubuntu-compass-ruby
Created April 16, 2016 01:06 — forked from stephanetimmermans/ubuntu-compass-ruby
Install Compass+Ruby on Ubuntu 14.04
#https://gorails.com/setup/ubuntu/14.04
sudo apt-get update
sudo apt-get install git-core curl zlib1g-dev build-essential libssl-dev libreadline-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev libcurl4-openssl-dev python-software-properties
sudo apt-get install libgdbm-dev libncurses5-dev automake libtool bison libffi-dev
curl -L https://get.rvm.io | bash -s stable
source ~/.rvm/scripts/rvm
echo "source ~/.rvm/scripts/rvm" >> ~/.bashrc
rvm install 2.1.2
rvm use 2.1.2 --default
@juliosmelo
juliosmelo / install-comodo-ssl-cert-for-nginx.rst
Created October 15, 2015 14:00 — forked from bradmontgomery/install-comodo-ssl-cert-for-nginx.rst
Steps to install a Comodo PositiveSSL certificate with Nginx.

Setting up a SSL Cert from Comodo

I use Namecheap.com as a registrar, and they resale SSL Certs from a number of other companies, including Comodo.

These are the steps I went through to set up an SSL cert.

Purchase the cert

@juliosmelo
juliosmelo / apache2.conf
Created September 23, 2015 16:14
LogFormat for proxy with x-forward-for
LogFormat "%{X-Forwarded-For}i %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" proxy