No announcement yet.

Backup and restore password script

  • Filter
  • Time
  • Show
Clear All
new posts

  • Backup and restore password script

    Hi community,
    i have to backup und restore the passwords from each user in order to export their personal data (calendar ...).
    Therefore i tried to backup the password hash.
    SELECT userPassword FROM oxdatabase_5.user where imapLogin='$username';
    Then i change the pw with the changeuser script to a default pw and do my export. After everything is done i want to restore the old password hash, so i do
    UPDATE user SET userPassword = '[hash]' where imapLogin='$username';
    Now everything should be back to normal. But i can't login any more with the old pw. Are there any other tables effected while changing the pw with the changeuser script, or do i have to reload a special component? What do i have to do to properly restore the old password. I looked through many posts here, but i could not find any solution. Would be so nice if anybody could help.