YAFLogo

obren
  • obren
  • 51.4% (Neutral)
  • YAF Forumling Topic Starter YAF Version: 2.3.0.2
a year ago
Users' passwords are in encrypted text in my database.(not forum db, that's my db)How can I add these usernames and passwords to the forum database in the same way?usernames and passwords will be the same
 mydb.png You have insufficient rights to see the content.
Sponsor

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 仍 YAF Version: 3.0.3
a year ago
Originally Posted by: obren 

Users' passwords are in encrypted text in my database.(not forum db, that's my db)How can I add these usernames and passwords to the forum database in the same way?usernames and passwords will be the same
 mydb.png You have insufficient rights to see the content.



It depends how the passwords are stored. If they are stored the same way as the membership provider, then you can simply import the user.
faildre
  • faildre
  • 55.6% (Neutral)
  • YAF Forumling YAF Version: 2.3.0.2
a year ago
Password field is empty in forum database,In my old database that belongs to me, the passwords of the users are in encrypted text. for example, the long sentence in the photo represents an encrypted password,I want to insert the md5 encrypted password into the table named yafUser in the forum database
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 仍 YAF Version: 3.0.3
a year ago
In your Yaf version the passwords are stored in theyaf_prov_Membership oraspnet_Membership depending on the membership provider you are using. But you would also need the PasswordSalt. And of course the entire user needs to be in that table.
faildre
  • faildre
  • 55.6% (Neutral)
  • YAF Forumling YAF Version: 2.3.0.2
a year ago
thank you for your reply, sorry but i don't know about PasswordSalt,I did not add such a column in my own database,How can I access the information you say?Thank you very much for your help, I am very grateful to you

 mydb.png You have insufficient rights to see the content.
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 仍 YAF Version: 3.0.3
a year ago
In that case it's not possible to import the user password. The user on first login would need to use the reset password function, in the login page
faildre
  • faildre
  • 55.6% (Neutral)
  • YAF Forumling YAF Version: 2.3.0.2
a year ago
If I manually change the Password column in the [yaf_prov_Membership] table in the database, will my change work?
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 仍 YAF Version: 3.0.3
a year ago
Originally Posted by: faildre 

If I manually change the Password column in the [yaf_prov_Membership] table in the database, will my change work?



Then again it would only work with both password and passwordsalt
faildre
  • faildre
  • 55.6% (Neutral)
  • YAF Forumling YAF Version: 2.3.0.2
a year ago
what is passwordsalt?
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 仍 YAF Version: 3.0.3
a year ago
Originally Posted by: faildre 

what is passwordsalt?



the password salt is generated during the saving on a password. For example when a user register or change the password. The salt is used to generate the password hash. But you cannnot create the salt from the password hash
faildre
  • faildre
  • 55.6% (Neutral)
  • YAF Forumling YAF Version: 2.3.0.2
a year ago
Is there any advice you can give me?
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 仍 YAF Version: 3.0.3
a year ago
Originally Posted by: faildre 

Is there any advice you can give me?



I would import the password hash. Then when the user tries to login. He/she would need to reset the password and then would be able to login again.

You could also send an email to all users, and tell them that they need to reset the password.
YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button