Skip to content

Instantly share code, notes, and snippets.

View guedressel's full-sized avatar

guedressel guedressel

  • Protobyte GmbH
  • Vienna
View GitHub Profile
@guedressel
guedressel / reset-sticky-group-permission.sh
Last active January 24, 2018 11:53
Resets permissions of a directory to have guid set on directories and everything group writable (recursively)
#!/bin/bash
find . -type d -exec chmod u=rwx,g=rwxs,o=rx {} \;
find . -type f -exec chmod g-s {} \;
@guedressel
guedressel / postgres-privileges-cheat-sheet
Last active September 24, 2021 19:31
Boilerplate DCL statements handy for PostgreSQL databases
CREATE DATABASE test OWNER postgres;
# connect to db test and stay connected for rest of statements in this file.
\c test
# prevent unauthorized access
REVOKE ALL ON DATABASE test FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM PUBLIC;
# create "groups" (read: ROLES)
@guedressel
guedressel / freistilbox-deploy-check.py
Last active March 27, 2018 17:09
Freistilbox utils
#!/usr/bin/env python3
import os
import sys
import re
import argparse
from datetime import timedelta
from datetime import datetime
@guedressel
guedressel / freistilbox-d7.htaccess
Last active May 18, 2018 08:21
Freistilbox Drupal 7 .htaccess
#
# Apache/PHP/Drupal settings:
#
# Protect files and directories from prying eyes.
<FilesMatch "\.(engine|inc|info|install|make|module|profile|test|po|sh|.*sql|theme|tpl(\.php)?|xtmpl)(~|\.sw[op]|\.bak|\.orig|\.save)?$|^(\.(?!well-known).*|Entries.*|Repository|Root|Tag|Template|composer\.(json|lock))$|^#.*#$|\.php(~|\.sw[op]|\.bak|\.orig\.save)$">
<IfModule mod_authz_core.c>
Require all denied
</IfModule>
<IfModule !mod_authz_core.c>
@guedressel
guedressel / google-drive-ocamlfuse-cache-stats
Created September 11, 2019 07:07
google-drive-ocamlfuse cache stats
Size (`du -a`) Path
----------------------------------------------------------------
19166316 .../.gdfuse/.../cache
517332 .../.gdfuse/.../cache/1iSEffpqIA4IMrTbHqzqpBtPXtAie9Vw9
516288 .../.gdfuse/.../cache/1kMIDRr3A_ZSgjmaRhCU-cO76R43M4Yey
514780 .../.gdfuse/.../cache/1A87e7yxr3ixhRp1QsGB3TFwM8HnMx_Op
514776 .../.gdfuse/.../cache/1mq-FOxCOJiguOsn-TkDZzjA7C-4JgFp3
514452 .../.gdfuse/.../cache/1Q8GQXRnH0DbuWgQX6JpUgyjHvDiTgaqE
514344 .../.gdfuse/.../cache/1hJlp9Sq6Pxrdlpf_1ODbkhZzJhFqWyb_
514096 .../.gdfuse/.../cache/1ss1_KZQFazZGDn0A_DmbgOFo82kr_Pwo