KB 10099 How to reset the admin password.

KB ID: 10099

Product: Storware Backup & Recovery

Version: not applicable

Published: 2023-06-06

Last modified: 2023-06-06

Problem

I want to reset the admin password.

Solution

Before executing any query on the database, create a backup of it.

  • wait for all tasks to finish and stop vprotect-server service

    systemctl stop vprotect-server
  • login to MySQL on Storware Backup & Recovery server host

    mysql -uroot -p vprotect
  • find GUID of the admin account, by default, it is '1'

    MariaDB [vprotect]> select * from appuser where login = 'admin'\G *************************** 1. row *************************** GUID: 1 VER: 952 FIRSTNAME: The LASTNAME: Admin LASTFAILEDLOGIN: 2022-11-07 08:49:37 LASTFAILEDLOGINIP: 10.10.10.10 LASTSUCCESSFULLOGIN: 2023-05-24 10:47:38 LOGIN: admin PASSWORD: $2a$07$l5ucy8fi8iMXuVvjBtFWh.24qBF1nBYpW0HbQg6uDY23attku2pDa UITIMEZONE: Europe/Sarajevo SOURCE: LOCAL LANGUAGE: EN APPUSERSETTINGS_GUID: cbf265b7-5756-11ec-aa58-005056a602a3 ACTIVE: 1 INFOTOURENABLED: 0 ENDPOINTSORGANIZATION_GUID: NULL
  • update the password for this user, this should reset it to “vPr0tect”