Raspberry Pi XBMC DB and Sickbeard Setup

Here are the steps I took to configure my Raspberry Pi to be my XBMC DB and also run SickBeard. Info here mainly so that I have something to refer to in the future if I ever have to rebuild.

Install and configure Raspbian

Download image from http://www.raspberrypi.org/downloads

Copy over image to the SD Card
sudo dd bs=1m if=/Users/alisterjupp/Downloads/2013-02-09-wheezy-raspbian.img of=/dev/rdisk5

Extend OS to full size of SD Card via raspi-config at first boot

Install required packages

sudo apt-get install python-dev python-setuptools

Set static ip

sudo nano /etc/network/interfaces
Change the line that reads

iface eth0 inet dhcp

to

iface eth0 inet static

with info below following;

address 192.168.0.111
netmask 255.255.255.0
network 192.168.0.0
broadcast 192.168.0.255
gateway 192.168.0.1

update repo lists and upgrade

sudo apt-get update

sudo apt-get upgrade -y

Set to local time

sudo ln -sf /usr/share/zoneinfo/Australia/Perth /etc/localtime

 

Install MySQL

http://wiki.xbmc.org/index.php?title=HOW-TO:Sync_multiple_libraries/Setting_up_MySQL

sudo apt-get install mysql-server

Configure MySQL to listen for connections from all network hosts

edit /etc/mysql/my.cnf

comment out the bind-address = 127.0.0.1

 

create xbmc user and assign permissions

CREATE USER 'xbmc' IDENTIFIED BY 'xbmc'

GRANT ALL ON *.* TO 'xbmc'

import database from NAS

Configure XBMC clients to use this database

<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>192.168.0.111</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </videodatabase> 

    <musicdatabase>
        <type>mysql</type>
        <host>192.168.0.111</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </musicdatabase>

     <videolibrary>
          <importwatchedstate>true</importwatchedstate>
     </videolibrary>
</advancedsettings>

 

Install sickbeard

http://raspberry-blog.com/general/sickbeard-on-raspberry-pi/

http://www.cylindric.net/blog/raspberrypi-adding-sabnzbd-sickbeard-and-couchpotato/

 

 

 

Install XBMC Server

still trying to work this out

 

Mount NFS drives

sudo mkdir /mnt/video

sudo chmod 777 /mnt/video

manual mount

sudo mount 192.168.0.110:/volume1/video /mnt/video

sudo nano fstab

add

192.168.0.110:/volume1/video /mnt/video nfs defaults 0 0

 

 

http://blog.retep.org/2012/07/07/using-nfs-to-provide-extra-disk-to-a-raspberry-pi/

 

 

 

Sick Beard Config

 

 

Backup my Setup SD card to image file

sudo dd if=/dev/disk5 of=/Users/alisterjupp/Documents/XBMCsvr.img bs=1m