Skip to content

Instantly share code, notes, and snippets.

View fabiotatsuo's full-sized avatar

Fabio Tatsuo fabiotatsuo

View GitHub Profile
@fabiotatsuo
fabiotatsuo / rollup-async-await.md
Last active May 26, 2020 02:33
Rollup 2.10.9 async/await
List all users
SELECT user, host FROM mysql.user;
Delete user
DROP USER 'user'@'host';
Create user
CREATE USER 'username'@'host' IDENTIFIED WITH mysql_native_password BY 'psswd';
Grant privileges on db
Files
1) ~/.iterm2_shell_integration.bash
2) vim ~/.profile
test -e "${HOME}/.iterm2_shell_integration.bash" && source "${HOME}/.iterm2_shell_integration.bash"
@fabiotatsuo
fabiotatsuo / deploy.sh
Last active April 24, 2019 03:39
acme-client deploy.sh customize to HAProxy with SSL Termination and multiple domains
#!/bin/sh
# This script copy fullchain.pem and privkey.pem to concatanate and make the CRT pem
# Separate domains by whitespace in DOMAIN_LIST
# CRT pem are stored at /usr/local/etc/haproxy/ssl for HAProxy use, change if you want a different dir
# ACMEDIR is the location for files produced by acme-client /usr/ports/security/acme-client/
set -e
TODAY=`date +"%Y%m%d"`
@fabiotatsuo
fabiotatsuo / gist:6101750
Last active April 8, 2018 12:01
Pip install django nonrel branch
pip install git+https://github.com/django-nonrel/django@nonrel-1.5-beta
pip install git+https://github.com/django-nonrel/djangotoolbox@toolbox-1.5-beta
pip install git+https://github.com/django-nonrel/mongodb-engine@mongodb-engine-1.5-beta
@fabiotatsuo
fabiotatsuo / gist:7a55c29635594cc7a25618b5cb456f5e
Created July 26, 2017 03:50
Loading and unloading services OS X
Check services
$ cd ~/Library/LaunchAgents/
Load
$ launchctl load $PATH_TO_LIST
Unload
$ launchctl unload $PATH_TO_LIST
https://robots.thoughtbot.com/starting-and-stopping-background-services-with-homebrew
@fabiotatsuo
fabiotatsuo / gist:f78a79a69535b178c679fda2417b3720
Last active July 13, 2017 01:43
Remove spam on wordpress approved comments
SPAM Wordpress Comments
Check spam on approved comments
Install Askimet
Turn approved to pending
update wp_comments set comment_approved='0' WHERE comment_approved='1'
Run Askimet
let g:mapleader=' '
syntax on
set clipboard=unnamed
set cursorline
set encoding=utf-8
set guifont= "Menlo:12"
set history=1000 "Store :cmdline history
set laststatus=2
set mouse=a
set number " line numbering
Create superuser
$ createuser -P -s -e username
psswd:
$ psql -U username
List databases
postgres=# \l
\q: Quit/Exit
Swap file
dd if=/dev/zero of=/usr/swap0 bs=1m count=4096
chmod 0600 /usr/swap0
echo "md99 none swap sw,file=/usr/swap0,late 0 0" >> /etc/fstab
swapon -aL