Skip to content

Instantly share code, notes, and snippets.

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

Chris Fidao fideloper

🏠
Working from home
View GitHub Profile
@fideloper
fideloper / install_mysql.sh
Last active July 1, 2020 10:13
instal mysql5.7 non-interactive on ubuntu 14.04
#!/usr/bin/env bash
# This is assumed to be run as root or with sudo
export DEBIAN_FRONTEND=noninteractive
# Import MySQL 5.7 Key
# gpg: key 5072E1F5: public key "MySQL Release Engineering <mysql-build@oss.oracle.com>" imported
apt-key adv --keyserver ha.pool.sks-keyservers.net --recv-keys 5072E1F5
echo "deb http://repo.mysql.com/apt/ubuntu/ trusty mysql-5.7" | tee -a /etc/apt/sources.list.d/mysql.list
@fideloper
fideloper / exec_file.js
Created January 4, 2016 20:41
Execute a shell script
// Import fs (filesystem)
var chmodSync = require('fs').chmodSync;
// Import execFile, to run our bash script
var execFile = require('child_process').execFile;
chmodSync('./build.sh', 0755);
var execOptions = {
maxBuffer: 1024 * 1024 * 5 // Increase max buffer to 5mb
};
@fideloper
fideloper / install_mysql.sh
Last active April 30, 2016 07:26
Install MySQL 5.7 (dev, not general availability)
#!/usr/bin/env bash
ROOT_USER_PASS='root'
sudo apt-get update
sudo apt-get install -y vim curl tmux wget unzip zip htop
sudo apt-key adv --keyserver ha.pool.sks-keyservers.net --recv-keys A4A9406876FCBD3C456770C88C718D3B5072E1F5
sudo cat > /etc/apt/sources.list.d/mysql.list <<EOL
@fideloper
fideloper / http_request.json
Created August 29, 2015 13:56
http request
{
"_index": "http-access-2015.08.28",
"_type": "fluentd",
"_id": "AU91sX8H3fvMhMs_8892",
"_score": null,
"_source": {
"remote": "45.55.237.56",
"host": "-",
"user": "-",
"method": "\\x16\\x03\\x01\\x010\\x01\\x00\\x01,\\x03\\x03\\x18\\x1B\\x85\\xAA\\x81\\xA7\\x91\\x1F\\xDA\\xCA1rg+\\xB0\\x1F\\x94\\xF3\\xE9\\x03\\xB5\\x80$g*\\x18\\xEFeAv\\xDES\\x00\\x00\\x96\\xC00\\xC0,\\xC0(\\xC0$\\xC0\\x14\\xC0",
@fideloper
fideloper / gist:8bc66ce0102fdc98f030
Created June 10, 2015 16:47
Apache redirect http to https
<VirtualHost *:80>
ServerName site.example.com
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{HTTPS} !=on
RewriteRule ^(.*)$ https://%{HTTP_HOST}/$1 [R=301,L]
</IfModule>
</VirtualHost>
<VirtualHost *:443>
@fideloper
fideloper / nginx.conf
Last active February 15, 2017 22:09
Nginx redirects
server {
# ...
# Redirect /book and any sub-uris
# e.g. /book/anything
# e.v. /book/whatever?maybe=a_query_too
location /book {
return 301 http://book.serversforhackers.com;
}
@fideloper
fideloper / stupid_sample.rb
Created June 8, 2015 00:17
just a printed string
print "This is whatever"
@fideloper
fideloper / crypt.py
Created June 4, 2015 13:52
Decrypt Laravel-encrypted value
import os
import base64
import json
from Crypto.Cipher import AES
from phpserialize import loads
def decrypt(payload):
data = json.loads(base64.b64decode(payload))
@fideloper
fideloper / gist:0dfb4491ffefba6766eb
Created May 28, 2015 12:26
nginx cache secondary php location
fastcgi_cache_path /tmp/cache levels=1:2 keys_zone=images:100m inactive=60m;
fastcgi_cache_key "$scheme$request_method$host$request_uri";
server {
listen 80 default_server;
listen [::]:80 default_server ipv6only=on;
#root /usr/share/nginx/html;
root /var/www/html;
index index.html index.htm;
sql_query = SELECT topic_id, topic FROM topics
# joined/payload field fetch query
# joined fields let you avoid (slow) JOIN and GROUP_CONCAT
# payload fields let you attach custom per-keyword values (eg. for ranking)
sql_joined_field = post from query; \
SELECT topic_id, post \
FROM posts \
ORDER BY topic_id ASC