VMmanager 6: Administrator guide

How to change the account email?

ISPSystem

To change the VMmanager account email:

  1. Connect to the server with VMmanager via SSH.
  2. Define account id in the auth_user and vm_account tables of VMmanager database:

    docker exec -it mysql bash -c "mysql isp -p\$MYSQL_ROOT_PASSWORD -e 'select id from auth_user where email=\"admin@example.com\";'
    docker exec -it mysql bash -c "mysql isp -p\$MYSQL_ROOT_PASSWORD -e 'select id from vm_account where email=\"admin@example.com\";'
    docker exec -it mysql bash -c "mysql isp -p\$MYSQL_ROOT_PASSWORD -e 'select user from msgs_user2delivery_method where email=\"admin@example.com\";'
     Comments to commands

    admin@example.com — account email

    An example of response
    +----+
    | id |
    +----+
    | 12 |
    +----+
  3. Change the email of the user with this id:

    docker exec -it mysql bash -c "mysql isp -p\$MYSQL_ROOT_PASSWORD -e 'update auth_user set email=\"new_admin@example.com\" where id=auth_user_id;' "
    docker exec -it mysql bash -c "mysql isp -p\$MYSQL_ROOT_PASSWORD -e 'update vm_account set email=\"new_admin@example.com\" where id=vm_account_id;' "
    docker exec -it mysql bash -c "mysql isp -p\$MYSQL_ROOT_PASSWORD -e 'update msgs_user2delivery_method set u2dm_params='{\"email\": \"new_admin@example.com\"}' where user=msgs_user2delivery_method_id;' "
     Comments to commands

    auth_user_id — account id in the auth_user table

    vm_account_id — account id in the vm_account table

    msgs_user2delivery_method_id — account id in the msgs_user2delivery_method table

    new_admin@example.com — new account email

  4. Restart VMmanager:

    vm restart
Thank you for your feedback!
Was the article useful?
Tell us why not:

it does not match the title

it was hard to understand

I didn't find the answer

recommendations from the article did not help

other

Tell us what you didn't like in the article: