Gidday Stuart....
Have a look at this....might help. I have to fix this problem also. It seems its a common problem with the D1 sunroofs at least.
The seals need redoing and the tubes (2 per sunroof) replacing and attaching properly to the channel outlet. I too want to know where the tubes go...