Importing MD5 passwords ??

Discussion in 'Integration' started by gswaim, Aug 29, 2006.

  1. gswaim

    gswaim CGI-Central Partner

    Joined:
    Jul 2, 2003
    Messages:
    641
    I am getting close to implementing aMember and am making plans to import the username and password information from the database I will be integrating with into aMember. I noticed that the passwords I need to import into aMember are in the MD5 format. I don't think I can do this or that is what it looks like to me.

    Assuming I will not be able to import MD5 passwords into aMember (and if I can please let me know), what is my next best option? Import the usernames and have aMember generate a new password. That would mean I would have to email all the members their new password.... Seems like a lot of "hassle" for the members.

    So what are my options here?

    Thanks in advance for any help on this!
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    You can import MD5 passwords to aMember "as is". When user logs-in, this password will be accepted and converted to plain-text.

    However, if you have integration plugins, there will be some mess until anyone logs-in, because aMember will export these MD5 passwords as actual user passwords to third-party scripts.
  3. gswaim

    gswaim CGI-Central Partner

    Joined:
    Jul 2, 2003
    Messages:
    641
    Alex,

    I just want to make sure I do not lock out my members in the process of integrating aMember with FusionBB. So I am going to lay out the scenario as I understand it. Please clarify and/or correct anything I don't have right :)


    1. I have a forum application, FusionBB, with about 300 members and their passwords are stored in MD5.
    2. I have aMember installed and tested using the newly written FusionBB plugin.
    3. I will clear out all test names in aMember and start out with an "empty" aMember
    4. I will take FusionBB offline.
    5. I will use myPhpAdmin to export FusionBB membership information into a flat file (CSV).
    6. Since FusionBB passwords are in stored in MD5 format, I will only export username and email address.
    7. I will import FusionBB CSV file into aMember and have aMember generate a new password.
    8. I will then use the emailing capabilities of aMember to send email to all members advising them of their new password and how they can log on and change it to anything they want.
    9. Now I assume I need to have the password generated by aMember to replace the passwords stored in FusionBB... Is that done with a DB sync?

    Thanks in advance for your help!
  4. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Grant, with little additions:

    1. I have a forum application, FusionBB, with about 300 members and their passwords are stored in MD5.
    2. I have aMember installed and tested using the newly written FusionBB plugin.
    3. I will clear out all test names in aMember and start out with an "empty" aMember
    4. I will take FusionBB offline.
    4A. I will backup aMember and FusionBB databases using phpMyAdmin.
    5. I will use myPhpAdmin to export FusionBB membership information into a flat file (CSV).
    6. Since FusionBB passwords are in stored in MD5 format, I will only export username and email address.
    7. I will import FusionBB CSV file into aMember and have aMember generate a new password.
    9->8. Now I assume I need to have the password generated by aMember to replace the passwords stored in FusionBB... Is that done with a DB sync? Just click aMember CP -> Rebuild Db. Make sure members are in Fusion, try to login as some test user.
    8->9. I will then use the emailing capabilities of aMember to send email to all members advising them of their new password and how they can log on and change it to anything they want.

Share This Page