Everything running via cgi-bin accounts is run not as an apache module (like mod_perl or mod_php), but via suexec in its own shell, limited to running with the permissions of the user/group/dept/class cgi principal. The following are relevant packages we have installed to run under suexec.
Programming languages and other programs:
All modules below are in the form of the Debian packages which install them. For Perl packages, they are usually of the form lib<something>-perl, where the something is the module name. For instance, libxml-parser-perl is XML::Parser. I should come back later and clean these into actual modules for ease of reading -- there's just a lot of them. For other languages, the module being installed should be evident from the package.