Why won’t IntelligenceCenter and/or DataCollector start anymore?

Products

• IntelligenceCenter

Issue/Introduction

When you install PostgreSQL as part of the IntelligenceCenter and/or DataCollector installation, a local Windows user named postgres is created. By default, the installer tries to create the password so that it never expires. However, if you have a Windows security policy that prevents the creation of users with passwords that don’t expire, the installer will not be able to create the user account with the proper setting and the password will expire after the number of days indicated by the Windows 2003 Maximum Password Age parameter (42 days by default). If the password associated with this user account expires, the PostgreSQL Database Server 8.2 service will not be able to start, which in turn will cause the IntelligenceCenter and/or DataCollector services on the machine to fail to start. To fix this, you must set a new password for the postgres user and configure the PostgreSQL Database Server 8.2 service to use the new password.

Resolution

To reset the local postgres user password if it has already expired, do the following:

1. Click Start and select Control Panel > Administrative Tools > Computer Management. The Computer Management dialog box appears.
2. Expand Local Users and Groups in the left pane.
3. Double-click the Users folder. The Windows users are displayed in the right pane.
4. Right-click the postgres user entry in the right pane and select Set Password…. The Set Password for postgres dialog box appears.
5. Click Proceed.
6. Type a New password. You can use any strong password; passwords are case sensitive.
7. Retype the password in the Confirm new password field and then click OK.
8. Click OK to confirm the password change.
9. On the Computer Management dialog box, expand Services and Applications and select Services.
10. Right-click the PostgreSQL Database Server 8.2 service and select Properties.
11. Select the Log On tab.
12. Enter the new password you created for the postgres user account in the Password and Confirm password fields and then click OK.
13. Restart the PostgreSQL Database Server 8.2 service.
14. Restart the PacketeerIntelligenceCenter service (on the server where IntelligenceCenter is installed).
15. Restart the PacketeerCollectorAgent and PacketeerDataCollector services (on the server where DataCollector is installed).