Skip to content

Instantly share code, notes, and snippets.

View carlessanagustin's full-sized avatar

carles san agustin carlessanagustin

View GitHub Profile
@carlessanagustin
carlessanagustin / install_lamp.sh
Last active February 28, 2018 17:00 — forked from rrosiek/install_mysql.sh
Vagrant provision script for php, Apache, MySQL, phpMyAdmin, Laravel, and javascript helpers. Outputs nearly everything to /dev/null since "quiet" on most commands is still noisy.
#!/usr/bin/env bash
# Variables
APPENV=local
DBHOST=localhost
DBNAME=dbname
DBUSER=dbuser
DBPASSWD=test123
echo -e "\n--- Mkay, installing now... ---\n"
@carlessanagustin
carlessanagustin / postgres-cheatsheet.md
Created February 29, 2016 09:44 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).

Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

@carlessanagustin
carlessanagustin / bash-cheatsheet.md
Last active February 28, 2018 16:59 — forked from LeCoupa/bash-cheatsheet.sh
Bash CheatSheet for UNIX Systems

#!/usr/bin/env bash

0. Shortcuts.

CTRL+A  # move to beginning of line
CTRL+B  # moves backward one character
CTRL+C  # halts the current command
CTRL+D  # deletes one character backward or logs out of current session, similar to exit
CTRL+E  # moves to end of line
import scrapy
import peewee
import re
import urllib
import cStringIO
from PIL import Image
from playhouse.db_url import connect
db = connect('mysql://root:@127.0.0.1/house')
@carlessanagustin
carlessanagustin / etc_hosts.yml
Last active June 7, 2018 10:21 — forked from rothgar/main.yml
ANSIBLE: Generate /etc/hosts with Ansible from https://gist.github.com/rothgar/8793800
---
- hosts: all
gather_facts: yes
tasks:
- name: Update /etc/hosts
become: true
tags:
- dns
lineinfile:
dest: /etc/hosts
@carlessanagustin
carlessanagustin / tmux-cheatsheet.markdown
Last active October 7, 2019 09:08 — forked from MohamedAlaa/tmux-cheatsheet.markdown
TMUX: tmux shortcuts & cheatsheet

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname
@carlessanagustin
carlessanagustin / VBoxGuestAdditions_Vagrant.md
Last active December 7, 2016 14:50 — forked from fernandoaleman/gist:5083680
VAGRANT: How to update VirtualBox Guest Additions with Vagrant
  • In host machine ($ )
vagrant init centos/7
vagrant up
vagrant ssh
  • In guest machine ([vagrant@localhost ~]$ )
## credit: http://fabian-affolter.ch/blog/the-lineinfile-module-of-ansible/
---
- hosts: alpine_install
user: root
tasks:
# - name: create a complete empty file
# command: /usr/bin/touch /test/test.conf
- name: create a new file with lineinfile
@carlessanagustin
carlessanagustin / ufw_cs.md
Last active March 7, 2018 17:49 — forked from drAlberT/CS_ufw.md
UFW Cheatsheet

UFW cheat sheet

Usage

ufw [--dry-run] enable|disable|reload
ufw [--dry-run] default allow|deny|reject [incoming|outgoing]
ufw [--dry-run] logging on|off|LEVEL
    toggle logging. Logged packets use the LOG_KERN syslog facility. Systems configured for rsyslog
    support may also log to /var/log/ufw.log. Specifying a LEVEL turns logging on for the specified LEVEL.
@carlessanagustin
carlessanagustin / iptables.sh
Last active June 19, 2018 10:38 — forked from Tristor/iptables.sh
Simple IPtables script for an OpenVPN server
#!/bin/bash
# Flushing all rules
iptables -F FORWARD
iptables -F INPUT
iptables -F OUTPUT
iptables -X
# Setting default filter policy
iptables -P INPUT DROP
iptables -P OUTPUT DROP
iptables -P FORWARD DROP