Skip to content

Instantly share code, notes, and snippets.

View drAlberT's full-sized avatar

Emiliano 'AlberT' Gabrielli drAlberT

View GitHub Profile
@drAlberT
drAlberT / w3setperms.sh
Last active February 3, 2016 09:43
Simple bash script for docroot permissions setting on Linux
#!/bin/bash
#
# @author Emiliano Gabrielli <[email protected]>
# @license MIT
#
BASE_DIR="${BASE_DIR:=.}"
WRT_DIRS="${WRT_DIRS:=}"
HTTPD_USR=`ps aux | grep -E '[a]pache|[h]ttpd|[_]www|[w]ww-data|[n]ginx' | grep -v root | head -1 | cut -d\ -f1`
@drAlberT
drAlberT / CS_SSL-certs.md
Last active November 13, 2016 05:39
SSL certificates cheatsheets

SSL certificates CheatSheet

Quick reference for SSL certificate workflow handling for commonly used commercial SSL products

General purpose commands

Generate

  • Generate a new private key
@drAlberT
drAlberT / CS_git-commands-reference.md
Last active December 16, 2017 15:55
Git / GitHub CheatSheet

Git / GitHub CheatSheet

Quick reference for git / GitHub daily workflow

Git

create branches

  • create the local branch
#
# /usr/local/bin/listAliasByDomain
#
# Lists all aliases for mailboxes and distribution lists associated with a particular domain
#
# Syntax: listAliasByDomain someMailDomain.com
#
# The settings for the LDAP queries are guesses. They work for me, but if I have overlooked
# something, please let me know!
#
@drAlberT
drAlberT / CS_ufw.md
Last active November 1, 2024 23:05
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.
@drAlberT
drAlberT / drAlberT.md
Last active March 8, 2016 11:12
onename-verify
<?php
define('FORCE_HTTPS', true); //set true if you want only https
//@see https://github.com/maxmind/geoip-api-php
define('GI_INCLUDE_PATH', __DIR__.'/includes/geoip');
require_once GI_INCLUDE_PATH.'/geoip.inc.php';
//XXX to be improved
$languages = array('en', 'it', 'de'); //first is default
#!/bin/bash
# Shell script to make a locally browseable version of a given URL
#
# @author Emiliano Gabrielli <[email protected]>
# @license MIT
LC_ALL=C
LANG=C
FONT_DEF=$'\033[0m'
@drAlberT
drAlberT / php-cs-fixer-git-hook.sh
Last active February 28, 2017 09:26
pre-receive / pre-commit git hook for PHP-CS-fixer
#!/bin/bash
FIXER_BIN=$(which php-cs-fixer.phar)
CFG_FILE=".php_cs"
COMMAND="${FIXER_BIN} fix --config=${CFG_FILE} -vvv --path-mode=intersection --dry-run --no-ansi"
TMP_DIR="$(mktemp -d -t CS-FIX.XXXXXXXXX)"
function do_cleanup {
@drAlberT
drAlberT / group-by-ip.sql
Created August 17, 2017 10:36 — forked from bennadel/group-by-ip.sql
Grouping The MySQL PROCESSLIST By IP Address To View Connection Counts
SELECT
tmp.ipAddress,
-- Calculate how many connections are being held by this IP address.
COUNT( * ) AS ipAddressCount,
-- For each connection, the TIME column represent how many SECONDS it has been in
-- its current state. Running some aggregates will give us a fuzzy picture of what
-- the connections from this IP address is doing.
FLOOR( AVG( tmp.time ) ) AS timeAVG,