Ok, so you disregard my previous comments.
I have an idea of how to solve this hopefully it is correct. Basically I calculated the force on a differential element of length dr and then integrated over the length of the cylinder. I have attached my solution. Hopefully it makes sense.
