For those of you who have the leaks on ur A-pillars and in the map-holders under the speakers, it is a pretty easy fix. I just fixed both of mine about a week ago cuz I was experiencing the same problem - if you search, you should be able to find a "how-to," but here it goes.
1. Pull off the weatherstripping around the door - very simple if just slides off.
2. Pop off the a-pillar - again, very simple - just yank on it. Obviously you wanna be careful, but it will require some force.
3. Take off the visor. The screw closest to the rearview mirror is a regular phillips head. The other three (under the little plastic cover) are a torx bit.
4. Once you this stuff out, the headliner should be free in that upper corner. Pry the headliner down gently and look around in there. You should see a hose and a "nipple" that that hose should slide on. Both my driver's side and my passengers side hoses weren't connected at all!
5. A lot of people people say to use a pair of needle nose pliers to pull the hose and slide it up onto the drain. However, I was able (barely) to get my arm in there and pull it over the drain.
6. Use a zip tie or hose clamp to ensure it doesn't come off again.
7. Repeat for passenger side - Passenger side requires one extra step as you gotta remove the grab bar or whatever its called.
I was a little weary about ripping the inside of my car apart, but once I started it really was simple. It took me about 45 minutes to do the drivers side cuz I had no idea what I was doing. After that, it took me literally no more than 15 minutes to do the passengers side.