Was Chris Farley in the Waterboy?

Nope, that was his brother, Kevin Farley.

http://www.imdb.com/name/nm0267659/