Add sign up function for the local_auth mode

[djs0109]

Currently, in local_auth mode, we can only support user creation via admin page. A sign up function need to be created for new user to create an account by themself. By default, the new user will be assigned a user role, so that they can not see any project.

[SBlechmann]

create entry in env file to active sign up functionality