The singer died aged 65 following a long journey with secondary breast cancer