Thursday, March 21, 2013

HOWTO get your Raspberry Pi running owncloud, tt-rss and thinkup

Today a case for my Raspberry Pi arrived from Adafruit arrived and it is time for some spring cleaning.

I was running the XBMC distro on the pi, but found it cumbersome to listen to music in the home office that way. So time to start with a fresh Raspbian install.

Here are my notes:

  • Get the current Raspbian release from and install it on a
    4GB flash disk.

  • Boot the new disk and make the following configurations using
    raspi-config which is run the first time it starts up.

    - Use only 16M for GPU since I'm not running an X desktop
    - set appropriate timezone
    - set appropriate locale
    - expand fs to use entire 4GB disk
    - change pi passwd
    - enable ssh access
    - update
    - reboot

  • Now some miscellaneous setup to make life easier later on. Both tt-rss and thinkup require MySQL, but I'll also want to use it for
    owncloud too. So install MySQL server:

    sudo apt-get install mysql-server

    Avahi (aka bonjour) is a very nice network tool that is a DNS-less way
    to announcing your hostname on the local network. Most (all) linux
    tools support it, but you'll need Apple's Bonjour kit for Windows.
    That means you can just 'ssh raspberrypi.local' or browse to

    sudo apt-get install avahi-utils

    I like emacs and screen is useful.

    sudo apt-get install emacs23-nox screen

    At this point I stop using the keyboard/monitor connected to the Raspberry Pi and use an ssh session from my laptop to do the rest.

  • First install ownCloud by taking a look here: Then connect to your Raspberry Pi:

    ssh pi@raspberrypi.local
    sudo -i

    Now run this script which I slightly modified from their page:

    apt-key add - < Release.key

    echo 'deb /' >> /etc/apt/sources.list.d/owncloud.list
    apt-get update
    apt-get install owncloud

    At this point you'll have all the required packages are installed. Now point a browser to http://raspberrypi.local/owncloud

    You will need to create an owncloud admin account and will want to then expand the Advanced tab and to use a MySQL server instead of SQLite. Fill in root, mysql root password (I didn't bother to set an mysql admin password, so null in my case). For the database, use owncloud and database host localhost. It may take a couple minutes to be complete, so be patient.

  • Now install tt-rss doing the following steps:

    cd /var/www/

    wget -c

    And follow the instructions here which are essentially:

    tar zxvf 1.7.4.tar.gz
    mv Tiny-Tiny-RSS-1.7.4 tt-rss

    chown -R www-data:www-data tt-rss

    You will have to manually create a mysql database and import the schema

    mysql -u root
    mysql> create database ttrss;
    mysql> quit

    Now import the database schema (a fancy way to say the database tables and some initial data)

    cd tt-rss/schema
    mysql -u root ttrss < ttrss_schema_mysql.sql

    And a little editing the configuration file...

    cd /var/www/tt-rss

    cp config.php-dist config.php

    emacs config.php (or use vi, nano, etc)

    I made the following edits:

    define('DB_TYPE', "mysql");
    define('DB_HOST', "localhost");
    define('DB_USER', "root");
    define('DB_NAME', "ttrss");
    define('DB_PASS', "");

    define('SELF_URL_PATH', 'http://raspberrypi.local/tt-rss/');
    define('SINGLE_USER_MODE', true);

    Point a browser to http://raspberrypi.local/tt-rss

    From there login with default login/password of admin/password and you are done.

  • Finally install

    The one package you'll need that isn't already installed at this point is php5-curl.

    apt-get install php5-curl

    Now get the kit. I used wget and the site provided the kit, but with an unusual name.

    cd /var/www
    wget -c
    mv index.html
    unzip thinkup-1.3.1
    chown -R www-data:www-data thinkup

    Almost done. Point a browser to http://raspberrypi.local/thinkup and complete the configuration.

    database host: localhost

    database name: thinkup

    user: root

    password: blank, in my case or whatever you set the mysql root password to.

    I (and probably you) don't have a smtp server configured, so in order to activate your account, you'll need to do this:

    # mysql -u root thinkup

    mysql> select id,full_name,is_activated from tu_owners;
    | id | full_name | is_activated |
    | 1 | Marc Nozell | 0 |
    1 row in set (0.00 sec)

    mysql> update tu_owners set is_activated=1 where id=1;
    mysql> quit

    Done! Now go back to http://raspberrypi.local/thinkup and configure the plugins to your favorite social media sites.

Monday, March 18, 2013

Trevor @ NH Mens' Gymnastics Championships 2013

Back from the NH Mens' Gymnastics Championships -- Trevor placed 2nd All Around and 1st in Floor, Rings and PBars. Nice way to end his gymnastics career.

Except for the New England Regionals the beginning of April of course.

  • Still Rings

  • Pommel Horse

  • Floor

  • High Bar

  • Parallel Bars

  • Vault

Saturday, March 2, 2013

7 hours of engineering pit from New Hampshire GSR FIRST Robotics competition compressed to 83 seconds

As soon as they opened the door at 8am this morning, I put the camera, tripod + arduino hack at the very top of the seating in the Verizon Wireless Center pointing down at the pit where the robots are prepped for competition.

*BEST* GSR (NH) FIRST Robotics time lapse in the pit (10fps)

GSR (NH) FIRST Robotics time lapse in the pit (5fps)

GSR (NH) FIRST Robotics time lapse in the pit (20fps)

After nearly seven hours (the length my camera's battery lasted taking photos every 30 seconds) there were 835 photos which were converted to an AVI using:

mencoder -nosound -ovc lavc -lavcopts vcodec=mjpeg -o timelapse-10fps.avi -mf type=jpeg:fps=10 mf://*.JPG

and then converted to a much smaller M4V file using ghb aka the very handy Handbrake tool.