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.
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
sudo apt-get install python-dev python-setuptools
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.111netmask 255.255.255.0network 192.168.0.0broadcast 192.168.0.255gateway 192.168.0.1
sudo apt-get update
sudo apt-get upgrade -y
sudo ln -sf /usr/share/zoneinfo/Australia/Perth /etc/localtime
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
mysql
192.168.0.111
3306
xbmc
xbmc
mysql
192.168.0.111
3306
xbmc
xbmc
true
http://raspberry-blog.com/general/sickbeard-on-raspberry-pi/
http://www.cylindric.net/blog/raspberrypi-adding-sabnzbd-sickbeard-and-couchpotato/
still trying to work this out
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/
sudo dd if=/dev/disk5 of=/Users/alisterjupp/Documents/XBMCsvr.img bs=1m