Network Management

Adding record to the Websites table

This article will help to update the Orion website URL to use a DNS alias instead of the hostname of the server. This article will show how to use (SQL query) to update the Website table in the Orion database.

First published date

10/9/2018 3:53 PM

Last published date

1/19/2022 4:59 AM

Overview


This article will show you how to update the Websites table using the Database Manager. For example, if you are configuring Orion Web Console to use the HTTPS protocol, you need to use port 443 (default) and change the Certificate column from 0 to 1. The Resolution section below will provide further detailed information.

Product section

Orion Platform

Cause

n/a

Resolution

Note:  Before making any manual changes to the database, make sure to back up the database.

To add a record to the Websites table, follow the steps below:

  1. Log in to the Orion Server.
  2. ​Open the Orion Database Manager.
  3. Expand the Server.
  4. Expand the Orion Database.
  5. Double-click the Websites table (or any table as it makes no difference).
  6. Overwrite the existing query with the following query: 
    -- Scripts are not supported under any SolarWinds support program or service. 
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further 
-- disclaims all warranties including, without limitation, any implied warranties 
-- of merchantability or of fitness for a particular purpose. The risk arising 
-- out of the use or performance of the scripts and documentation stays with you. 
-- In no event shall SolarWinds or anyone else involved in the creation, 
-- production, or delivery of the scripts be liable for any damages whatsoever 
-- (including, without limitation, damages for loss of business profits, business 
-- interruption, loss of business information, or other pecuniary loss) arising 
-- out of the use of or inability to use the scripts or documentation.

INSERT INTO [dbo].[Websites] ([ServerName],[IPAddress],[Port],[SSLEnabled],[Type])
VALUES ('HOST','(All Unassigned)','PORT',SSL,'TYPE')

HOST - hostname, FQDN, IP address
PORT - relevant port (i.e. 80 for default Non-SSL, 443 for default SSL)
SSL - 0 if Non-SSL or 1 if SSL
TYPE - additional or primary depending on the function of the website (Note: there can only be one primary, and the first one will always be selected in case multiple primary records are in table)

  1. Click Execute Query.
  2. Close Database Manager.
  3. Once the Entry has been Added Please restart the Orion services  using Orion Service Manager (Start and stop Orion services)

Note:

  1. If you are using a DNS alias as the Server Name, you may need to revise these changes after the Configuration Wizard is run.
  2. If you want to update the Websites table manually, click Enable Table Editing, then select correct protocols (HTTP or HTTPS) and use the exact port number for each. HTTPS requires to change SSL enabled from 0 to 1 and then restart IIS services.