nk23x

global
    maxconn     10000 # Total Max Connections. This is dependent on ulimit
    nbproc      2

defaults
    mode        http
    option      redispatch
    maxconn     2000
    contimeout  5000
    clitimeout  50000

nk23x

#!/bin/bash

##
## patterns copied from 
##   https://raw.githubusercontent.com/staxmanade/ExceptionMessageBeautifier/master/src/ExceptionMessageBeautifier.js 
## see also:
##   https://superuser.com/a/747905
##

PERL_CMD="perl -pe 's/   at/\\r\\n   at/g; s/ ---> /\\r\\n ---> /g; s/\) at /\\r\\n at /g; s/ --- End of inner exception stack trace ---/\\r\\n   --- End of inner exception stack trace ---/g;'"

nk23x

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

nk23x

    mkfifo reply
    ncat -kl 8765 < reply | ncat 127.0.0.1 4567 > reply # listens on port 8765 and redirects to localhost:4567. Runs until C-c.
    rm reply # cleanup after end

nk23x

My Openshift Cheatsheet

Openshift build secrets for cloning git repos using SSH Keys

• To create ssh secret:

oc create secret generic sshsecret \
    --from-file=ssh-privatekey=$HOME/.ssh/id_rsa

nk23x

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

nk23x

-- Create a group
CREATE ROLE readaccess;

-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

-- Grant access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

nk23x

How to setup your own CA with OpenSSL

For educational reasons I've decided to create my own CA. Here is what I learned.

First things first

Lets get some context first.

nk23x

## https://www.gravatar.com/avatar/[sha1 hash]?d=retro
## if needed use f.e. https://sha1generator.de/ to create sha1 hash
RewriteRule ^shavatar/(.*)$ https://www.gravatar.com/avatar/$1?d=retro

nk23x

Common Options

-#, --progress-bar Make curl display a simple progress bar instead of the more informational standard meter.

-b, --cookie <name=data> Supply cookie with request. If no =, then specifies the cookie file to use (see -c).

-c, --cookie-jar <file name> File to save response cookies to.