To install a module from a release tarball, specify the path to the tarball instead of the module name.
If you cannot connect to the Forge, or you are installing modules that have not yet been published to the Forge repository that comes with puppetlabs, use the --ignore-dependencies option and manually install any dependencies.
For example:
puppet module install ~/puppetlabs-apache-0.10.0.tar.gz --ignore-dependencies