CODEWITHSUNDEEP
sugarcrm
user603666
user603666

Reputation: 63

SugarCRM user password

I've created a user in SugarCRM; once I've created a user the password is mailed to the user. I see the table user, but the user_hash is blank.

Where does it store the password before it sends an email?

Upvotes: 2

Views: 4440

Answers (3)

ErasmoOliveira
ErasmoOliveira

Reputation: 1426

You can create user using md5 function if you using phpmyadmin.

You can alter the passworld and use md5() function;

Upvotes: 0

Anthony
Anthony

Reputation: 37065

I think you might be mistaken. I just created a new user with a user name new_user. I then did the following query:

SELECT * FROM users WHERE user_name = "new_user"

The user_hash has a value of 1e3fab09c625a96334d18d2da27dae46.

I double-checked, and the password emailed to me was l7YaR7, which md5 hashes to the above.

I did this in Sugar 6.1.1. What version are you using?

Also, did the email get sent out? It's possible that the password hash isn't sent to the DB until after the email has been successfully sent.

Upvotes: 0

Maria L
Maria L

Reputation: 41

Check the column 'system_generated_password'. 'user_hash' will be null until the new user logs in with the the system generated password and then creates a new password for themselves.

Upvotes: 2

Related Questions