Results 1 to 8 of 8

Thread: Forgot Password option in SugarCRM

  1. #1
    kmram is offline Member
    Join Date
    Nov 2006
    Posts
    8

    Default Forgot Password Page with logical prcess flow added

    Hey

    We have built in a small process to reset a lost password into SugarCRM. The basic workflow is described below

    Workflow :
    1. We went ahead and setup a landing page which validates the user name, email id & a captcha code
    2. Once the email id is verified with the user & captcha code entered is correct, a confirmation email is sent to the the user. this mail contains an approval url.
    3. Once the email approval link is clicked, the password will be reset and sent back to the user's email.

    We had to ensure the right person is requesting for the password reset and this flow helped us achieve that.

    Incase someone needs to avoid the effort, you can use the file and just link it from the login page.

    I can send you the piece of code, if required.

    Thanks

    KM Ram
    SourceFuse Technologies (India) Pvt. Ltd.
    Last edited by kmram; 2008-08-12 at 09:52 PM. Reason: adding details for clarity

  2. #2
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Forgot Password option in SugarCRM

    Hi KM

    You can re-set the user password in the phpMyAdmin or any other database interface:

    UPDATE users SET user_hash = MD5('new_password') WHERE user_name = 'user_name'

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  3. #3
    kmram is offline Member
    Join Date
    Nov 2006
    Posts
    8

    Default Re: Forgot Password option in SugarCRM

    sorry..looks like i sounded wrong.
    Basically i have scripted a standard process for the password reset with the security checks built in, like email confirmation.

    Just wondering if anyone would be interested in have this piece of code. I can send you the file. Its a pretty simple straight forward piece and no customisations required.

    With this a user(valid & authenticated) user can reset his password without playing with the database.

    Thanks
    KM Ram
    SourceFuse Technologies (I) Pvt.Ltd.

  4. #4
    nirmit is offline Senior Member
    Join Date
    Aug 2008
    Posts
    42

    Smile Re: Forgot Password option in SugarCRM

    Quote Originally Posted by andopes
    Hi KM

    You can re-set the user password in the phpMyAdmin or any other database interface:

    UPDATE users SET user_hash = MD5('new_password') WHERE user_name = 'user_name'

    Cheers
    Moreover I guess it isn't advisable to give the access to the database (PHPMyAdmin) to all users. In this case, I see forgot password as an impeccable feature.
    -------------------------------------------------------
    Nirmit Bothra
    http://twitter.com/nirmit

  5. #5
    suramya is offline Junior Member
    Join Date
    Aug 2008
    Posts
    1

    Default Re: Forgot Password option in SugarCRM

    Plus this new process allows the *end* user to reset their password easily and quickly without having to contact support or DB administrators.

  6. #6
    nileema is offline Sugar Community Member
    Join Date
    Jan 2008
    Posts
    93

    Default Re: Forgot Password Page with logical prcess flow added

    Quote Originally Posted by kmram View Post
    Hey

    We have built in a small process to reset a lost password into SugarCRM. The basic workflow is described below

    Workflow :
    1. We went ahead and setup a landing page which validates the user name, email id & a captcha code
    2. Once the email id is verified with the user & captcha code entered is correct, a confirmation email is sent to the the user. this mail contains an approval url.
    3. Once the email approval link is clicked, the password will be reset and sent back to the user's email.

    We had to ensure the right person is requesting for the password reset and this flow helped us achieve that.

    Incase someone needs to avoid the effort, you can use the file and just link it from the login page.

    I can send you the piece of code, if required.

    Thanks

    KM Ram
    SourceFuse Technologies (India) Pvt. Ltd.
    Hello,
    Please tell me how you include approval url in email, how it works?
    reply.
    Thanks.

  7. #7
    sandeeplakshmi is offline Sugar Community Member
    Join Date
    Apr 2008
    Location
    bangalore,India
    Posts
    20

    Default Re: Forgot Password option in SugarCRM

    Hello,

    I have also developed a similar addon to sugar 4.5, my design goes as this -

    -> Reset page asks for sugar user name( we are maintaining unique sugar user names )
    -> It validates against the db & sends a email with reset link to the email in his sugar profile.
    Here, i had gone bit ahead & added expiration to this reset link to 4 hrs.
    The link becomes inactive after 4 hours of its request .
    -> once user clicks that(with in 4 hours) , it get backs to the sugar & asks for old & new password.
    -> for this i have placed a customized link in the sugar login page as "forgot password ?"

    Attached a reference image.
    Attached Images Attached Images  

  8. #8
    saas is offline Member
    Join Date
    Jul 2009
    Posts
    7

    Default Re: Forgot Password option in SugarCRM

    Hi Kmram and SandeepLakshmi,

    I m interested to get the forgot password feature. Can any one of you please share the source code of the same and little explanation how to implement that?

    Thanks in advance.

    Regards..

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Enable Logging
    By vidtechsteve in forum Help
    Replies: 12
    Last Post: 2009-11-09, 02:54 PM
  2. Replies: 19
    Last Post: 2008-04-11, 05:41 PM
  3. sugarcrm with trixbox -password reset
    By apnaveen in forum Help
    Replies: 1
    Last Post: 2007-11-16, 03:09 PM
  4. Merge Contacts show sql error
    By hheckner in forum General Discussion
    Replies: 5
    Last Post: 2006-10-04, 01:57 PM
  5. Replies: 16
    Last Post: 2006-07-29, 07:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •