asanchez75

global
  maxconn 4096

defaults
  mode http
  balance roundrobin
  option redispatch
  option forwardfor

  timeout connect 5s

asanchez75

2018-08-20: Postgres failure

What happened

The PostgreSQL container stopped unexpectedly, was automatically restarted, but suddenly didn't accept any connections anymore. Neither from the API service containers nor from the Macbook over the internet.

Error in logs:

FATAL:  pg_hba.conf rejects connection for host "10.0.1.2", user "postgres", database "******", SSL off

asanchez75

# Below are the dependencies required for installing the common combination of numpy, scipy, pandas and matplotlib 
# in an Alpine based Docker image.
FROM alpine:3.4
RUN echo "http://dl-8.alpinelinux.org/alpine/edge/community" >> /etc/apk/repositories
RUN apk --no-cache --update-cache add gcc gfortran python python-dev py-pip build-base wget freetype-dev libpng-dev openblas-dev
RUN ln -s /usr/include/locale.h /usr/include/xlocale.h
RUN pip install numpy scipy pandas matplotlib

asanchez75

docker run  -v /Users/mbreese/tmp:/tmp1 -w /tmp1 -i centos:7 /bin/bash -s <<EOF 
date > foo
echo 'foo' >> foo
cat /etc/redhat-release >> foo
whoami >> foo
EOF

asanchez75

CREATE OR REPLACE FUNCTION ontosides.group_enrolment_date(name text, alias text, createdat date, updatedat date) RETURNS text as  
$$
DECLARE result text;
BEGIN

  IF name ~ '.*([0-9]{4}).*([0-9]{4}).*' THEN     
    IF name like '%2013%' and name like '%2014%'THEN
      result := '2013-2014'; 
    END IF;
    IF name like '%2014%' and name like '%2015%'THEN

asanchez75

#!/bin/bash
# Steps to build and install tmux from source on Ubuntu.
# Takes < 25 seconds on EC2 env [even on a low-end config instance].
export VERSION=2.5
sudo apt-get -y remove tmux && \
sudo apt-get -y install wget tar libevent-dev libncurses-dev && \
wget https://github.com/tmux/tmux/releases/download/${VERSION}/tmux-${VERSION}.tar.gz && \
tar xf tmux-${VERSION}.tar.gz && \
rm -f tmux-${VERSION}.tar.gz && \
cd tmux-${VERSION} && \

asanchez75

set -g pane-active-border-bg default
set -g pane-active-border-fg "colour14"
set -g pane-border-fg "colour239"

set -g message-fg black
set -g message-bg "colour14"

set -g status-justify left
set -g status-bg "colour236"
set -g status-fg "colour14"

asanchez75

#!/bin/sh
# install needed curl package
sudo apt install --no-install-recommends curl  -y
# install kubectl
curl -Lo /tmp/kubectl https://storage.googleapis.com/kubernetes-release/release/$(curl -s https://storage.googleapis.com/kubernetes-release/release/stable.txt)/bin/linux/amd64/kubectl && \
 chmod +x /tmp/kubectl && \
 sudo mv /tmp/kubectl /usr/local/bin/kubectl
# kubectl tab completion
sudo sh -c 'echo "source <(kubectl completion bash)" > /etc/bash_completion.d/kubectl'
# install needed packages for kvm (see https://github.com/kubernetes/minikube/blob/master/docs/drivers.md#kvm2-driver)

asanchez75

#!/bin/sh

cd ~/proj/root

tmux new-session -d -s pdev

tmux new-window -t pdev:1 -n shell 
tmux rename-window -t pdev:1 "shell"
tmux send-keys -t pdev:1 "workon pdev" Enter "PS1=\$_OLD_VIRTUAL_PS1" Enter "clear" Enter

asanchez75

#!/usr/bin/env bash

# https://docs.docker.com/install/linux/docker-ce/ubuntu/
sudo apt-get install apt-transport-https ca-certificates curl software-properties-common
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -
sudo add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu xenial stable"
sudo apt-get update
sudo apt-get install docker-ce

# https://docs.docker.com/compose/install/