path: root/db/data.sql

INSERT INTO posts (
    title,
    body,
    created_at,
    updated_at
)
VALUES

(
    'Succinct Description of UTF-8 Encoding',
    'UTF-8 is actually a pretty neat way to encode text. Its clever design leads to several interesting
properties. Notably of which, at least to me, is that all ASCII files are already UTF-8 encoded.

      Unicode code points    |       UTF-8 encoding (binary)
    --------------------------------------------------------------
            00-7F ( 7 bits)  |                            0tuvwxyz
        0080-07FF (11 bits)  |                   110pqrst 10uvwxyz
        0800-FFFF (16 bits)  |          1110jklm 10npqrst 10uvwxyz
    010000-10FFFF (21 bits)  | 11110efg 10hijklm 10npqrst 10uvwxyz',
    TO_TIMESTAMP(1303776000)::DATE,
    TO_TIMESTAMP(1303776000)::DATE
)
,
(
    'A Solid Breakdown of the Linux Font Rendering Stack',
    '[This](https://freddie.witherden.org/pages/font-rasterisation "A Treatise on Font Rasterisation With an Emphasis on Free Software")
article saved me. Explains hinting and anti-aliasing quite well, also includes an excellent description of the Linux 
font rendering stack.',
    TO_TIMESTAMP(1303776000)::DATE,
    TO_TIMESTAMP(1303776000)::DATE
)
,
(
    'gvim + ibus woes / building gvim from source',
    'My main development machine is running Ubuntu 12.04 and for a while now I''ve had issues with using gvim 7.3.x in 
conjunction with ibus. Specifically upon starting gvim there''s a long start up latency (30s+) while the ibus daemon
is running. Shutdown the ibus daemon and gvim starts up near instantly. 
[Here](https://bugs.launchpad.net/ubuntu/+source/vim/+bug/987707) is the ticket describing the issue in more 
detail in [Launchpad](https://launchpad.net/)

Yesterday vim 7.4 was just released and according to the aforementioned ticket the issue was resolved in 7.3.530.
Unfortunately neither vim 7.4 nor 7.3.530 are yet in the Ubuntu repos, so I decided to build 7.4 from source. 
Along the way I''ll attempt to jot down some notes here for my future self.

I didn''t know before I began, but gvim is actually built from the same source tree as vim source. Before we start, we''ll need 
to make sure we have all the necessary development libraries required to build gvim. Ubuntu docs suggest the following 
command should work -- I can''t say for sure as I had a lot of requisite development libraries installed as other projects 
I''m working on depend on them as well.

    ~ $ sudo apt-get build-dep vim

We''ll need mercurial to pull down the latest vim sources. I''m going to build the sources in my `~/working` directory.
Since I doubt I''ll need the repo metadata (the included `.hg` directory) so I''ll remove that to reclaim a little space.

    ~ $ sudo apt-get install mercurial
    ~ $ cd ~/working/
    ~/working $ hg clone https://vim.googlecode.com/hg/ vim
    ~/working $ cd vim
    ~/working/vim $ du -sh
    139M	.
    ~/working/vim $ rm -rf .hg
    ~/working/vim $ du -sh
    65M	.

Then to build, change into the `src` directory and run configure with the options below. I want to build with pretty 
much all the features so I''ll go with the option `--with-features=huge`; optionally you can use tiny, small, normal, or big
instead; a breakdown of the differences is given [here](http://www.drchip.org/astronaut/vim/vimfeat.html). The options 
of the form `--enable-XXXinterp` are support for vim plugins written in XXX. The `--enable-gui=gtk2` option is 
obviously for gvim support.

    ~/working/vim $ cd src
    ~/working/vim $ ./configure --with-features=huge --enable-rubyinterp  \
                               --enable-pythoninterp --enable-perlinterp \
                               --enable-luainterp --enable-gui=gtk2

Once the configuration script runs without errors, we can then build with make. Note the `VMRUNTIMEDIR` variable passed
to make. This is the location of default system runtime director for vim plugins, docs, dictionaries, etc... for Ubuntu.

    ~/working/vim $ make VIMRUNTIMEDIR=/usr/share/vim/vim73

At this point one could optionally install vim on their system using the typical `make install` target. But 
this feels dirty to me. Plus I prefer to keep all my development tools installed within my home directory. This makes migrating my 
my development environment much less painful. So I''ll define an alias in my `~/.bashrc` and be good to go.

    ~/working/vim $ alias | grep gvim
    alias gvim=''~/working/vim/src/vim -g -p''

やった！',
    TO_TIMESTAMP(1376179200)::DATE,
    TO_TIMESTAMP(1376179200)::DATE
)
,
(
    'Shell Wildcard Channel Attacks',
    'Using wildcards with a shell can open you up to channeling attacks (for example, sql injection is a type of channeling attack).
When using the `*` wildcard in particular in a directory containing argument-like-filenames (e.g. `-rf`) can lead to wild results.

zum Beispiel:

    [root@defensecode public]# ls -al
    total 20
    drwxrwxr-x.  5 leon   leon   4096 Oct 28 17:04 .
    drwx------. 22 leon   leon   4096 Oct 28 16:15 ..
    drwxrwxr-x.  2 leon   leon   4096 Oct 28 17:04 DIR1
    drwxrwxr-x.  2 leon   leon   4096 Oct 28 17:04 DIR2
    drwxrwxr-x.  2 leon   leon   4096 Oct 28 17:04 DIR3
    -rw-rw-r--.  1 leon   leon      0 Oct 28 17:03 file1.txt
    -rw-rw-r--.  1 leon   leon      0 Oct 28 17:03 file2.txt
    -rw-rw-r--.  1 leon   leon      0 Oct 28 17:03 file3.txt
    -rw-rw-r--.  1 nobody nobody    0 Oct 28 16:38 -rf

    [root@defensecode public]# rm *
    [root@defensecode public]# ls -al
    total 8
    drwxrwxr-x.  2 leon   leon   4096 Oct 28 17:05 .
    drwx------. 22 leon   leon   4096 Oct 28 16:15 ..
    -rw-rw-r--.  1 nobody nobody    0 Oct 28 16:38 -rf

Because `rm *` expands to:

    [user@defensecode WILD]$ rm DIR1 DIR2 DIR3 file1.txt file2.txt file3.txt -rf

This type of attack used in conjunction with seemingly innocuous utilities like `tar` can lead to execution of arbitrary commands.',
    TO_TIMESTAMP(1408579200)::DATE,
    TO_TIMESTAMP(1408579200)::DATE
)
,
(
    'Debugging CGI / CGit',
    'I''ve been using CGit as a [git web front-end](http://bunkergate.org/cgit) for a bit now and just recently started
looking into customizing the root header. Assuming I''d have to hack the code to do so, I decided to pull down the source and build it.

    ~ $ git clone http://git.zx2c4.com/cgit/
    ~ $ cd cgit/
    ~/cgit $ make get-git && make

After perusing
`cgit.c` and `ui-shared.c` I was pleasantly surprised to find I wouldn''t have to hack anything; it seems
that just about everything I wanted to change was configurable via the cgit config file (default: `/etc/cgitrc`).
For example for changing the root title and description, just set `root-title` and `root-desc`:

    ~ $ grep ''root'' /etc/cgitrc
    root-title=bunkergate.org
    root-desc=git repository browser

This worked fine, but what about changing the logo? Just overwriting the `logo.png` in the resources directory should work,
but I want to use an animated gif. The file extension then would be technically incorrect, the worst kind of incorrect. Fortunately, it
too looks like this could be set with `logo` in `cgitrc` as well. But this didn''t seem to work. What''s going on?

To run cgit from the CLI, simply do the following. HTML output is printed to stdout and errors are printed to stderr.
This will generate the root index content.

    ~/cgit $ CGIT_CONFIG="./cgitrc" ./cgit 1>stdout.html 2>stderr.log

As an example, to see the content generated for a specific repo, do the following:

    ~/cgit $ CGIT_CONFIG="./cgitrc" QUERY_STRING="url=bunkergate" ./cgit 1>stdout.html 2>stderr.log
    ~/cgit $ CGIT_CONFIG="./cgitrc" QUERY_STRING="url=bunkergate/tree/index.html" ./cgit 1>stdout.html 2>stderr.log

It''s worth noting that this is probably a basic template for debugging any CGI.

Setting `logo` in the configuration file
didn''t seem to have the desired effect. How can we see what''s going on? Simple, run it in GDB:

    ~/cgit $ CGIT_CONFIG="./cgitrc" QUERY_STRING="url=bunkergate/tree/index.html" gdb ./cgit

So what was happening? Well after setting a watchpoint on `ctx.cfg.logo` I noticed something peculiar. The variable was getting set to
the value I expected, but then later it was getting set yet again to the undesired value. Turns out that the problem was that I had set
`logo` twice in the configuration file. Ugh.',
    TO_TIMESTAMP(1409011200)::DATE,
    TO_TIMESTAMP(1409011200)::DATE
)
,
(
    'Sideloading Nexus Devices with the Android SDK',
    'Android 5.0 "Lollipop" was released yesterday and I wanted to check it out on my Nexus 7 2013 WiFi tablet without having to wait for the update to be pushed.
I''ve done this several times with various Nexus devices now, but so infrequently that I always have to look up how to do it. So this time I''m taking
some notes. It should be noted that most of this information is just scraped from the `flash-all.{bat,sh}` included in the factory image.

First off, Nexus factory images are listed [here](https://developers.google.com/android/nexus/images). Start off by pulling the proper
one down, verifying the integrity, and then extracting the tarball:

    ~ $ mkdir tmp && cd tmp && wget -q https://dl.google.com/dl/android/aosp/razor-lrx21p-factory-ba55c6ab.tgz
    ~/tmp $ md5sum razor-lrx21p-factory-ba55c6ab.tgz 
    fd868b03bd00074dd7f70e31ad73b25a  razor-lrx21p-factory-ba55c6ab.tgz
    ~/tmp $ tar xf razor-lrx21p-factory-ba55c6ab.tgz 
    ~/tmp $ ls razor-lrx21p
    bootloader-flo-flo-04.04.img  flash-all.bat  flash-all.sh  flash-base.sh  image-razor-lrx21p.zip

To start the bootloader will need to be unlocked. This will wipe the data on the device, but once unlocked this is no longer an issue when flashing
in the future. Sideloading the image requires the [Android SDK platform tools](http://developer.android.com/tools/sdk/tools-notes.html).

First thing''s first: get into the bootloader. Begin by plugging the tablet into the PC and verifying that it''s connected.

    ~/android-studio/sdk/platform-tools $ ./adb devices -l
    List of devices attached 
    0a16e983               device usb:1-1.2 product:razor model:Nexus_7 device:flo

Now reboot into the bootloader:

    ~/android-studio/sdk/platform-tools $ ./adb reboot bootloader

Once in the bootloader make sure the device is connected/detected:

    ~/android-studio/sdk/platform-tools $ sudo ./fastboot devices -l
    0a16e983               fastboot usb:1-1.2

If the bootloader is not already unlocked this will need to be done first (note: this wipes the device, so be sure to back things up beforehand).
Unlock the bootloader with the following command (follow the prompts on the device; it''ll warn about wiping the device clean):

    ~/android-studio/sdk/platform-tools $ sudo ./fastboot oem unlock
    ...
    (bootloader) Unlocking bootloader...
    (bootloader) erasing userdata...
    (bootloader) erasing userdata done
    (bootloader) erasing cache...
    (bootloader) erasing cache done
    (bootloader) Unlocking bootloader done!
    OKAY [ 65.559s]
    finished. total time: 65.559s

Now flash the bootloader image downloaded earlier:

    ~/android-studio/sdk/platform-tools $ sudo ./fastboot  flash bootloader ~/tmp/razor-lrx21p/bootloader-flo-flo-04.04.img 
    sending ''bootloader'' (3911 KB)...
    OKAY [  0.192s]
    writing ''bootloader''...
    OKAY [  1.936s]
    finished. total time: 2.128s

And reboot into the bootloader again:

    ~/android-studio/sdk/platform-tools $ sudo ./fastboot reboot-bootloader
    rebooting into bootloader...
    OKAY [  0.006s]
    finished. total time: 0.006s

Next flash the zip image:

    ~/android-studio/sdk/platform-tools $ sudo ./fastboot -w update ~/tmp/razor-lrx21p/image-razor-lrx21p.zip 
    archive does not contain ''boot.sig''
    archive does not contain ''recovery.sig''
    archive does not contain ''system.sig''
    --------------------------------------------
    Bootloader Version...: FLO-04.04
    Baseband Version.....: none
    Serial Number........: 0a16e983
    --------------------------------------------
    checking product...
    OKAY [  0.003s]
    checking version-bootloader...
    OKAY [  0.004s]
    sending ''boot'' (7154 KB)...
    OKAY [  0.347s]
    writing ''boot''...
    OKAY [  0.420s]
    sending ''recovery'' (7740 KB)...
    OKAY [  0.369s]
    writing ''recovery''...
    OKAY [  0.297s]
    erasing ''system''...
    OKAY [  1.510s]
    sending ''system'' (799121 KB)...
    OKAY [ 37.893s]
    writing ''system''...
    OKAY [ 35.392s]
    erasing ''userdata''...
    OKAY [ 23.679s]
    formatting ''userdata'' partition...
    Creating filesystem with parameters:
        Size: 28856791040
        Block size: 4096
        Blocks per group: 32768
        Inodes per group: 8192
        Inode size: 256
        Journal blocks: 32768
        Label: 
        Blocks: 7045115
        Block groups: 215
        Reserved block group size: 1024
    Created filesystem with 11/1761280 inodes and 154578/7045115 blocks
    sending ''userdata'' (139085 KB)...
    writing ''userdata''...
    OKAY [ 13.485s]
    erasing ''cache''...
    OKAY [  0.406s]
    formatting ''cache'' partition...
    Creating filesystem with parameters:
        Size: 587202560
        Block size: 4096
        Blocks per group: 32768
        Inodes per group: 7168
        Inode size: 256
        Journal blocks: 2240
        Label: 
        Blocks: 143360
        Block groups: 5
        Reserved block group size: 39
    Created filesystem with 11/35840 inodes and 4616/143360 blocks
    sending ''cache'' (10984 KB)...
    writing ''cache''...
    OKAY [  1.033s]
    rebooting...

    finished. total time: 114.857s

And now it''s finished. If the bootloader was already locked previously, then you can remove the `-w` flag in the last
command to avoid wiping the device (note: I''ve not tried this yet).',
    TO_TIMESTAMP(1415836800)::DATE,
    TO_TIMESTAMP(1415836800)::DATE
)
,
(
    'Flask Development on a Raspberry Pi',
    'Currently the [`flog`](http://bunkergate.org/git/flog "flog git repo") project requires lxml as a dependency. I had some issues pulling this in.

    ~ $ cd py_toy/
    ~/py_toy $ cat dependencies.txt
    lxml
    ~/py_toy $ virtualenv -p `which python3` venv
    Already using interpreter /usr/bin/python3
    Using base prefix ''/usr''
    New python executable in venv/bin/python3
    Also creating executable in venv/bin/python
    Installing setuptools, pip...done.
    ~/py_toy $ . venv/bin/activate
    (venv)~/py_toy $ time pip install -r dependencies.txt
    [ output truncated ]
        creating build/temp.linux-armv6l-3.4/src/lxml

        gcc -pthread -Wno-unused-result -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -march=armv6 -mfloat-abi=hard -mfpu=vfp -O2 -pipe -fstack-protector --param=ssp-buffer-size=4 -fPIC -I/usr/include/libxml2 -I/tmp/pip-build-3ikmlcvh/lxml/src/lxml/includes -I/usr/include/python3.4m -c src/lxml/lxml.etree.c -o build/temp.linux-armv6l-3.4/src/lxml/lxml.etree.o -w

        gcc: internal compiler error: Killed (program cc1)

        Please submit a full bug report,

        with preprocessed source if appropriate.

        See <https://github.com/archlinuxarm/PKGBUILDs/issues> for instructions.

        /usr/lib/python3.4/distutils/dist.py:260: UserWarning: Unknown distribution option: ''bugtrack_url''

          warnings.warn(msg)

        error: command ''gcc'' failed with exit status 4

        ----------------------------------------
        Command "/root/py_toy/venv/bin/python3 -c "import setuptools, tokenize;__file__=''/tmp/pip-build-3ikmlcvh/lxml/setup.py'';exec(compile(getattr(tokenize, ''open'', open)(__file__).read().replace(''\r\n'', ''\n''), __file__, ''exec''))" install --record /tmp/pip-ytt52_hh-record/install-record.txt --single-version-externally-managed --compile --install-headers /root/py_toy/venv/include/site/python3.4" failed with error code 1 in /tmp/pip-build-3ikmlcvh/lxml

    real    27m18.069s
    user    26m55.390s
    sys     0m11.620s
    (venv)~/py_toy $

I was exhausting all 512 MB of memory. As a workaround, I temporarily employed a 512 MB swapfile on the SD card.

    (venv)~/py_toy $ sudo dd if=/dev/zero of=/swapfile bs=1M count=512
    512+0 records in
    512+0 records out
    536870912 bytes (537 MB) copied, 132.228 s, 4.1 MB/s
    (venv)~/py_toy $ sudo mkswap /swapfile
    Setting up swapspace version 1, size = 524284 KiB
    no label, UUID=c45c43c4-00dd-463b-a5ca-30ddeb0b102e
    (venv)~/py_toy $ sudo chmod 600 /swapfile
    (venv)~/py_toy $ sudo swapon /swapfile
    (venv)~/py_toy $ time pip install -r dependencies.txt 
    Collecting lxml (from -r dependencies.txt (line 1))
      Using cached lxml-3.4.2.tar.gz
        Building lxml version 3.4.2.
        Building without Cython.
        Using build configuration of libxslt 1.1.28
        Building against libxml2/libxslt in the following directory: /usr/lib
        /usr/lib/python3.4/distutils/dist.py:260: UserWarning: Unknown distribution option: ''bugtrack_url''
          warnings.warn(msg)
    Installing collected packages: lxml
      Running setup.py install for lxml
        Building lxml version 3.4.2.
        Building without Cython.
        Using build configuration of libxslt 1.1.28
        Building against libxml2/libxslt in the following directory: /usr/lib
        building ''lxml.etree'' extension
        gcc -pthread -Wno-unused-result -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -march=armv6 -mfloat-abi=hard -mfpu=vfp -O2 -pipe -fstack-protector --param=ssp-buffer-size=4 -fPIC -I/usr/include/libxml2 -I/tmp/pip-build-8m8hfu47/lxml/src/lxml/includes -I/usr/include/python3.4m -c src/lxml/lxml.etree.c -o build/temp.linux-armv6l-3.4/src/lxml/lxml.etree.o -w
        gcc -pthread -shared -Wl,-O1,--sort-common,--as-needed,-z,relro build/temp.linux-armv6l-3.4/src/lxml/lxml.etree.o -L/usr/lib -L/usr/lib -lxslt -lexslt -lxml2 -lz -lm -lpython3.4m -o build/lib.linux-armv6l-3.4/lxml/etree.cpython-34m.so
        building ''lxml.objectify'' extension
        gcc -pthread -Wno-unused-result -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -march=armv6 -mfloat-abi=hard -mfpu=vfp -O2 -pipe -fstack-protector --param=ssp-buffer-size=4 -fPIC -I/usr/include/libxml2 -I/tmp/pip-build-8m8hfu47/lxml/src/lxml/includes -I/usr/include/python3.4m -c src/lxml/lxml.objectify.c -o build/temp.linux-armv6l-3.4/src/lxml/lxml.objectify.o -w
        gcc -pthread -shared -Wl,-O1,--sort-common,--as-needed,-z,relro build/temp.linux-armv6l-3.4/src/lxml/lxml.objectify.o -L/usr/lib -L/usr/lib -lxslt -lexslt -lxml2 -lz -lm -lpython3.4m -o build/lib.linux-armv6l-3.4/lxml/objectify.cpython-34m.so
        /usr/lib/python3.4/distutils/dist.py:260: UserWarning: Unknown distribution option: ''bugtrack_url''
          warnings.warn(msg)
    Successfully installed lxml-3.4.2

    real	33m46.351s
    user	32m43.210s
    sys	0m16.700s
    (venv)~/py_toy $

Success!',
    TO_TIMESTAMP(1426824928)::DATE,
    TO_TIMESTAMP(1426824928)::DATE
)
,
(
    'SSH Tunneling for Fun and Profit',
    'First, to test, set up temporary Python http server on the remote host:

    [user@remotehost ~]$ mkdir tmp && cd tmp
    [user@remotehost tmp]$ echo "HELLO WORLD" > index.html
    [user@remotehost tmp]$ python -m http.server 8080 # python3
    Serving HTTP on 0.0.0.0 port 8080 ...
    [user@remotehost tmp]$ python -m SimpleHTTPServer 8080 #python2
    Serving HTTP on 0.0.0.0 port 8080 ...


Then on the localhost use ssh to set up a tunnel. Here port 8081 on the local machine will tunnel through to 8080 on the remote host:
    
    user@localhost ~ $ ssh -p 443 -f user@remotehost.com -L 8081:127.0.0.1:8080 -N
    user@remotehost.com''s password: 

* `-p` for remote sshd port (default is 22).
* `-f` tells ssh to go into the background just before it executes the command. This is followed by the username and server you are logging into. 
* The `-L` 8081:127.0.0.1:8080 is in the form of -L local-port:host:remote-port. Here the I''m using the loopback for the host, this refers to the remote host''s loopback interface.
* Finally the `-N` instructs OpenSSH to not execute a command on the remote system.

Test the tunnel with telnet on local machine.

    user@localhost ~ $ telnet 127.0.0.1 8081
    Trying 127.0.0.1...
    Connected to 127.0.0.1.
    Escape character is ''^]''.
    GET /

    HELLO WORLD
    Connection closed by foreign host.',
    TO_TIMESTAMP(1428316230)::DATE,
    TO_TIMESTAMP(1428316230)::DATE
)
,
(
    'RPM Packaging Environment for an Arbitrary User',
    'Recently I had to roll my own package on CentOS 7. It''s been a while since I''ve done this and so I had to dig around online to remember how to set up an environment for packaging. So this time around I''ll jot down some notes.

First thing''s first, to build as an arbitrary user we''ll need to set up a space for RPMs to be packaged in. Start by defining the location with this via the RPM Macro `_topdir`:

    [mcvady@centos7 ~]$ cat ~/.rpmmacros
    %_topdir /home/mcvady/working/rpm

Once set this value should be picked up immediately. Test the value from shell like so:

    [mcvady@centos7 ~]$ rpm --eval ''%_topdir''
    /home/mcvady/working/rpm

Now create the RPM top-level directory:

    [mcvady@centos7 ~]$ mkdir -p `rpm --eval ''%_topdir''` # create RPM output directory

Here''s a helper script I drop in `~/bin/` to flesh out the structure of the RPM packaging top-level directory (Note that `~/bin/` is automatically added to `$PATH` in the default `~/.bash_profile`):

    #!/bin/bash

    set -e

    RM_BIN="/usr/bin/rm"
    RPM_BIN="/usr/bin/rpm"
    MKDIR_BIN="/usr/bin/mkdir"

    rpmtopdir=`$RPM_BIN --eval ''%_topdir''`

    pushd $rpmtopdir 2>&1 > /dev/null

    $RM_BIN -rf BUILD/*
    $RM_BIN -rf BUILDROOT/*
    $RM_BIN -rf RPMS/*
    $RM_BIN -rf SOURCES/*
    $RM_BIN -rf SPECS/*
    $RM_BIN -rf SRPMS/*

    $MKDIR_BIN -p BUILD
    $MKDIR_BIN -p BUILDROOT
    $MKDIR_BIN -p RPMS/x86_64
    $MKDIR_BIN -p SOURCES
    $MKDIR_BIN -p SPECS
    $MKDIR_BIN -p SRPMS

    popd 2>&1 > /dev/null

And now to test that packaging works by packaging a project:

    [mcvady@centos7 ~]$ cd working/
    [mcvady@centos7 working]$ git clone http://git.bunkergate.org/chunker
    Cloning into ''chunker''...
    [mcvady@centos7 working]$ cd chunker/
    [mcvady@centos7 chunker]$ ./package.sh 0.9.1
    srcdir /home/mcvady/working/rpm/SOURCES
    ~/working/chunker ~/working/chunker
    rm -f chunker test-overflow test-cleanMarkerKeepLast test-handshake ./src/stats.o ./src/connection.o
    -rw-rw-r-- mcvady/mcvady  3654 2015-05-13 15:59 chunker.spec
    -rw-rw-r-- mcvady/mcvady   474 2015-05-13 15:59 INSTALL
    drwxrwxr-x mcvady/mcvady     0 2015-05-13 15:59 lib/
    -rw-rw-r-- mcvady/mcvady  6551 2015-05-13 15:59 lib/dictionary.h
    -rw-rw-r-- mcvady/mcvady 39097 2015-05-13 15:59 lib/iniparser-3.1.tar.gz
    -rw-rw-r-- mcvady/mcvady 11574 2015-05-13 15:59 lib/iniparser.h
    -rw-rw-r-- mcvady/mcvady 17594 2015-05-13 15:59 lib/libiniparser.a
    -rwxrwxr-x mcvady/mcvady 18867 2015-05-13 15:59 lib/libiniparser.so.0
    -rw-rw-r-- mcvady/mcvady  2221 2015-05-13 15:59 makefile
    -rwxrwxr-x mcvady/mcvady  1035 2015-05-13 15:59 package.sh
    -rw-rw-r-- mcvady/mcvady   236 2015-05-13 15:59 README
    drwxrwxr-x mcvady/mcvady     0 2015-05-13 15:59 src/
    -rwxrwxr-x mcvady/mcvady  3718 2015-05-13 15:59 src/chunker-init
    -rw-rw-r-- mcvady/mcvady 22744 2015-05-13 15:59 src/chunker.c
    -rw-rw-r-- mcvady/mcvady  1066 2015-05-13 15:59 src/chunker.conf
    -rw-rw-r-- mcvady/mcvady  2409 2015-05-13 15:59 src/chunker.h
    -rwxrwxr-x mcvady/mcvady  2628 2015-05-13 15:59 src/chunker2s3.sh
    -rw-rw-r-- mcvady/mcvady    98 2015-05-13 15:59 src/chunker_health-cron
    -rwxrwxr-x mcvady/mcvady   969 2015-05-13 15:59 src/chunker_health.sh
    -rw-rw-r-- mcvady/mcvady 12154 2015-05-13 15:59 src/connection.c
    -rw-rw-r-- mcvady/mcvady  1325 2015-05-13 15:59 src/connection.h
    -rw-rw-r-- mcvady/mcvady  5014 2015-05-13 15:59 src/stats.c
    -rw-rw-r-- mcvady/mcvady   382 2015-05-13 15:59 src/stats.h
    drwxrwxr-x mcvady/mcvady     0 2015-05-13 15:59 test/
    -rw-rw-r-- mcvady/mcvady  2978 2015-05-13 15:59 test/test-cleanMarkerKeepLast.c
    -rw-rw-r-- mcvady/mcvady  3159 2015-05-13 15:59 test/test-handshake.c
    -rw-rw-r-- mcvady/mcvady  1923 2015-05-13 15:59 test/test-overflow.c
    -rw-rw-r-- mcvady/mcvady   464 2015-05-13 15:59 TODO
    ~/working/chunker
    SPEC [/home/mcvady/working/rpm/SPECS/chunker_0.9.1.spec]
    ~/working/rpm/SPECS ~/working/chunker
    Executing(%prep): /bin/sh -e /var/tmp/rpm-tmp.FV0fiB
    + umask 022
    + cd /home/mcvady/working/rpm/BUILD
    + cd /home/mcvady/working/rpm/BUILD
    + rm -rf chunker-0.9.1
    + /usr/bin/mkdir -p chunker-0.9.1
    + cd chunker-0.9.1
    + /usr/bin/gzip -dc /home/mcvady/working/rpm/SOURCES/chunker-0.9.1.tgz
    + /usr/bin/tar -xvvf -
    -rw-rw-r-- mcvady/mcvady  3654 2015-05-13 15:59 chunker.spec
    -rw-rw-r-- mcvady/mcvady   474 2015-05-13 15:59 INSTALL
    drwxrwxr-x mcvady/mcvady     0 2015-05-13 15:59 lib/
    -rw-rw-r-- mcvady/mcvady  6551 2015-05-13 15:59 lib/dictionary.h
    -rw-rw-r-- mcvady/mcvady 39097 2015-05-13 15:59 lib/iniparser-3.1.tar.gz
    -rw-rw-r-- mcvady/mcvady 11574 2015-05-13 15:59 lib/iniparser.h
    -rw-rw-r-- mcvady/mcvady 17594 2015-05-13 15:59 lib/libiniparser.a
    -rwxrwxr-x mcvady/mcvady 18867 2015-05-13 15:59 lib/libiniparser.so.0
    -rw-rw-r-- mcvady/mcvady  2221 2015-05-13 15:59 makefile
    -rwxrwxr-x mcvady/mcvady  1035 2015-05-13 15:59 package.sh
    -rw-rw-r-- mcvady/mcvady   236 2015-05-13 15:59 README
    drwxrwxr-x mcvady/mcvady     0 2015-05-13 15:59 src/
    -rwxrwxr-x mcvady/mcvady  3718 2015-05-13 15:59 src/chunker-init
    -rw-rw-r-- mcvady/mcvady 22744 2015-05-13 15:59 src/chunker.c
    -rw-rw-r-- mcvady/mcvady  1066 2015-05-13 15:59 src/chunker.conf
    -rw-rw-r-- mcvady/mcvady  2409 2015-05-13 15:59 src/chunker.h
    -rwxrwxr-x mcvady/mcvady  2628 2015-05-13 15:59 src/chunker2s3.sh
    -rw-rw-r-- mcvady/mcvady    98 2015-05-13 15:59 src/chunker_health-cron
    -rwxrwxr-x mcvady/mcvady   969 2015-05-13 15:59 src/chunker_health.sh
    -rw-rw-r-- mcvady/mcvady 12154 2015-05-13 15:59 src/connection.c
    -rw-rw-r-- mcvady/mcvady  1325 2015-05-13 15:59 src/connection.h
    -rw-rw-r-- mcvady/mcvady  5014 2015-05-13 15:59 src/stats.c
    -rw-rw-r-- mcvady/mcvady   382 2015-05-13 15:59 src/stats.h
    drwxrwxr-x mcvady/mcvady     0 2015-05-13 15:59 test/
    -rw-rw-r-- mcvady/mcvady  2978 2015-05-13 15:59 test/test-cleanMarkerKeepLast.c
    -rw-rw-r-- mcvady/mcvady  3159 2015-05-13 15:59 test/test-handshake.c
    -rw-rw-r-- mcvady/mcvady  1923 2015-05-13 15:59 test/test-overflow.c
    -rw-rw-r-- mcvady/mcvady   464 2015-05-13 15:59 TODO
    + STATUS=0
    + ''['' 0 -ne 0 '']''
    + /usr/bin/chmod -Rf a+rX,u+w,g-w,o-w .
    + exit 0
    Executing(%build): /bin/sh -e /var/tmp/rpm-tmp.MTVkPK
    + umask 022
    + cd /home/mcvady/working/rpm/BUILD
    + cd chunker-0.9.1
    + make chunker
    gcc -std=gnu99 -O2 -Wall -c ./src/connection.c -o ./src/connection.o
    gcc -std=gnu99 -O2 -Wall -c ./src/stats.c -o ./src/stats.o
    gcc -std=gnu99 -O2 -Wall ./src/chunker.c ./src/connection.o ./src/stats.o -o chunker -I./lib -L./lib -liniparser
    + exit 0
    Executing(%install): /bin/sh -e /var/tmp/rpm-tmp.BluP5U
    + umask 022
    + cd /home/mcvady/working/rpm/BUILD
    + ''['' /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64 ''!='' / '']''
    + rm -rf /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64
    ++ dirname /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64
    + mkdir -p /home/mcvady/working/rpm/BUILDROOT
    + mkdir /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64
    + cd chunker-0.9.1
    + rm -rf /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64
    + make PFX=/home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64 install
    gcc -std=gnu99 -O2 -Wall -c ./src/connection.c -o ./src/connection.o
    gcc -std=gnu99 -O2 -Wall -c ./src/stats.c -o ./src/stats.o
    gcc -std=gnu99 -O2 -Wall ./src/chunker.c ./src/connection.o ./src/stats.o -o chunker -I./lib -L./lib -liniparser
    install -m 775 chunker /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64/opt/tsdb/bin
    install -m 755 ./src/chunker-init /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64/etc/init.d/chunker
    install -m 644 ./src/chunker.conf /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64/etc
    install -m 755 ./src/chunker2s3.sh /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64/opt/tsdb/scripts
    install -m 755 ./src/chunker_health.sh /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64/opt/tsdb/scripts
    install -m 644 ./src/chunker_health-cron /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64/opt/tsdb/scripts
    + /usr/lib/rpm/find-debuginfo.sh --strict-build-id -m --run-dwz --dwz-low-mem-die-limit 10000000 --dwz-max-die-limit 110000000 /home/mcvady/working/rpm/BUILD/chunker-0.9.1
    extracting debug info from /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64/opt/tsdb/bin/chunker
    dwz: Too few files for multifile optimization
    /usr/lib/rpm/sepdebugcrcfix: Updated 0 CRC32s, 1 CRC32s did match.
    + /usr/lib/rpm/check-buildroot
    + /usr/lib/rpm/redhat/brp-compress
    + /usr/lib/rpm/redhat/brp-strip-static-archive /usr/bin/strip
    + /usr/lib/rpm/brp-python-bytecompile /usr/bin/python 1
    + /usr/lib/rpm/redhat/brp-python-hardlink
    + /usr/lib/rpm/redhat/brp-java-repack-jars
    Processing files: chunker-0.9.1-1.el7.centos.x86_64
    Provides: chunker = 0.9.1-1.el7.centos chunker(x86-64) = 0.9.1-1.el7.centos config(chunker) = 0.9.1-1.el7.centos
    Requires(interp): /bin/sh /bin/sh /bin/sh /bin/sh
    Requires(rpmlib): rpmlib(CompressedFileNames) <= 3.0.4-1 rpmlib(FileDigests) <= 4.6.0-1 rpmlib(PayloadFilesHavePrefix) <= 4.0-1
    Requires(pre): /bin/sh
    Requires(post): /bin/sh
    Requires(preun): /bin/sh
    Requires(postun): /bin/sh
    Requires: /bin/bash /bin/sh libc.so.6()(64bit) libc.so.6(GLIBC_2.14)(64bit) libc.so.6(GLIBC_2.2.5)(64bit) libc.so.6(GLIBC_2.3)(64bit) libc.so.6(GLIBC_2.3.2)(64bit) libc.so.6(GLIBC_2.9)(64bit) rtld(GNU_HASH)
    Processing files: chunker-debuginfo-0.9.1-1.el7.centos.x86_64
    Provides: chunker-debuginfo = 0.9.1-1.el7.centos chunker-debuginfo(x86-64) = 0.9.1-1.el7.centos
    Requires(rpmlib): rpmlib(FileDigests) <= 4.6.0-1 rpmlib(PayloadFilesHavePrefix) <= 4.0-1 rpmlib(CompressedFileNames) <= 3.0.4-1
    Checking for unpackaged file(s): /usr/lib/rpm/check-files /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64
    Wrote: /home/mcvady/working/rpm/SRPMS/chunker-0.9.1-1.el7.centos.src.rpm
    Wrote: /home/mcvady/working/rpm/RPMS/x86_64/chunker-0.9.1-1.el7.centos.x86_64.rpm
    Wrote: /home/mcvady/working/rpm/RPMS/x86_64/chunker-debuginfo-0.9.1-1.el7.centos.x86_64.rpm
    Executing(%clean): /bin/sh -e /var/tmp/rpm-tmp.vSpeIF
    + umask 022
    + cd /home/mcvady/working/rpm/BUILD
    + cd chunker-0.9.1
    + rm -rf /home/mcvady/working/rpm/BUILDROOT/chunker-0.9.1-1.el7.centos.x86_64
    + exit 0
    ~/working/chunker
    [mcvady@centos7 chunker]$ ls -Ahl chunker-0.9.1-1.el7.centos.x86_64.rpm 
    -rw-rw-r--. 1 mcvady mcvady 21K May 13 16:00 chunker-0.9.1-1.el7.centos.x86_64.rpm

やった！',
    TO_TIMESTAMP(1431212057)::DATE,
    TO_TIMESTAMP(1431212057)::DATE
)
,
(
    'SQLite Cheat Sheet',
    'Some notes on using SQLite

Opening a database

        mcvady@b:/tmp$ sqlite3 sqlite.db

Show tables

    sqlite> .tables
    seq  name             file                                                      
    ---  ---------------  ----------------------------------------------------------
    0    main             /tmp/sqlite.db                                            
    sqlite> .tables
    acc                  globalblacklist      purplemap          
    active_watchers      grp                  re_grp             
    address              htable               rls_presentity     
    aliases              imc_members          rls_watchers       
    carrier_name         imc_rooms            sca_subscriptions  
    carrierfailureroute  lcr_gw               silo               
    carrierroute         lcr_rule             sip_trace          
    cpl                  lcr_rule_target      speed_dial

Describe a table

    sqlite> .schema TABLENAME

Create a table

    sqlite> CREATE TABLE connection(connection_id BIGINT, username STRING);

Insert into a table

    sqlite> INSERT INTO connection (connection_id, username) VALUES (1, ''mcvady'');

Dump output into a file

    sqlite> .output SCHEMA_DUMP
    sqlite> .schema

Run SQL commands from file into a DB

    $ sqlite3 sqlite3.db < schema.sql',
    TO_TIMESTAMP(1444863580)::DATE,
    TO_TIMESTAMP(1444863580)::DATE
)

;