User activation via email does not work when system status is "off"
This has been changed on the upcoming Craft 2.3 release such that if the system status is set to off, account verification and set/forgot password logic will still run.