No, that was handheld. I don't think you will need 5 sec exposure to capture. I am sure you know things but just I am pointing few things which we may forget to set.
1. Since you want clouds too in the focus, set smaller aperture value (In my compact smallest f/8 and I used f/7.1, I don't how small would be good in your lens. It could be one stop down from the smallest).
2. Set the focus mode to manual (MF) and turn the ring to the extreme. It should do (I don't know what would be the problem (practical) to set the focus at infinity as I don't know much about interchangeable lens/camera)
3. You can't use the focus ring to adjust the focus when your focus mode is set at AF or other mode which are not manual focus mode. It should be either MF or S-AF+MF.
4. Clean your lens.
5. My setting for that shot, at full zoom, spot metering, I guess Aperture setting and -ive exposure to raise shutter speed...
* There is something called resetting lens. After resetting turn on the camera, lens should be set at infinity, I read.
Wait for few days, Jun 4th is full moon day. You will have a nice opportunity then.