notomorrow.de code

code:audio

anonymous@undisclosed.example.com (Anonymous) — Mon, 14 Jul 2014 18:36:35 +0000

#!/bin/bash
# status: hurt me plenty   <- make a BACKUP!
 
action=${1-'echo'}
dir="$2"
dir2="$3"
 
find $dir -type f | while read f; do
 
    a=$( basename "$f" )
    dn=$( dirname "$f" )
    #dokuwiki compatible filenames
    b=`expr "xxx$a" : 'xxx\(.*\)' | sed 's/@/at/' | tr '[A-Z]' '[a-z]' | tr -cs '[:alnum:]_\-.\n' '_' `
    odir=$dir2${dn#$dir}
 
    if [ $action == "ffmpeg" ]; then
        [ -d "$odir" ] || mkdir -p $odir
        echo 'ffmpeg -y -i "'$f'" -acodec vorbis "'$odir'/'$b.ogg'"'
        #ffmpeg -ab 160k -y -i "$f" -acodec vorbis "$odir/$b.ogg"
    else                                                                                                                                         
        echo "$f -> $odir/$b.ogg"
    fi
  done

code:bash

anonymous@undisclosed.example.com (Anonymous) — Thu, 05 Feb 2026 15:21:01 +0000

bash

bashrc

# settings
TZ='Europe/Berlin'; export TZ
# path
export PATH="~/bin:/sbin:/usr/sbin:/usr/local/sbin:${PATH}"
export XDG_DATA_HOME=~/.config
export XDG_CACHE_HOME=~/.cache
# sys
[ -f ~/.bash_alias ] && source ~/.bash_alias
[ -f /etc/profile.d/bash-completion ] && source /etc/profile.d/bash-completion


# editor
set -o vi
export EDITOR="vim"
umask 022

# history
export HISTFILESIZE=10000
export HISTSIZE=10000
shopt -s histappend
export HISTCONTROL=ignoredups
export LS_OPTIONS='--color=auto'
eval `dircolors $HOME/.dircolors`

# start screen
if [[ $- = *i* && -z "$STY" ]]; then exec screen -dR chat irssi; fi

snippets

# macros
  [ $1 ] || { echo -ne "\033[0m>>> usage: $0 <target>\n" >&2; exit 1; }

### pipes
## sqlite to html
  sqlite3 ex1 'select * from tbl1' | awk '{printf "<tr><td>%s<td>%s\n",$1,$2 }'

### tools
## remove html
  lynx -dump

ip and gateway

    while [ "x$INET_IPM" == "x" ]; do
       
      i=`ip a s wlan0 | grep "inet " | grep -v "169.254" | awk '{print $2}'`
      if [ "x$i" != "x" ]; then
        INET_IFACE="wlan0"
        INET_IPM="$i"
        break; fi
       
      i=`ip a s eth0 | grep "inet " | grep -v "169.254" | awk '{print $2}'`
      if [ "x$i" != "x" ]; then
        INET_IFACE="eth0"
        INET_IPM="$i"
        break; fi
       
      if [ "x$INET_IPM" == "x" ]; then                                                                                                           
        [ "x$wait" != "x" ] || echo -n "waiting for ip on $INET_IFACE .."
        echo -n "."
        wait=now
        sleep 3
      fi
    done
    echo
        
    INET_IP=${INET_IPM%/*}
    INET_GW=`ip r | grep default | awk '{print $3}'`

youtube-dl

* https://github.com/rg3/youtube-dl.git

yt.sh

#!/bin/sh
COOKIE_FILE=/var/tmp/youtube-dl-cookies.txt
for i in $*; do
  mplayer -cookies -cookies-file ${COOKIE_FILE} $(youtube-dl -g --cookies ${COOKIE_FILE} $i)
done

mysql

ex='mysql -u root -pxxx mydb -e '
min() { echo $(( $1 < $2 ? $1 : $2 )); }
i=470;m=479; while [[ "$i" -le "$m" ]]; do 
  a=$i;b=$(min $((i+2)) $m);i=$((i+3));                                                                                                        
  $ex "insert into postlabel (fsid,lsid) values ($a, $b)"; done;

echo “test?”

code:dokuwiki-sql

anonymous@undisclosed.example.com (Anonymous) — Wed, 12 Feb 2020 21:53:45 +0000

sample preload.php snippet

preload.php

$http_host  = $_SERVER['HTTP_HOST'];
if( strpos( $http_host, ':' ) !== false ) {
        list( $http_host, $http_port ) = explode( ':', $http_host );
}
$animal     = str_replace( 'www.', '', $http_host );
$request_id = $_SERVER['REQUEST_URI'];
 
require_once( $farmbasedir.'/conf/animal_alias.php' ); // normalizes animal names and stuff
 
$farmdir    = "$farmbasedir/domains/$animal/";
if( !$animal || !is_dir( $farmdir )) {
  $animal     = $farmer;
  $farmdir    = "$farmbasedir/domains/$animal/"; }
 
if( !is_dir( $farmdir )) { die( 'nofarm' ); }
define( 'FARMDIR', $farmdir );
 
if( !defined( 'DOKU_CONF' )) define( 'DOKU_CONF', DOKU_FARMDIR.'/'.$animal.'/conf/' );
if( !defined( 'ACL_DOM' )) define( 'ACL_DOM', $animal ); // for auth psql in .protected.php
if( !defined( 'ACL_TOPDOM' )) define( 'ACL_TOPDOM', 'notomorrow.de' ); // for auth psql in .protected.php
 
if( !defined( 'DOKU_CONF_DEFAULT' )) define( 'DOKU_CONF_DEFAULT', $farmbasedir.'/dokuwiki/conf/' );
if( !defined( 'DOKU_CONF' )) define( 'DOKU_CONF', $farmdir.'conf/' );
 
require_once( $farmbasedir.'/dokuwiki/inc/config_cascade.php' );
require_once( $farmbasedir.'/conf/cascade.php' );

sample farm.protected.php snippet

$conf['plugin']['authpgsql']['checkPass']   = "SELECT pass
   FROM usergroup AS ug
     JOIN users AS u ON u.uid=ug.uid
     JOIN groups AS g ON g.gid=ug.gid
   WHERE u.login='%{user}'
     AND g.name='%{dgroup}'
     AND ( u.domain='".ACL_DOM."' OR u.domain is null )
   ";
 
$conf['plugin']['authpgsql']['getUserInfo'] = "SELECT pass, fullname AS name, email AS mail
   FROM users
   WHERE lower(login)=lower('%{user}')
     AND ( domain='".ACL_DOM."' OR domain is null )
   ";
 
$conf['plugin']['authpgsql']['getGroups']   = "SELECT g.name as group
   FROM groups g, users u, usergroup ug
  WHERE u.uid = ug.uid
    AND g.gid = ug.gid
    AND u.login='%{user}'
    AND ( u.domain='".ACL_DOM."' OR u.domain is null )
    ";
 
 
$conf['plugin']['authpgsql']['getUsers']    = "SELECT DISTINCT u.login AS user
   FROM users AS u 
      LEFT JOIN usergroup AS ug ON u.uid=ug.uid
      LEFT JOIN groups AS g ON ug.gid=g.gid
      WHERE ( u.domain='".ACL_DOM."' "
        .( ACL_TOPDOM ? 'OR u.domain in ( \'"'.implode( "','", explode( ',', ACL_TOPDOM )).'\' )' : '' )
        #."OR u.domain is null"
        ." )";
$conf['plugin']['authpgsql']['FilterLogin'] = "u.login LIKE '%{user}'";                                                                                                                                                      
$conf['plugin']['authpgsql']['FilterName']  = "u.fullname LIKE '%{name}'";
$conf['plugin']['authpgsql']['FilterEmail'] = "u.email LIKE '%{email}'";
$conf['plugin']['authpgsql']['FilterGroup'] = "g.name LIKE '%{group}'";
$conf['plugin']['authpgsql']['SortOrder']   = "ORDER BY u.login";
 
$conf['plugin']['authpgsql']['addUser']     = "INSERT INTO users
    (login, pass, email, fullname, domain)
    VALUES ('%{user}', '%{pass}', '%{email}', '%{name}', '".ACL_DOM."')";
 
$conf['plugin']['authpgsql']['addGroup']    = "INSERT INTO groups (name)                                                               
    VALUES ('%{group}')";
 
$conf['plugin']['authpgsql']['addUserGroup']= "INSERT INTO usergroup (uid, gid)
     VALUES ('%{uid}', '%{gid}')";
 
$conf['plugin']['authpgsql']['delGroup']    = "DELETE FROM groups
    WHERE gid='%{gid}'";
 
$conf['plugin']['authpgsql']['getUserID']   = "SELECT uid AS id FROM users WHERE login='%{user}'
    AND ( domain='".ACL_DOM."' OR domain is null )";
 
$conf['plugin']['authpgsql']['getGroupID']  = "SELECT gid AS id FROM groups WHERE name='%{group}'";
 
$conf['plugin']['authpgsql']['delUser']     = "DELETE FROM users
    WHERE uid='%{uid}'
      AND ( domain='".ACL_DOM."' )";
 
$conf['plugin']['authpgsql']['delUserRefs'] = "DELETE FROM usergroup
      WHERE uid='%{uid}'";
 
$conf['plugin']['authpgsql']['updateUser']  = "UPDATE users SET";
$conf['plugin']['authpgsql']['UpdateLogin'] = "login='%{user}'";                                                                       
$conf['plugin']['authpgsql']['UpdatePass']  = "pass='%{pass}'";
$conf['plugin']['authpgsql']['UpdateEmail'] = "email='%{email}'";
$conf['plugin']['authpgsql']['UpdateName']  = "fullname='%{name}'";
$conf['plugin']['authpgsql']['UpdateTarget']= "WHERE uid=%{uid}";
 
$conf['plugin']['authpgsql']['delUserGroup']= "DELETE FROM usergroup
      WHERE uid='%{uid}'
        AND gid='%{gid}'";

code:dokuwiki

anonymous@undisclosed.example.com (Anonymous) — Sat, 18 Nov 2017 17:00:03 +0000

Dokuwiki

Install

git clone https://github.com/splitbrain/dokuwiki.git
vim dokuwiki/inc/preload.php
 
sudo mkdir -p /var/lib/dokuwiki/default/conf
sudo cp -r dokuwiki/data /var/lib/dokuwiki/default
sudo cp -r dokuwiki/data /var/lib/dokuwiki/default
sudo cp dokuwiki/conf/users.auth.php.dist /var/lib/dokuwiki/default/conf/users.auth.php
sudo cp dokuwiki/conf/acl.auth.php.dist /var/lib/dokuwiki/default/conf/acl.auth.php
 
sudo rsync -avv --exclude=.git* --exclude=/data --exclude=install.php dokuwiki /var/www/
sudo chown -R apache:apache /var/lib/dokuwiki/default/data
sudo chown -R apache:apache /var/lib/dokuwiki/default/conf
 
sudo yum install php
sudo service httpd restart

preload.php

<?php
if(!defined('DOKU_FARMDIR')) define('DOKU_FARMDIR', '/var/lib/dokuwiki/' );
if(!defined('DOKU_CONF')) define('DOKU_CONF', DOKU_FARMDIR.'default/conf/');  ## disableing dynamic path selection
 
include(fullpath(dirname(__FILE__)).'/farm.php');

local.protected.php

<?php
$conf["savedir"]     = DOKU_FARMDIR."default/data";
$conf["useacl"]     = 1;
$conf["autopasswd"]     = 0;
$conf["superuser"]     = "alice,@admin";

rewrites

nginx/conf.d/dokuwiki.inc

  index  index.php index.html;
 
  client_max_body_size 1600m;
  fastcgi_read_timeout 180;
 
  location ~ ^/(data|conf|bin|inc)/ { return 444; }
  location ~ /\.ht { return 444; }
 
  location = /favicon.ico {
    log_not_found off;
    access_log off; }     
  location = /robots.txt {
    allow all;
    log_not_found off;
    access_log off; }
  location ~* \.(txt|log)$ {
    deny all; }
  location ~ \..*/.*\.php$ {
    return 403; }
  location ~ /\.ht {
    deny  all; }
  location / {  
    try_files $uri @rewrite; }       
 
  location @rewrite {
     rewrite ^/$ /doku.php last;
     rewrite ^/_media/(.*)              /lib/exe/fetch.php?media=$1 last;
     rewrite ^/_detail/(.*)             /lib/exe/detail.php?media=$1 last;
     rewrite ^/_export/([^/]+)/(.*)     /doku.php?do=export_$1&id=$2 last;
 
    ## styleimg is a template confhelper feature
     rewrite ^/_img/((.*)/)?(.*)        /lib/exe/fetch.php?mode=styleimg&media=$3&template=$2 last;
     rewrite ^/images/((.*)/)?(.*)      /lib/exe/fetch.php?mode=styleimg&media=$3&template=$2 last;
    ## force styleimage for template images ( out of root templates )
     rewrite ^/lib/tpl/((.*)/)?images/(.*)      /lib/exe/fetch.php?mode=styleimg&media=$3&template=$2 last;
 
     rewrite ^/(.*)?(.*)  /doku.php?id=$1&$2 last;
     break;       
 }

php-fpm

for reverse proxy setup see nginx

/etc/nginx/sites-available-notomorrow.de

client_max_body_size 50m;
fastcgi_read_timeout 180;
 
## needed because of the reverse proxy
## x_forwarded port ans stuff is set there
 
map $http_x_forwarded_port $external_port { 
    default $http_x_forwarded_port; 
    '' $server_port; 
}        
map $http_x_forwarded_proto $external_proto { 
    '' $https; 
    'http' ''; 
    'https' 'on'; 
}        
 
server { 
        listen [::]:80 default;
        server_name notomorrow.de *.notomorrow.de;
 
        error_log  /var/log/nginx/notomorrow.error.log;
        root   /srv/dokuwiki;
        index  index.php index.html;
 
        include        conf.d/status.inc;
        include        conf.d/public.inc;
        include        conf.d/dokuwiki.inc;
        include        conf.d/notomorrow.php.inc;
}

/etc/nginx/conf.d/php.inc

location ~ \.php$ {
  fastcgi_split_path_info ^(.+\.php)(/.+)$;
  fastcgi_index  index.php;              
 
  #fastcgi_param  PATH_INFO          $fastcgi_path_info;
  #fastcgi_param  PATH_TRANSLATED    $document_root$fastcgi_path_info;
  #fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
 
  include fastcgi_params;                
 
  fastcgi_param  SERVER_PORT          $external_port;
  fastcgi_param  HTTPS                $external_proto; 
 
  fastcgi_intercept_errors on;           
  fastcgi_pass unix:/tmp/php-fpm-notomorrow.de.sock;
 
}

/etc/php/fpm/pool.d/notomorrow.de.conf

[notomorrow.de]
 
user = notomorrow-de
group = notomorrow-de
listen.owner = notomorrow-de
listen.group = notomorrow-de
listen = '/tmp/php-fpm-notomorrow.de.sock'
pm = dynamic
pm.max_children = 5
pm.start_servers = 2
pm.min_spare_servers = 1
pm.max_spare_servers = 3

code:irssi

anonymous@undisclosed.example.com (Anonymous) — Wed, 12 Mar 2014 23:48:33 +0000

irssi

commands with */* are to type in irssi. command with *#* in the shell.

screen

you will want to run irssi in screen. Screen is a windomanager.

shortintro
some commands:
- [ctrl+a c] # new window
- [ctrl+a a] # switch to last window (space ⇒ next,backspace previous)

OTR (end2end encryption)

load otr (first time)

/load otr
/statusbar window add otr

Mailing list: otr-dev@lists.cypherpunks.ca First of all, we strongly recommend to set this option to speed up any OTR commands or sessions.

/set cmd_queue_speed 1msec

initialise encryption

/msg alice ?OTR?

check fingerprint

lists all keys encountered for comparison to copy paste to your friends (there is no standardiced way for sharing keys)

/otr contexts

configure

configure irssi (in shell)

# echo "load otr" >> ~/.irssi/startup

code:mysql

anonymous@undisclosed.example.com (Anonymous) — Thu, 25 Jun 2015 06:04:57 +0000

mysql

dump

mysqldump -p --no-data  --routines --triggers test allt > allt-data.sql

export /import sh

export.sh

fields_in="email"
fields_out="@usr"
file="/tmp/ca.csv"
table="table"
 
echo "exporting $fields_in from $table"
mysql -u in -N << eof
  select $fields_in
  from $table                                                                                                                                
    into outfile '$file'                                                                                                                         
    fields enclosed by '"' terminated by ';' escaped by '"'
    lines terminated by '\r\n';
eof
[[ $? != 1 ]] || exit
 
echo "importing $fields_out from $file"
mysql -u out << eof
  load data infile '$file' ignore into table usrs 
    fields enclosed by '"' terminated by ';' escaped by '"'
    lines terminated by '\r\n'
    ( $fields_out )
    set id = @id,
      usr = @usr;
eof
[[ $? != 1 ]] || exit

-- check charsets
SELECT * FROM information_schema.SCHEMATA S;

SELECT 
    CCSA.character_set_name,CCSA.collation_name,T.table_name 
  FROM information_schema.`TABLES` T,
       information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA 
  WHERE CCSA.collation_name = T.table_collation ;
 
SELECT table_schema, table_name, column_name, character_set_name 
  FROM information_schema.`COLUMNS` C;

== php

=== utterly complicated csv output
 
<?php                                                                
 
$db = new mysqli( '','root','xxx','a');          
$res = $db->query( 'select * from t1 order by ide' );                      
 
$db_p = new mysqli( '','root','xxx','b');                   
$fp = fopen('php://output', 'w');                                    
 
while( $row = $res->fetch_assoc( )) {                                
    if( $row['id'] == 0 ) { continue; }                           
    $res_p = $db_p->query( 'select * from t2 where id = '.$row['id'] );
    $row_p = $res_p->fetch_assoc( );                                 
    if( $row_p ) {                                                   
        fputcsv($fp, array(                                          
            $row['id )); }}                                                                    
fclose($fp);

=== primitive searchfield parsing

public function search( $s ) {                                                                                                                   
 
        $q = array( ); $p = array( ); $a = array( );
 
        $s = str_replace( '*', '%', trim( $s ));
        if( !$s ) { return array( ); }
 
        foreach( explode( ' ', $s ) as $sv ) {
                if( strpos( $sv, '@' ) !== false ) {
                        $q[] = 'tix.e like ?';
                        $p[] = 's';
                        $a[] = "%$sv%";
                } else {
                    $qv = array( );
                    foreach( array( 'fn', 'ln' ) as $f ) {
                        $qv[] = "$f like ?";
                        $p[] = "s";
                        $a[] = "%$sv%";
                    }
                    $q[] = '('.implode( ' or ', $qv ).')';
                }
        }
        $q = 'select tix.*, usrs.name as crewname from tix, usrs 
                where usrs.uname=tix.parent and ('.implode( ' and ', $q ).')';
        $res = $this->sql->query( $q,$p,$a );
        return $res;
}

code:postgres

anonymous@undisclosed.example.com (Anonymous) — Wed, 10 Sep 2014 02:14:34 +0000

Postgresql Repmgr Script

preview

db setup clone and replication work
status view doesnt
loads of dead ends

ipranges bugy and useless

pgnode.sh

#!/bin/bash
 
# env
PGBIN="/usr/pgsql-9.1/bin"
PGCTL="${PGBIN}/pg_ctl"
INITDB="${PGBIN}/initdb"
PGBENCH="${PGBIN}/pgbench -i -s 1"
PSQL="psql -a -h /tmp"
 
REPMGR_USER="repmgr"
REPMGR_DB="pgbench"
REPMGR="${PGBIN}/repmgr"
REPMGRD="${PGBIN}/repmgrd"
 
#pgnode config
USER="alice"  #owner of the postgres process
PREFIX="/home/alice/pg/env"
NODE_CONF="/home/alice/pg/pgnode.conf"
 
#cluster config
CLUSTER_NAME=sirius
CLUSTER_PORT=5443
CLUSTER_IPRANGE="192.168.1.0/24"
CLUSTER_IPRANGE2="192.168.2.0/24" #FIXME, muesste mit einer range gehen
CLUSTER_IPRANGE3="10.10.1.0/24"
CLUSTER_IPRANGE4="10.10.2.0/24"
 
#cluster locations
DB_PATH="${PREFIX}/var/lib/pgsql/${CLUSTER_NAME}/data"
DB_LOG="${PREFIX}/var/lib/pgsql/${CLUSTER_NAME}/log"
DB_CONF="${PREFIX}/var/lib/pgsql/${CLUSTER_NAME}/repmgr"
 
  #ui
  rerror(){ echo $@; exit 1; }
  rinfo(){ echo -ne "\033[1;30m>\033[0;33m>\033[1;33m> \033[0m${@}\n" >&2;}
 
  #commands
  rpsql(){ $PSQL -p $CLUSTER_PORT -U $USER $REPMGR_DB -c "$1"; }
  rpsql_admin(){ $PSQL -p $CLUSTER_PORT -U $USER template1 -c "$1"; }
  rpgctl(){ $PGCTL -D ${DB_PATH} $1 >> $DB_LOG/pg.log 2>&1 & }
  rpgctl_cmd(){ $PGCTL -D ${DB_PATH} $1; }
  rpgbench(){ $PGBENCH $REPMGR_DB -h /tmp -p ${CLUSTER_PORT}; }
 rrepmgrd(){ PGENGINE=$PGBIN PATH="$PATH:$PGENGINE" $REPMGRD -f ${DB_CONF}/$db.repmgr.conf --monitoring-history --verbose >> ${DB_LOG}/repmgr.log 2>&1 & }
  rrepmgrd_log(){ tail -f ${DB_LOG}/*; }
  rrepmgrd_stop(){ pkill repmgrd; }
  rrepmgr(){ PGENGINE=$PGBIN PATH="$PATH:$PGENGINE" $REPMGR -f ${DB_CONF}/$db.repmgr.conf --verbose $@; }
  rrepmgr_asrepmgr(){ PGENGINE=$PGBIN PATH="$PATH:$PGENGINE" $REPMGR -f ${DB_CONF}/$db.repmgr.conf -U ${REPMGR_USER} --verbose $@; }
  rrepmgr_clone(){ PGENGINE=$PGBIN PATH="$PATH:$PGENGINE" $REPMGR -D ${DB_PATH} -d ${REPMGR_DB} -p ${CLUSTER_PORT} -U ${REPMGR_USER} -R ${USER} --verbose $@; }
 
  ##config (#TODO: use templates)
  configure_node( ) {
    [ "$db" ] || db=$(hostname)
    rinfo "configure nodename $db"
    ( cat <<-NEWNODE
db=$db
NEWNODE
    ) > $NODE_CONF; }
 
  configure_cluster( ) {
    rinfo "configure cluster ${CLUSTER_NAME} (port: ${CLUSTER_PORT})"
    ( cat <<-NEWPORT
listen_addresses='*'
wal_level = 'hot_standby'
archive_mode = on
archive_command = 'exit 0' # Managed by repmgr
max_wal_senders = 10
wal_keep_segments = 640     # 10 GB required on pg_xlog
#wal_keep_segments = 5000     # 80 GB required on pg_xlog
hot_standby = on
unix_socket_directory = '/tmp'
log_directory = 'pg_log'
external_pid_file = 'postgres.pid'
port=$CLUSTER_PORT
NEWPORT
    ) > ${DB_PATH}/postgresql.conf;                                                                                                              
    rinfo "configure permissions ${REPMGR_USER}@${CLUSTER_IPRANGE}"
    rinfo "configure permissions ${USER}@${CLUSTER_IPRANGE}"
    ( cat <<-DB1
local   all     $USER                                ident
host    all     $USER        127.0.0.1/32            ident
host    all     $USER        $CLUSTER_IPRANGE        trust
host    all     $USER        $CLUSTER_IPRANGE2        trust
host    all     $USER        $CLUSTER_IPRANGE3        trust
host    all     $USER        $CLUSTER_IPRANGE4        trust
host    all     $USER        ::1/128                 ident
host    ${REPMGR_DB}     ${REPMGR_USER}        127.0.0.1/32            trust
host    ${REPMGR_DB}     ${REPMGR_USER}        $CLUSTER_IPRANGE        trust
host    ${REPMGR_DB}     ${REPMGR_USER}        $CLUSTER_IPRANGE2        trust
host    ${REPMGR_DB}     ${REPMGR_USER}        $CLUSTER_IPRANGE3        trust
host    ${REPMGR_DB}     ${REPMGR_USER}        $CLUSTER_IPRANGE4        trust
host    ${REPMGR_DB}     ${REPMGR_USER}        ::1/128                 trust
host    replication     ${REPMGR_USER}        127.0.0.1/32            trust
host    replication     ${REPMGR_USER}        $CLUSTER_IPRANGE        trust
host    replication     ${REPMGR_USER}        $CLUSTER_IPRANGE2        trust
host    replication     ${REPMGR_USER}        $CLUSTER_IPRANGE3        trust
host    replication     ${REPMGR_USER}        $CLUSTER_IPRANGE4        trust
host    replication     ${REPMGR_USER}        ::1/128                 trust
DB1
    )  > ${DB_PATH}/pg_hba.conf; }
 
  configure_repmgr( ) {
    rinfo "configure replication ${DB_CONF}/$db.repmgr.conf"
    rinfo "conninfo='host=$db user=${REPMGR_USER} dbname=pgbench port=${CLUSTER_PORT}'"
    ( cat <<-RMC
cluster=${CLUSTER_NAME}
node=$db
node_name=$db
conninfo='host=$db user=${REPMGR_USER} dbname=pgbench port=${CLUSTER_PORT}'
master_response_timeout=60
reconnect_attempts=6
reconnect_interval=10
failover=automatic
priority=-1
promote_command='$REPMGR standby promote -f ${REPMGR_CONF}/$db.repmgr.conf'
follow_command='$REPMGR standby follow -f ${REPMGR_CONF}/$db.repmgr.conf -W'
RMC
    ) > ${DB_CONF}/$db.repmgr.conf; }
 
# master script                                                                                                                                  
 
  [ -f $NODE_CONF ] && source $NODE_CONF
  [ "$db" ] || configure_node
 
  rinfo "pgnode $db"
  rinfo "cluster: **${CLUSTER_NAME}** (${REPMGR_USER}@${CLUSTER_IPRANGE}:${CLUSTER_PORT})"
  rinfo "db: $DB_PATH"
 
run( ) {
 
  action=$1
  shift
 
  case $action in
    createdb)
      $INITDB ${DB_PATH}/
      install -d ${DB_LOG} ;;
    configuredb)
      configure_cluster ;;
    initdb)
      rpsql_admin "create database $REPMGR_DB"
      rpsql_admin "create role ${REPMGR_USER} login superuser"
      rpsql_admin "create role ${USER} login superuser" ;;
    db)
      [[ "$1"  ]] || rerror "$0 $action <cmd>"
      rpgctl $@ ;;
    removedb)
      rpgctl stop
      rm -vr $DB_PATH ;;
 
    bench) rpgbench ;;
 
    clone)
      [[ "$1"  ]] || rerror "$0 $action <node>"
      rrepmgr_clone standby clone $1 ;;
    forceclone)
      [[ "$1"  ]] || rerror "$0 $action <node>"
      rrepmgr_clone --force standby clone $1 ;;
 
    configure)
      install -d ${DB_LOG}
      install -d ${DB_CONF}
      configure_repmgr ;;
 
    standby)
        [[ "$1"  ]] || rerror "$0 $action <register,clone,follow,promote>"
      rrepmgr standby $@ ;;
    master)
        [[ "$1"  ]] || rerror "$0 $action <register>"
      rrepmgr master $@ ;;
    cluster)
        [[ "$1"  ]] || rerror "$0 $action <show,cleanup>"
      rrepmgr master $@ ;;
 
    start)
      rrepmgrd ;;
    stop)
      rrepmgrd_stop ;;
    monitor)
      rrepmgrd_log ;;
    status)
      #rpsql "select * from repmgr_${CLUSTER_NAME}.repl_monitor"
      rpsql "select * from repmgr_${CLUSTER_NAME}.repl_nodes"
      rpsql "select * from repmgr_${CLUSTER_NAME}.repl_status" ;;
    cleanup)
      rrepmgr cluster cleanup -k 1 ;;
    *)
      echo "$0 <createdb,configouredb,removedb,db,init,status,bench>" ;;
  esac
}
 
run $@

code:rsyslogd

anonymous@undisclosed.example.com (Anonymous) — Tue, 08 Apr 2014 00:09:18 +0000

rsyslogd

remote logs

server:

--snip--
$ModLoad imudp
$UDPServerAddress 10.5.0.70
$UDPServerRun 5140
--snip--

client

--snip--
#### custom RULES ####
auth,authpriv.*                 /var/log/auth.log
auth,authpriv.*                 ~

*.*     @10.5.0.70:5140

if $syslogfacility-text == 'local6' and $programname == 'apache2' then /var/rlog/httpd-access.log
if $syslogfacility-text == 'local6' and $programname == 'apache2' then ~
if $syslogfacility-text == 'local7' and $programname == 'apache2' then /var/rlog/httpd-error.log
if $syslogfacility-text == 'local7' and $programname == 'apache2' then ~

$IncludeConfig /etc/rsyslog.d/*.conf

#### RULES ####

#
# First some standard log files.  Log by facility.
#
*.*;auth,authpriv.none          -/var/log/syslog

#cron.*                         /var/log/cron.log
daemon.*                        -/var/log/daemon.log
kern.*                          -/var/log/kern.log
lpr.*                           -/var/log/lpr.log
mail.*                          -/var/log/mail.log
user.*                          -/var/log/user.log