cleanup API for looking up a user by email or username, add specs, fix invalid auto association in open id provider