Skip to content

Instantly share code, notes, and snippets.

View opistola's full-sized avatar

Sergio Pinto opistola

View GitHub Profile
@opistola
opistola / create_layer_aws_lambda
Created February 6, 2021 13:14
create layear for aws lambda
#
# This are the steps to create a folder with dependencies for a specific python version for AWS lambda
#
# create a folder
mkdir folder1
# now run docker to
docker run --rm -v `pwd`:/var/task:z lambci/lambda:build-python3.8 python3.8 -m pip --isolated install -t folder1 pdpyras simple-salesforce
@opistola
opistola / gist:5da528ac84429fc3964a70ac9442d18d
Created September 22, 2019 13:18
Docker set user with limited permissions
# substitute app with anything you want
RUN addgroup --gid 10001 app
RUN adduser --gid 10001 --uid 10001 --home /app --shell /sbin/nologin --disabled-password app
@opistola
opistola / calculate_size_mysql.sql
Created April 15, 2018 11:47
Calculate the size of a Mysql database
# single database
SELECT SUM(((DATA_LENGTH + INDEX_LENGTH)/1024/1024)) AS "MB"
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = "wordpress";
# all instance
SELECT TABLE_SCHEMA as 'Database',
SUM(((DATA_LENGTH + INDEX_LENGTH)/1024/1024)) AS "MB"
FROM INFORMATION_SCHEMA.TABLES
@opistola
opistola / docker-compose.yml
Created March 28, 2017 11:41
l4d composer docker
nginx:
image: 'bitnami/nginx'
ports:
- '8080:80'
links:
- phpfpm
volumes:
- ./logs/access.log:/opt/bitnami/nginx/logs/myapp-access.log
- ./logs/error.log:/opt/bitnami/nginx/logs/myapp-error.log
- ./nginx/app.conf:/bitnami/nginx/conf/vhosts/app.conf
@opistola
opistola / ssh-to-docker-container
Created December 20, 2016 20:15
Add ssh to a docker container
FROM ubuntu:16.04
MAINTAINER Sven Dowideit <SvenDowideit@docker.com>
RUN apt-get update && apt-get install -y openssh-server
RUN mkdir /var/run/sshd
RUN echo 'root:screencast' | chpasswd
RUN sed -i 's/PermitRootLogin prohibit-password/PermitRootLogin yes/' /etc/ssh/sshd_config
# SSH login fix. Otherwise user is kicked off after login
RUN sed 's@session\s*required\s*pam_loginuid.so@session optional pam_loginuid.so@g' -i /etc/pam.d/sshd
@opistola
opistola / jquery_no_follow
Created November 30, 2012 12:38
Jquery script to add rel="nofollow" to all likes besides the current domain
$('a').each(function()
{
var reg_exp = new RegExp('/' + window.location.host + '/');
if (!reg_exp.test(this.href))
{
// External Link Found
$(this).attr('rel','nofollow');
}
});
@opistola
opistola / OSX - Development
Created September 28, 2011 09:23
OSX Development Environment
# install macports
# update hostname + /etc/host
sudo hostname dw-mbp-home
# add user account + configure keys in sshd_config + add ssh key