Installation, Configuration, & Upgrades  :: 
Bulk Encryption of Passwords for Import to PN User Table
 Top

  • Has anybody built a PN user table from another, non-PN, database? Sepcifically has anybody done anything to make the bulk encryption of passwords to the PN md5 encrypted passwords any easier?

    Slugger
  • I did once, it wasn't too hard. Is it coming from a database or a file?
  • It's in a database now.

    Slugger
  • A common chore. Check out this article: http://www.mtrad.com/displayarticle28.html
  • Very easy then.. Key is to remember to add the new users to the users group :) I made that mistake with my first import script I wrote.
  • mhalbrook

    Very easy then.. Key is to remember to add the new users to the users group :) I made that mistake with my first import script I wrote.


    Yeah, I always forgot to add users to groups. That's one of the reasons that I wrote the script. (It does add users to the the default group.) 8)
  • Worked like a charm!

    One thing I did was to change the existing password (it's a new site so there's only one-the admin) to its unencrpted version. Not necessary! If I were using this for an existing site with hundreds, perhaps thousands, of pre-existing users, I'd really appreciate this feature. Perhaps a mention in the docs?

    Anyway, lke Swiss Army Knife, this is a tool every serious postnuker needs to know about. It's great!

    Thanks!

    Slugger
  • Slugger

    One thing I did was to change the existing password (it's a new site so there's only one-the admin) to its unencrpted version. Not necessary! If I were using this for an existing site with hundreds, perhaps thousands, of pre-existing users, I'd really appreciate this feature. Perhaps a mention in the docs?

    The script only affects users if the regdate column is the literal string 'today'. So it won't affect any users that were not loaded according to the instructions. That means it won't affect any existing users.

    I suppose I could update the docs with a note to this effect. I'll add it to my todo list. icon_lol

    I'm glad you found this to be of value. 8)
  • Maybe it could be merged in to the PSAK?
  • Nah...that'd be too good. Someone would have to make it illegal or somethin'.

    Slugger
This list is based on the users active over the last 60 minutes.