patio awning problem

Hi, I hope someone can give me some guidance. My back porch is leaking quite badly. The roof appears to be made of metal, with wood placed on top (presumably so that it won’t get too hot). I’ve included pictures of what the porch looks like from the inside, and what it looks like from the outside. The major leaks are in between the 2 pieces of blue tape – during heavy rain, I have to place receptacles there to catch the rain. The green tape is where the ceiling is wet, but water does not seem to fall down. The leaking is toward the front end of the porch, away from the house. At the point where the porch attaches to the house, it is completely dry, with no leaking. In addition, along the sides, in the front part of the porch, water seems to come in through the screens. I tried bending up one of the eaves to deflect the water away from the screen, but that didn’t seem to work. I imagine that the wood that is sitting on top of the metal roof has to be removed to get to the leak. Then what? I don’t want to replace the whole porch roof. . .

Greetings, I need to secure a 10'X12' pergola/gazebo to a concrete patio. Each of the four pergola's legs has a plate with 4 holes in it and I was thinking of using Tapcon screws. I never used this screws before. Are there any specifics I need to be aware of before doing it? What length of screw would you use? How far do I need to be from the patio's edge (is there a chance the slab could crack while I drive the screw down? Shall I also use construction adhesive underneath the 4 plates or is this an overkill? Appreciate any advice. Thanks.