Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...DNN User Password SecurityDNN User Password Security
Previous
 
Next
New Post
3/25/2006 11:25 AM
 

Hi there,

can anyone explain me how are DNN passwords secured in the database?

What kind of mechanism is used?

Thanks

 
New Post
3/25/2006 12:15 PM
 

The password storage format is determined by the web.config. During install we automatically generate unique keys to protect viewstate (the machinevalidationkey via SHA1) and passwords. The actual type of password storage is determined by the passwordFormat in the DNNSQLMembershipProvider e.g.

<add name="DNNSQLMembershipProvider" type="DotNetNuke.Security.Membership.DNNSQLMembershipProvider, DNNSQLMembershipProvider" connectionStringName="SiteSqlServer" enablePasswordRetrieval="true" enablePasswordReset="true" requiresQuestionAndAnswer="false" minRequiredPasswordLength="4" minRequiredNonalphanumericCharacters="0" requiresUniqueEmail="false" passwordFormat="Encrypted" applicationName="/" description="Stores and retrieves membership data from the local Microsoft SQL Server database" />

By default we use encryption, which utilises the machinevalidationkey generated during install. In addition a unique Salt value is used along with the password and the key, to make passwords even safer. You can select alternative values of clear (passwords are stored in cleatext) or hashed (passwords are hashed - this does mean that they're not retrievable) if you wish.

Cathal

 


Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
2/5/2007 3:36 PM
 

I forgot a password and had to go reset it, so I just used QueryAnalyzer and ran the stored procedure aspnet_Membership_ResetPassword.  When I did this, I did not specify a value for the PasswordFormat parameter and it defaults to zero.  It turns out that the "0", which is stored in the "PasswordFormat" field of the aspnet_Membership table, indicates clear text, and that the new password I sent was simply stored in the clear.  That's pretty useful to know, and I see that the other passwords, which were set up by the app, indicate a Format of "2" and appear to be hashed, though it doesn't look like MD5.  After reading the previous post, should I understand they are actually encrypted, not hashed?  Can I get the different values for the PasswordFormat field and their meanings?  And is the "PasswordSalt" field not used when the Format is zero?  Is there a way to set these up in the GUI rather than through the back-end directly, as I have done?

Thx!

 
New Post
5/7/2007 8:22 AM
 

I want to create login users for many DNN instances from one main DNN instance.

At the main DNN instance, connection strings to other DNN databases and machine key are stored.

 
New Post
1/23/2008 12:37 PM
 

Hi, in my aplication for default, the password is encrypted but I want chance format for Not encrypted, What is the parameter for "  passwordFormat= " to change password encrypted to Not encrypted.

Thanks for your comments.

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...DNN User Password SecurityDNN User Password Security


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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out