site created using drush arr failing with missing index.php
I think you problem is likely that you need to set the RewriteBase in the .htaccess file.  Edit your .htaccess, find the line that looks like

# RewriteBase /


And add a line under it that reads

RewriteBase /~drew/site2


then clear Drupal caches, and try your site.