*****OFF TOPIC***** I NEED HELP · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

obren
51.4% (Neutral)
YAF Forumling Topic Starter YAF Version: 2.3.0.2

2 years 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.

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2

2 years ago

mydb.png You have insufficient rights to see the content.

Originally Posted by: obren

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
55.6% (Neutral)
YAF Forumling YAF Version: 2.3.0.2

2 years 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
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2

2 years ago

In your Yaf version the passwords are stored in the yaf_prov_Membership or aspnet_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
55.6% (Neutral)
YAF Forumling YAF Version: 2.3.0.2

2 years 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
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2

2 years 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
55.6% (Neutral)
YAF Forumling YAF Version: 2.3.0.2

2 years ago

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

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2

2 years ago

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

Originally Posted by: faildre

Then again it would only work with both password and passwordsalt

faildre
55.6% (Neutral)
YAF Forumling YAF Version: 2.3.0.2

2 years ago

what is passwordsalt?

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2

2 years ago

#10

what is passwordsalt?

Originally Posted by: faildre

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
55.6% (Neutral)
YAF Forumling YAF Version: 2.3.0.2

2 years ago

#11

Is there any advice you can give me?

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2

2 years ago

#12

Is there any advice you can give me?

Originally Posted by: faildre

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.

Important Information: