WORKAROUND
The following function change can be applied to allow the Command Line Installer (CLI) to read passwords from registry values.
- In the Foglight Management Server, navigate to Configuration | Definitions
- Select Databases | SQL Server | Installer | SilentInstaller
- In the search box change the pulldown item to Functions
- Click read Input CSV File
- In the right pane, click the Edit button (the Foglight user must have the Cartridge Developer role for this button to be available to click)
- Replace the code presently in the field with the code in the attached file readInputCSVFile_335673.groovy
- Click the Save button
- Navigate to Rules & Notifications | Manage Registry Variables
- Click the Add button
- In the Popup, pull down the option and choose Password, then click the Next button
- Enter the Name of the Registry value, then click the Next button
- Choose the Static Value radio button, enter the password in both fields, click the Finish button
- Follow the steps in the CLI installer readme file to create the new SQL Server agent.
Note:
- The registry variable name will be entered into the "DB Password" field
- Steps 8-12 can be repeated for other passwords, or the same registry entry can be used for all of the password fields (e.g. a Domain password)
- The same or other (similar) registry names can be entered into the fields: "DB power password", "OS password", and "VMware Password"
- The registry variable includes the password as a encrypted password type.
- Once the new agent(s) are created, the registry variable/value can be removed
- The registry variable/value can be added back again if additional agents are created by CLI
STATUS
Enhancement FOG-2889 has been logged to allow the Command Line Installer (CLI) to read passwords from registry values.