Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ..."Forgot Password" with email, not username"Forgot Password" with email, not username
Previous
 
Next
New Post
5/2/2013 5:11 PM
 

DNN Ver 6.2.6

Most of our users forget their usernames. How can I allow them to retrieve a new password by entering their email address?

I tried the tutorial on this site but after making he change to the web.config I couldn't login with my host account. I'm not sure why that happened, but I'm hesitant to make that change in production.

Is there another way? 

Thanks

 
New Post
5/3/2013 1:39 AM
 
Hi,

there is a setting to use the email address instead of the username also for login - but if you switch to this, make 100% sure that email addresses are unique in your users table. You can do this by entering this two commands under Host :: SQL:

SELECT COUNT(*)
FROM {databaseOwner}{objectQualifier}Users

and

SELECT COUNT(*)
FROM
(SELECT DISTINCT Email
FROM {databaseOwner}{objectQualifier}Users) AS Temp

Both results must be the same number.

You find the setting under Admin :: Site Settings :: User Account Settings

Best wishes
Michael

Michael Tobisch
DNN★MVP
dnn-Connect.org - The most vibrant community around the DNN-platform
 
New Post
5/3/2013 2:00 AM
 

Hi again,

I just tried this, and found out there are some other issues:

1) Only do this if your DotNetPortal is a single portal installation. and only this installation uses the connected database Otherwise you have to modify the following SQL Scripts in a way that only users of this portal are affected! Don't blame me if something goes wrong, so try it in a test environment with a backup of your installation and database!

2) You have to update the Users table with the following SQL Script:

UPDATE {databaseOwner}{objectQualifier}
SET Username = Email
WHERE Username <> 'host'

(You may forget the last line, but then the 'host' user has to login with his email as well. Use the username of the host, if it's not 'host').

3) You have to update the aspnet_Users table with the following SQL script:

UPDATE aspnet_Users
SET UserName = (SELECT Email FROM aspnet_Membership WHERE UserId = aspnet_Users.UserId),
LoweredUserName = (SELECT LoweredEmail FROM aspnet_Membership WHERE UserId = aspnet_Users.UserId)
WHERE LoweredUserName <> 'host'

(Same as above!)

4) After this, recycle your AppPool.

Best wishes
Michael

 


Michael Tobisch
DNN★MVP
dnn-Connect.org - The most vibrant community around the DNN-platform
 
New Post
5/3/2013 1:17 PM
 

Haha, don't worry Michael I'll take full responsibility! Thanks for the input and testing.

This is the only portal for this install and I don't foresee us ever adding another one based on it's purpose.

Thanks again

 
New Post
5/3/2013 1:24 PM
 
As an alternative you may consider using this freebie from Mitch Sellers. http://www.iowacomputergurus.com/prod...

We've used it for about a year now and it's significantly reduced our support issues related to password recovery/reset. It also ticks the boxes as a much more secure solution for password resets than the core.

Users can reset passwords using username or email address.



Steven Webster
Manager, Community Platform
F5 Networks, DevCentral
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ..."Forgot Password" with email, not username"Forgot Password" with email, not username


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out