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:

\Webtrends>\common\database\mysql\bin\

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:

wtdecrypt.exe

The output will display the user’s decrypted password.

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;