Build your own embedded XBMC HTPC

Earlier I wrote an article how to build a cheap XBMC media center with a XBOX1. But nowadays you want a high definition media center and XVID and DIVX isn’t acceptable anymore on your full HD television. So I read a lot of information how to make an nice media streamer like the popcorn hour, ac rayon and xstreamer but then highly customizable .

I choose for XBMC because it is highly customizable and there are tons of addons, plugins, script, skins, fanart, visualizations. XBMC is a media streamer so it’s recommended that all your downloaded music, photo’s, tv series and movies are on a NAS (network attached storage) device. If you want there are NZB and torrent plugins and you can download the software to the local disk but I don’t use any of these methods. XBMC is also in almost every language and the GUI for normal use is girlfriend, wife and kids friendly 😉

Because the software is highly customizable and it’s always in development you get sometimes some unstable situations when you change some config settings. I can live with that but if you want a very stable product maybe you can better look further to an out-of-the-box product like the AC Ryan.

Also the software isn’t for noobs. If you don’t like to spent hours to tweaking the software how YOU want it please buy a product like the Popcorn Hour or AC Ryan that isn’t customizable.

But for normal use the software is stable and you will very often surprised by the tricks and the nice performance of the XBMC.

XBMC is open source and cross platform. There are official builds for OSX, Windows, Linux, iPAD, Apple TV and more ports still coming. The build I choose is OpenELEC. I choose for OpenELEC because that is an embedded linux distribution optimized for XBMC only. The software is compiled for all the common hardware platforms. The boot time is 30 seconds with SD (with SSD 5 sec) and the installation is very easy and I explain here how you can install the XBMC OpenELEC software.

The hardware I use is a Zotac ZBOX ID41, 2 GB RAM (Kingston ValueRAM KVR1333D3S9/2G) and a 4GB SD class 2 card. If you have an Android or Apple smartphone (or tablet)  you can download the “XBMC remote” app for remote. So you don’t need to buy a remote.  Total costs 200,- euro. That is very cheap for a full hd media center 🙂

What do you need to build this system:

  1. Zotac ZBOX
  2. 2 GB of RAM
  3. 4GB SD card
  4. Tabled or smartphone for remote (xbmc remote app installed)
  5. 256mb or higher USB stick for the installation
  6. OpenELEC ION x86_64 build (link)
  7. HDMI cable
  8. USB keyboard
  9. Putty
  10. UTP Network cable and network connection (wireless also supported)





First you need to do is build in the RAM. You can loosen the screws just with your hands.
Now open the cover
Build in the memory
and *click*
Close the cover and connect the ZBOX with the HDMI cable to the TV
Turn on the ZBOX to see if you get a boot error (and the memory is working correctly)
Ok, now we create the bootable OpenELEC USB stick to install the software. Because these steps are very good

documented by OpenELEC please follow these steps:
Now insert the SD card, USB stick and the keyboard into the Zotac ZBOX and press the power button. The setup will start.

Press ok and then quick install
Choose the SD card and then OK
Now the setup will start. This will take 3 minutes.
After the setup is done you can restart the device. The first time boot takes 2 minutes and than you have the most EPIC Media Center you can have:
Now you must install 2 fixes. One for the sound over HDMI and one to fix the splash screen.
For both fixes you need putty and a little linux knowledge. Open the system preferences to see the IP adres. (If you use wireless please configure this first).
Now connect with putty. User “root“, password is “openelec” and apply the fixes. After you applied the fixes with SSH/Putty you can change the sound settings within XBMC. But if you don’t it work also 😛
Bye bye good old XBOX. After eight years of loyal service, I will miss you 😉
I hope you enjoyed this review if you have some questions feel free to ask 🙂

Howto: Combine or edit subtitles

Run Subtitle Workshop.
Tools > Join Subtitles
Check the boxes ‘Load file after join’ and ‘Recalculate time values’.
[it will load the new combined file and reset the values on the second part of the subs]
‘Add’ the subtitle files and click ‘Join’.
The new combined files will load.
Click ‘Movie’ and open the movie file and check the subs sync.

How to shrink a SQL Transaction Log

For 2005:
–* you can get the logical log file name usingthe following command in Query Analizer:

exec "databaseName".dbo.sp_helpfile

Now execute the following command to shrink the database log to 200MB:

DBCC SHRINKFILE ("logicalLogFileName", 200)
DBCC SHRINKFILE ("logicalLogFileName", 200)

–if it doesn’t work, run the two commands again.

–When done with that, do a full backup of your db as you will have broken your tlog backup chain.

For 2008+

USE databasename;
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE databasename
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (2, 1);  -- here 2 is the file ID for trasaction log file,you can also mention the log file name (dbname_log)
-- Reset the database recovery model.
ALTER DATABASE databasename