Julio Silveira Melo juliosmelo

## cpf_consulta_api_sus.py
#!/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

## MySQL size of tables in MB
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;'

## Kill sleep or slow query in mysql
#!/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',

## Nginx cache for Wordpress
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 {

## Brazil geoJSON
{
"type": "FeatureCollection",

"features": [

## Nginx for wodpress
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;
}

## ubuntu-compass-ruby
#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

## install-comodo-ssl-cert-for-nginx.rst

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                juliosmelo
                / install-comodo-ssl-cert-for-nginx.rst
            
            
              Created Oct 15, 2015
                — forked from bradmontgomery/install-comodo-ssl-cert-for-nginx.rst
            
              
                Steps to install a Comodo PositiveSSL certificate with Nginx.
              
          
      View install-comodo-ssl-cert-for-nginx.rst
  
      
    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


## apache2.conf
LogFormat "%{X-Forwarded-For}i %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" proxy

## keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                juliosmelo
                / keybase.md
            
            
              Last active Sep 21, 2015
            
          
      View keybase.md
  
      
    Keybase proof
I hereby claim:

I am juliosmelo on github.
I am juliocsmelo (https://keybase.io/juliocsmelo) on keybase.
I have a public key whose fingerprint is 2463 D5C4 826C 2B25 E9F8  8B40 0736 13C4 6A88 8C5F

To claim this, I am signing this object:
	#!/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
	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;'
	#!/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',
	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 {
	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;
	}
	#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