Cannot login to 7.5x or 8.0x software install

Products

Webtrends Analytics 8.1x
Webtrends Analytics 8.0x
Webtrends Enterprise 7.5x
Webtrends Professional 7.5x
Webtrends Small Business 7.5x

Cause

An administrator of a Webtrends installation is unable to log into their administrator account and there are either no other administrators available or no other administrator accounts on the system.

Resolution

Execute the attached “Webtrends_80x-81x_insert_admin.txt” script for Webtrends Analytics installations 8.0x – 8.1x or “Webtrends_75_insert_admin.txt” for Webtrends 7.5x installations.The scripts will create an administrator-level account with the user name “wtsupport” and the password “admin”.

Perform the following steps before running the script:
1. Stop all Webtrends services, stopping the “Webtrends – MySQL” service last.

2. Back up the MySQL database, found in the following location:

\Webtrends\common\database\mysql\data

3. Start the “Webtrends – MySQL” service.

4. Examine the wt_user table in the wtmaster database. Make note of the last number used in the “UserID” column.

5. Replace each occurrence of “999” in the applicable script to be the next incremented value from the current UserID value from step 4.

Execute the queries in the script, then log in and confirm the application is accessible with administrative rights.

It is recommended the user changes the account user name and password immediately after logging in.