How to reset the Filr Admin user password.

  • 7012569
  • 06-Jun-2013
  • 24-Jun-2020

Environment

Filr 3

Situation

Forgot the password for the built-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 built-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:

1)  Use an 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)

After the password was set, reboot the Filr appliance(s).


In case the built-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
After the password was set, reboot the Filr appliance(s).

In the event that the 'admin' user and the 'desireduser' are using different password encryption methods, the existing user's password will not work for the admin user. 
In order to copy/reset the password encryption method in the database, login to mysql from the server console (either via the hypervisor or over ssh) and follow these steps:
  1. :~# mysql -uroot -p (enter the mysql root password when prompted)
  2. mysql> use filr
  3. mysql> select name,pwdenc from SS_Principals where name='admin'; (keep a copy of this for backup, just in case)
  4. mysql> select name,pwdenc from SS_Principals where name='desireduser'; (this should be the user you know the password for, save this)
  5. mysql> update SS_Principals set pwdenc='xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' where name='admin'; (keep the single quotes, replace the xxxx with the 'pwdenc' from the user above).

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.