Reset IMSS 7.0 for Linux console

Thanks to CK for sharing this.

Please do the following using the psql tool that comes with PostgreSQL:

1. Run "/opt/trend/imss/PostgreSQL/bin/psql imss sa" command.
2. Run the following psql commands:

• Imss=# update tb_administrator set md5_digest='18e143b754dc7690ca2ab8ddcd0bfbe8' where admin_id=1;

Note: Optionally you can use "admin_name” as WHERE condition.

3. Verify that the password has been changed by executing the following command:

• Imss=# select admin_id, md5_digest from tb_administrator;

The result should be:

admin_id | md5_digest

-----------+-----------------------------------------------------------------

1 | 18e143b754dc7690ca2ab8ddcd0bfbe8

Important: After following the above procedure, the password will be reset to the default "imss7.0" without the quotes.