How to reset the Filr Admin user password.

This document (7012569) is provided subject to the disclaimer at the end of this document.

Environment

Filr 1.0

Situation

Forgot the password for the Filr admin user.
How to change the Filr admin user's password.

Resolution

Do one of the following:

1) Either create a local user with a new password or use a existing user that 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 by typing:
mysql -u root -p
<root password>
use filr
select name,password from SS_Principals where name='admin'; (keep a copy of this for backup, just incase)
select name,password from SS_Principals where name='desireduser'; (this should be the user you know the password for, save this)
update SS_Principals set password='xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' where name='admin'; (keep the single quotes, replace the xxxx with the saved password from the user above)
Reboot Filr after that change.

Or

2) Reset the password for admin back to the default, which was admin, do the following:

mysql -uroot -p
[Enter database root Password]
Use filr;
UPDATE SS_Principals SET password='bc8f3945a1466d220df9c91b655fb864b2664421', pwdenc='SHA' WHERE name='admin' and type='user';
exit;

Restart Filr Service.

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.

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

Document ID:7012569
Creation Date:06-JUN-13
Modified Date:11-JUN-13
- NovellFilr

Did this document solve your problem? Provide Feedback