Onset of Hall-mediated magnetic reconnection in weakly ionized astrophysical plasmas