How to reset the Filr Admin user password.

  • 7012569
  • 06-Jun-2013
  • 16-Jan-2019

Environment

Filr

Situation

Forgot the password for the build-in Filr admin user.
How to change the Filr Zone admin user's password when forgotten.

Resolution

The scenario is similar but different if the Filr uses zones and if it's the original build-in Filr 'kablink" admin user or one of the admin users for a Zone.

Choose the scenario that applies.


In case of a Filr system without Zones or for the original (kablink) admin user, there are two possibilities:

1)  Use a existing user for which you know the password for, then copy its password in the database to the password of admin.
In order to copy/reset the password in the database, login to mysql from the server console (either via the hypervisor or over ssh) by going trough this scenario:
  1. :~# mysql -uroot -p (enter the mysql root password when prompted)
  2. mysql> use filr
  3. mysql> select name,password from SS_Principals where name='admin'; (keep a copy of this for backup, just in case)
  4. mysql> select name,password from SS_Principals where name='desireduser'; (this should be the user you know the password for, save this)
  5. mysql> update SS_Principals set password='xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' where name='admin'; (keep the single quotes, replace the xxxx with the saved password from the user above)
Or

2) Reset the password for admin back to the default, which was admin, do the following:
  1. :~# mysql -uroot -p (enter the mysql root user's password when prompted).
  2. mysql> Use filr;
  3. mysql> UPDATE SS_Principals SET password='uQgmrEdsBQnB/HOh1w87ooxE5a66U5u/Y5k2EIlNJLw=' WHERE name='admin' and type='user';
  4. mysql> exit;
After the password was set, reboot the Filr appliance(s).



In case the build-in admin Filr user for which the password was lost was created for a Zone, the procedure is somewhat different. But the same base principal does apply.

1) Copy the password value of a user for which the password is known to the Zone Admin's password field.
  1. :~# mysql -uroot -p (enter the mysql user's password when prompted)
  2. mysql> use filr
  3. mysql> SELECT zoneID,zoneName FROM SS_ZoneInfo; (note down the number of the zoneID for the correlating affected zone.)
  4. mysql> select id,name,password FROM SS_Principals WHERE name='admin' AND zoneID='zoneID from step3'; (keep a back-up, just in case and note down the id).
  5. mysql> select name,password FROM SS_Principals WHERE name='desireduser'; (this should be the user you know the password for, save this)
  6. mysql> update SS_Principals set password='xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' where id='id from step 5.)'; (keep the single quotes, replace the xxxx with the saved password from the user above)
  7. mysql> exit

Or

2) reset the password to admin.
  1. :~# mysql -uroot -p (enter the mysql root user's password when prompted).
  2. mysql> Use filr;
  3. mysql> SELECT zoneID,zoneName FROM SS_ZoneInfo; (note down the number of the zoneID for the correlating affected zone.)
  4. mysql> select id,name,password,pwdenc FROM SS_Principals WHERE name='admin' AND zoneID='zoneID from step3'; (keep a back-up, just in case and note down the id).
  5. mysql> UPDATE SS_Principals SET password='5WiYX0kj+ctcOMOlF9aN+6zzdP8ZQHqovF6/PxZcJfQ=' WHERE id='value from step 4' and type='user';
  6. mysql> exit;
Afterwards, reboot the Filr appliance(s).

Additional Information

If changing the password back to admin, remember after logging in as admin, to go into the 'View Profile' for admin, located in the drop down box for the user, then click edit, the change the password.

The mysql commands need to reflect the names as they are configured in the running system.
If for instance a different name for the database then filr was used, the command "use filr" needs to reflect the correct database name.