Finally, after hours of searching, John stumbled upon a post from another user who had encountered the same issue. The user had contacted the vendor's support team and received the password for the .rar file.