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

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

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

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

a year 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

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

a year ago

what is passwordsalt?

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 3.0.3

a year ago

#10

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

a year ago

#11

Is there any advice you can give me?

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 3.0.3

a year ago

#12

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.

Important Information:

The YAF.NET Support Forum uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close