Add integration test for signing up as a local user