Results 1 to 3 of 3

Thread: Newly Imported Users Can't Log In

  1. #1
    mbuttrey01 is offline Senior Member
    Join Date
    Feb 2009
    Posts
    40

    Question Newly Imported Users Can't Log In

    I imported a number of new users and set them as Active as part of the inport. While all of the rows seem to have come in fine, no default passwords were created so no one can log in.

    Right now I am forced to go in for each rep and reset their password manually. There has to be a better way!!!

    How can I update the ones that I have already imported and how do I keep this from happening in the future?

    Michael

  2. #2
    mbuttrey01 is offline Senior Member
    Join Date
    Feb 2009
    Posts
    40

    Default Re: Newly Imported Users Can't Log In

    I don't know what caused this or if it is supposed to happen that way but here's the way I fixed it:

    phpMyAdmin +

    UPDATE `users`
    SET `user_hash` = '5f4dcc3b5aa765d61d8327deb882cf99'
    WHERE IsNull(`user_hash`)

    The above hash translates to "password"

    M

  3. #3
    Angel's Avatar
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Newly Imported Users Can't Log In

    You could always copy the user_hash value from a working user record to the non-working ones via MySQL and that would make the password for all those non-working users the same as the working one that you picked. Or get the md5 hash for another password of your liking that you'd like to use as the default for those users and use that value to populate the user_hash value on those records.
    Regards,

    Angel Magaņa
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 2008-11-04, 05:05 PM
  2. Replies: 1
    Last Post: 2008-11-04, 03:29 PM
  3. How to newly write cron job in sugarcrm...?
    By maniram2202 in forum Developer Help
    Replies: 3
    Last Post: 2008-10-14, 03:21 PM
  4. Replies: 1
    Last Post: 2007-08-24, 09:47 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
  •