Mounting SSHFS at Startup
This tutorial was created using information from the following sites:
Connecting SSH Without Using A Password
How To Automount SSHFS Filesystems Automatically at Startup
There are two reasons why I did this. The first is that I constantly move files back and forth between systems using the command line, and SSHFS is the easiest way to do it. The second is that I am connecting my XBMC's together using MySQL for the database, but thumbnail files need to stay in the .xbmc/userdata folder on each machine. This will also setup an easy rsync without having to create an SSH connection on the fly.
SSH Passwordless Login
This is pretty much taken and modified from http://contentwhores.com/media-centers/configuring-xbmc-to-use-a-mysql-library/.
For my scenario, I am using Ubuntu 9.04 Server with MySQL 5.0.75 for the server (and Samba for file shares) and XP Pro 32-bit running XBMC Dharma Beta 4
There are many connectors to manage your MySQL server, but I prefer Webmin. If you are going to have your server be headless but still wish to have somewhat of a graphical environment, use Webmin. To install as of 11/18/2010 run this set of commands:
wget http://prdownloads.sourceforge.net/webadmin/webmin_1.520_all.deb && sudo dpgk -i webmin_1.520_all.deb && sudo apt-get install -f
With my new (to me) dual-core atom Zotac with NVidia Ion graphics, I've been wanting to push out a new media center to the living room. The living room machine is currently a dual-core 2.2GHz P4 with 2GB of RAM. Not great specs, but certainly not bad as it can push 1080p easily. The real concern I have with it is the size of the computer. It's a slighly-larger-than-mid tower and has only somewhat quiet fans constantly blowing. Over a movie I can't hear it, but without the TV on it is a little noticeable.