Show error on attempt to register with disabled self registration

[``* `#7051` Wrong success message when user is not allowed to register himself``](https://www.openproject.org/work_packages/7051)

This happens for normal registration as well as registration via omniauth.

This also changes the redirect to not go to / and go to signin_url instead.