How can I recover a lost password when using Webtrends authentication?


Webtrends Analytics 8.1x
Webtrends Analytics 8.0x
Webtrends Enterprise 7.x
Webtrends Professional 7.x
Webtrends Small Business 7.x


To recover a lost password on a Webtrends installation using Webtrends authentication, perform the steps below:
1. Open a command line window.
2. Navigate to the following location:
3. Type the following command:
mysql.exe -u -p
…and enter the password when prompted. The default user name is “Administrator”.
4. On entering the MySQL command line shell, type the following, then press Enter:
use wtmaster
5. Type the following command, then press Enter:
SELECT username, password FROM wt_user WHERE username IS NOT null;
6. From the output returned from the above command, locate the user name value for the user in question, then copy the encrypted password value correlating to the username.
7. Open a command line window in a location where the wtdecrypt.exe file has been saved and type the following command, then press Enter:
The output will display the user’s decrypted password.

More Information

Replace the query in step 5 with the following query to display the same information as above in addition to the type of authentication being used.
SELECT username, password, passwordtype FROM wt_user WHERE username IS NOT null;