1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Password changed

Discussion in 'Sitebuilder 3.0 for Linux' started by tek01, Jun 21, 2007.

  1. tek01

    tek01 Guest

    Hi there,

    We just upgraded from SB 2.1.3 to SB 3.0.2 on Linux. We also migrated all websites from the old SB but noticed that all users now have different password.

    Yes, we can manually change all the password but since there are more than 200 users i would like to know if there any way we can do it automatically.

    I think this is a common issue for everyone migrating from old version...

    Thank you!
  2. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    Sep 19, 2005
    Likes Received:
    Yes, you are right. During migration, passwords of resellers are changed. Also, passwords for site owners created in the process of preparatory migration are generated. See information on users' passwords in the <sitebuilder-root>tmp/migration/migration-passwords.log file. In the migration-passwords.log file, information is stored in a table with vertical lines used as separators. The table has the following format:

    | User name | Password | E-mail | User role |

    Password for appropriate user in Sitebuilder database can be updated with following command:

    mysql> update user set user_password=md5('NEW_PASSWORD') where user_name='USER_NAME';

    So you can get the list of user names from migration files or directly from database, compose list of password for users and right a little script which will update password for each user.

    Hope this information will be helpful.
  3. tek01

    tek01 Guest

    Thank you!