Thanks for your input buddy,

I plan on routing the holes due to wanting it automatic, and understand that a longer bit would be needed.

To mount the spindle on the side wouldn't give me what I require as when routing the holes the pipe would need to spin which would leave a chamfer on the inside of the holes, and that wouldn't enable me to slide a socket into them.