BPS. LLC
ArboristSite Operative
I have the same type of hole, only through block wall. I used cement patch around the pipe, then lots of roof patch. From the inside i filled cavity with spray foam. Only installed last fall, but no leaks yet. It also only enters house about a foot below grade.
Also be interested in how everyone else does it.
Don't use spray foam to waterproof anything! Insulate, YES, waterproof, NO!!! A lot of people do it, it doesn't last and wasn't intended for this purpose.