OpenMediaVault & XBMC

I recently stumbled upon OpenMediaVault (OMV), a Linux distribution specific for NASes based on debian squeeze. It's inspired by FreeNas as I gathered.


There is a fast-growing community around OMV that offers guides and how-tos. I tried to give the VM a shot and wanted to see how far XBMC has come. There is a detailed guide of ow to install XBMC on OMV here and here. Unfortunately I hit a roadblock because I was unable to install Oracle Java 7. The command 

sudo add-apt-repository ppa:webupd8team/java

Was not recognized. After some digging I found out how to add the correct repo for debian squeeze on the webupd8 blog here. Here are the relevant commands:

su -
echo "deb http://ppa.launchpad.net/webupd8team/java/ubuntu precise main" | tee -a /etc/apt/sources.list
echo "deb-src http://ppa.launchpad.net/webupd8team/java/ubuntu precise main" | tee -a /etc/apt/sources.list
apt-key adv --keyserver keyserver.ubuntu.com --recv-keys EEA14886
apt-get update
apt-get install oracle-java7-installer
exit

I was not able to get the keys added, so I had to install the package without verification, which worked fine too.

Update:
I had to update libtinyxml and libtinyxml-dev from the Debian wheezy repository to get xbmc to compile.
The two packages can be found here and here. 

Update 2:
I had to remove any and all taglib and depending packets and compiled and installed taglib manually from source.
Here's how:

wget https://github.com/downloads/taglib/tagl...1.8.tar.gz
tar xzf taglib-1.8.tar.gz
cd taglib-1.8
cmake -DCMAKE_INSTALL_PREFIX=/usr/local -DCMAKE_RELEASE_TYPE=Release .
make
make install

Make would complain about some missing libraries. So I had to run make with additional options:

export CFLAGS="-ldl"
export CXXFLAGS="-ldl"

 Which stops xbmc from complaining about missing libraries.

Read More

SQL Server Update Woes

There are various issues that can happen when trying to update SQL Server. For almost all there are workarounds, and they usually work well.

Today I had a trickier experience, and thought I'd share my findings. I wanted to install KB2494113 - "Security Update for SQL Server 2005 Service Pack 3". I got error 57A through Windows Updates. So I had to resort to downloading and installing the update manually.



The installation failed, but at least the summary had the real error message:

**********************************************************************************
Product Installation Status
Product                   : SQL Server Database Services 2005 (SQLEXPRESS)
Product Version (Previous): 4053
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2494113_sqlrun_sql.msp.log
SQL Express Features      :
Error Number              : 1402
Error Description         : MSP Error: 1402  Could not open key: UNKNOWN\Components\GUID1\GUID2.   Verify that you have sufficient access to that key, or contact your support personnel.
----------------------------------------------------------------------------------

The relevant registry path can be found in 

HKLM\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\GUID1\GUID2

Where Guid1 and Guid2 are the specific paths from the error log above. Sure enough, I was not able to even access these keys as Administrator.


This blog post had the solution, although one important step was left out in workaround 1. In order to change the permissions of those folders, you first have to claim ownership.
I didn't feel comfortable changing ownership of the whole Components key, so I just changed the keys that were referenced in the error log above, namely GUID1\GUID2.
It's bad enough having to change the registry as local system, I didn't want to further endanger the stability of the system.

That means going through the following process:

1. Attempt to install KB2494113
2. On failure, get the registry key from the error from "View Summary"
3. Run "psexec -i -s cmd.exe", then invoke "regedit"
4. Navigate to HKLM\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\GUID1
5. Right click the key GUID1 and select "Permissions". Click "Advanced".
   
6. In the Permissions, Owner tab: Check "Replace owner on subcontainers and objects" then chose a valid user or group. Click "Apply". You'll get a message that tells you that it couldn't set the owner on some of the subkeys. That's alright in this case.
7. In the Permissions, Permissions tab check "Replace all child object permissions with inheritable permissions frmo this object" and click "OK". Answer "Yes" when prompted.
8. Goto 1 until the installation doesn't fail

In my case I had to tweak two dozen or so reg keys, but then it worked.

Read More

XenServer 6.1

As I've previously written about here, I'm using the Citrix XenServer. I've been using the free version in a production environment for a few years now. Sure, there were minor issues or hiccups, but no deal breakers.

I'm still running XenServer 5.6, although XenServer 6 and even 6.1 were already released.
Why didn't I upgrade yet?



Well, for one there is the mantra of "Never change a running system." Other than that, what's to be gained from an upgrade? For one the list of features in the free edition of XenServer has remained more or less constant. 
On the other hand due to changes in the XenTools in 6.1 a lot of problems were introduced for Windows VMs. There are a lot of problem reports on the citrix forums, so I decided to wait until those were addressed.

Read More