Changing the SwSQL Account Password

From support-works
Jump to navigation Jump to search



Status: Draft
Version: 1.1
Authors: HTL QA
Applies to: Supportworks ESP Version 6.0 (Server Build 2215) and higher

Changing the SwSQL Account Password

A backup of the Supportworks installation is recommended before making the changes listed below.

The SwSQL database account, whose user ID is "root" by default, is the one used by the Supportworks server to connect to the database. It is also the account used by third-party applications or scripts (if any), as well as by some Custom HTML reports, for their own database connections.

This document first takes you through the steps required to change the SwSQL account password itself (which is blank by default). You are then given instructions on how to correspondingly change the password settings as configured in Supportworks and in the DSNs that each of the connecting entities uses. These latter instructions differ according to whether or not the version of Supportworks ESP is 7.5.0 or above. Finally, you are given instructions on how to make the Hornbill Interactive SQL utility issue a prompt for credentials if there is currently no password set.

For the purposes of this document, it is assumed that both the application database and the system databases are accessed using the one account (whether directly or via ODBC), and that its user ID remains as "root".

Stage 1: Changing the Password of the Account

To change the account password on the database itself, the procedure is as follows:

  1. Ensure that all users are logged out of Supportworks.
  2. Run the Supportworks Server Configuration utility by selecting Start > Programs > Supportworks Server > Supportworks Server Configuration.
  3. On the Server tab, under Installed Services and starting at the top, stop all services.
  4. On the Database tab, check to confirm that the User ID is "root".
  5. Run the Interactive SQL utility by selecting Start > Programs > Hornbill Core Services > Interactive SQL.
  6. Enter the following SQL statements:
    use mysql;
    update user set password=password('new-password') where User = 'root';
    flush privileges;
    exit;

Stage 2: Changing the Password Settings Elsewhere

To allow entities such as Supportworks to now connect to the database using the new password, follow the instructions given in either of the two sections below, depending on your version of Supportworks.

For Supportworks ESP Version 7.4.1 and Below

  1. On the Database tab of the Supportworks Server Configuration utility, enter the new password in the Password field. This setting is for fallback ODBC access to the application database.
  2. In the administrative section of Windows Control Panel, run the Data Sources (ODBC) tool and select the System DSN tab.
  3. For each relevant DSN shown on the list (for example, Supportworks Data and Supportworks Cache), click Configure, enter the new password in the Password field and click OK. These settings are for ODBC access to the application and system databases.
  4. In Windows Explorer, view the root contents of the folder whose default location is C:\Program Files\Hornbill\Supportworks Server\conf. You will see a number of XML files.
  5. Open each of the XML files in turn using a text editor and search for a line containing the tag SwSqlGlobalRootPasswordMsl. If it exists in a given file, add the new password as the specified value, so that you end up with the following:
    <SwSqlGlobalRootPasswordMsl type="string" value="new-password"/>
    These settings are for direct access to the system databases.
  6. On the Server tab of the Supportworks Server Configuration utility, start all services, beginning at the bottom.
  7. Using the Services tool in Windows Control Panel, restart the SwHTTPServer, SwAdminServices and SwSqlServer services as well.

For Supportworks ESP Version 7.5.0 and Above

  1. On the Application Database sub-tab of the Database tab in the Supportworks Server Configuration utility, enter the new password in the Password field. This setting is for fallback ODBC access to the application database.
  2. In the administrative section of Windows Control Panel, run the Data Sources (ODBC) tool and select the System DSN tab.
  3. For each relevant DSN shown on the list (for example, Supportworks Data and Supportworks Cache), click Configure, enter the new password in the Password field and click OK. These settings are for ODBC access to the application and system databases.
  4. Back on the Database tab of the Supportworks Server Configuration utility, select the System Databases sub-tab and enter the new password in the Password field. This setting is for direct access to the system databases.
  5. On the Server tab of the Supportworks Server Configuration utility, start all services, beginning at the bottom.
  6. Using the Services tool in Windows Control Panel, restart the SwHTTPServer, SwAdminServices and SwSqlServer services as well.

Stage 3: Forcing a Prompt for Interactive SQL

Once SwSqlServer has been restarted, all access to the SwSQL server via the root account will be protected by the new password. As Interactive SQL itself will require a login using the new password (if previously blank), you now have to make it issue a prompt, as follows:

  1. Select Start > Programs > Hornbill Core Services > Interactive SQL, and right-click the item to display its properties.
  2. In the Target field on the Shortcut tab, add the switch -p.

If you require any further information or assistance in relation to the procedures above, please feel free to contact the Support Team.