Problem : CONNECT ERROR: Couldn’t resolve host ‘magento-community’ while installing an extension from Magento Community
Solution :
suppose you get extension key as magento-community/HelloWired_Free_Theme_1_4
then instead of using this use :
http://connect20.magentocommerce.com/community/HelloWired_Free_Theme_1_4
Hope this helps !