May I ask why you need an open source solution? My company does exactly what you are looking for, but it is a hosted solution.

Email me if you're interested in discussing further.

wbarrow@realitydigital.com