YAFLogo

obren
  • obren
  • 51.4% (Neutral)
  • YAF Forumling Topic Starter YAF Version: 2.3.0.2
6 months 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
6 months 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
6 months 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
6 months 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
6 months 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
6 months 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
6 months 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
6 months 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
6 months ago
what is passwordsalt?
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 仍 YAF Version: 3.0.3
6 months 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
6 months ago
Is there any advice you can give me?
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 仍 YAF Version: 3.0.3
6 months 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.